[Digikam-devel] [Bug 113915] New: Tags are lost after "Save As..."ing.

[Tung NGUYEN]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=113915         
           Summary: Tags are lost after "Save As..."ing.
           Product: digikam
           Version: 0.8.0-beta2
          Platform: Compiled Sources
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: digikam-devel kde org
        ReportedBy: ntung free fr


Version:           0.8.0-beta2 (using KDE KDE 3.4.2)
Installed from:    Compiled From Sources
OS:                Linux

TEST 1:
======
- In Album1, open Photo1, which has tag T1, with the DigiKam Image Editor.
- In the Image Editor, "Save As..." Photo1 as Photo2 in the same album Album1.
- Quit the Image Editor and reopen Photo1 with it.
- "Save As..." Photo1 as Photo3 in the same album Album1.

=> Photo3 has lost his tag T1 and I have in Konsole:

digikam: Saving to :/home/anonyme/Dossiers personnels/Photos/Album1/OCjKba.tmp (jpeg)
digikam: WARNING: sqlite_step error: columns imageid, tagid are not unique on query: INSERT INTO ImageTags (imageid, tagid)
SELECT I.id, T.tagid FROM Images AS I, ImageTags AS T WHERE
     I.id=(SELECT Images.id FROM Images WHERE
           dirid=17 AND name='Photo 003.jpg')
AND  T.tagid IN (SELECT tagid FROM ImageTags WHERE
                   imageid=(SELECT id FROM Images WHERE
                             dirid=17 AND name='Photo 001.jpg'))
digikam: Dirty: /
digikam: Dirty: /Album1

=> Sometimes (in another tests), Photo2 can lose his tag T1 too and I have the same Konsole message.

TEST 2:
======
- In Album1, open Photo1, which has tag T1, with the DigiKam Image Editor.
- In the Image Editor, "Save As..." Photo1 as Photo2 in a different album Album2.

=> Photo2 has lost his tag T1 and I have in Konsole:

digikam: Saving to :/home/anonyme/Dossiers personnels/Photos/Album2/et7jAa.tmp (jpeg)
digikam: WARNING: sqlite_step error: columns imageid, tagid are not unique on query: INSERT INTO ImageTags (imageid, tagid)
SELECT I.id, T.tagid FROM Images AS I, ImageTags AS T WHERE
     I.id=(SELECT Images.id FROM Images WHERE
           dirid=1 AND name='Photo 002.jpg')
AND  T.tagid IN (SELECT tagid FROM ImageTags WHERE
                   imageid=(SELECT id FROM Images WHERE
                             dirid=17 AND name='Photo 001.jpg'))
digikam: Dirty: /
digikam: Dirty: /Album2