On 06/16/16 04:29, Kern Sibbald wrote:
> For Bacula, the solution is even simpler, simply delete or the DEFAULT
> 0. Bacula does use the value 0, which MySQL unsuccessfully attempts to
> outlaw, and it is absolutely critical to use with Bacula, but Bacula
> will set it itself even if it is not
For Bacula, the solution is even simpler, simply delete or the DEFAULT
0. Bacula does use the value 0, which MySQL unsuccessfully attempts to
outlaw, and it is absolutely critical to use with Bacula, but Bacula
will set it itself even if it is not the default value.
On 06/15/2016 10:56 PM, Ph
Hello Heitor,
This is fixed in 7.4.1. The problem originates from MySQL version 5.7
no longer permitting a DEFAULT 0 on a timestamp. However, a timestamp
in MySQL is nothing other than a Unix/Linux time/date, which is nothing
other than a simple integer, and the value 0 is a perfectly valid
On 06/15/16 16:49, Heitor Faria wrote:
> Hello, Kern,
>
> Another Ubuntu 16 issue is running the make_mysql_tables results in error:
>
> ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate'
> ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime'
> ERROR 1067 (42
Hello, Kern,
Another Ubuntu 16 issue is running the make_mysql_tables results in error:
ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate'
ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 145: Invalid default value for 'SchedTim
