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).
Description
Related Objects
Event Timeline
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).
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.
Removing XTools as we have our own task for adding Flow contributions: T136950: Add Flow contributions to XTools
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):
- https://www.mediawiki.org/w/index.php?title=Topic:U3pozpeq0msjd4ws&topic_revId=u3q0z1bhcgyrbu73&action=single-view
- https://www.mediawiki.org/wiki/Topic:U3pozpeq0msjd4ws
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.