[Tickets #6182] convert_prefs_to_sql.php results in duplicate blacklist / whitelist rules

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=6182
-----------------------------------------------------------------------
 Ticket             | 6182
 Created By         | liamr at deathstar.org
 Summary            | convert_prefs_to_sql.php results in duplicate blacklist / whitelist
                    | rules
 Queue              | Ingo
 Version            | 1.2-RC2
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
-----------------------------------------------------------------------


liamr at deathstar.org (2008-01-31 12:25) wrote:

After running convert_prefs_to_sql.php, I ended up with two sets of
"Whitelist / Blacklist" rules in positions 1-4.  It seems to happen
randomly.. it worked for my account right now, but other users in this
batch have the issue:

+---------+------------+-----------+-------------+------------+------------+-----------------+--------------+-----------+-------------+------------+
| rule_id | rule_owner | rule_name | rule_action | rule_value | rule_flags
| rule_conditions | rule_combine | rule_stop | rule_active | rule_order |
+---------+------------+-----------+-------------+------------+------------+-----------------+--------------+-----------+-------------+------------+
|       1 | amw        | Whitelist |           9 | NULL       |       NULL
| NULL            |         NULL |      NULL |           1 |          1 |
|       3 | amw        | Blacklist |           7 |            |       NULL
| NULL            |         NULL |      NULL |           1 |          3 |
|       6 | amw        | Whitelist |           9 |            |          0
| a:0:{}          |            1 |         1 |           1 |          6 |
|       7 | amw        | Blacklist |           7 |            |          0
| a:0:{}          |            1 |         1 |           0 |          7 |
+---------+------------+-----------+-------------+------------+------------+-----------------+--------------+-----------+-------------+------------+
4 rows in set (0.00 sec)

This was a freshly created set of ingo_ tables, and the original
horde_prefs ingo rules pref don't have  multiple blacklist and whitelist
entries.