Control: reassign -1 bacula-director-mysql Hi,
> since some days I get this and all job fails: > > [quote] > 03-Feb 12:05 merkur.jff-webhosting.net-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 > ('merkur-data.2017-02-03_12.05.01_04','merkur-data','B','I','C','2017-02-03 > 12:05:01',1486119901,2,'') failed. ERR=Incorrect datetime value: '0000-00-00 > 00:00:00' for column 'StartTime' at row 1 > [/quote] > > I you need more infos pleas ask. while you didn't say so in your bug report, I suppose you are using a MySQL-Database. Your problem is discussed here: https://sourceforge.net/p/bacula/mailman/bacula-users/thread/30db3ed3-64e9-53f6-8b65-8147a9575776%40caerllewys.net/#msg35406296 So, did you upgrade your MySQL-Server just before the errors started occuring? If yes, from which version to which? Or did you maybe purge your MySQL-Server and then reinstalled a newer version or something like that? - Carsten