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.
Thanks, DanB
On Mon, Mar 28, 2011 at 2:50 PM, Daniel Barrett danb@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.
-Chad
Chad writes:
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.
That's interesting. In my case, however, user_editcount was too low, not too high, which is the opposite of your situation. Any idea how that could happen?
Thanks, DanB
Daniel Barrett wrote:
Chad writes:
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.
That's interesting. In my case, however, user_editcount was too low, not too high, which is the opposite of your situation. Any idea how that could happen?
Thanks, DanB
Special:Import maybe?
mediawiki-l@lists.wikimedia.org