older OSCommerce + mySQL 5.0 Compatibility Workaround

When upgrading an OSCommerce installation to a mysql 5.0 server, you will need to modify the source code of OSC to get it to work correctly with the database. The reason for this is because MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode.

Here is a detailed article indicating what needs to be changed (line numbers may vary from installation to installation):

http://erikimh.com/osc-mysql5.0-compatibility.php

Share on Facebook