Invalid default value '0000-00-00'

If you get an error during step 5 of the installation process saying something about Invalid default values, it is probably related to MySQL configuration.

MySQL has what they call SQL Modes, and one of them is whether to allow non real dates like '0000-00-00' or not. This config is called NO_ZERO_DATE. Family Connections requires this config to be turned off.

How to fix it

  1. If you have access to my.ini (the mysql configuration file)

Then, just remove the NO_ZERO_DATE option from the SQL_MODE configuration

Recent Discussions

05 Oct, 2020 12:05 PM
05 Oct, 2020 11:56 AM
09 Aug, 2020 07:49 PM
02 Aug, 2020 04:59 AM
25 Jul, 2020 03:29 PM