https://bugs.kde.org/show_bug.cgi?id=394291
Bug ID: 394291 Summary: cannot upgrade mysql db from v7 to v9 Product: digikam Version: 5.9.0 Platform: Other OS: Linux Status: UNCONFIRMED Severity: major Priority: NOR Component: Database-Mysql Assignee: digikam-bugs-n...@kde.org Reporter: k...@forum.titlis.org Target Milestone: --- When I run Digikam 5.9 the first time, the mysql db is upgraded to v9. The upgrade failed with the error message: Error messages: "QMYSQL: Unable to execute query" "BLOB/TEXT column 'name' used in key specification without a key length" 1170 2 Bound values: () digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ] Statement [ "ALTER TABLE Images MODIFY COLUMN name LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;" ] digikam.coredb: Core database: schema update to V 9 failed! Deleting the guilty index solved the issue for me ALTER TABLE Images DROP INDEX image_name_index; Is that a problem in general or where does my index coming from? Do I need to recreate it manually? PS: I still cannot convert to v9, but these are other issues, to be investigated -- You are receiving this mail because: You are watching all bug changes.