Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    20
    Plugin Contributions
    0

    Default tableu2 - Cant Access Order History from My account (HELP NEEDED)

    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

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,696
    Plugin Contributions
    123

    Default Re: Cant Access Order History from My account (HELP NEEDED)

    Unfortunately tableau2 overwrites a bunch of core files. It might not work with 1.5.7.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. GC: My Account - Order History - none?
    By pooka in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 3
    Last Post: 30 Mar 2011, 10:15 PM
  2. Click to pay order CC via MIGS from Account History
    By UltraLtd in forum Addon Payment Modules
    Replies: 0
    Last Post: 13 Jan 2011, 06:04 AM
  3. Re-order from Account/ Order history pages
    By bigbadboy in forum Managing Customers and Orders
    Replies: 0
    Last Post: 1 May 2008, 04:30 PM
  4. My account - History - Order #
    By philc in forum Managing Customers and Orders
    Replies: 1
    Last Post: 27 May 2007, 09:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR