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

* Your Email Address
* Spam protection	Enter the letters below: . .. ..__ . ,.__ \|_/ \|\/\|\| \ \./ [__) \| \\| \|\|__/ \| \| \
Comment	> 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.
Attachment
Watch this ticket