limfan Posted January 31, 2009 Share Posted January 31, 2009 I just installed my OSC and the site is working fine except when i click on the categories, i was shown the following 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 = '21' [TEP STOP] Can anyone kindly advise me on how to resolve the above? Thank you so much. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 31, 2009 Share Posted January 31, 2009 You have installed an old version either install the latest version or see the patches link in my signature block. 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 ======>>>>>. 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.