Product Manager ceased displaying product detail
Posted: Mon Jul 18, 2011 3:19 am
Product Manager has ceased to display product detail and shows the following message at the base of the page - not being terribly techie, and knowing what has happened I am in need of assistance.
SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_product_categories cc ON cc.product_id = c.id INNER JOIN cms_module_products_categories cs ON cs.id = cc.category_id WHERE c.status = 'published' AND cs.name IN ('Trigger Spray Bottles') ORDER BY create_date in LIMIT 0, 100000
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 'LIMIT 0, 100000' at line 1
Any help would be super appreciated
Cheers from downunder
SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_product_categories cc ON cc.product_id = c.id INNER JOIN cms_module_products_categories cs ON cs.id = cc.category_id WHERE c.status = 'published' AND cs.name IN ('Trigger Spray Bottles') ORDER BY create_date in LIMIT 0, 100000
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 'LIMIT 0, 100000' at line 1
Any help would be super appreciated
Cheers from downunder