[SOLVED] digiKam cannot open database

CollieJim · 02-22-2014, 02:51 AM

I'm using Kubuntu 13.04, digiKam 3.4.0, and KDE 4.11.5, and have run apt-get upgrade 2 days ago.

Last month I moved my collection from a removable drive to a partition on the internal HDD. I have not been able to use it since.

When started from the command line I get

Code:

659 15:14:27 ~ $ digikam
Object::connect: No such signal org::freedesktop::UPower::DeviceAdded(QDBusObjectPath)
Object::connect: No such signal org::freedesktop::UPower::DeviceRemoved(QDBusObjectPath)
digikam(3238)/digikam (core): Error while opening the database. Error details [ QSqlError(-1, "Error opening database", "unable to open database file") ] 
digikam(3238)/digikam (core): Error while opening the database. Error details [ QSqlError(-1, "Error opening database", "unable to open database file") ] 
digikam(3238)/digikam (core): Error while opening the database. Error details [ QSqlError(-1, "Error opening database", "unable to open database file") ]

I tried migrating the database, which appeared to be successful. No luck.
I have tried deleting the .db files to no avail.
It would be *really* nice if digiKam would tell my why it could not open the sqlite database...

What's the next step?

Thanks,
Jim

bigrigdriver · 02-23-2014, 12:42 PM

You need to tell digikam where the collection of photos is located.

Go into the Settings menu -> configure digikam.

In the left hand pane, click on Collections. In the right hand pane, under Local Collections, click on Add Collection. Enter the path to the collection.

Then in the Albums menu, click on refresh.

If that doesn't pick up the new photos, try closing digikam and restarting.

CollieJim · 02-23-2014, 10:45 PM

I start digiKam from the command line and get the messages above, followed by a lot more. When the display stabilises I delete the lot (I'm using an emacs shell) and click on Settings. I immediately get the following:

Code:

QSqlDatabase:  driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-149273744' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-149273744', old connection removed.
QSqlDatabase:  driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-149273744' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-149273744', old connection removed.
QSqlQuery::prepare: database not open
QSqlDatabase:  driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL

The steps I follow are:

Code:

Click on Settings -> Configure digiKam -> Collections -> Local Collections Add Collection
    Select folder
    Click OK - get message giving name and location of collection
    Click OK - correct path is shown
    Click OK - get message saying "It was not possible to add a collection for the following paths:
                  the correct path is shown.

This suggests that for some reason digiKam is not able to use sqlite. Other packages, such as Thunderbird, do not have any problems with sqlite. I know there is sqlite and sqlite3. Perhaps that is related.

CollieJim · 02-24-2014, 01:39 AM

Problem solved.
In the Settings -> Database it still had the old location for the collection even though I had changed it. It appears the change was not saved.

I have entered (and verified) the new collection's location and all is well.
One would think that migrating the database to a new location would take care of that!