On Mon, Mar 28, 2011 at 2:50 PM, Daniel Barrett <danb(a)vistaprint.com> wrote:
Recently I discovered that the user_editcount column
in the "user" table disagrees with the actual edits in the "revisions"
table by a significant amount. To fix this, I ran maintenance/initEditCount.php. My
question is: what causes these numbers to get out of sync in the first place? Should I
need to run this maintenance script regularly?
This is MediaWiki 1.16.2 on a single server with a single database. The wiki began its
life at 1.10.0, if that matters.
user_editcount is never decreased for things like page deletions, etc.
As soon as you start deleting pages, you're moving stuff out of the
revision table so the counts begin to differ.