[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Voyagerfan5761 / dgw mediaw...@technobabbl.es changed: What|Removed |Added CC||mediaw...@technobabbl.es -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Legoktm legoktm.wikipe...@gmail.com changed: What|Removed |Added CC||legoktm.wikipe...@gmail.com -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Liangent liang...@gmail.com changed: What|Removed |Added CC||liang...@gmail.com --- Comment #4 from Liangent liang...@gmail.com --- RESOLVED INVALID? [[mw:Manual:User table]]: user_editcount Count of edits and edit-like actions. *NOT* intended to be an accurate copy of COUNT(*) WHERE rev_user=user_id. May contain NULL for old accounts if batch-update scripts haven't been run, as well as listing deleted edits and other myriad ways it could be out of sync. Execute the script initEditCount.php to update this table column. Meant primarily for heuristic checks to give an impression of whether the account has been used much. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 --- Comment #5 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (In reply to comment #4) I don't think this is invalid. Just because its not perfect now doesn't mean we can't do better. But first of all perhaps we should add approximently to the edit counter on prefs -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Diederik van Liere dvanli...@gmail.com changed: What|Removed |Added Keywords||analytics -- 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
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Soxred93 soxre...@gmail.com changed: What|Removed |Added CC||soxre...@gmail.com --- Comment #2 from Soxred93 soxre...@gmail.com 2010-04-05 01:36:01 UTC --- It may be quite possible to... a) create a maintenance script that replaces every user_editcount field with the result of SELECT COUNT(*) AS count FROM revision WHERE rev_user_text = 'Example'; b) set the function in the User class which gets the edit count to just do that SQL query. However, for users with a large number of edits, this is very slow. This may be out of our reach. Might this be possible? -- 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
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 --- Comment #3 from MZMcBride b...@mzmcbride.com 2010-04-05 01:42:06 UTC --- (In reply to comment #2) a) create a maintenance script that replaces every user_editcount field with the result of SELECT COUNT(*) AS count FROM revision WHERE rev_user_text = 'Example'; This is essentially what initEditCount.php does: http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/initEditCount.php?view=markup b) set the function in the User class which gets the edit count to just do that SQL query. Way too expensive. Even with the index on rev_user_text, you're talking about millions of rows with some of these users. The value must be stored so that it can be easily retrieved for things like creating the 'edit' links or not (autoconfirm checks this field). There might be other creative ways of updating it, though, like every time a user logs in. -- 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
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Christian Thiele ap...@apper.de changed: What|Removed |Added CC||ap...@apper.de --- Comment #1 from Christian Thiele ap...@apper.de 2009-08-22 00:45:36 UTC --- I think there are at least two problem, which generate the difference between the normal edit counters on the toolserver and the user_editcount field. The first thing seems to be the problem with deleted edits. As the poster of this bug writes, the initEditCount.php doesn't account for deleted contributions. This is the correct behavior, as all edit counters don't count these. But after initializing user_editcount, only incEditCount() in User.php seems to be called, which increases user_editcount. But when a page is deleted, user_editcount is not decreased. So user_editcount is the number of all edits a user did (deleted and not deleted) minus all deleted edits up to the time, initEditCount() was called. The second thing is an older bug, which results in having deleted revisions in the revisions table, which should be in the archive table. Therefore all edit counters check, if the rev_page id exists in the page table (this is from de.wikipedia): SELECT count(*) FROM revision WHERE rev_user=10276; - 39702 SELECT count(*) FROM revision, page WHERE rev_user=10276 AND rev_page=page_id; - 39688 The 14 edits are from 2005/2006. SELECT * FROM revision WHERE rev_user=10276 AND rev_page NOT IN(SELECT page_id FROM page); I don't know if this bug exists anymore, but it doesn't seem so, because the last one for me was from March 2006. These were newly created redirects (mostly by moving a page), which were deleted later, but the moving message wasn't moved to archive. Because I think the bug was fixed, maybe a maintenance script would be good, moving all revisions with a rev_page id, which is not in the page table to the archive table. -- 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
[Bug 19311] User edit counts (user.user_editcount field) is often wrong
https://bugzilla.wikimedia.org/show_bug.cgi?id=19311 Brion Vibber br...@wikimedia.org changed: What|Removed |Added Blocks||16660 -- 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