| Summary: | Pictures from old collection (network share) still in database after removing it | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | venik |
| Component: | Database-Sqlite | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | REPORTED --- | ||
| Severity: | normal | CC: | matthias.braendli, metzpinguin, venik |
| Priority: | NOR | ||
| Version First Reported In: | 8.2.0 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
| Attachments: | Removed collection still available with "null album" | ||
|
Description
venik
2023-12-10 13:13:41 UTC
First of all, it is normal for deleted pictures to have NULL album. We keep them for a while, so if they are added again we won't need to fully scan them anymore. But, images with NULL albums are usually not displayed or processed. So you must have a strange entry in your album root table. To determine the cause I would need to have your digikam4.db. Or at least a list of the album root table to start with. Maik In which album mode are the deleted images displayed? Is a search album? Maik Thank you Maik for your support, these are visible in "Dates" and "Timeline" sections. The db is 148mb , if you explain me what you need I can try to support you (I am not expert). Opening it with sqlite I see two AlbumRoot under Albums table (3, 6). id albumRoot relativePath date caption collection icon modificationDate ... 4964 6 /2003_12_23 Varie Casa 2003-12-21 2023-09-24T23:49:52.467 2902 6 / 2022-12-08 2023-12-09T14:46:10.574 3648 3 /Varie/x zia 2008-12-29 2022-01-09T22:47:37.192 But under "Set root albums location" I have only one entry. This is also visible in AlbumRoots table where I correctly have only one entry 6 photo -HDD 0 2 volumeid:?uuid=c02303a9&fileuuid=c0e04540-3506-43bc-be15-b842d22850ed /photo 1 Besides the possible bug that lead to these strange situation.. How can I recover? Is it sufficient to delete all entries with albumRoot 3 ? Thank you in advance In order to solve I would also take into consideration create a new database. Is there any option in digikam to this end? The missing entry in the album root is definitely the problem. The first question is, is an album root correct? Otherwise, if you must have 2, try creating a dummy entry with id 3. You can then create the correct entry in digiKam using the update function (circle icon tool button) in the collection settings behind this dummy. Maik albumRoot = 3 refers to the network storage I removed, This was removed from collections, but all the images and albums are still in the database! I would like avoid to re-add it.. Now my question are 1) how to recover? Should I just remove all the orphan images entries (DELETE FROM Albums WHERE albumRoot = 3; ) should I expect orphan records? How should I make proper cleanup? 2) Why this happened? Is it correct my reproduction scenario? 3) is there a reset db or create new db option? I also tried maintenance tool like "performance database cleaning" ... Apparently no benefits/change Hello, I had a similar issue. I had added a read-only mounted external image collection, and then removed it again before it terminated scanning all entries. No "null album" visible, but picture placeholders (no thumbnails) in the timeline. The database still contained albums referring to the non-existing AlbumRoot. I have made a backup copy of digikam4.db and have executed `DELETE from Albums WHERE albumRoot <> 1;`, which fixed the problem for me. As Maik said it's ok to have Images with NULL album, I didn't clean up anything else. Cheers Matthias Hi, The 8.7.0 pre-release Windows installer from today have been rebuilt from scratch with Qt 6.8.3, KDE 6.12, OpenCV 4.11 + CUDA support, Exiv2 0.28.5, ExifTool 13.27, ffmpeg 7, all image codecs updated to last version (jxl, avif, heif, aom, etc.). Please try with this version to see if your problem still reproducible... https://files.kde.org/digikam/ Thanks in advance Best regards Gilles Caulier |