Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Sub-Category Error


Recommended Posts

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'




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.




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...