osCommerce MS2.2 bug fixes for errors caused by upgrades to PHP5 and MySQL5 based servers and hosting inviroments.

osCommerce MS2.2 works well on PHP4 and MySQL4, but for those who have not installed the latest version moving to PHP5 and MySQL5 will give rise to some errores and problems.

This also applies to a large number of osCommerce powered Monster Template web shop templates, which needs the same fixes to work on PHP5 and MySQL5.

The newest version of osCommerce v2.2 is compatible with PHP5 and MySQL5, and by going to the osCommerce download site you can get the latest version which also have manual upgrade instructions for older versions included in the package.

But for some upgrading to osCommerce RC1, RC2 or RC2a can cause problems with already installed osCommerce contributions and cause these not to work correctly anymore.

So under you can find some links to ressurces for upgrading the most commone errors without the need for a full upgrade.

If you your hosting or server provider have recently upgraded to PHP5 and MySQL5 and you get this error, 1054 – Unknown column ‘p.products_id’ in ‘on clause’  in your oscommerce or oscommerce template shop then you can find the solution here: Fix for 1054 – Unknown column ‘p.products_id’ in ‘on clause’

A slightly outdated contribution package for making older oscommerce MS2.2 PHP5 and MySQL5 compatible can be found here: File changes needed to work with PHP5 and MySQL5