Guest Posted March 30, 2005 Share 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 Link to comment Share on other sites More sharing options...
OceanRanch Posted March 30, 2005 Share 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 Link to comment Share on other sites More sharing options...
Guest Posted March 30, 2005 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.