| Summary: | Failed to update the database schema from version 5 to version 6 | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Matthieu Pupat <kde> |
| Component: | Database-Schema | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | caulier.gilles, kurt.andersson.jr |
| Priority: | NOR | ||
| Version First Reported In: | 2.3.0 | ||
| Target Milestone: | --- | ||
| Platform: | Fedora RPMs | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | 7.0.0 | |
| Sentry Crash Report: | |||
*** This bug has been marked as a duplicate of bug 283502 *** Not reproducible with 7.0.0 beta1. |
Version: 2.3.0 (using KDE 4.7.3) OS: Linux First of all I have read a few reports about this where the problem is that thumbnails and main data are in two different MySQL databases. This is not my case. I have a unique database for both. I recently upgraded from F15 to F16 which made digikam go from 1.9 to 2.3. I cannot start digikam with the following error message: digikam(7138)/digikam (core) Digikam::AlbumManager::setDatabase: DatabaseParameters: [ Type "QMYSQL", Name "digikam2" (Thumbnails Name "digikam2"); Host Name and Port: "localhost" 3306; Username and Password: "digikam", "password"] QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work. digikam(7138)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig: Loading SQL code from config file "/usr/share/kde4/apps/digikam/database/dbconfig.xml" digikam(7138)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig: false "1" 1 1 digikam(7138)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater update digikam(7138)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a database structure version 5 digikam(7138)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates 5 to 6 digikam(7138)/digikam (core) Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing query: "" Error messages: "QMYSQL: Unable to execute query" "PROCEDURE digikam2.create_index_if_not_exists does not exist" 1305 2 Bound values: () digikam(7138)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error while executing DBAction [ "UpdateSchemaFromV5ToV6" ] Statement [ "CALL create_index_if_not_exists('ImageTags','tag_id_index','imageid');" ] digikam(7138)/digikam (core): Schema update to V6 failed! digikam(7138)/kdeui (KNotification) KNotificationManager::notificationClosed: 16 Reproducible: Always Steps to Reproduce: Start digikam Expected Results: No error message, collections populated