Hello, It sounds like this is another change in MySQL in a newer
version. Previously they prohibited a DEFAULT 0 for the start
time, because zero is not a permitted value, even though the field
is a Unix Time stamp, where 0 is a perfectly valid time.
Consequently we removed the DEFAULT. Apparently, they now require
a start time. The problem is that Bacula counts on the default
start time to be zero in some of the database records (the Media
record I think). Note: in the Job record, there is no start time
when the Job is created. The start time is known only when the
Job begins running, so the default value must be zero. So, I can see a few possible solutions: 1. Modify the make_mysql_tables that creates the Job record to
include DEFAULT '0000-00-00 00:00:00'. 2. Fall back to an older version of MySQL. 3. Research if they permit some other way of setting a default value of zero. 4. Use MariaDB but not version 10.2.x 5. Use PostgreSQL (this is my preferred solution). Best regards, Kern
On 07/16/2017 09:28 AM, Mick wrote:
Hi, |
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users