[Digikam-devel] [Bug 288839] New: Failed to update the database schema from version 5 to version 6

[Matthieu Pupat]

https://bugs.kde.org/show_bug.cgi?id=288839

           Summary: Failed to update the database schema from version 5 to
                    version 6
           Product: digikam
           Version: 2.3.0
          Platform: Fedora RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: kde at pupat-ghestem.net


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

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.