Diabolic Posted November 8, 2005 Share Posted November 8, 2005 When I click on a category, I get this error: 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 = '28' Could someone please help me resolve this? Everything else seems to be working. Link to comment Share on other sites More sharing options...
MarcoZorro Posted November 8, 2005 Share Posted November 8, 2005 Sounds like you are using mysql 5... Change p.products_id = s.products_id to p2c.products_id = s.products_id Link to comment Share on other sites More sharing options...
Diabolic Posted November 8, 2005 Author Share Posted November 8, 2005 Sounds like you are using mysql 5... Change p.products_id = s.products_id to p2c.products_id = s.products_id Indeed I am. Thank you, I'll try that. Should that change be made at every occurrence in every page? Link to comment Share on other sites More sharing options...
MarcoZorro Posted November 8, 2005 Share Posted November 8, 2005 Should that change be made at every occurrence in every page? Take a look at this thread http://www.oscommerce.com/forums/index.php?showtopic=179130 It should get you going in the right direction. 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.