Im not a MySQL crack but "EXPLAIN Job;" results in
[...]
Field                 |   Type                | Null  |Key| 
Default                        | Extra      |

SchedTime       | datetime            | YES  |     | 0000-00-00 00:00:00 
|                |
StartTime         | datetime            | YES  |     | 0000-00-00 
00:00:00 |                |
EndTime           | datetime            | YES  |     | 0000-00-00 
00:00:00 |                |
RealEndTime     | datetime            | YES  |     | 0000-00-00 00:00:00 
|                |
[...]

and also an querying an entry of the old data results in displaying 
correct values:

JobId     | Job | Name         | SchedTime                  | 
StartTime                    | EndTime

179281 | server1.db.2016-09-12_19.30.17_10 | server1.db | 2016-09-12 
19:30:17 | 2016-09-13 12:58:15 | 2016-09-13 12:58:16

It would be really interesting how Bacula 7 is handling this timestamp 
thing when generating the SQL-command

Am 30.09.16 um 10:49 schrieb Andreas Nastke:
> 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 AT lists.sourceforge DOT net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users