#1 you can also do yourself; just update your includes/configure.php file to add

define('DB_MYSQL_MODE','NO_ENGINE_SUBSTITUTION');