Tickets :: Comment on [#14112] tags not being cleaned from rampage tables when tagged object is deleted

* Your Email Address
* Spam protection	Enter the letters below: .__ \ /.__..__ .___ \| \ >< \| \|\| \[__ \|__// \\|__\\|__/[___
Comment	> Versions: > Horde 5.2.2 > Turba H5 (4.2.2) > Kronolith H5 (4.2.2) > Mnemo H5 (4.2.1) > > rampage_* tables not updated when a tagged object is deleted: > > rampage_objects still keeps the deleted object reference > > rampage_tag_stats still keeps the usage count including the deleted object > > rampage_user_tag_stats still keeps the usage count including the > deleted object > > How to reproduce: > > 1 - Create two calendar events and tag them with > 'tagpersistencetest_calendar' > > 2 - Create two contacs and tag them with 'tagpersistencetest_contact' > > 3 - Create two notes and tag them with 'tagpersistencetest_notes' > > 4 - Run this query on the database: > > SELECT > rampage_tags.tag_name, > rampage_tag_stats.count as tagcount, > rampage_user_tag_stats.count as usertagcount, > rampage_objects.object_name, > rampage_types.type_name > from > rampage_tags > left join rampage_tag_stats using (tag_id) > left join rampage_user_tag_stats using (tag_id) > left join rampage_tagged using (user_id, tag_id) > left join rampage_objects using (object_id) > left join rampage_types using (type_id) > where tag_name regexp 'tagpersistencetest_'; > > 5 - Verify the usage count and tagged objects; take note of [object_id]s > > 6 - Delete (UI) the created notes, contacts and events. > > 7 - Re-run the query > > Result: > > The note and contact objects and tags/tag count remain the same in > all tables. > > The event object is no longer in rampage_tagged, but still in > rampage_objects (look for its object_id), and the tage is still in > rampage_tags, rampage_tag_stats, and rampage_user_tag_stats. > > Expected: > > Deleted object should be removed from rampage_objects and > rempage_tagged, tag counters should decrement. >
Attachment
Watch this ticket

Saved Queries