Dreded 1054 error...HELP

[kawagner]

Help- I have not been in my catalog in a while and from what I can tell someone else had a simular problem beucase her host co upgreaded there version of php - but she does not say what the fix was. Here is what I'm getting:

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

 

[TEP STOP]

 

Help - I cant access any of my items from the categories section or access my printable catalog - I get the same message on all those links?

 

:'(

[WoundedPaw]

I just discovered the same error.

Any solutions?

[kawagner]

I just discovered the same error.

Any solutions?

 

 

I'm headed to this link to try it I will keep you posted. http://www.oscommerce.com/ext/update-20051...l#_Toc119473702 I found it under the bug reports. I will try to get it done today but if not I ncat get it finished until Tuesday of next week. Not sure if you will ahve more time or not. Her is the link to the bug report also. http://www.oscommerce.com/community/bugs,3...2B%28General%29

 

Keep me posted and I will do the same.

[kawagner]

I'm headed to this link to try it I will keep you posted. http://www.oscommerce.com/ext/update-20051...l#_Toc119473702 I found it under the bug reports. I will try to get it done today but if not I ncat get it finished until Tuesday of next week. Not sure if you will ahve more time or not. Her is the link to the bug report also. http://www.oscommerce.com/community/bugs,3...2B%28General%29

 

Keep me posted and I will do the same.

 

 

Hello - I just finished going thru the steps for the MySQL 5.0 Compatibility and it worked - the only problem I have now is the 104 error on my printable catalog, but at least I can access my products now. Good luck. Kim

[jasonabc]

This is caused by a switch from MySQL 4.1 to MySQL 5. Go here and scroll down to the post made on 9 Jan 2006 05:25:14 for the fix:

 

http://www.oscommerce.com/community/bugs,3171