Desperate fix needed-

[obsolete]

Hi,

 

On my live store, when you click a catagory in the Catagories box, you get this message:

 

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

 

[TEP STOP]

 

This worked just fine until recently, not sure how I could have screwed it up. I was using the Category_box_enhancement_V2_pt contrib, which has been fine for a year. I don't think the problem is with that, as the problem remains when I reverted to the default box. I tried some suggestions posted here for similar problems (such as having the Admin:Use Search-Engine Safe URLs set to "false"), but none have helped.

 

A free DVD from my site to the person(s) who help me solve this! :thumbsup:

 

http://www.yammeringmagpie.com

 

Thanks......

[jasonabc]

This is usually caused by an upgrade from MySQL 4 to MySQL 5. Your host may have done this recently which is now causing the error.

 

Search for the error message on Google - there are plenty of results and fixes. Here's one:

 

http://www.oscommerce.com/forums/index.php?showtopic=263592

[obsolete]

Thanks!

 

It worked like a charm! My host did just upgrade to PHP 5- I thought they would email me an advance warning, but they didn't.

 

I'm going to PM you....