Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    34
    Plugin Contributions
    0

    Default 1064 error sql syntax related to "MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX"

    Hey I see this error code everytime i login using a test account.

    can someone help me out thanks!

    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 'MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX' at line 5
    in:
    [select o.orders_id, o.date_purchased from zen_orders o where o.customers_id = '1' order by o.date_purchased desc limit MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX]

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: 1064 error sql syntax

    Sounds like an add-on with configuration_keys or defined constants:
    MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX

    that did not get installed right ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Mar 2008
    Posts
    34
    Plugin Contributions
    0

    Default Re: 1064 error sql syntax

    can you tell me how to fix the problem? thanks

  4. #4
    Join Date
    Mar 2008
    Posts
    34
    Plugin Contributions
    0

    Default Re: 1064 error sql syntax

    nvm i fixed it thanks !

 

 

Similar Threads

  1. Inatall error "1064 You have an error in your SQL syntax"
    By StatoLNL in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 14 Aug 2011, 08:48 AM
  2. 1064 You have an error in your SQL syntax: "limit -3"
    By dealbyethan.com in forum General Questions
    Replies: 3
    Last Post: 13 Dec 2010, 12:49 PM
  3. "1064 You have an error in your SQL syntax;
    By webbuyer in forum General Questions
    Replies: 1
    Last Post: 1 Jul 2010, 07:46 AM
  4. Replies: 2
    Last Post: 16 Sep 2009, 06:15 PM
  5. Replies: 2
    Last Post: 25 Feb 2007, 09:50 PM

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