[Bug 294995] New: Delete photos and their management in the database Mysql

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

           Summary: Delete photos and their management in the database
                    Mysql
           Product: digikam
           Version: 2.1.1
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           2.1.1 (using KDE 4.8.0)
OS:                Linux

When I delete a photo on the table "Images" does not clear the row only sets
the value of the column "album" to NULL.

It should delete all the rows (tags, metadata, properties, ...) for that image.

Reproducible: Always

Steps to Reproduce:
Delete a photo
See table mysql Images, tags, metadata, properties, ...


Expected Results:  
Delete all rows in all tables when you delete a photo

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=294995


Gilles Caulier <[hidden email]> changed:

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




--- Comment #1 from Gilles Caulier <caulier gilles gmail com>  2012-02-29 04:36:16 ---
Francesco,

This is true ? Mysql tables are not clear at item deletion event ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=294995





--- Comment #2 from Mauro Esteve Ferrer <mauroesteve yahoo es>  2012-02-29 10:16:05 ---
I tested with version 2.5 on Kubuntu with KDE 4.8 and the tables are not
cleaned after deleting a photo or an album with photos.

Only sets the value of the column "album" to NULL.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=294995


Marcel Wiesweg <[hidden email]> changed:

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




--- Comment #3 from Marcel Wiesweg <marcel wiesweg gmx de>  2012-02-29 21:49:42 ---
Feature not bug...entries will be garbage collected later. Information is kept,
otherwise a simple move operation may result in information loss (when the
information is irreversibly deleted for the removed file)

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- 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=294995

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

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Mysql

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