[Digikam-devel] [digikam] [Bug 324134] SCAN : Images disappear after advanced rename

[Gerard Dirkse via KDE Bugzilla]

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

--- Comment #17 from Gerard Dirkse <gerard.dirkse at kpnmail.nl> ---
I have been able to recover the data in following way against the digikam
database:

CREATE TEMPORARY TABLE `orphans` SELECT DISTINCT `id` FROM `Images` WHERE `id`
NOT IN (SELECT `imageid` FROM `ImageInformation`);
DELETE from `Images` WHERE `id` in (SELECT * FROM `orphans`);

Then when digikam gets started again, images are recovered, not sure if this
process leaves rubbish or not, but it appears not.  Would be nice if a database
tool could do this, recover information that has been somehow lost.

-- 
You are receiving this mail because:
You are the assignee for the bug.