digikam 2.6.0-rc Schema update to V6 failed

[leif]

Hi,

I just recently upgraded my digikam from 1.9 32-bit to 2.6.0-rc 64bit  
(Fedora).
The program launches just fine but when i try to reconfigure to use
mysql server I get the error:

[leif@elitebook ~]$ digikam
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is
still in use, all queries will cease to work.
digikam(11411)/digikam (core): Schema update to V6 failed!

I think the database schemas was created by migrating from sqlite using
digikam 1.9 but it was a while ago so I don't remember exactly.
The connection to mysql is working fine and the user account is granted
all privileges on the two schemas "digikam4" and "digikam4_thumbs".

Any way to get this working, or do I have to throw away all my metadata
and start from scratch?

/Leif


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[leif]

I solved it myself:

After the error message Digikam starts, but no collection is shown
(naturally).

I used the database transfer too to extract all data from mysql down to
a local sqlite database.
Then I deleted the database tables in mysql and created a pair of new
ones (empty)
Then I restored the mysql tables from the local sqlite by again using
the database transfer tool in the other direction.
Now all my metadata is back on mysql and I can use digicam again!

Hope this helps someone else...
/Leif

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users