I was changing some stuff in the admin section today, and in the “Configuration” panel I clicked on “Category/Display Products Order”. It then gave me 4 options to choose from in the right hand column, but when I tried to choose an option and update it, the “Category/Display Products Order” value was set to 0 and now I can’t change it. Now in the catalog side when a customer tries to click on anything in categories up comes this 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 'limit 0, 15' at line 11
select p.products_image, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], s.specials_new_products_price, p.products_price) as final_price from (products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by limit 0, 15"
I haven’t changed this value since getting the new CRE Loaded cart, so I assume it is problem that arose when the database was converted, but I don't know. I want someone who knows exactly what the problem is so I can get this resolved quickly.
Hello Sir. I can help you with your sql problem within right now. I'm available via GMail CHat, MSN or ICQ. Regards Zend Certified PHP Developer Vladimir Kuznetsov.