https://bugs.kde.org/show_bug.cgi?id=522204
Bug ID: 522204
Summary: "Core database: schema update to V 17 failed" on
AppImage launch of 9.1.0
Classification: Applications
Product: digikam
Version First 9.1.0
Reported In:
Platform: Ubuntu
OS: Linux
Status: REPORTED
Severity: grave
Priority: NOR
Component: Database-Migration
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
DESCRIPTION
On the first launch of digikam 9.1 appimage (upgrading from 9.0),
("./digiKam-9.1.0-Qt6-x86-64.appimage"), I receive a dialog box with this
message:
Failed to update the database schema from version 16 to version 17.
Please read the error messages printed on the console and report this error as
a bug at bugs.kde.org.
And the relevant log messages from the console are:
Digikam::AlbumWatch::AlbumWatch: AlbumWatch is disabled
Digikam::AlbumManager::setDatabase: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similarity Name: "digikam"
Connect Options: "UNIX_SOCKET=/var/run/mysqld/mysqld.sock"
Host Name: "localhost"
Host Port: 3306
WAL Mode: false
Internal Server: false
Internal Server Path: ""
Internal Server Init Cmd: ""
Internal Server Admin Cmd: ""
Internal Server Program Cmd: ""
Internal Server Upgrade Cmd: ""
Username: "digikam"
Password: "XXXXXXX"
unknown: QSvgHandler: Image filename is empty
unknown: QSvgHandler: Image filename is empty
Digikam::DbEngineConfigSettingsLoader::readConfig: Loading SQL code from config
file "/tmp/.mount_digiKaaAzh8G/usr/share/digikam/database/dbconfig.xml"
Digikam::DbEngineConfigSettingsLoader::readConfig: Checking XML version ID =>
expected: 3 found: 3
Digikam::CoreDbSchemaUpdater::update: Core database: running schema update
Digikam::CoreDbSchemaUpdater::startUpdates: Core database: have a structure
version 16
Digikam::CoreDbSchemaUpdater::makeUpdates: Core database: makeUpdates 16 to
17
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
""
Error messages: "QMYSQL: Unable to execute query" "Cannot drop index
'imagetagproperties_tagid_index': needed in a foreign key constraint" "1553" 2
Bound values: QList()
Digikam::BdEngineBackend::execDBAction: Error while executing DBAction [
"UpdateSchemaFromV16ToV17" ] Statement [ "CALL
drop_index_if_exists('ImageTagProperties', 'imagetagproperties_tagid_index');"
]
Digikam::CoreDbSchemaUpdater::performUpdateToVersion: Core database: schema
update to V 17 failed!
Digikam::CoreDbAccess::checkReadyForUse: Core database: cannot process schema
initialization
STEPS TO REPRODUCE
1. launch the digikam 9.1 appimage.
2.
3.
OBSERVED RESULT
dialog box with the error above, when I click "okay", it will present me with a
database configuration dialog box. I verify the settings, click "okay" and
then it loops back to the same error.
EXPECTED RESULT
digikam starts.
SOFTWARE/OS VERSIONS
Ubuntu 24.04.04 LTS
Not running KDE, so it's running whatever is bundled in the AppImage
ADDITIONAL INFORMATION
I'm running an external mysql installation:
$ mysql --version
mysql Ver 8.0.46-0ubuntu0.24.04.3 for Linux on x86_64 ((Ubuntu))
--
You are receiving this mail because:
You are watching all bug changes.
