What does this error mean and how to fix problem?

[cballin]

Hi every one. I was deleting out of stock items from my website and started udating new pics and products. As I viewed website after I uploaded a few pics and click on a Top catagory, I got this error 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 = '443'

 

[TEP STOP]

 

Would any one know what I did to get this message or have any idea on how to rectify this error. Any help would be greatly appreciated. Thanks

[Jack_mcs]

It's a mysql compatibility problem. The fix is in the oscommerce patches contribution.

 

Jack

[cballin]

It's a mysql compatibility problem. The fix is in the oscommerce patches contribution.

 

Jack

 

Thanks Jack but I have not had much luck with contributions and patches. I dont have a clue as to how to install them or get them to work. I have been trying to figure out how to install Google Checkout Contribution for about 4 months. Could you tell me where do i install patch?

[Jack_mcs]

In the instructions for that contribution, it mentions what it is fixing. You just find the section that applies to your problem (compatibility) and install those changes. It would be best to do them all but it isn't required.

 

Jack