The cleaner but more complicated fix is when you upgrade to a newer
version of MySQL, update to the latest version of Bacula, which should
solve your problem.
On 28/10/2016 02:45, Phil Stracchino wrote:
> 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.
>
>
------------------------------------------------------------------------------
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
