On 08/06/18 15:32, Tilman Schmidt wrote: > Am 02.08.2018 um 23:47 schrieb Phil Stracchino: >>> >>> Minimal fix: >> >> ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL; > > Thanks. I extended that to: > > ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL; > ALTER TABLE Media MODIFY LastWritten datetime DEFAULT NULL; > ALTER TABLE Media MODIFY LabelDate datetime DEFAULT NULL; > ALTER TABLE Media MODIFY InitialWrite datetime DEFAULT NULL; > > Now I can label volumes on that machine without a problem.
Yup, all the DATETIME fields would have to be modified. Also, just so you know, you could do that as a single operation: ALTER TABLE Media MODIFY FirstWritten datetime DEFAULT NULL, MODIFY LastWritten datetime DEFAULT NULL, MODIFY LabelDate datetime DEFAULT NULL, MODIFY InitialWrite datetime DEFAULT NULL; -- 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
