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

Reply via email to