Hello everyone,
I updated my old bacula database from version 12 (Bacula version 5.0.0)
to version 15 (Bacula version 7.4.2) which went more or less without
errors (see below):
bacula@backup-host:~/etc$ ./update_mysql_tables -u bacula -p
This script will update a Bacula MySQL database from version 12-14 to 15
Depending on the current version of your catalog,
you may have to run this script multiple times.
Enter password:
Enter password:
ERROR 1067 (42000) at line 19: Invalid default value for 'SchedTime'
Update of Bacula MySQL tables from 12 to 13 succeeded.
Enter password:
Enter password:
Update of Bacula MySQL tables from 13 to 14 succeeded.
Enter password:
Enter password:
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 8: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 9: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 29: Invalid default value for 'SchedTime'
Update of Bacula MySQL tables from 14 to 15 succeeded.
Enter password:
bacula@backup-host:~/etc$
After that I tried to restore a file which gave me this error in bconsole:
20-Sep 13:13 backup-host-dir JobId 0: Fatal error: sql_create.c:86
Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment)
VALUES
('RestoreFiles.2016-09-20_13.13.49_03','RestoreFiles','R','F','C','2016-09-20
13:13:43',1474370023,128,'') failed. ERR=Incorrect datetime value:
'-00-00 00:00:00' for column 'StartTime' at row 1
How can I fix this?
Thanks you very much.
--
Mit freundlichen Gruessen / Best regards
Daniel Heitepriem
pribas GmbH
Valterweg 24-25
65817 Eppstein-Bremthal
Germany
Phone +49 (0) 6198 57146400
Fax +49 (0) 6198 57146433
eMail daniel.heitepr...@pribas.com
Corporate Headquarters: Huenfelden-Dauborn Managing Director: Arnulf Pribas
Registration: Amtsgericht Limburg a. d. Lahn 7HRB874 Tax ID: DE113840457
This e-mail is confidential. Information in this e-mail is intended for
the exclusive use of the individual or entity named above and may
constitute information that is privileged or confidential or otherwise
protected from disclosure. The information in this e-mail may be read,
published, copied and/or forwarded only by the individual or entity
named above. Dissemination, distribution, forwarding or copying of this
e-mail by anyone other than the intended recipient is prohibited. If you
have received this e-mail in error, please notify us immediately by
telephone or e-mail and completely delete or destroy any and all
disseminated, distributed, forwarded electronic or other copies of the
original message and any attachments.
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
