>>>>> On Tue, 7 Aug 2018 13:14:00 -0400, Phil Stracchino said: > > 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'.
OK, but AFAICS these fields were never 'datetime NOT NULL' (just 'datetime'). I thought NULL is supposed to be the default default anyway, but maybe not in MariaDB. __Martin ------------------------------------------------------------------------------ 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
