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
The migrate tool have been improved into 5.8.0. Please test with 5.8.0 pre-release Linux AppImage bundle available here : https://files.kde.org/digikam/ Gilles Caulier
The latest update to the schema update from V7 to V8 is not yet included in the AppImage. The procedures for deleting the index and foreign key have only been added after 29.12.2017. Maik
Bundles are under construction with last code from git/master. Please wait... Ah, most important : Happy new year 2018 (:=))))... Gilles Caulier
The new appimage bundle 5.8.0 64 bits will be ready to download in few minutes at https://files.kde.org/digikam/ This one will includes last changes done in Mysql interface. Gilles Caulier
Git commit 6b767163e6ba14b86e6f27341342b84df473f07c by Maik Qualmann. Committed on 04/01/2018 at 20:08. Pushed by mqualmann into branch 'master'. remove double entries with ALTER IGNORE TABLE statement Related: bug 388501 FIXED-IN: 5.8.0 M +3 -2 NEWS M +23 -21 data/database/dbconfig.xml.cmake.in https://commits.kde.org/digikam/6b767163e6ba14b86e6f27341342b84df473f07c