https://bugs.kde.org/show_bug.cgi?id=391340
Bug ID: 391340
Summary: Mysql Migration fails (makeUpdates 8 to 9)
Product: digikam
Version: 5.8.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Migration
Assignee: digikam-bugs-n...@kde.org
Reporter: danielbl...@gmail.com
Target Milestone: ---
Mysql migration from schema 8 to 9 fails.
I'm running Ubuntu 16.04 and mysql 5.7.21-0.
digikam.dbengine: Loading SQL code from config file
"/tmp/.mount_digikazndF4k/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 8
digikam.coredb: Core database: makeUpdates 8 to 9
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 'IGNORE TABLE AlbumRoots\n
ADD UNIQUE (iden' at line 1" 1064 2
Bound values: ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV9" ]
Statement [ "ALTER IGNORE TABLE AlbumRoots\n
ADD UNIQUE (identifier(127), specificPath(128)),\n
ENGINE InnoDB;" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
KMemoryInfo: Platform identified : "LINUX"
KMemoryInfo: TotalRam: 4142694400
digikam.general: Allowing a cache size of 197 MB
QThreadStorage: Thread 0x7f051cbfec80 exited after QThreadStorage 11 destroyed
Acording to this
https://stackoverflow.com/questions/5456520/mysql-alter-ignore-table-add-unique-what-will-be-truncated#5456599
"ALTER IGNORE TABLE" is no longer supported.
--
You are receiving this mail because:
You are watching all bug changes.
