[Digikam-devel] [Bug 250610] wish: tool or procedure to check digikam database

[Vincent Tassy]

https://bugs.kde.org/show_bug.cgi?id=250610


Vincent Tassy <timetre at free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |timetre at free.fr




--- Comment #4 from Vincent Tassy <timetre free fr>  2011-08-11 13:36:53 ---
Hi, I resurrect this entry as I had the same feeling.
Having used Digikam for several years, my database holds about 40k pictures and
more than 500 tags.

My Digikam (currently v1.9) works great but I still haven't been able to
migrate to using MySQL as the generated migrated MySQL tables differ from my
current SQLite tables (in terms of entries).

This lead my to thinking that there might be some semantic inconsistencies in
my SQLite DB.

So I finally wrote a program that checks all rows in the database for poteltial
problems (Albums linked to innexistant AlbumRoots, Images linked to innexistant
Albums, Images without ImageInformation, Tag hierachies, and what not).

Well, given the volume, most of my DB is consistent but my tool still found 466
"ghost" pictures (pictures present in the DB linked to an Album that doesn't
exist ...) and these I'll need to fix by hand ...

So there is definitely a need for such a tool and I'll make mine available ASAP

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.