bagheera202 Posted August 20, 2010 Share Posted August 20, 2010 I am receiving the following error when you click on the sub-category link on the left column: 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 = '20' [TEP STOP] When you click on the category link on the left column it works fine it brings you to the category area and you can click on products that are in that category, but if you then click on the sub-category on the left column, it brings up the error message listed above. Am I missing something or what do I need to do to correct this error message. Any help is greatly appreciated. Thanks, bagheera202 Link to comment Share on other sites More sharing options...
FIMBLE Posted August 20, 2010 Share Posted August 20, 2010 try this post http://www.oscommerce.com/forums/topic/263592-1054-unknown-column-pproducts-id-in-on-clause/ Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
bagheera202 Posted August 21, 2010 Author Share Posted August 21, 2010 Thank you FIMBLE! That thread fixed the problem. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.