Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error when I select a category


Guest

Recommended Posts

When I click on a category a 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 = '42'

 

[TEP STOP]

 

 

Any idea ?

 

Thanks, Jan

Link to comment
Share on other sites

mysql 5.x issue. Install the latest osc upgrade from the downloads section. Or follow the manual instructions to upgrade your store.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...