Page MenuHomePhabricator

User account on MediaWiki shows it has two edits, but nothing visible in deleted contributions
Closed, DuplicatePublic

Description

User we are talking about is JamieCarollKrol. It shows 2 edits according to CentralAuth, but when going to the contributions of this user on MediaWiki.org nothing can be seen (according to Trijnstel and Matiia, both stewards). It's also not hidden in some way (eg. RevDel or oversighted).

Event Timeline

Wiki13 renamed this task from User account on MediaWiki shows two edits, but nothing visible in deleted contributions to User account on MediaWiki shows it has two edits, but nothing visible in deleted contributions.Jan 14 2018, 11:44 PM
Wiki13 updated the task description. (Show Details)

Also, JamieCarollKrol info on XTools show 0 edits in Mediawiki!

So, the problem here from XTools or Mediawiki-CentralAuth?

Something fishy is going on.
When a user is expected to have no deleted contributions, Special:DeletedContributions should show the message nocontribs, but that message is not shown on https://www.mediawiki.org/wiki/Special:DeletedContributions/JamieCarollKrol. It shows the output of an empty pager instead. Compare to https://www.mediawiki.org/wiki/Special:DeletedContributions/MainframeBot.

I'm attempting to find out where these edits have gone using Quarry, but so far no luck yet: https://quarry.wmflabs.org/query/16995

I checked on the database master, there are no rows in the revision nor archive table corresponding to their user id (12188407).

Something fishy is going on.
When a user is expected to have no deleted contributions, Special:DeletedContributions should show the message nocontribs, but that message is not shown on https://www.mediawiki.org/wiki/Special:DeletedContributions/JamieCarollKrol. It shows the output of an empty pager instead. Compare to https://www.mediawiki.org/wiki/Special:DeletedContributions/MainframeBot.

There's an HTML comment saying <!-- Could not format Special:DeletedContribution row. --> (see DeletedContribsPager::formatRow()).

Please check if they're Flow edits. They'll be on the account of the sysop that deleted the Topic.

Unfortunately, XTools doesn't have access to anything Flow. See T136950 for details.

Pppery subscribed.

This is not CentralAuth-specific; their user-editcount value is two.

This is caused by T118024: When deleting StructuredDiscussion content, deleted content is misattributed to the sysop that deleted it. In other words: the user created something via Flow, that something was later deleted and due to T118024, the authorship of that something was transferred to the deleting admin. That makes finding what the content was way harder, but not impossible.

Finding the edits

Despite the bug, the edits can be found in in flowdb, which is documented here. I queried that database to find the page the user edited:

mysql:research@dbstore1007.eqiad.wmnet [mediawikiwiki]> select * from actor where actor_name='JamieCarollKrol'\G
*************************** 1. row ***************************
  actor_id: 12881264
actor_user: 12188407
actor_name: JamieCarollKrol
1 row in set (0.001 sec)

mysql:research@dbstore1007.eqiad.wmnet [mediawikiwiki]>

mysql:research@dbstore1009.eqiad.wmnet [flowdb]> select flow_workflow.* from flow_revision join flow_tree_revision on tree_rev_id=rev_id join flow_tree_node on tree_descendant_id=tree_rev_descendant_id join flow_workflow on workflow_id=tree_ancestor_id where rev_user_wiki='mediawikiwiki' and rev_user_id=12188407\G
*************************** 1. row ***************************
                   workflow_id: AZ_'
                 workflow_wiki: mediawikiwiki
            workflow_namespace: 3
              workflow_page_id: 743652
           workflow_title_text: 79.18.132.236
                 workflow_name: 
workflow_last_update_timestamp: 20171213183355
              workflow_user_id: NULL
           workflow_lock_state: 0
        workflow_definition_id: NULL
              workflow_user_ip: NULL
            workflow_user_wiki: NULL
                 workflow_type: topic
*************************** 2. row ***************************
                   workflow_id: AZ_'
                 workflow_wiki: mediawikiwiki
            workflow_namespace: 3
              workflow_page_id: 743652
           workflow_title_text: 79.18.132.236
                 workflow_name: 
workflow_last_update_timestamp: 20171213183355
              workflow_user_id: NULL
           workflow_lock_state: 0
        workflow_definition_id: NULL
              workflow_user_ip: NULL
            workflow_user_wiki: NULL
                 workflow_type: topic
2 rows in set (0.002 sec)

mysql:research@dbstore1009.eqiad.wmnet [flowdb]>

The user did something at https://www.mediawiki.org/w/index.php?title=User_talk:79.18.132.236. Unfortunately, its deleted contributions are not going to provide any information either (they are affected by T118024 as well). However, with the knowledge of the bug, it is possible to look into the deleting admin's deleted contributions (to make querying simpler, the page was edited on December 13, 2017). In there, one will find a pointer to https://www.mediawiki.org/wiki/Topic:U3pozpeq0msjd4ws, where the edit is (correctly) attributed to the user in question.

So, the two edits are (links only accessible to MediaWiki.org sysops):

Hence, there is no bug in the edit counter. Instead, the bug here is "edit authorship is magically reassigned to the deleting admin" (T118024).

This sort of bug obviously shouldn't happen. Fortunately, they will soon be made insignificant by the Flow deprecation process. Since this is not a separate issues, I am going to merge it with T118024.