1064 error sql syntax related to "MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS

30 Aug 2008, 6:09 PM

#1

icehokz

New Zenner

Join Date:: Mar 2008
Posts:: 36
Plugin Contributions:: 0

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]

30 Aug 2008, 8:19 PM

#2

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: 1064 error sql syntax related to "MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX"

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

that did not get installed right ... :unsure:

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!

31 Aug 2008, 1:06 PM

#3

icehokz

New Zenner

Join Date:: Mar 2008
Posts:: 36
Plugin Contributions:: 0

Re: 1064 error sql syntax related to "MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX"

can you tell me how to fix the problem? thanks

31 Aug 2008, 1:17 PM

#4

icehokz

New Zenner

Join Date:: Mar 2008
Posts:: 36
Plugin Contributions:: 0

Re: 1064 error sql syntax related to "MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX"

nvm i fixed it thanks !