Guest Posted March 30, 2005 Posted March 30, 2005 I get the following error when entering my specials page please can some one help me 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 '-10, 10' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -10, 10
OceanRanch Posted March 30, 2005 Posted March 30, 2005 Newer versions of mysql do not allow for "negative" limits in the sql statement. This bug report will show you what changes you need to make in split_results.php. http://www.oscommerce.com/community/bugs,1605 HTH Tom
Guest Posted March 30, 2005 Posted March 30, 2005 Newer versions of mysql do not allow for "negative" limits in the sql statement. This bug report will show you what changes you need to make in split_results.php. http://www.oscommerce.com/community/bugs,1605 HTH Tom <{POST_SNAPBACK}> Thanks You are a star... Works fine now
Recommended Posts
Archived
This topic is now archived and is closed to further replies.