Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!]

2021-06-02 Thread Eric Bollengier via Bacula-users
Hello, On 6/1/21 05:50, Phil Stracchino wrote: > Actually, there is no point to that DROP INDEX operation, because the > entire table is going to be dropped after its replacement is rebuilt anyway. > > What you can (and probably should) do is find the following two lines: > > DROP INDEX IF EXIST

Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!]

2021-06-01 Thread Humphrey Bryant via Bacula-users
...@caerllewys.net ; bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!] These errors might cause errors in use: > ERROR 1067 (42000) at line 53: Invalid default value for 'EventsInsertTime' > ERROR 1146 (42S02) a

Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!]

2021-06-01 Thread Martin Simmons
ntsInsertTime' > ERROR 1146 (42S02) at line 66: Table 'bacula.Events' doesn't exist > Update of Bacula MySQL tables 1021 to 1022 succeeded. > Enter password: > [root@baculaserv bacula]# > > Regards, > Humphrey > ____ > From: Phil Stracchi

Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!]

2021-06-01 Thread Humphrey Bryant via Bacula-users
[Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!] On 5/31/21 3:22 PM, Humphrey Bryant via Bacula-users wrote: > Hi All, > > I had a perfectly good Bacula 9.6.6 Server and upgraded Bacula 9.6.6 to > the new Bacula 11.03 and now my bacula-dir will not start. 🙁 Als

Re: [Bacula-users] Update of Bacula MySQL tables from 16 to 1017 failed. [Help!]

2021-05-31 Thread Phil Stracchino
On 5/31/21 3:22 PM, Humphrey Bryant via Bacula-users wrote: > Hi All, > > I had a perfectly good Bacula 9.6.6 Server and upgraded Bacula 9.6.6 to > the new Bacula 11.03 and now my bacula-dir will not start. 🙁 Also the > database upgrade was not done automatically even though I used > slanesh-Bacul