API tools faq
paste
Guest User

EPESI_error_warehouse_view

a guest
Feb 8th, 2016
48
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.34 KB | None | 0 0
raw download clone embed print report
  1. Type: E_USER_ERROR (256)
  2. Message: mysqlt error: [1054: Unknown column 'r.f_item_name' in 'order clause'] in EXECUTE("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50")
  3. File: D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php
  4. Line=77
  5. error backtrace:
  6. [PHP core called function]
  7. function called: handle_epesi_error(256, "mysqlt error: [1054: Unknown column 'r.f_item_name' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50\") ", "D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1054, "Unknown column 'r.f_item_name' in 'order clause'", "SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50", false, Object (ADODB_mysqlt), "SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50", false, "mysqlt error: [1054: Unknown column 'r.f_item_name' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50\") "))
  8.  
  9. File: D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php
  10. line 77
  11. function called: trigger_error("mysqlt error: [1054: Unknown column 'r.f_item_name' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50\") ", 256)
  12.  
  13. File: D:\crm.hcp0.local\libs\adodb\adodb.inc.php
  14. line 1071
  15. function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1054, "Unknown column 'r.f_item_name' in 'order clause'", "SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50", false, "Object (ADODB_mysqlt)")
  16.  
  17. File: D:\crm.hcp0.local\libs\adodb\adodb.inc.php
  18. line 1027
  19. function called: _Execute("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = 8 AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = 0 AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50")
  20.  
  21. File: D:\crm.hcp0.local\libs\adodb\drivers\adodb-mysql.inc.php
  22. line 591
  23. function called: Execute("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = ? AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = ? AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC LIMIT 0,50", Array (8, 0))
  24.  
  25. [PHP core called function]
  26. function called: SelectLimit("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = ? AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = ? AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC", "50", 0, Array (8, 0))
  27.  
  28. File: D:\crm.hcp0.local\include\database.php
  29. line 455
  30. function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = ? AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = ? AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC", "50", 0, Array (#2)))
  31.  
  32. File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowserCommon_0.php
  33. line 1298
  34. function called: SelectLimit("SELECT r.* FROM premium_warehouse_location_data_1 AS r WHERE r.active=1 AND (((r.f_warehouse = %d AND r.f_warehouse IS NOT NULL)) AND (NOT (r.f_quantity = %d AND r.f_quantity IS NOT NULL))) ORDER BY r.f_item_name ASC", "50", 0, Array (8, 0))
  35.  
  36. File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
  37. line 933
  38. function called: get_records("premium_warehouse_location", Object (Utils_RecordBrowser_Crits), Array (), Array (Array (#3)), Array ("50", 0), false)
  39.  
  40. [PHP core called function]
  41. function called: show_data(Array (8, 0), Array (false, true), Array ("ASC"))
  42.  
  43. File: D:\crm.hcp0.local\include\module.php
  44. line 898
  45. function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "show_data"), Array (Array (#2), Array (#2), Array (#1)))
  46.  
  47. File: D:\crm.hcp0.local\include\module.php
  48. line 818
  49. function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#2), Array (#2), Array (#1)), "show_data")
  50.  
  51. File: D:\crm.hcp0.local\modules\Premium\Warehouse\Items\Location\Location_0.php
  52. line 67
  53. function called: display_module(Object (Utils_RecordBrowser), Array (Array (#2), Array (#2), Array (#1)), "show_data")
  54.  
  55. [PHP core called function]
  56. function called: warehouse_item_list_addon(Array (#17), Object (Utils_RecordBrowser))
  57.  
  58. File: D:\crm.hcp0.local\include\module.php
  59. line 898
  60. function called: call_user_func_array(Array (Object (Premium_Warehouse_Items_Location), "warehouse_item_list_addon"), Array (Array (#17), Object (Utils_RecordBrowser)))
  61.  
  62. File: D:\crm.hcp0.local\include\module.php
  63. line 818
  64. function called: get_html_of_module(Object (Premium_Warehouse_Items_Location), Array (Array (#17), Object (Utils_RecordBrowser)), "warehouse_item_list_addon")
  65.  
  66. [PHP core called function]
  67. function called: display_module(Object (Premium_Warehouse_Items_Location), Array (Array (#17), Object (Utils_RecordBrowser)), "warehouse_item_list_addon")
  68.  
  69. File: D:\crm.hcp0.local\modules\Utils\TabbedBrowser\TabbedBrowser_0.php
  70. line 120
  71. function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "display_module"), Array ("Object (Premium_Warehouse_Items_Location)", Array (#2), "warehouse_item_list_addon"))
  72.  
  73. File: D:\crm.hcp0.local\modules\Utils\TabbedBrowser\TabbedBrowser_0.php
  74. line 85
  75. function called: display_contents(Array (0, Array (#2), Array (#3), false), 0, true)
  76.  
  77. [PHP core called function]
  78. function called: body()
  79.  
  80. File: D:\crm.hcp0.local\include\module.php
  81. line 898
  82. function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())
  83.  
  84. File: D:\crm.hcp0.local\include\module.php
  85. line 818
  86. function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)
  87.  
  88. File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
  89. line 1531
  90. function called: display_module(Object (Utils_TabbedBrowser))
  91.  
  92. File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
  93. line 1196
  94. function called: view_entry("view", "8", Array (), true)
  95.  
  96. [PHP core called function]
  97. function called: view_entry_with_REQUEST("view", "8", Array (), true, Array ())
  98.  
  99. File: D:\crm.hcp0.local\include\module.php
  100. line 898
  101. function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "8", Array (#0), true, Array (#0)))
  102.  
  103. File: D:\crm.hcp0.local\include\module.php
  104. line 818
  105. function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "8", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
  106.  
  107. File: D:\crm.hcp0.local\modules\Base\Box\Box_0.php
  108. line 138
  109. function called: display_module(Object (Utils_RecordBrowser), Array ("view", "8", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
  110.  
  111. File: D:\crm.hcp0.local\include\epesi.php
  112. line 246
  113. function called: body()
  114.  
  115. File: D:\crm.hcp0.local\include\epesi.php
  116. line 291
  117. function called: go(Object (Base_Box))
  118.  
  119. File: D:\crm.hcp0.local\include\epesi.php
  120. line 314
  121. function called: process("__location=1454928656.5", false, true)
  122.  
  123. File: D:\crm.hcp0.local\process.php
  124. line 41
  125. function called: process("__jump_to_RB_table=premium_warehouse&__jump_to_RB_record=8&__jump_to_RB_action=view", false)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!