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

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14112
------------------------------------------------------------------------------
  Ticket             | 14112
  Created By         | jsveiga at it.eng.br
  Summary            | tags not being cleaned from rampage tables when tagged
                     | object is deleted
  Queue              | Horde Framework Packages
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


jsveiga at it.eng.br (2015-09-15 16:33) wrote:

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.