looks to me as if this toy (mysql) finally handles invalid
timestamps as erroneous.
Daniel Heitepriem schrieb:
> Hi guys,
>
> any thoughts on this ?
>
> Thanks and regards,
> Daniel Heitepriem
>
> Am 20.09.16 um 12:01 schrieb Daniel Heitepriem:
>
> 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@...:~/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@...:~/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:
> '0000-00-00 00:00:00' for column 'StartTime' at row 1
>
> How can I fix this?
> Thanks you very much.
>
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Mit besten Grüßen / Kind Regards
Andreas Nastke
IT System Management
g/d/p Markt- und Sozialforschung GmbH
Ein Unternehmen der Forschungsgruppe g/d/p
Richardstr. 18
D-22081 Hamburg
Fon: +49 (0)40 / 29876-117
Fax: +49 (0)40 / 29876-127
nas...@gdp-group.com
www.gdp-group.com
Sitz der Gesellschaft ist Hamburg, Handelsregister Hamburg, HRB 40482
Geschäftsführer: Christa Braaß, Volker Rohweder
-----------------------------------------------------------------------
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient please notify the sender and delete
this e-mail from your whole system. Any unauthorised copying, disclosure
or distribution of the material in this e-mail is strictly forbidden.
-----------------------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
