https://bugzilla.wikimedia.org/show_bug.cgi?id=34895

--- Comment #8 from Ryan Kaldari <[email protected]> 2012-10-20 00:17:33 
UTC ---
A good start on cleaning the bad data would be running something like:
UPDATE article_feedback_revisions SET afr_total = 0 WHERE afr_count = 0 AND
afr_total > 1000000000;

That table is huge though, so we might want to use a maintenance script that
first pulls the effected page IDs from a slave DB, and then target those page
IDs specifically in the master table.

Like I said though, this would only fix about half of them.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to