edwinx Posted March 13, 2007 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
edwinx Posted March 13, 2007 Author Posted March 13, 2007 also, would I be able to change the name of "specials" to something else?
Guest Posted March 13, 2007 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
edwinx Posted March 13, 2007 Author 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?
Guest Posted March 13, 2007 Posted March 13, 2007 the osc documentation of the latest release includes instruction for manual upgrade.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.