[Digikam-devel] [Bug 255478] digikam database tables only grow in size and get never cleaned

[Andi Clemens]

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





--- Comment #6 from Andi Clemens <andi clemens gmx net>  2010-11-14 16:53:18 ---
Marcel, the problem seems to be the following line:

http://lxr.kde.org/source/extragear/graphics/digikam/libs/database/collectionscanner.cpp#270

I guess this can not work. The passed in albumID list will not contain albums
that have been deleted, right?
So we either need to change the query in void
AlbumDB::deleteRemovedItems(QList<int> albumIds):

SqlQuery query = d->db->prepareQuery( QString("DELETE FROM Images WHERE
status=? AND (album=? or album IS NULL);") );

or use the version without the parameter:
void AlbumDB::deleteRemovedItems()

This seems to work for me.

Andi

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.