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

[benwalsh]

my oscommerce has stopped workin we are getting the following error any thoughts PLEASE

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

[Jack_mcs]

It's a known compatiblity problem (your host probably updated mysql). The fix is in the updates for oscommerce. There is also a contribution that lists it (search for oscommerce patch).

 

Jack

[benwalsh]

Jack is right, I tried some of the update and it fixed some of the problem, i do not have time to do it all any one care to help?

[Jack_mcs]

There are only two in the updates - index.php and advanced_search_results.php. If you have more than that, they are most likely caused by contributions you have installed. In that case, you would have to isolate which contribution is causing the problem and check the updates for it in the contributions section. Many of them have such updates.

 

Jack