On Thursday, February 6, 2020 at 2:30:27 AM UTC+3, Thomas Kimpel wrote: > > My Upgrade failed, the database upgrade script put out an error > > Tried to run the script separately, i got this: > > root@backup:/usr/lib/bareos/scripts# ./update_bareos_tables > Updating mysql tables > Upgrading database schema from version 2171 to 2192 > ERROR 1064 (42000) at line 6: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'IF NOT EXISTS jobtdate_idx ON Job (JobTDate)' at line 1 > Failed to upgrade database schema from version 2171 to 2192 > root@backup:/usr/lib/bareos/scripts# > > > > System is Ubuntu 18.04, database is MySQL, all on newest release > > > Thomas >
change string CREATE INDEX jobtdate_idx ON Job (JobTDate); -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/a5f63c48-8ea8-40be-9ddb-47bb8f522c47%40googlegroups.com.
