Product search/listing - mysql error

[Forty-two_?]

My ISP's server crashed and they reinstalled mysql. I then reinstated the database from a backup.

 

The home page is ok but after that it all fails.

 

When I try to use "advanced_search_result.php" I get the following error.

 

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

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%coaster%' or p.products_model like '%coaster%' or m.manufacturers_name like '%coaster%') )

 

 

 

"product_info.php?products_id=xx" displays the correct image.

 

The database looks ok ( to an untrained eye).

 

I think I am running version 2.2. The site has been running so smoothly I have not had to work on it for ages.

 

Website www.jsceramics.co.uk

 

 

 

I have looked at the code but it is way over my level of basic php and mysql coding.

 

Can anyone give me a clue as where to start looking ?

 

 

Thank you

 

Stuart

[Nullachtfuffzehn]

It's because of the upgrade to mySQL 5. Check the contrib section for oscommerce patch and install it accordingly.

[Forty-two_?]

It's because of the upgrade to mySQL 5. Check the contrib section for oscommerce patch and install it accordingly.

 

 

 

Thanks, I will try that.

[Forty-two_?]

Thanks, I will try that.

 

 

The mod works fine. I should have asked sooner.

 

Thanks again.