HELP Admin problem

[pridder]

I tried to do something in my database but this went wrong. When i open my admin now and choose "configuration-my store" it is completely empty!!

If i open my site the right column is gone and at the bottom it says:

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 10' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '2' and p.products_date_available >=20080523 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit 10]

PLEASE help me out here, my business is offline now!!!!

[Ajeh]

Almost sounds like you wiped out the configurations table ...

Peek at your database in phpMyAdmin and browse the configuration table ...

How many records do you have in there?

[DrByte]

Sounds like you're using an older version of Zen Cart.
Try this:
http://www.zen-cart.com/forum/showth...357#post378357
... and plan an upgrade ...