Error in menu

[ecorepair]

HI EVERYBODY,

 

I HAVE A PROBLEM THAT COMES OUT WHEN YOU CLICK ON A CATEGORY IN THE MENU

 

THIS IS THE ERROR THAT COMES OUT

 

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 = '3' and p2c.categories_id = '8'

[TEP STOP]

 

WHAT COULD THIS BE ?

[developer_x]

It is always a good idea to first search the existing forum threads as usually the problem and the solution both are available already.

 

Regarding your problem, please refer to this thread.