Bug 294995

Summary:	Delete photos and their management in the database Mysql
Product:	[Applications] digikam	Reporter:	Mauro Esteve Ferrer <mauroesteve>
Component:	Database-Mysql	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED NOT A BUG
Severity:	normal	CC:	caulier.gilles, vivo75+kde
Priority:	NOR
Version:	2.1.1
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed In:	2.6.0

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)