On 10/27/16 20:14, Michael Munger wrote:
> Upgraded to MySQL 5.7 today. Now Bacula is upset. When I tried to run a
> job, I got an instant failure:
>
> 27-Oct 20:10 d8-dir JobId 0: Fatal error: sql_create.c:86 Create DB Job
> record INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment)
> VALUES
> ('SERVER01.2016-10-27_20.10.41_33','SERVER01','B','I','C','2016-10-27
> 20:10:39',1477613439,7,'') failed. ERR=Incorrect datetime value:
> '0000-00-00 00:00:00' for column 'StartTime' at row 1
>
> What's the fix here?
The quick and dirty fix is to remove NO_ZERO_DATE and NO_ZERO_IN_DATE
from the SQL_MODE configuration variable.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: 603.293.8485
------------------------------------------------------------------------------
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive.
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
