On 06/15/16 16:49, Heitor Faria wrote: > Hello, Kern, > > Another Ubuntu 16 issue is running the make_mysql_tables results in error: > > 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 workaround for this is: > > sed -i s/'DATETIME DEFAULT 0'/'DATETIME'/g > /etc/bacula/scripts/make_mysql_tables
OR, you could replace the 0 with a valid DATETIME default value such as '0000-00-00 00:00:00' or '01-01-1970 00:00:00' (the Unix epoch), which would be a more proper fix than just removing the default. MySQL started enforcing valid defaults for DATETIME in the 5.6 branch. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://pubads.g.doubleclick.net/gampad/clk?id=1444514421&iu=/41014381 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
