https://bugzilla.wikimedia.org/show_bug.cgi?id=19311
Web browser: --- Summary: User edit counts (user.user_editcount field) is often wrong Product: Wikimedia Version: unspecified Platform: All OS/Version: All Status: NEW Severity: normal Priority: Normal Component: General/Unknown AssignedTo: wikibugs-l@lists.wikimedia.org ReportedBy: pub...@mzmcbride.com Example user: [[User:Joao]]. On the Toolserver's copy of enwiki_p: mysql> SELECT user.user_editcount FROM user WHERE user_name="Joao"\G *************************** 1. row *************************** user_editcount: 266 1 row in set (0.00 sec) mysql> SELECT COUNT(*) FROM revision WHERE rev_user_text = "Joao" GROUP BY rev_user_text\G *************************** 1. row *************************** COUNT(*): 265 1 row in set (0.03 sec) mysql> SELECT COUNT(*) FROM archive WHERE ar_user_text = "Joao" GROUP BY ar_user_text\G *************************** 1. row *************************** COUNT(*): 35 1 row in set (0.01 sec) This isn't an anomaly. Many users, esp. users with higher edit counts, have inaccurate values stored. The values don't match the number of deleted or live contributions. Part of the problem seems to stem from the fact that the initEditCount.php maintenance script doesn't account for deleted contributions. We're currently advertising an edit count (in Special:Preferences and elsewhere) that isn't accurate. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l