On 08/07/18 08:27, Martin Simmons wrote: >>>>>> On Mon, 6 Aug 2018 20:13:17 -0400, Phil Stracchino said: >> >> On 08/06/18 20:05, George Anchev via Bacula-users wrote: >>> Today I installed 9.2.0 FD on one of the network >>> workstations. Trying to run an estimate for an >>> incremental job tells me that "Job 0" cannot find >>> previous Full backup, so it will estimates a full one. >>> >>> My workaround with changing the SQL_MODE didn't work >>> in this case. >>> >>> On Mon, 6 Aug 2018 16:37:02 -0400 Phil Stracchino >>> wrote: >>> >>>> ALTER TABLE Media >>>> MODIFY FirstWritten datetime DEFAULT NULL, >>>> MODIFY LastWritten datetime DEFAULT NULL, >>>> MODIFY LabelDate datetime DEFAULT NULL, >>>> MODIFY InitialWrite datetime DEFAULT NULL; >>> >>> Can anyone please confirm if that is all that is >>> required to get rid of all these MariaDB related >>> issues? Also - how safe is it? (I really know very >>> little about DBs). >> >> You probably need to go through each table and change any field (except >> BLOB or TEXT) that is declared NOT NULL without a DEFAULT to 'DEFAULT NULL'. > > I think you mean "that is *not* declared NOT NULL" (a field that is declared > NOT NULL cannot have 'DEFAULT NULL').
I think you inferred something different than what was said. See the example above where Media.FirstWritten is changed from 'datetime NOT NULL' to 'datetime DEFAULT NULL'. You're correct that 'NOT NULL DEFAULT NULL' is obvious nonsense. In fact it will crash some releases of MySQL. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ 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
