The problem is that there are 1682 users (of which 97 have no email set) with ukwikimedia set as their home wiki in globaluser.gu_home_db. These accounts may have no local attachments if ukwikimedia was their only wiki, like https://meta.wikimedia.org/wiki/Special:CentralAuth/CategoryError – that's why they aren't visible in localuser`.

The remaining two cases are covered by T309738 and T411577.

This should be done besides Special:RecentChangesLinked (T411577) and SpecialUnusedTemplates.

Change #1202356 merged by jenkins-bot:

[mediawiki/core@REL1_45] ApiQueryInfo: Filter templatelinks correctly

https://gerrit.wikimedia.org/r/1202356

Change #1202356 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@REL1_45] ApiQueryInfo: Filter templatelinks correctly

https://gerrit.wikimedia.org/r/1202356

Change #1202324 merged by jenkins-bot:

[mediawiki/core@master] ApiQueryInfo: Filter templatelinks correctly

https://gerrit.wikimedia.org/r/1202324

Change #1202324 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] ApiQueryInfo: Filter templatelinks correctly

https://gerrit.wikimedia.org/r/1202324

This probably needs the SecurePoll schema files to be split in two, one for the tables on all wikis and one for the tables on wikis with local elections only?

Re-reading my first response, I realize I might have been a bit unclear. Indeed my focus was to respond to number 2, namely should it contain the shell username of whoever made the wiki? , not to question sending the email in the first place. I agree that this should still be sent. It's a notification as you say, not an auditing mechanism.

Sorry yes, I wrote that misleadingly, but I think @akosiaris and I are both addressing the question of whether the username needs to be in the email body. No objections to sending an email notification.

I think we are mixing two questions here:

I agree with @akosiaris (and thanks for the archaeology). It wouldn't be hard to implement this, but I think it's the wrong approach -- especially if addWiki.php is the only script using SUDO_USER, we should update the script rather than add an anachronism to pretend we're still using sudo.

BTW, on the technical side, mw-script does indeed keep the username in the labels of the job and the pod, e.g.

This functionality was added 10 years ago in https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/WikimediaMaintenance/+/a17c2ef30e0e85ced460f304cf481cdb7d924486%5E%21

@RLazarus Do you have any thoughts on how to tackle this one, please?

T393444 reports that (likely since this change?) emails are not being sent anymore to the newprojects mailing list when addWiki.php runs.

I think this is done. If there are any remaining issues, they can be split out into separate tasks.

I dropped api_feature_usage, bot_passwords and globalimagelinks in nupwiki. Someone in TSP says securepoll_log should actually exists and it's weird it's not in enwiki.

Not sure about securepoll_log but the rest of nupwiki tables missing in enwiki I'm sure needs fixing and removal.

Comparing it to enwiki, on enwiki there are following tables which are not on nupwiki:

Currently the following tables are created on wiki creation (nupwiki created in T390384):