Dear All,
I encountered a problem using tableu2 theme, all is working fine accept for order history in my account.
I had tried searching the forums for similar problems but found none.
This is the error log.
[27-Jul-2020 03:32:23 America/Chicago] Request URI: /index.php?main_page=account_history,
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/includes/classes/split_page_results.php:78]
#5 splitPageResults->__construct() called at [/includes/modules/pages/account_history/header_php.php:40]
#6 require(/includes/modules/pages/account_history/header_php.php) called at [/index.php:35]
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 :: select count(*) as total FROM orders o, orders_total ot, orders_status s WHERE o.customers_id = 2 AND o.orders_id = ot.orders_id AND ot.class = 'ot_total' AND s.orders_status_id = (SELECT orders_status_id FROM orders_status_history osh WHERE osh.orders_id = o.orders_id AND osh.customer_notified >= 0 ==> (as called by) /includes/classes/split_page_results.php on line 78 <== in /includes/classes/db/mysql/query_factory.php on line 170.
Someone please point me at the right direction to solve the problem..
Regards,
Alex
Bookmarks