https://bugzilla.wikimedia.org/show_bug.cgi?id=34014
--- Comment #3 from MZMcBride <[email protected]> 2012-01-29 19:15:48 UTC --- (In reply to comment #2) > Sounds like we just need to go through all wikis and update the underscores > back to spaces > > UPDATE ipblocks SET ipb_address = REPLACE(ipb_address, '_', ' ') WHERE > ipb_address LIKE '%\_%'; > > Wonder if it's worth adding an updater action for this too, or whether it's a > WMF site issue Well, as I pasted above, some of these (duplicative) block entries apply to the same user. I think you'll need a maintenance script to go through, find instances where ipb_user is not equal to 0 and is non-unique, select the block with the highest ipb_timestamp, delete the older entries, and then fix ipb_address as necessary. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
