Feature request for FOG 1.6.x - Change default mysql date from invalid 00/00/0000

[george1421]

Many of the new implementation of the mysql/mariadb/percona have default settings that are causing issues within fog. Specifically these two parameters are now default when the database starts.

NO_ZERO_IN_DATE and NO_ZERO_DATE

FOG uses a default dates of 00/00/0000 for some fields, which causes an issue when converting the mysql database format from ISAM to INNODB. FOG should pick a valid yet improbable date as a null date like 1/1/1980 (the old folks will know this date) or 1/1/2000 (for the millennial) as the default improbable date instead of 00/00/0000.

ref: https://forums.fogproject.org/topic/14254/high-cpu-usage/9?_=1601237694089

[Tom Elliott]

Fog 1.6 already does this.