Bug 288839 - Failed to update the database schema from version 5 to version 6
Summary: Failed to update the database schema from version 5 to version 6
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Schema (show other bugs)
Version: 2.3.0
Platform: Fedora RPMs Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-12-12 20:40 UTC by Matthieu Pupat
Modified: 2020-01-01 21:45 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 7.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Matthieu Pupat 2011-12-12 20:40:33 UTC
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
Comment 1 caulier.gilles 2011-12-12 20:52:46 UTC

*** This bug has been marked as a duplicate of bug 283502 ***
Comment 2 caulier.gilles 2020-01-01 21:45:10 UTC
Not reproducible with 7.0.0 beta1.