Upgrade 18.2.5 to 19.2.5 failed while upgrading database

[Thomas Kimpel]

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

[hell...@gmail.com]

change string CREATE INDEX jobtdate_idx ON Job (JobTDate);

[Frank Bergkemper]

A bug report has been created, please see
https://bugs.bareos.org/view.php?id=1176 .

A fix will follow as soon as possible.

Best Regards,
Frank

Am 06.02.20 um 06:50 schrieb hell...@gmail.com:

> --
> 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 bareos-users...@googlegroups.com
> <mailto:bareos-users...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/bareos-users/a5f63c48-8ea8-40be-9ddb-47bb8f522c47%40googlegroups.com
> <https://groups.google.com/d/msgid/bareos-users/a5f63c48-8ea8-40be-9ddb-47bb8f522c47%40googlegroups.com?utm_medium=email&utm_source=footer>.


--
Frank Bergkemper frank.be...@bareos.com
Bareos GmbH & Co. KG Phone: +49-221-630693-94
http://www.bareos.com

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz