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 = '23'
from hosting company
After the recent MySQL server upgrade you might be getting the following errors in some of the forums installed on our servers,
"#1054 - Unknown column 'xxxx' in 'on clause'"
This is the error on MySQL 5, but it's working fine in MySQL 4.1
You need to redefine the Join query in the script or could use some readymade fixing by searching in Search Engines.
Detailed MySQL documentation on 'Join':
[url removed, login to view]