On Jan 27, 2016, at 11:55 AM, Michael Munger <[email protected]> wrote: > > Not sure where to report this, so, please someone reply so I can submit the > corrected files. > > I downloaded the latest version of Bacula, and compiled from source. After > running the various scripts to create the MySQL databases, I got a few > errors, but ignored them at first. > > Then, when trying to run the initial backup that comes pre-configured in the > configs, I got this error: > > 27-Jan 11:39 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 > ('BackupClient1.2016-01-27_11.39.03_06','BackupClient1','B','I','C','2016-01-27 > 11:39:01',1453912741,1,'') failed. ERR=Table 'bacula.Job' doesn't exist > > Turns out, the errors (listed below) were causing the corresponding tables to > not be created. > > ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate' > ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime' > ERROR 1067 (42000) at line 145: Invalid default value for 'SchedTime' > ERROR 1067 (42000) at line 187: Invalid default value for 'Date' > ERROR 1067 (42000) at line 201: Invalid default value for 'CreateTime' > ERROR 1067 (42000) at line 225: Invalid default value for 'FirstWritten' > ERROR 1067 (42000) at line 321: Invalid default value for 'Time' > > The problem is the default value for certain DATETIME fields. > > To fix the issue, I did a find and replace over the make_mysql_tables file: > s/DATETIME DEFAULT 0/DATETIME/g
I'm not sure a removing a the default value will help. Perhaps null might help. I advocate using PostgreSQL, but I'm not suggesting you change if you're tied to MySQL. ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
