Re: [Bacula-users] bacula.Job does not exist

On Jan 27, 2016, at 11:55 AM, Michael Munger <michael AT highpoweredhelp DOT 
com> 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
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users