[Digikam-devel] [Bug 283502] New: database upgrade v5 to v6 failed

[Kusi]

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

           Summary: database upgrade v5 to v6 failed
           Product: digikam
           Version: 2.1.1
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: kusi at forum.titlis.org


Version:           2.1.1 (using KDE 4.7.1) 
OS:                Linux

I upgraded from digikam 1.9 to 2.1.1. My metadata is saved in a mysql database.
When lauching digikam 2.1.1, I get the following error

digikam(5640)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
Loading SQL code from config file
"/usr/share/kde4/apps/digikam/database/dbconfig.xml"
digikam(5640)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
false "1" 1 1
digikam(5640)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(5640)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  5
digikam(5640)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates 
5  to  6
digikam(5640)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "" 
Error messages: "QMYSQL: Unable to execute query" "PROCEDURE
digikamdb.create_index_if_not_exists does not exist" 1305 2 
Bound values:  ()
digikam(5640)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "UpdateSchemaFromV5ToV6" ] Statement [ "CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid');" ]
digikam(5640)/digikam (core): Schema update to V6 failed! 

please let me know if you need more information

best regards, kusi

Reproducible: Always

Steps to Reproduce:
launch digikam 2.1.1

Actual Results:  
schema update failed

Expected Results:  
database update works

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