Images without Album, Albums in non-existing Root Album, how to solve?

[Remco Viëtor]

On dimanche 9 février 2025 18:54:26 heure normale d’Europe centrale Helen 
Jelen wrote:
> Hello,
> 
> I have a python script pulling my own statistics from digikam's DB file and
> I've noticed I have many Images missing Album (field images.album is null)
> and many more images contained in Albums in non-existing Root Albums (field
> albums.albumRoot is informed to a number that doesn't exist in field
> albumsRoot.id).
> 
> I randomly checked the hash for those images and it seems that they were
> re-scanned in any case and actual files are now contained also either in
> any existing Album (for the first case), or those Albums are already in any
> Root Album (for the second).
> 
> How would you recommend me to get this fixed?
> 
Clean up the database...
Removing an entry does not reclaim the space, but marks the entry as removed.
As long as you have no signs that the database is corrupted, cleaning up and 
compacting the database should get rid of stale entries (sqlite "VACUUM" 
command, stop digikam and backup beforehand and make sure you have enough 
space on the hard drive).


As for the best database to use, no idea. (but an external server means extra 
indirection for each request).