Quick and dirty fix for now. "Correct" fix later.
Thank you!
Michael Munger, dCAP, MCPS, MCNPS, MBSS
High Powered Help, Inc.
Microsoft Certified Professional
Microsoft Certified Small Business Specialist
Digium Certified Asterisk Professional
mich...@highpoweredhelp.com
On 10/28/2016 06:16 AM, Kern Sibbald wrote:
> 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
------------------------------------------------------------------------------
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
