[Bug 300920] New: tags are stored multiple times

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

            Bug ID: 300920
          Severity: normal
           Version: unspecified
          Priority: NOR
          Assignee: [hidden email]
           Summary: tags are stored multiple times
    Classification: Unclassified
                OS: Linux
          Reporter: [hidden email]
          Hardware: Ubuntu Packages
            Status: UNCONFIRMED
         Component: Tags
           Product: digikam

assign tag A to an image, hit 'apply'
assign tag B to the same image, hit 'apply'
tag A is now 2 times assigned to A (also two times in the database in the
ImageTags table).

Reproducible: Always



Expected Results:  
A tag should only be assigned once to an image

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from Gilles Caulier <[hidden email]> ---
Not reproducible here. Which version of digiKam you use ?

Do you share tags with Nepomuk (look Metadata setup for details) ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #2 from koperwiek <[hidden email]> ---
Digikam Versie 2.5.0
Gebruikmakend van KDE Development Platform 4.8.2 (4.8.2)

Do not share tags with Nepomuk

Han van Os

Gilles Caulier schreef op do 31-05-2012 om 10:01 [+0000]:

> https://bugs.kde.org/show_bug.cgi?id=300920
>
> Gilles Caulier <[hidden email]> changed:
>
>            What    |Removed                     |Added
> ----------------------------------------------------------------------------
>                  CC|                            |[hidden email]
>
> --- Comment #1 from Gilles Caulier <[hidden email]> ---
> Not reproducible here. Which version of digiKam you use ?
>
> Do you share tags with Nepomuk (look Metadata setup for details) ?
>
> Gilles Caulier
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|unspecified                 |2.5.0

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #3 from Gilles Caulier <[hidden email]> ---
Which Database type do you use ? Mysql or sqlite ?

If you store tags into image metadata (check Metadata setup dialog), look your
image metadata to see if dual tags are stored in XMP or IPTC or Exif ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #4 from koperwiek <[hidden email]> ---
In the metadata they are ok (each tag once).
In the database and below the thumbnail they are  multiple,

Han van Os

Gilles Caulier schreef op do 31-05-2012 om 10:49 [+0000]:

> https://bugs.kde.org/show_bug.cgi?id=300920
>
> --- Comment #3 from Gilles Caulier <[hidden email]> ---
> Which Database type do you use ? Mysql or sqlite ?
>
> If you store tags into image metadata (check Metadata setup dialog), look your
> image metadata to see if dual tags are stored in XMP or IPTC or Exif ?
>
> Gilles Caulier
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #5 from Gilles Caulier <[hidden email]> ---
run kdebugdialog and turn on digikam debug space.
run digiKam from a console, assign tags to image and look debug trace on the
console. There is any suitable info to hack ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #6 from koperwiek <[hidden email]> ---
I activated Digikam in kdebugdialog.
Started Digikam from console.
Assigning tags only results messages about image orientation:

digikam(5524)/digikam (core) Digikam::DImg::load:
"/home/han/Afbeeldingen/Afbeeldingenmap/2012/2012-05-12/L1030866.jpg"  :
JPEG file identified
digikam(5524)/digikam (core) Digikam::DImg::load:
"/home/han/Afbeeldingen/Afbeeldingenmap/2012/2012-05-12/L1030866.jpg"  :
JPEG file identified
digikam(5524)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation:
Orientation => Exif.Image.Orientation =>  1
digikam(5524)/KEXIV2 KExiv2Iface::KExiv2::getImageOrientation:
Orientation => Exif.Image.Orientation =>  1


Han v Os

Gilles Caulier schreef op do 31-05-2012 om 11:40 [+0000]:
> https://bugs.kde.org/show_bug.cgi?id=300920
>
> --- Comment #5 from Gilles Caulier <[hidden email]> ---
> run kdebugdialog and turn on digikam debug space.
> run digiKam from a console, assign tags to image and look debug trace on the
> console. There is any suitable info to hack ?
>
> Gilles Caulier
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

--- Comment #7 from Gilles Caulier <[hidden email]> ---
There is nothing special to see in the console.

Can you share your DB file for investigations ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #8 from koperwiek <[hidden email]> ---
You will receive my database via WeTransfer.com within some minutes

Han v Os

Gilles Caulier schreef op do 31-05-2012 om 11:56 [+0000]:
> https://bugs.kde.org/show_bug.cgi?id=300920
>
> --- Comment #7 from Gilles Caulier <[hidden email]> ---
> There is nothing special to see in the console.
>
> Can you share your DB file for investigations ?
>
> Gilles Caulier
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #9 from Marcel Wiesweg <[hidden email]> ---
CREATE TABLE ImageTags
 (imageid INTEGER NOT NULL,
  tagid INTEGER NOT NULL,
  UNIQUE (imageid, tagid));

Any duplicate entry in the database would be violating the table definition.
How do you check the entries? MySQL or SQLite?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #10 from koperwiek <[hidden email]> ---
sqlite.
check screenprint of database browser attached.

HvO

Marcel Wiesweg schreef op do 31-05-2012 om 18:04 [+0000]:

> https://bugs.kde.org/show_bug.cgi?id=300920
>
> --- Comment #9 from Marcel Wiesweg <[hidden email]> ---
> CREATE TABLE ImageTags
>  (imageid INTEGER NOT NULL,
>   tagid INTEGER NOT NULL,
>   UNIQUE (imageid, tagid));
>
> Any duplicate entry in the database would be violating the table definition.
> How do you check the entries? MySQL or SQLite?
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

--- Comment #11 from koperwiek <[hidden email]> ---
I checked the database. The Create table statement does not contain the
constraints mentioned below. So the problem is solved, as far as i am
concerned.  I will repair the database.
Thank kindly for your help.

Best regards, Han van Os


Marcel Wiesweg schreef op do 31-05-2012 om 18:04 [+0000]:

> https://bugs.kde.org/show_bug.cgi?id=300920
>
> --- Comment #9 from Marcel Wiesweg <[hidden email]> ---
> CREATE TABLE ImageTags
>  (imageid INTEGER NOT NULL,
>   tagid INTEGER NOT NULL,
>   UNIQUE (imageid, tagid));
>
> Any duplicate entry in the database would be violating the table definition.
> How do you check the entries? MySQL or SQLite?
>

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

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

koperwiek <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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

--- Comment #12 from Marcel Wiesweg <[hidden email]> ---
Still weird that the UNIQUE constraint was not in your database's schema. It's
definitely in the SQL code that we ship.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Version Fixed In|                            |2.6.0

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel