Regarding the strict mode issue in mySQL 5, disabling it will correct the problem.
Find your installation directory and edit my.ini
FIND:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
REPLACE WITH:
sql-mode=""
Of course, this is at your own risk. This disables MySQL’s strict mode, which we are doing since it is only for an internal program. Please remember you are responsible for your own actions