system32 Posted May 16, 2007 Share Posted May 16, 2007 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 = '55' [TEP STOP] Please help this error :( Link to comment Share on other sites More sharing options...
system32 Posted May 17, 2007 Author Share Posted May 17, 2007 Please help me... this error :( Link to comment Share on other sites More sharing options...
Guest Posted May 17, 2007 Share Posted May 17, 2007 upgrade your store to the latest osc version http://www.oscommerce.com/solutions/downloads It's due to the older osc queries with mysql 5.x. 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.