Why getting this error message when clicking on menu product items? 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 = '45' [TEP STOP]
select count(p.products_id) as total from products_description as pd, products as 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 = '45' perhaps that will help...you forgot the AS on the table names.
Until yesterday, the site was running fine and today I simply changed the name server with the new hosting company I signed up. So how come it showing this error all of sudden? Its puzzling to me.
First let me know which database you are using. If it is MySQL, then you should be aware left join is supported in previous versions of MySQL5. Check it from your hosting provider which version of MYSQL they are providing.