Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sub-Category Error


bagheera202

Recommended Posts

Posted

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

Archived

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

×
×
  • Create New...