Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

What does this error mean and how to fix problem?


Recommended Posts

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'




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

Link to comment
Share on other sites

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




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?

Link to comment
Share on other sites

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.



Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...