My website stopped working-help please

[mechpilot]

My catalog has been working fine for over a year and recently I got the following 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 = '21'

[TEP STOP]

 

Please help!

[Guest]

My catalog has been working fine for over a year and recently I got the following 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 = '21'

[TEP STOP]

 

Please help!

 

which page does this happen on? what it is saying is the query can't find that field (p.products_id). Since that is an important field, my guess is you recently made some changes to the query on that page where its looking for that field in the wrong table or that field is really missing from that table. Check your db and make sure nothing was deleted or if you were indeed changing code on that page, undo it and try it. You might want to compare that file to a known good backup as well.

[mechpilot]

I think I got it resolved by having my host revert back to the old mySQL version