Error at bottom of my pages

14 May 2007, 8:10 AM

New Zenner

Join Date:: Apr 2007
Posts:: 37
Plugin Contributions:: 0

Error at bottom of my pages

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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070514 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Also have this error at bottom of page .

Help please lol

14 May 2007, 12:36 PM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Error at bottom of my pages

Those items in UPPERCASE relate to configuration settings in your database. The only reason that should occur is if you've upgraded from a prior version and missed a step.

What is your upgrade history?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

14 May 2007, 10:13 PM

mobilemick

New Zenner

Join Date:: Apr 2007
Posts:: 37
Plugin Contributions:: 0

Re: Error at bottom of my pages

Dont remeber doing anything in phpmyadmin, may have installed a sql for one of the mods, cant remeber which one though :(

Mick