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

[Guest]

This is what I get when I try to browse my os commerce catalog.Instead of viewing my items. is ee

 

 

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

 

What is this. I have no Idea what cuased it or how to fix it, and my website is usless if I cant fix it.

 

here is a url where it occures.

http://getoutandplaysports.com/v-web/ecomm...afb9edc969e2c64

 

if someone can help I will be eternally grateful.

 

Thanks

[email protected]

[jhsands]

I'm not much help on this but try http://www.oscommerce.com/community/bugs,3...;+Configuration

and google for "1054 - Unknown column 'p.products_id' in 'on clause'" ... lots of hits.

 

Someone that knows something will come along soon. :)

[spax]

If you wasn't getting this error, then all of a sudden it appeared, it seems your host has upgraded MySql 5 and you have an older version of osC (or you installed a mod that uses an older index.php file).

 

Go to this link http://www.oscommerce.com/ext/update-20051113.html to see how to upgrade. The section MySQL 5.0 Compatibility obviously applies to you.