Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+\'Incorrect\s+datetime\s+value\'\s+after\s+database\s+update\s+from\s+12\s+to\s+15\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[Bacula\-users\]\s+\'Incorrect\s+datetime\s+value\'\s+after\s+database\s+update\s+from\s+12\s+to\s+15\s*$/: 8 ]

Total 8 documents matching your query.

1. [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Daniel Heitepriem <daniel.heitepriem AT pribas DOT com>; Date: Tue, 20 Sep 2016 13:59:56 +0200; 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:~/e; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00056.html (15,551 bytes)
2. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Daniel Heitepriem <daniel.heitepriem AT pribas DOT com>; Date: Fri, 30 Sep 2016 08:35:51 +0200; 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; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00122.html (12,704 bytes)
3. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Andreas Nastke <nastke AT gdp-group DOT com>; Date: Fri, 30 Sep 2016 10:49:07 +0200; looks to me as if this toy (mysql) finally handles invalid timestamps as erroneous. Daniel Heitepriem schrieb: -- Mit besten Grüßen / Kind Regards Andreas Nastke IT System Management g/d/p Markt- und; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00123.html (14,932 bytes)
4. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Daniel Heitepriem <daniel.heitepriem AT pribas DOT com>; Date: Fri, 30 Sep 2016 12:50:12 +0200; 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; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00124.html (15,807 bytes)
5. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Kern Sibbald <kern AT sibbald DOT com>; Date: Fri, 30 Sep 2016 14:29:32 +0200; This is due to a change in MySQL. There are various workarounds, the first one to start with is to get the latest 7.4.4 release. I thought it was fixed in 7.4.2 but maybe it was 7.4.3. If that does; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00125.html (15,160 bytes)
6. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Kern Sibbald <kern AT sibbald DOT com>; Date: Fri, 30 Sep 2016 14:31:22 +0200; Yes, MySQL now treats 0 timestamps as erroneous, which is rather simple minded, since 0 is a perfectly valid Unix timestamp value. -- _______________________________________________ Bacula-users mail; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-09/msg00126.html (15,538 bytes)
7. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: asari <asari.takashi AT gmail DOT com>; Date: Thu, 29 Dec 2016 11:25:40 -0700 (MST); It looks like you are using relatively new MySQL server which has stricter policies. http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes My workaround was to dump, sed and restore f; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-12/msg00006.html (12,128 bytes)
8. Re: [Bacula-users] 'Incorrect datetime value' after database update from 12 to 15 (score: 1): Author: Phil Stracchino <phils AT caerllewys DOT net>; Date: Thu, 29 Dec 2016 19:31:01 -0500; Well, you COULD do it that way. Or you could temporarily disable no-zero-date and no-zero-in-date in SQL_MODE, do a couple of UPDATE operations to change all 0000-00-00 00:00:00 dates to 1970-01-01 0; /usr/local/webapp/mharc-adsm.org/html/Bacula-users/2016-12/msg00007.html (12,349 bytes)

Current List: 1 - 8
Page: [1]