Bug 388467

Summary: failed to migrate from schema 7 to 8
Product: [Applications] digikam Reporter: Gabor.Ziegler@ericsson.com <orrmany>
Component: Database-SchemaAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 5.5.0   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: https://commits.kde.org/digikam/6b767163e6ba14b86e6f27341342b84df473f07c Version Fixed In: 5.8.0
Sentry Crash Report:

Description Gabor.Ziegler@ericsson.com 2018-01-02 22:42:40 UTC 
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
Comment 1 caulier.gilles 2018-01-02 22:46:54 UTC 
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
Comment 2 Maik Qualmann 2018-01-03 06:54:30 UTC 
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
Comment 3 caulier.gilles 2018-01-03 10:59:21 UTC 
Bundles are under construction with last code from git/master. Please wait...

Ah, most important : Happy new year 2018 (:=))))...

Gilles Caulier
Comment 4 caulier.gilles 2018-01-03 13:57:24 UTC 
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
Comment 5 Maik Qualmann 2018-01-04 20:10:44 UTC 
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