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

2021-06-01 Thread Humphrey Bryant via Bacula-users
OK, Thanks for pointing that out. How can I correct these errors? Will it corrupt my database or prevent me from backing up and restoring files? Regards, Humphrey From: Martin Simmons Sent: Tuesday, June 1, 2021 10:39 AM To: Humphrey Bryant Cc: ph...@caerlle

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

2021-06-01 Thread Martin Simmons
These errors might cause errors in use: > ERROR 1067 (42000) at line 53: Invalid default value for 'EventsInsertTime' > ERROR 1146 (42S02) at line 66: Table 'bacula.Events' doesn't exist It looks like commit 48905baa40933ad4bab45b1557b2caa0e4994c5d is also needed for update_mysql_tables.in. __Ma

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

2021-06-01 Thread Humphrey Bryant via Bacula-users
Hey Phil, Thank you very much, I deleted the 2 lines that you suggested and ran the script again and it took about 20-30 minutes to update/convert the database successfully, I had to enter my MYSQL password multiple times before its completed. My Bacula Server is up and running again and I am