LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-22-2014, 01:51 AM   #1
CollieJim
Member
 
Registered: Mar 2005
Distribution: Gentoo, Kubuntu
Posts: 582

Rep: Reputation: 28
digiKam cannot open database


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
 
Old 02-23-2014, 11:42 AM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,908

Rep: Reputation: 354Reputation: 354Reputation: 354Reputation: 354
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.
 
Old 02-23-2014, 09:45 PM   #3
CollieJim
Member
 
Registered: Mar 2005
Distribution: Gentoo, Kubuntu
Posts: 582

Original Poster
Rep: Reputation: 28
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.
 
Old 02-24-2014, 12:39 AM   #4
CollieJim
Member
 
Registered: Mar 2005
Distribution: Gentoo, Kubuntu
Posts: 582

Original Poster
Rep: Reputation: 28
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!

Last edited by CollieJim; 02-24-2014 at 12:41 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] digikam not starting after installing kde4.10.5 - unable to compile digikam now. camorri Slackware 19 07-25-2013 04:43 PM
LXer: digiKam 2.0 beta review - the ultimate open source image editor LXer Syndicated Linux News 0 05-31-2011 07:30 PM
LXer: Geotag Photos with Open GPS Tracker and digiKam LXer Syndicated Linux News 0 02-16-2011 06:40 AM
digikam database crash measekite Linux - Software 2 03-30-2009 08:08 PM
how to move digikam photos and database dukeinlondon Linux - Software 5 09-09-2007 07:05 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration