seanb6 Posted March 25, 2006 Posted March 25, 2006 I am constantly getting this error. I have been trying to fix it for week now. 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 = '23'
Guest Posted March 25, 2006 Posted March 25, 2006 get the latest osc upgrade http://www.oscommerce.com/solutions/downloads and change the queries as they're documented in the latest archive. Happens because of mysql v5.x
seanb6 Posted March 26, 2006 Author Posted March 26, 2006 get the latest osc upgradehttp://www.oscommerce.com/solutions/downloads and change the queries as they're documented in the latest archive. Happens because of mysql v5.x thanks how do i change the queries?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.