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
Tweet
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.