It looks like you are using relatively new MySQL server which has stricter policies.
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes My workaround was to dump, sed and restore from backup, i.e.: $ sed -e 's/0000-00-00 00:00:00/1970-01-01 00:00:00/g' \ ... < /tmp/var/lib/bacula/bacula.sql \ ... | mysql -ubacula -p bacula -- View this message in context: http://bacula.10910.n7.nabble.com/Incorrect-datetime-value-after-database-update-from-12-to-15-tp84501p85064.html Sent from the Bacula - Users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users