Guest Posted October 31, 2006 Posted October 31, 2006 Hi all I am getting a new error in the admin.. it's only these three sections and I havent' touched the code for a year. Is this something the host did if or when he upgraded the server?? Specials 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 '-20, 20' at line 1 select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 [TEP STOP] Products Expected 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 '-20, 20' at line 1 select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20 [TEP STOP] Manufacturers 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 '-20, 20' at line 1 select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20 [TEP STOP]
241 Posted October 31, 2006 Posted October 31, 2006 this is to do with split page results and newer versions of mysql and is a know bug http://www.oscommerce.com/community/bugs,1605 No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Guest Posted November 1, 2006 Posted November 1, 2006 Thanks Mucho Aprecciated! this is to do with split page results and newer versions of mysql and is a know bug http://www.oscommerce.com/community/bugs,1605
Recommended Posts
Archived
This topic is now archived and is closed to further replies.