https://bugzilla.wikimedia.org/show_bug.cgi?id=61876

            Bug ID: 61876
           Summary: Attach all broken autocreated local accounts to their
                    global account
           Product: Wikimedia
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Site requests
          Assignee: wikibugs-l@lists.wikimedia.org
          Reporter: federicol...@tiscali.it
                CC: benap...@gmail.com,
                    bugzilla+org.wikime...@tuxmachine.com,
                    dereck...@espace-win.org, g...@wikimedia.org,
                    tom...@twkozlowski.net, wikimedia.b...@snowolf.eu
        Depends on: 39996
            Blocks: 16660, 29782, 35707
       Web browser: ---
   Mobile Platform: ---

Created attachment 14675
  --> https://bugzilla.wikimedia.org/attachment.cgi?id=14675&action=edit
MetaWiki autocreated, detached accounts

See bug 29234, bug 35792, bug 39060, bug 39996, bug 39997 and friends for
context.

One example silly query one can run e.g. on toolserver (sql metawiki_p):

SELECT
  log_title,
  log_user,
  log_timestamp
FROM logging
JOIN user ON logging.log_action = 'autocreate' /*
AND log_timestamp > 20130431000000 */
AND logging.log_user = user.user_id
WHERE user.user_name NOT IN (
  SELECT lu_name
  FROM centralauth_p.localuser lu
  WHERE lu.lu_wiki = 'metawiki'
);

15k results on Meta-Wiki only.

An actual query needs to be made slightly faster, I suppose, and actually check
for the validity of the local account (it can be attached but nevertheless
unusable, with password and email not working) and of its global username
(which might have been deleted, or detached on purpose).

Note, at some point James said this would be done as part of the work for bug
35707.

-- 
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

Reply via email to