Installation: 1064 You have an error in your SQL syntax

[juglesh]

Installation In Progress...

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 'upgrade_exceptions' at line 1
in:
[DROP TABLE IF EXISTS zen_ upgrade_exceptions;]

Everything was installing fine until this...

thanks for your help,
juglesh

[paperthreads]

That's odd...I have been running my store just fine, and I got the same error today, but it's only when you click on NEW PRODUCTS listing in the store...


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 ':1' at line 10
in:
[SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 order by p.products_date_added DESC, pd.products_name limit 0, 4:1]

I had made some changes to the layout in the store yesterday, but everything was running fine....but now today, I get this error...

[juglesh]

@ paperthreads: Well, this problem was during the actual install.

Anyway, if anyone else has this problem, try just resarting the install process. Seems to have worked... :)