On 10/03/2016 02:52 PM, Phil Stracchino wrote: > On 10/03/16 05:19, Ralph Bolton wrote: >> Yeah, Oracle are making changes alright - not all of them are good :-( >> >> It's a relatively easy to fix, and actually, it's probably something >> that should be changed in the "make_mysql_tables" file supplied with >> Bacula (as it's backwards compatible with older MySQL and MariaDBs). The >> change is a search and replace for: >> >> DATETIME DEFAULT 0, >> >> ...to... >> >> DATETIME DEFAULT '0000-00-00 00:00:00',
Hmm. It doesn't surprise me, but I have not run into the problem you mention below on any of the MySQL versions that are currently in the most popular distros. What MySQL version has that change? Best regards, Kern > > Currently supported versions of MySQL also object (quite rightly) to NOT > NULL without DEFAULT. So > > `JobStatus` binary(1) NOT NULL, > > is not strict SQL compliant. DEFAULT 0 will work fine here. > > > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
