Hello, I have try to update bacula database after update Mysql (8.0.17) and bacula ( 9.0.8-r1).
I have get this result and backup don't work ........ : This script will update a Bacula MySQL database from version 12-15 to 16 Depending on the current version of your catalog, you may have to run this script multiple times. mysql: [Warning] Using a password on the command line interface can be insecure. mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1067 (42000) at line 3: Invalid default value for 'FirstWritten' ERROR 1060 (42S21) at line 4: Duplicate column name 'VolParts' ERROR 1067 (42000) at line 5: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 6: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 7: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 13: Invalid default value for 'StartTime' ERROR 1067 (42000) at line 14: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 15: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 16: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 17: Invalid default value for 'StartTime' ERROR 1067 (42000) at line 18: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 19: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 20: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 23: Invalid default value for 'LastWritten' ERROR 1067 (42000) at line 24: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 25: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 26: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 29: Invalid default value for 'SchedTime' Update of Bacula MySQL tables 15 to 16 succeeded. mysql: [Warning] Using a password on the command line interface can be insecure. Thanks, Erwan
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users