https://bugs.kde.org/show_bug.cgi?id=379987
Bug ID: 379987
Summary: UpdateSchemaFromV7ToV8: Unable to execute query (MySQL
specific)
Product: digikam
Version: 5.5.0
Platform: Gentoo Packages
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-devel at kde.org
Reporter: bbc.quincy at gmx.de
Target Milestone: ---
Starting digikam 5.5.0 for the first time after upgrading from (likely) 4.14 it
reports the following error:
digikam.dbengine: Loading SQL code from config file
"/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected: 3 found: 3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: have a structure version 7
digikam.coredb: Core database: makeUpdates 7 to 8
digikam.dbengine: Failure executing query:
""
Error messages: "QMYSQL: Unable to execute query" "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 EXISTS identifier' at line 2" 1064 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ]
Statement [ "ALTER TABLE AlbumRoots\n
DROP INDEX IF EXISTS identifier;" ]
digikam.coredb: Core database: schema update to V 8 failed!
digikam.coredb: Core database: cannot process schema initialization
My database is running on a local MySQL Server version 5.6.35.
Obviously this part was introduced as a fix for bug #372312.
According to the MySQL documentation this syntax is not supported by my MySQL
version or the following one, but by MariaDB (as in the mentioned bug) and
others.
--
You are receiving this mail because:
You are the assignee for the bug.