While putting together EEClassifieds, I came across some SQL errors with default MySQL 5.7 settings. The site is using MySQL 5.7.
References:
http://stackoverflow.com/questions/14625191/error-code-1292-incorrect-date-value-mysql
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
- Date Values cannot be all zeros (YYYY-MM-DD = 0000-00-00)
Invalid Default Value (Error 1067)
Example: struct.sql CREATE TABLE /*TABLE_PREFIX*/t_user
Incorrect Date value (Error 1292)
Example: basic_data.sql INSERT INTO /*TABLE_PREFIX*/t_cron (e_type, d_last_exec, d_next_exec) VALUES
One way to remove the restriction is re-defining 'sql-mode' system variable to omit the 'NO_ZERO_DATE' mode - Some OSClass SQL statements would fail because of default GROUP_BY restrictions imposed by default in MySQL 5.7.
One way to remove the restrictions is re-defining 'sql-mode' system variable to omit 'ONLY_FULL_GROUP_BY' mode
References:
http://stackoverflow.com/questions/14625191/error-code-1292-incorrect-date-value-mysql
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html