Tickets :: [#7685] Problem with deleting filter rules in SQL

Summary	Problem with deleting filter rules in SQL
Queue	Ingo
Queue Version	1.2
Type	Bug
State	Not A Bug
Priority	2. Medium
Owners
Requester	R.Gilbert (at) sheffield (dot) ac (dot) uk
Created	11/14/2008 (6054 days ago)
Due
Updated	10/26/2009 (5708 days ago)
Assigned	11/14/2008 (6054 days ago)
Resolved	10/26/2009 (5708 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/26/2009 06:35:45 PM	Jan Schneider	Comment #2 Taken from Jan Schneider State ⇒ Not A Bug	Reply to this comment
Can't reproduce this. Has probably been fixed since.

11/14/2008 08:03:07 PM	Chuck Hagenbuch	Priority ⇒ 2. Medium State ⇒ Assigned Assigned to Jan Schneider

11/14/2008 06:38:24 PM	R (dot) Gilbert (at) sheffield (dot) ac (dot) uk	Comment #1 Priority ⇒ 3. High New Attachment: ingo_bug.ods Patch ⇒ No Milestone ⇒ Summary ⇒ Problem with deleting filter rules in SQL Type ⇒ Bug State ⇒ Unconfirmed Queue ⇒ Ingo	Reply to this comment
Deleting multiple rules in the same filter edit session made other rules become invisible. This was because the rule_order was not being changed correctly after the first deletion. The problem is reproducible. (I used convert_prefs_to_sql.php on a set of rules in horde_prefs.) The attached OO speadsheet shows how the rule_order changed after each deletion.