Bug 294995 - Delete photos and their management in the database Mysql
Summary: Delete photos and their management in the database Mysql
Status: RESOLVED NOT A BUG
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 2.1.1
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-28 12:50 UTC by Mauro Esteve Ferrer
Modified: 2017-07-25 10:34 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.6.0

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Mauro Esteve Ferrer 2012-02-28 12:50:02 UTC 
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
Comment 1 caulier.gilles 2012-02-29 04:36:16 UTC 
Francesco,

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

Gilles Caulier
Comment 2 Mauro Esteve Ferrer 2012-02-29 10:16:05 UTC 
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.
Comment 3 Marcel Wiesweg 2012-02-29 21:49:42 UTC 
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)