Clicking on Transaction History in tile view gives us this error after updating from 1.7.1 to 1.7.2:
Type: E_USER_ERROR (256)
Message: mysqlt error: [1054: Unknown column 'r.f_transaction_date' in 'order clause'] in EXECUTE("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50")
File: D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [1054: Unknown column 'r.f_transaction_date' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50\") ", "D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1054, "Unknown column 'r.f_transaction_date' in 'order clause'", "SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50", false, Object (ADODB_mysqlt), "SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50", false, "mysqlt error: [1054: Unknown column 'r.f_transaction_date' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50\") "))
File: D:\crm.hcp0.local\libs\adodb\adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1054: Unknown column 'r.f_transaction_date' in 'order clause'] in EXECUTE(\"SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50\") ", 256)
File: D:\crm.hcp0.local\libs\adodb\adodb.inc.php
line 1071
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1054, "Unknown column 'r.f_transaction_date' in 'order clause'", "SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50", false, "Object (ADODB_mysqlt)")
File: D:\crm.hcp0.local\libs\adodb\adodb.inc.php
line 1027
function called: _Execute("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = 676 AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50")
File: D:\crm.hcp0.local\libs\adodb\drivers\adodb-mysql.inc.php
line 591
function called: Execute("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = ? AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC LIMIT 0,50", Array (676))
[PHP core called function]
function called: SelectLimit("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = ? AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC", "50", 0, Array (676))
File: D:\crm.hcp0.local\include\database.php
line 455
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = ? AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC", "50", 0, Array (#1)))
File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowserCommon_0.php
line 1298
function called: SelectLimit("SELECT r.* FROM premium_warehouse_items_orders_details_data_1 AS r WHERE r.active=1 AND (((r.f_item_name = %d AND r.f_item_name IS NOT NULL))) ORDER BY r.f_transaction_date DESC, (SELECT rdt.f_transaction_id FROM premium_warehouse_items_orders_data_1 AS rdt WHERE rdt.id=r.f_transaction_id) DESC", "50", 0, Array (676))
File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
line 946
function called: get_records("premium_warehouse_items_orders_details", Object (Utils_RecordBrowser_Crits), Array (), Array (Array (#3), Array (#3)), Array ("50", 0), false)
[PHP core called function]
function called: show_data(Array (676), Array (false, false), Array ("DESC", "DESC"))
File: D:\crm.hcp0.local\include\module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "show_data"), Array (Array (#1), Array (#2), Array (#2)))
File: D:\crm.hcp0.local\include\module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#1), Array (#2), Array (#2)), "show_data")
File: D:\crm.hcp0.local\modules\Premium\Warehouse\Items\Orders\Orders_0.php
line 290
function called: display_module(Object (Utils_RecordBrowser), Array (Array (#1), Array (#2), Array (#2)), "show_data")
[PHP core called function]
function called: transaction_history_addon(Array (#29), Object (Utils_RecordBrowser))
File: D:\crm.hcp0.local\include\module.php
line 898
function called: call_user_func_array(Array (Object (Premium_Warehouse_Items_Orders), "transaction_history_addon"), Array (Array (#29), Object (Utils_RecordBrowser)))
File: D:\crm.hcp0.local\include\module.php
line 818
function called: get_html_of_module(Object (Premium_Warehouse_Items_Orders), Array (Array (#29), Object (Utils_RecordBrowser)), "transaction_history_addon")
[PHP core called function]
function called: display_module(Object (Premium_Warehouse_Items_Orders), Array (Array (#29), Object (Utils_RecordBrowser)), "transaction_history_addon")
File: D:\crm.hcp0.local\modules\Utils\TabbedBrowser\TabbedBrowser_0.php
line 120
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "display_module"), Array ("Object (Premium_Warehouse_Items_Orders)", Array (#2), "transaction_history_addon"))
File: D:\crm.hcp0.local\modules\Utils\TabbedBrowser\TabbedBrowser_0.php
line 85
function called: display_contents(Array (2, Array (#2), Array (#3), false), 2, true)
[PHP core called function]
function called: body()
File: D:\crm.hcp0.local\include\module.php
line 898
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())
File: D:\crm.hcp0.local\include\module.php
line 818
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)
File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
line 1544
function called: display_module(Object (Utils_TabbedBrowser))
File: D:\crm.hcp0.local\modules\Utils\RecordBrowser\RecordBrowser_0.php
line 1209
function called: view_entry("view", "676", Array (), true)
[PHP core called function]
function called: view_entry_with_REQUEST("view", "676", Array (), true, Array ())
File: D:\crm.hcp0.local\include\module.php
line 898
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "676", Array (#0), true, Array (#0)))
File: D:\crm.hcp0.local\include\module.php
line 818
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "676", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
File: D:\crm.hcp0.local\modules\Base\Box\Box_0.php
line 138
function called: display_module(Object (Utils_RecordBrowser), Array ("view", "676", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")
File: D:\crm.hcp0.local\include\epesi.php
line 246
function called: body()
File: D:\crm.hcp0.local\include\epesi.php
line 291
function called: go(Object (Base_Box))
File: D:\crm.hcp0.local\process.php
line 41
function called: process("__action_module__=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_2027fcdc5ccee0c3980076176b3178f6%2FUtils_TabbedBrowser%7Crecordbrowser_addons_premium_warehouse_items_676&%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_2027fcdc5ccee0c3980076176b3178f6%2FUtils_TabbedBrowser%7Crecordbrowser_addons_premium_warehouse_items_676_page=2", false)
