Bug 393068 - digikam.coredb: Core database: Album library path from config file is empty. Aborting update.
Summary: digikam.coredb: Core database: Album library path from config file is empty. ...
Status: REPORTED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Engine (show other bugs)
Version: 5.6.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-12 20:34 UTC by arne anka
Modified: 2023-10-12 05:50 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description arne anka 2018-04-12 20:34:18 UTC
starting didkam after a long time again
get popup 

No album library path has been found in the configuration file. Giving up the schema updating process. Please try with an empty database, or repair your configuration.


as far as i remember i never edited the config file manually, it's all what digikam created on its own.

Application: digikam (5.6.0)

Qt Version: 5.10.1
Frameworks Version: 5.44.0
Operating System: Linux 4.15.0-2-amd64 x86_64
Distribution: Debian GNU/Linux unstable (sid)

$ digikam 
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
   Type:                     "QSQLITE"
   DB Core Name:             "/home/username/Pictures/digikam4.db"
   DB Thumbs Name:           "/home/username/Pictures/thumbnails-digikam.db"
   DB Face Name:             "/home/username/Pictures/recognition.db"
   Connect Options:          ""
   Host Name:                ""
   Host port:                -1
   Internal Server:          false
   Internal Server Path:     ""
   Internal Server Serv Cmd: ""
   Internal Server Init Cmd: ""
   Username:                 ""
   Password:                 ""

digikam.dbengine: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected:  3  found:  3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: have a structure version  4
digikam.coredb: Core database: makeUpdates  4  to  8
digikam.coredb: Core database : running updateV4toV7
digikam.coredb: Core database: moved tables
digikam.coredb: Core database: dropped triggers
digikam.coredb: Core database: Album library path from config file is empty. Aborting update.
digikam.coredb: Core database: cannot process schema initialization
KMemoryInfo: Platform identified :  "LINUX"
KMemoryInfo: TotalRam:  16520769536
digikam.general: Allowing a cache size of 200 MB
digikam.dimg: ("/usr/share/color/icc")
digikam.general: Does not contain  "Comment"  Namespace
digikam.metaengine: Loading default values ++++++++++++++++
digikam.dimg: No X.org XICC profile installed for screen  0
digikam.general: Camera XML data:  "/home/username/.local/share/digikam/cameras.xml"
digikam.facedb: FaceDB SelectFaceSetting val ret =  0
digikam.facedb: FaceDB SelectFaceSetting val ret =  0
digikam.facedb: Face database: have a structure version  "2"
digikam.facesengine: Face database ready for use
digikam.general: Face PipeLine: add database writer
digikam.general: Face PipeLine: add faces trainer
digikam.facesengine: Face database ready for use
digikam.general: Face PipeLine: add database writer
digikam.general: Face PipeLine: add faces trainer
libpng warning: iCCP: known incorrect sRGB profile
libpng warning: iCCP: known incorrect sRGB profile
digikam.geoiface: "setting backend marble"
QtAV 1.12.0(Apr  8 2018, 20:08:00)
Multimedia framework base on Qt and FFmpeg.
Distributed under the terms of LGPLv2.1 or later.
Shanghai University->S3 Graphics->Deepin->PPTV, Shanghai, China Copyright (C) 2012-2016 Wang Bin (aka. Lucas Wang) wbsecg1@gmail.com
Donate: http://qtav.org/donate.html
Source: https://github.com/wang-bin/QtAV
Home page: http://qtav.org
digikam.general: AudioOutput backends: ("OpenAL", "Pulse", "null")
digikam.general: Stacked View Mode :  0
digikam.geoiface: "setting backend marble"
digikam.geoiface: "setting backend marble"
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT tagid, property, value FROM TagProperties ORDER BY tagid, property;" 
Error messages: "Unable to execute statement" "no such table: TagProperties" 1 2 
Bound values:  ()
digikam.dbengine: Failure executing query:
 "SELECT tagid, property, value FROM TagProperties ORDER BY tagid, property;" 
Error messages: "Unable to fetch row" "No query" -1 1 
Bound values:  ()
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "SELECT property, value FROM TagProperties WHERE tagid=:a;" 
Error messages: "Unable to execute statement" "no such table: TagProperties" 1 2 
Bound values:  ()
KCrash: crashing... crashRecursionCounter = 2
KCrash: Application Name = digikam path = /usr/bin pid = 26249
KCrash: Arguments: /usr/bin/digikam 
KCrash: Attempting to start /usr/lib/x86_64-linux-gnu/libexec/drkonqi from kdeinit
sock_file=/run/user/1000/kdeinit5__0
pa_write() failed while trying to wake up the mainloop: Bad file descriptor
pa_write() failed while trying to wake up the mainloop: Bad file descriptor
pa_write() failed while trying to wake up the mainloop: Bad file descriptor
Invalid write to eventfd: Bad file descriptor
Code should not be reached at pulsecore/fdsem.c:199, function pa_fdsem_post(). Aborting.
Unable to start Dr. Konqi
Comment 1 Maik Qualmann 2018-04-13 08:36:27 UTC
Was the first start dialog displayed after starting digiKam the first time? Did you choose that the old configuration should be copied? The configuration file is now expected at a different location ($USER/.config). I think that we can not solve the problem with such an old database. The best way will be to create a new database.

Maik
Comment 2 arne anka 2018-04-13 09:32:16 UTC
as mentioned, I just hadn't used digikam for some time (about 6 months).
there was no dialog whatsoever, just something about looking for something and the the error popup.

apparently you expect some sort of user action, but I never got anything beyond the above and then the crash.

"I think that we can not solve the problem with such an old database."


it's not quite comprehensible for me how the database can be that old -- I use debian/sid and update almost every day. looks like some sort of communication trouble if you can make such large jumps without distributions noticing.

anyway: 
"The best way will be to create a new database."

care to elaborate? 

- how do I do that?
- what files need to be deleted/moved?
- what information will be lost?


digikam should do exactly that, shouldn't it?
notfiying me about the issue, offering to create a new db (and most importantly, clearly stating the consequences - what information will be lost?).
from your description I still don't understand why digikam fails to solve the issue on its own.

Remember: didgikam doesn't even START! whatever needs to be done is obviously more that digikam is able to handle and it doesn't tell me anything either.
Comment 3 Maik Qualmann 2018-04-13 10:01:10 UTC
Only 6 months not used? The current update wants to switch from V4 to V8. The change from V4 to V5 was made 11 years ago. Could it be that your previous digiKam was so old? Or was the database replaced by importing from an outdated backup?

Maik
Comment 4 arne anka 2018-04-30 20:05:43 UTC
neither nor.
apt's history log goes back until a year ago.
first occurence of digikam in October:
digikam:amd64 (4:5.3.0-1, 4:5.6.0-3)

so, last known working version was at least 5.3 -- I doubt this was released 11 years ago.

first bug: failure to handle the db version (if in fact it did even recognize the right version! that may still be the case!)

second bug: crashing.

third bug: no information how to solve the issue.
I'm left with a message I cannot readily translate (what configuration file where? what album library path? is it the folder where the pictures aree stored? is it something else? what does a schema have to do with the pictures folder (back to: what is the album library path?) where is that database? how do I create an empty one? why can didgikam not do it by itself? WHERE is the configuration? how can it be broken all of a sudden? how am I supposed to do anything without useful information?)
Comment 5 Maik Qualmann 2018-04-30 22:41:53 UTC
I know it's all very technical, but digiKam will not be able to solve this problem automatically. Let's go through the error log for explanation:

Here is the core database:
> DB Core Name:             "/home/username/Pictures/digikam4.db"

It has a very old version number (4):
> digikam.coredb: Core database: have a structure version  4

DigiKam is trying to update the database, but the album path has not been saved to the program configuration for a long time:
> digikam.coredb: Core database: Album library path from config file is empty.

Here's another hint that the database is very old, the table "TagProperties" does not exist yet:
> "SELECT tagid, property, value FROM TagProperties ORDER BY tagid, property;" 
> Error messages: "Unable to execute statement" "no such table: TagProperties"

It is possible that the database was damaged by something, but I think it is old. The database could also not by digiKam-5.3.0. been used, the update would have started also here. Remove the database, digiKam will create a new one. Alternatively, they can look in their system for the current "digikam4.db" and put them in the settings. There will not be another solution.

Maik
Comment 6 caulier.gilles 2020-08-04 08:17:24 UTC
digiKam 7.0.0 stable release is now published:

https://www.digikam.org/news/2020-07-19-7.0.0_release_announcement/

We need a fresh feedback on this file using this version.

Best Regards

Gilles Caulier
Comment 7 caulier.gilles 2022-01-10 08:04:11 UTC
Hi Arne and happy new year,

Can you check if problem remain with digiKam 7.5.0 pre-release bundle available
here :

https://files.kde.org/digikam/

Thanks in advance

Gilles Caulier
Comment 8 caulier.gilles 2023-04-28 04:05:06 UTC
@arne

digiKam 8.0.0 is out. This report still valid ?

Best regards
Comment 9 caulier.gilles 2023-10-12 05:43:01 UTC
arne,

What's about this file using current 8.2.0 AppImage Linux bundle ? It's
reproducible ?

https://files.kde.org/digikam/

Note: bundle is now based on Qt 5.15.11 and KDE framework 5.110.

Thanks in advance

Gilles Caulier
Comment 10 Maik Qualmann 2023-10-12 05:50:35 UTC
Gilles, we can close this.
The album collection path has not been saved in the digikamrc for years. If the database version is so old (reset by a backup or due to a defect), an update is simply no longer possible. We should remove the really old database update code of the digiKam-0.x versions.

Maik