You can check in phpmyadmin by running this
Code: Select all
SELECT @@sql_mode;
Code: Select all
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
Code: Select all
SET @@sql_mode = sys.list_drop(@@sql_mode, 'STRICT_TRANS_TABLES');
Also note that turning it off this way is not permanent, so restarting apache will enable strict mode again. To turn it off permenantly youll need to edit my.cnf and youll also want to remove NO_ZERO_IN_DATE, NO_ZERO_DATE and ERROR_FOR_DIVISION_BY_ZERO as they are all part of mysql strict mode