edwinx Posted March 13, 2007 Share Posted March 13, 2007 Hi, when trying to go to the specials.php page, I get 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_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 -9, 9 any idea? the specials box in the left side was removed, so i tried to access the specials.php directly. I am using MySQL 4.1.14 and PHP Version 4.3.11 Link to comment Share on other sites More sharing options...
edwinx Posted March 13, 2007 Author Share Posted March 13, 2007 also, would I be able to change the name of "specials" to something else? Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2007 Share Posted March 13, 2007 upgrade to the latest osc http://www.oscommerce.com/solutions/downloads this particular issue is documented here. http://www.oscommerce.com/community/bugs,1605 Link to comment Share on other sites More sharing options...
edwinx Posted March 13, 2007 Author Share Posted March 13, 2007 upgrade to the latest osc http://www.oscommerce.com/solutions/downloads this particular issue is documented here. http://www.oscommerce.com/community/bugs,1605 thanks. most of the pages are heavily customized. what is the best way to upgrade? would I have to redo my changes again? Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2007 Share Posted March 13, 2007 the osc documentation of the latest release includes instruction for manual upgrade. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.