Guest Posted March 14, 2007 Posted March 14, 2007 Hello, I keep receiving this error message if one of my categories or manufacturers has no items in it. I hope someone can help me with this. ---------- 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 '-9, 9' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = '53' group by p.products_id order by pd.products_name limit -9, 9 [TEP STOP]
Guest Posted March 14, 2007 Posted March 14, 2007 Hi, I had the same problem (although I detected it when installing the discount coupon contribution). The formal solution is documented here: http://www.oscommerce.com/community/bugs,1605/. See the final entry dated 29 Sep 2005 19:21:49. I applied the solution (caused by a newer version of MySQL) and I'm now back up and running.
Jack_mcs Posted March 14, 2007 Posted March 14, 2007 A cleaner fix is in the latest oscommerce update package. Look for the one dealing with split_page_results. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Recommended Posts
Archived
This topic is now archived and is closed to further replies.