1054 - Unknown column 'p.products_id' in 'on clause'?

[Isiah]

When i click on a category then a sub category i get

 

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 = '13'

 

[TEP STOP]

 

Is there any way someone could give me step by step instructions on what to do i would really appreciate it.

[BryceJr]

This is such a common problem, usually after an upgrade.

Instructions to deal with this is in the CONTRIBUTION section.

[MrPhil]

Are you using MySQL version 5? osC has problems with that level -- you need to find and fix all SQL "JOIN" statements that have a comma-separated list of tables between FROM and JOIN. For this particular error, find the PHP code to produce the listed error, and add parentheses around the table list. Once fixed, the query will look like this (and should not produce the error):

 

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 = '13'