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

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Bugzilla from kde@pupat-ghestem.net
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: [hidden email]
        ReportedBy: [hidden email]


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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 288839] Failed to update the database schema from version 5 to version 6

Gilles Caulier-4
https://bugs.kde.org/show_bug.cgi?id=288839


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |[hidden email]
         Resolution|                            |DUPLICATE




--- Comment #1 from Gilles Caulier <caulier gilles gmail com>  2011-12-12 20:52:46 ---


*** This bug has been marked as a duplicate of bug 283502 ***

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 288839] Failed to update the database schema from version 5 to version 6

bugzilla_noreply
In reply to this post by Bugzilla from kde@pupat-ghestem.net
https://bugs.kde.org/show_bug.cgi?id=288839

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Schema

--
You are receiving this mail because:
You are the assignee for the bug.