https://bugs.kde.org/show_bug.cgi?id=388467
Bug ID: 388467
Summary: failed to migrate from schema 7 to 8
Product: digikam
Version: 5.5.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: Database-Schema
Assignee: digikam-bugs-n...@kde.org
Reporter: orrm...@gmail.com
Target Milestone: ---
QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-orrmany'
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "thumbnails-digikam"
DB Face Name: ""
Connect Options: ""
Host Name: "localhost"
Host port: 3306
Internal Server: false
Internal Server Path: "/home/orrmany/.local/share/digikam/"
Internal Server Serv Cmd: "mysqld"
Internal Server Init Cmd: "mysql_install_db"
Username: "digikam"
Password: "XXXXXXXXXXXXX"
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: A lekérdezés nem hajtható végre" "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
--
You are receiving this mail because:
You are watching all bug changes.
