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: [email protected]
Reporter: [email protected]
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.
