I recently migrated my digikam database from MySQL to SQLite. After the migration, digikam didn't show any tags at all. Investigations showed that for all tags that had no parent, the pid field in the Tags table was set to -1. After manually setting the pid to 0 (via "update Tags set pid=0 where pid=-1"), the tags showed correctly again. The pid was set to 0 in the original MySQL database, so something incorrectly converts the value during migration. Reproducible: Always
*** Bug 301075 has been marked as a duplicate of this bug. ***
This file still valid using last digiKam 5.0.0 ? Gilles Caulier
Sorry, at the moment I don't have time to update to digiKam 5.0.0 and set up appropriate tests (still on digiKam 4.9.0).
And with 4.9.0, the problem is reproducible ? Gilles Caulier
Swati, This file must be checked with migration tool when Mysql DB must be converted to Sqlite. Gilles Caulier
Git commit 9a17c743ea9a41c1ef050b08517343813ef6a9f4 by Maik Qualmann. Committed on 25/11/2017 at 22:02. Pushed by mqualmann into branch 'master'. update DB to v9 and fix migration from SQLite to MySQL Related: bug 378838, bug 369083, bug 350574 FIXED-IN: 5.8.0 M +5 -1 NEWS M +129 -97 data/database/dbconfig.xml.cmake.in M +1 -1 data/database/mysql-global.conf M +1 -20 libs/database/coredb/coredbcopymanager.cpp M +5 -2 libs/database/coredb/coredbschemaupdater.cpp https://commits.kde.org/digikam/9a17c743ea9a41c1ef050b08517343813ef6a9f4