Zen Follower
- Join Date:
- Apr 2008
- Posts:
- 159
- Plugin Contributions:
- 0
Oops! 1064 You have an error in your SQL syntax when clicking "New Products"
Just noticed a really ugly error in my shop...
This used to work before. Don't know what I might have done to cause this error. I've googled but not found the exact solution for my case.
Here's the problem :
When I click "New Products" in my store, I get the following message:
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 '-0, 0' at line 11
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, p.master_categories_id FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_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, 0]
The shop is located at https://www.crashdiet.org/webshop
Was suppose to make the shop official tonight, so it would be awesome with some guidence here :) thanks alot in advance
best regards
peter
