Website Issues-Products Not working?

[robertw477]

Since last night my site/products have not been functional. I have never had a problem like this and I need to know if this is an issue with oscommerce, or the webhost?

 

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

 

[TEP STOP]

 

http://www.bigapplecard.com/ncaa-college-products-c-127.html

 

I have not done any changes or modifications on the site.

 

Robert

[FIMBLE]

http://www.oscommerce.com/community/contributions,4654

try this

[gold682]

Since last night my site/products have not been functional. I have never had a problem like this and I need to know if this is an issue with oscommerce, or the webhost?

 

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

 

[TEP STOP]

 

http://www.bigapplecard.com/ncaa-college-products-c-127.html

 

I have not done any changes or modifications on the site.

 

Robert

 

Hi,

I recently had the same issue. It was caused by me web host upgrading MySQL to v5. MySQLv5 is stricter in what it allows in the code and this is causing your problems. There is a contribution that you can apply which should fix your problems.

 

See here : 1054 - MySQL5 fix

 

Cheers

Paul