[Digikam-devel] [Bug 189080] comments not saved with digikam 0.10.0 on KDE 4.2.2

[Marcel Wiesweg]

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





--- Comment #8 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-04-13 14:46:49 ---
This may be SQL to fix an affected database:

DELETE FROM ImageComments WHERE id IN (SELECT C2.id FROM ImageComments AS C1,
ImageComments AS C2 WHERE C1.imageid=C2.imageid AND C1.type=C2.type AND
C1.language=C2.language AND C1.author IS NULL AND C2.author IS NULL AND C1.id <
C2.id);

(removes all second entries where the UNIQUE enforcement fails because author
is null)

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