madcrazygirl Posted July 31, 2006 Share Posted July 31, 2006 Hi Urgent help required please :'( No idea why but my specials box has disappeared - thought this was simply a column issue but nooooo when I press the other links to specials I get the following error: 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 '-24, 24' 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 -24, 24 [TEP STOP] Do not remember dabbling in anything........... thank you, thank you Link to comment Share on other sites More sharing options...
madcrazygirl Posted July 31, 2006 Author Share Posted July 31, 2006 Ah and now I look in admin they have all become inactive even though in date....... Link to comment Share on other sites More sharing options...
Guest Posted July 31, 2006 Share Posted July 31, 2006 http://www.oscommerce.com/community/bugs,1605 check the fix at the end of the page. Link to comment Share on other sites More sharing options...
madcrazygirl Posted July 31, 2006 Author Share Posted July 31, 2006 Thank you for quick reply. I have tried this but although error message disappears there are still no specials and in admin still inactive........ Any other ideas? Link to comment Share on other sites More sharing options...
madcrazygirl Posted July 31, 2006 Author Share Posted July 31, 2006 Ok hope this helps others. Following reading many threads lol and changing lots of code and not being able to work out why no specials appeared thought would have a go at deleting them and then adding again. And hey this desperate measure works and they now appear again. Bit of a newbie but guess old table was corrupt in some way and needs new info after code edit? 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.