godaisy Posted November 15, 2007 Posted November 15, 2007 A site I designed last year for a friend has started displaying error messages whenever the user clicks to view an individual product. If you click on an individual product from the home page "new products", it displays with no problems. But if you select it from the categories box, once you get to the individual product it always gives this 1054 error message: 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 = '120' [TEP STOP] Neither I nor the owner have changed anything on the site since spring & it was working fine then, he asked me if he needs to upgrade to resolve the issue but I have no idea. Any help would be appreciated.
♥geoffreywalton Posted November 15, 2007 Posted November 15, 2007 Has your isp upgraded to php5 Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
♥geoffreywalton Posted November 15, 2007 Posted November 15, 2007 Try http://www.oscommerce.com/forums/index.php?showtopic=263592 Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
godaisy Posted November 15, 2007 Author Posted November 15, 2007 Aahh thanks for the link, I had done a previous search but couldn't find anything. I will check with him on his isp too
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.