ezsmurf30 Posted October 22, 2007 Share Posted October 22, 2007 My oscommerce site has started showing the following error when you click on a product: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '233' I didn't make any changes at all that could have caused this. It's awful and I have no idea what happened - it has been working fine for months and then suddenly this happened. if anyone can help I'd really appriciate it, the website is: www.eventwindow.eu. Thank you very much Link to comment Share on other sites More sharing options...
Gauravs Posted October 22, 2007 Share Posted October 22, 2007 Most likely your host has upgraded mysql to version 5. If that is the case, please search forum - and you would get instructions on how to modify query to make it work again. Best Regards,Gaurav Link to comment Share on other sites More sharing options...
Guest Posted October 23, 2007 Share Posted October 23, 2007 at host-try to repair the dbase.It my get corupted.At dbase setting at host there is option to check/repair.Check it and then repair. 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.