Wikipedia talk:Database reports/Archive 8

Listing maintenance categories
For some reason, tonight's Empty Categories list has maintenance categories listed on it. They are typically ommitted as they would overwhelm the content categories and because they don't stay empty for long and they do not get tagged for speedy deletion, CSD C1. I'm not sure if this talk page is monitored so I'll just ping Jonesey95 and see if they know what has happened. Liz Read! Talk! 01:11, 15 September 2022 (UTC)
 * They've gone and changed the schema on us. See query/67346; what's now in lt_namespace and lt_title in the new linktargets table used to be in tl_namespace and tl_title (which now seem to always be 0 and '' ?), and the database report still assumes they're there. —Cryptic 01:34, 15 September 2022 (UTC)
 * Apparently it was announced in March. The change to templatelinks is (obviously) live; pagelinks, imagelinks, and categorylinks aren't yet, but will follow. —Cryptic 01:46, 15 September 2022 (UTC)
 * , you can ping me any time. I noticed that Database reports/Transclusions of non-existent templates had been blanked by the bot this morning and figured that something screwy was happening with a database or one of the servers, so I restored the previous report and figured I'd give things a day to sort themselves out. The above wikitech-l posting is gibberish to me, but maybe will know if and what things need to change in that report. If this change affects a bunch of reports, I expect that we'll see a thread on VPT in the next day or two. – Jonesey95 (talk) 02:57, 15 September 2022 (UTC)
 * This is a pretty succinct statement of how to update queries that read from templatelinks. For the non-existent template report, for example, you'd need to change this to this. —Cryptic 03:57, 15 September 2022 (UTC)
 * This is all like reading a Greek textbook to me but I have enormous confidence in your abilities to get to the bottom of this, Cryptic and Jonesey95. Thank you for looking into this. There are only one or two of us that utilize this database report but it's one I check daily and helps us keep on top of the category clutter than comes out of deleting articles at AFD and categories at CFD. It also helps us notice if a new editor (they are almost always new editors) goes on a tear, creating dozens of unused categories. And lately a very experienced editor has been working on a major job recategorizing pages that left hundreds of empty categories to tag and delete.
 * Now that I think about it, when there are problems with this list, I usually go directly to the bot operator, MZMcBride so I will ping him to this discussion in case he can follow all of this. I appreciate your help! Liz Read! Talk! 07:23, 15 September 2022 (UTC)
 * Thanks for the fix, @Cryptic! - F ASTILY   07:50, 15 September 2022 (UTC)
 * , Database reports/Transclusions of non-existent templates appears to be broken for the last couple of days. It should have 100+ entries on it every day (see typical pages in the history from a couple of weeks ago). – Jonesey95 (talk) 01:46, 19 September 2022 (UTC)
 * Thanks for letting me know, looks like I missed a change in Cryptic's example; this should be fixed now. -  F ASTILY   04:35, 19 September 2022 (UTC)
 * All fixed today, back to 270 entries. Thanks. – Jonesey95 (talk) 14:18, 19 September 2022 (UTC)
 * That was my error, not yours - I was fooled by there still being enough rows in templatelinks with tl_title not the empty string that the results looked right, when I hadn't found even a single non-empty instance before that. —Cryptic 17:40, 19 September 2022 (UTC)
 * Cryptic and Jonesey95, it happened again on tonight's Database reports/Empty categories. Looks like they are maintenance categories involving files and Proposed deletions. There are plenty of empty clean-up categories that aren't appearing on this list, it's the daily, not monthly maintenance If you tell me that this situation will be lasting a while, then I'll stop pinging you every time it happens. Just thought I'd let you know. Liz Read! Talk! 01:13, 16 September 2022 (UTC)
 * Database reports/Empty categories is updated by BernsteinBot, which is maintained by MZMcBride & Legoktm; you'll probably have to ask one of them to fix it. -  F ASTILY   02:50, 16 September 2022 (UTC)
 * Yes, I pinged MZMcBride (above) but I'll go to their talk page and ask about this. Liz Read! Talk! 03:11, 16 September 2022 (UTC)
 * Sorry, I fixed another tool of mine (ours even), forgot about these. I'm traveling tomorrow, so it might not be until Saturday that I have time to fix the reports. Legoktm (talk) 05:51, 16 September 2022 (UTC)
 * Hello, Legoktm,
 * You know how to fix this problem? That's great! I look forward to it. Liz Read! Talk! 01:17, 17 September 2022 (UTC)
 * I think fixed most of them, hopefully the next runs of the reports are better. If there's a monthly report that's off let me know and I can kick it manually. Legoktm (talk) 23:19, 17 September 2022 (UTC)
 * Oh, my, Legoktm. Things went back to normal for a few days and then in tonight's report, things went bananas! Even worse than before. Ayiiieeee! Liz Read! Talk! 01:24, 22 September 2022 (UTC)
 * When I run the query in Database reports/Empty categories/Configuration, I only get Category:MAX (band) video albums, Category:IIT Roorkee Alumni, and Category:Polish pilots, which looks right. —Cryptic 01:53, 22 September 2022 (UTC)
 * Ughhh, I have no clue why and I'm mostly offline tomorrow, if it's still wrong after tomorrow's update I'll start poking at it again... Legoktm (talk) 08:38, 22 September 2022 (UTC)
 * Well, everything is back to normal after last night's chaotic report. I don't know who did what but you all have my thanks! Liz Read! Talk! 01:28, 23 September 2022 (UTC)

New articles proposed to Merge
Category:All articles to be merged currently has about 2,600 articles. Could a report be generated that shows which of these are Unreviewed articles (still listed in Special:NewPagesFeed), by date of proposed merge? MB 20:25, 8 September 2022 (UTC)
 * I've used Database report to get this at New pages patrol/Reports. It doesn't have the date of proposed merge, but maybe someone can tweak the sql further to get that. -MPGuy2824 (talk) 09:19, 2 November 2022 (UTC)

Request: editors by number of unreviewed pages
This would be very useful for prioritisation at new page patrol (related discussion: Wikipedia_talk:New_pages_patrol/Reviewers) and WP:PERM/A. I've mocked up an SQL query on quarry that's straightforward enough – can it be converted into a regular database report? –&#8239;Joe (talk) 10:03, 27 June 2022 (UTC)


 * Never mind. I've used Database report to create the report at New pages patrol/Reports. -MPGuy2824 (talk) 09:05, 2 November 2022 (UTC)
 * That's a really handy template, thanks! –&#8239;Joe (talk) 09:27, 2 November 2022 (UTC)

Polluted categories
Is there any particular reason why Database reports/Polluted categories only runs once a month? Given the importance of cleaning polluted categories out, and the fact that running it only once a month means that there are typically hundreds of categories to deal with by the time it actually updates (thus making it an onerous task that people become significantly less likely to bother with at all), once a month isn't often enough. Bearcat (talk) 15:41, 22 November 2022 (UTC)


 * @Bearcat: how often would you like it to run? Legoktm (talk) 16:01, 22 November 2022 (UTC)


 * Weekly would be best, if possible, but every two weeks would also be okay if there's a reason why weekly isn't feasible. Bearcat (talk) 16:03, 22 November 2022 (UTC)
 * Done. Legoktm (talk) 16:19, 22 November 2022 (UTC)

Database report template
Database report template can now be used to set up one-off or periodically updating reports in userspace or project namespace, given an SQL query. The template doc lists the supported formatting options. Feel free to give it a try and let me know if you face any issues. – SD0001  (talk) 15:43, 28 October 2022 (UTC)
 * This is nice, thanks. Hopefully no-one kills the DBs with it. -MPGuy2824 (talk) 03:12, 29 October 2022 (UTC)
 * There are some protections in place to prevent anyone from killing the DBs with it, see T320657 for details. – SD0001  (talk) 10:45, 2 November 2022 (UTC)
 * Hi SD0001. I played around with the wiki template-based approach the other day on and I quite enjoyed it. The wikilinks formatting options of  are neat and it's cool that it supports on-demand updates by clicking a link. Nice job.
 * Could we please switch the bot to use similar to what Database reports/Unused templates/2 is using?
 * I also wonder whether configuration could be moved to a subpage, but for now I just made Database reports/Bizarrely subnested userpages/Configuration a redirect. --MZMcBride (talk) 07:37, 1 February 2023 (UTC)

Goodbye BernsteinBot, hello HaleBot
If you haven't seen the news yet, BernsteinBot has been disabled. HaleBot will take over most of the tasks that it used to do. There are a lot of scattered reports in various places, if you notice something isn't updating, please leave a note here and ping me.

A big thank you to MZMcBride for starting this project 14(!) years ago. Wikipedia is better because of it. Legoktm (talk) 15:10, 12 October 2022 (UTC)


 * @Legoktm please document this bot's tasks on its userpage. — xaosflux  Talk 15:18, 12 October 2022 (UTC)
 * , thank you for taking on this responsibility. – Jonesey95 (talk) 16:05, 12 October 2022 (UTC)
 * Hale hath no fury. --MZMcBride (talk) 18:18, 12 October 2022 (UTC)


 * Legoktm, thanks to you and the bot approval team for your swift action. And thanks to all of our bot operators, like MZMcBride, of past and present. The tools you create make our editing lives so much easier. Liz Read! Talk! 02:00, 13 October 2022 (UTC)

, can you please check on Database reports/Unused templates and Database reports/Uncategorized templates? The former was updating daily, and the latter was weekly, so it is not overdue yet. MZMcBride was also developing Database reports/Unused templates (filtered) just before the bot retired (discussion); that would be a useful daily report. Thanks. – Jonesey95 (talk) 12:54, 13 October 2022 (UTC)


 * I tried to get Unused templates working last night but messed up with the subst:#time calls, will fix that tonight. I found the code for the (filtered) report, I'll set that up tonight too. Uncategorized templates should be set to go on the regular schedule. Legoktm (talk) 15:43, 14 October 2022 (UTC)
 * I saw the update and figured you were working on it. Did you notice that there were undesirable underscores, and that links with parens in them were not quite right, e.g.  (in code here to make sure that the underscores show)? Maybe that's all tied up in the subst work. – Jonesey95 (talk) 17:00, 14 October 2022 (UTC)
 * I did not notice that, it was me being lazy by using the pipe trick. Should be fixed now, though the last page of the report is missing because of an edit filter I just fixed. The (filtered) report is running daily now too. Legoktm (talk) 02:48, 15 October 2022 (UTC)
 * Nice work. It's good to have the reports running again. Please see this discussion for suggestions about how the filtered report could benefit from a few more filters. It should be able to fit on one page pretty easily. – Jonesey95 (talk) 05:32, 15 October 2022 (UTC)

, if there is any way to get Database reports/Ownerless pages in the user space up and running again, it would be helpful. Most of these pages appear to be errors or the result of incomplete moves. I would guess that a monthly refresh is all that is needed for now. – Jonesey95 (talk) 17:30, 7 December 2022 (UTC)
 * After cleaning up this report somewhat, I have noticed that redirects and soft redirects are included, but those pages are valid when an editor's username has been changed. Ideally, those pages would be excluded from the report. Soft redirects are in . Regular redirects are often, but maybe not always, in . – Jonesey95 (talk) 19:00, 8 December 2022 (UTC)
 * @Jonesey95: the report is running daily now, I can adjust the frequency to monthly if you want. Redirects should be skipped, I'll get around to soft redirects shortly. Legoktm (talk) 07:22, 12 December 2022 (UTC)
 * Daily is fine if cycles are cheap. Thanks for doing this. – Jonesey95 (talk) 14:15, 12 December 2022 (UTC)
 * Yes. I should get to it over the weekend. Legoktm (talk) 05:05, 9 December 2022 (UTC)

Is it possible to get Database reports/Articles containing links to the user space working again too?-- Jac 16888 Talk 14:56, 16 December 2022 (UTC)


 * It is already being run; check the history of that page. Or otherwise the bot would be doing something wrong. 0x Deadbeef →∞ (talk to me) 15:13, 16 December 2022 (UTC)
 * Yes but there is clearly an issue since it's coming out blank which is definitely not correct, there are certain articles that have a userspace link for legitimate reasons (Jimmy Wales for example), if the report was running correctly these would be listed-- Jac 16888 Talk 15:53, 16 December 2022 (UTC)
 * Something is definitely wonky with that report, the /Configuration page is for a different report entirely! Legoktm (talk) 00:03, 17 December 2022 (UTC)
 * @Jac16888: should be fixed in the next run. Legoktm (talk) 00:34, 17 December 2022 (UTC)
 * Thanks-- Jac 16888 Talk 01:02, 17 December 2022 (UTC)
 * Hi, this week it seems to have included all articles featuring Template:Cleanup bare URLs (due to the citation bot link) which were previously not counted (approx. 4K articles), are you able to exclude this please?-- Jac 16888 Talk 15:25, 7 January 2023 (UTC)
 * @Jac16888: Will be fixed for the next run. (If you're comfortable with GitHub PRs, feel free to submit them in the future!) Legoktm (talk) 23:36, 7 January 2023 (UTC)
 * @Legoktm The Largely duplicative file names report stopped when the bot was swtiched. I just checked the page today and realised it hasn't updated since october. Is it possible to start running this one again? Thanks, Terasail [✉️] 04:23, 1 February 2023 (UTC)
 * I have started working on a Rust rewrite of that report. Stay tuned! 0x Deadbeef →∞ (talk to me) 04:34, 1 February 2023 (UTC)
 * The report was deployed. 0x Deadbeef →∞ (talk to me) 07:41, 1 February 2023 (UTC)

Inclusion of bot
Today's update to List of Wikipedians by number of edits/1–1000 has suddenly added User:BG19bot - a deactivated bot that last ran in February 2017, so I cannot imagine what triggered its addition.. Please could this be removed, as the list is not supposed to include bots - thanks - Arjayay (talk) 13:54, 1 February 2023 (UTC)
 * Also reported at Wikipedia talk:List of Wikipedians by number of edits as it is unclear where it should be reported. - Arjayay (talk) 13:58, 1 February 2023 (UTC)
 * This was already answered elsewhere, but the exclusion page is List of Wikipedians by number of edits/Unflagged bots. We have many talk pages, it's true. --MZMcBride (talk) 17:06, 1 February 2023 (UTC)

Paginated reports using automated row numbering
Hi. For paginated reports such as Database reports/Potential U5s/2, we currently restart the row numbering for each subsequent page. That is, page 2 is 1–3000 instead of 3001–6000. We could adjust this by specifying , but I'm still pondering whether that would be a good idea. --MZMcBride (talk) 19:19, 7 February 2023 (UTC)

New report request: FAs by length
Would it be possible to have a database report listing WP:featured articles by word count or readable prose size (not wikitext size) or is there a better way to produce such a list? If it's to be a database report, it wouldn't need to be run more than once a month. Thanks! HJ Mitchell &#124; <span style="color: navy; font-family: Times New Roman" title="(Talk page)">Penny for your thoughts? 18:33, 11 February 2023 (UTC)


 * Hi @HJ Mitchell, Is there a definition for how "word count" or "readable prose size" should be measured? Specifically, is there a list of what elements should be excluded or not? Legoktm (talk) 00:21, 13 February 2023 (UTC)


 * This was Featured articles/By length of course, though it just used the overall page size in bytes. --MZMcBride (talk) 07:46, 13 February 2023 (UTC)
 * Prosesize is able to produce prose size in both characters (bytes) and words; could that definition be used? I'm aware of FA/By length but as you say MZM, it only measures the the total page size, which doesn't necessarily bear any resemblance to the amount of prose. Articles that cite lots of sources (especially web sources), for example, use more markup and hence have more wikitext than those that cite fewer sources more heavily (eg books). Hence Taylor Swift (10111 words) tops that list and Douglas MacArthur (18679 words) is at #34. Thanks, <b style="color: teal; font-family: Tahoma">HJ Mitchell</b> &#124; <span style="color: navy; font-family: Times New Roman" title="(Talk page)">Penny for your thoughts? 14:13, 13 February 2023 (UTC)
 * @HJ Mitchell: here you go: Database reports/Featured articles by size, it'll update weekly. Let me know if you want things in a different format, e.g. in kb rather than bytes.
 * Note that the numbers will be slightly different than the prosesize gadget, as I re-implemented it for use in the bot. Legoktm (talk) 06:18, 14 February 2023 (UTC)
 * Thank you very much for such a speedy response! <b style="color: teal; font-family: Tahoma">HJ Mitchell</b> &#124; <span style="color: navy; font-family: Times New Roman" title="(Talk page)">Penny for your thoughts? 10:02, 14 February 2023 (UTC)

New WikiProjects report
Please add the redirect status to it, for each row. The italic font change isn't enough of a difference. -MPGuy2824 (talk) 02:39, 19 February 2023 (UTC)


 * Maybe we can put something like (redirect) after those rows? Legoktm (talk) 03:36, 19 February 2023 (UTC)
 * Yup, that would be good. -MPGuy2824 (talk) 03:47, 19 February 2023 (UTC)
 * Done, will take effect in the next report update. Legoktm (talk) 22:12, 19 February 2023 (UTC)

Categorization of Database reports/Template categories containing articles
Legoktm and 0xDeadbeef, thank you for maintaining and operating User:HaleBot. Would it be possible to tweak the bot so that it doesn't remove categorization of the page Database reports/Template categories containing articles which was previous added? —⁠andrybak (talk) 22:01, 24 February 2023 (UTC)


 * I guess we could...could you just link to the report from the category instead? It would be simpler than having to maintain a special case just for this report. Legoktm (talk) 23:35, 24 February 2023 (UTC)
 * I suppose we could make the bot only update part of the page? We could use some kind of a marker to determine which part needs to be overwritten and which parts don't. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 04:53, 25 February 2023 (UTC)

HaleBot is sleeping
's been quiet for the past couple days. Hasn't made any edits. Does it have a new, more relaxed and human-like editing schedule? Just runs its reports whenever it's in the mood for that? wbm1058 (talk) 11:57, 28 April 2023 (UTC)


 * @Wbm1058: See User_talk:Legoktm. Legoktm (talk) 16:17, 28 April 2023 (UTC)

Database updating stopped
It looks like (cc, ) stopped its daily updating of List of Wikipedians by number of edits subpages a few days ago. Best, &#123;{u&#124; Sdkb  }&#125;  talk 18:21, 28 May 2023 (UTC)


 * @Sdkb: See Village_pump_(technical). Legoktm (talk) 18:22, 28 May 2023 (UTC)

Provide link to Commons file?
As the person who cleans out Database reports/Non-free files shadowing a Commons file every week, I wonder if it could be reformatted so that it links to the Commons file that is shadowed. Jo-Jo Eumerus (talk) 15:21, 12 June 2023 (UTC)


 * Pinging @Fastily as the operator for that report. Legoktm (talk) 16:09, 12 June 2023 (UTC)
 * Sure, I can look into that - F ASTILY   17:13, 12 June 2023 (UTC)
 * Thanks! Jo-Jo Eumerus (talk) 07:23, 13 June 2023 (UTC)

Wikipedia:Database reports/Unused templates (filtered)/Configuration
Two requested chages to Database reports/Unused templates (filtered)/Configuration: Gonnym (talk) 08:01, 1 June 2023 (UTC)
 * 1) Please add Category:Templates for deletion to the list of categories that are excluded. Some templates (such as Template:S-line/RB-SN right/31) still appear on the list after being sent to TfD which makes it harder to see what new templates were added to the report.
 * 2) static row numbers is missing from Database reports/Unused templates (filtered) but is shown at Database reports/Unused templates (filtered)/1. Can this be fixed?


 * Did the first part, the second probably needs to be fixed in the on-wiki Lua module. I can look at it later. Legoktm (talk) 05:49, 14 June 2023 (UTC)
 * Thanks! Gonnym (talk) 08:53, 14 June 2023 (UTC)
 * Done for the second part. Legoktm (talk) 05:07, 15 June 2023 (UTC)

A new report of the most watched pages
Hi everyone. I think that the list of most watched pages should be updated, since the last time it was run was 6 years ago. Can this be done without too much difficulty? Thanks! Trawle (talk) 13:32, 7 June 2023 (UTC)


 * We're blocked on T59617. Legoktm (talk) 05:11, 15 June 2023 (UTC)

HaleBot is on holiday
FYI (cc, ) has not updated List of Wikipedians by number of edits recently — GhostInTheMachine talk to me 08:48, 19 June 2023 (UTC)
 * Thanks for getting it running again. Any chance the runtime can be scheduled as it used to be, so that it runs at 5am as nature intended — GhostInTheMachine talk to me 14:40, 22 June 2023 (UTC)
 * Please  — GhostInTheMachine talk to me 22:14, 24 June 2023 (UTC)
 * I think you may be able to reset the time for the next run by adjusting the hour back to the desired hour like this. – wbm1058 (talk) 03:07, 29 June 2023 (UTC)
 * I thought that the timestamp in List of Wikipedians by number of edits/Age is just output by the bot when it runs — GhostInTheMachine talk to me 18:11, 1 July 2023 (UTC)
 * I also (trepidatiously) added the report to Database_reports (in the last block). That OK ? — GhostInTheMachine talk to me 18:11, 1 July 2023 (UTC)

Obtaining reports from AnomieBOT's predecessor
Hi! On May 14th, 2022, AnomieBOT began maintaining CAT:COIREQ. Is it possible to obtain the edit history for this bot's predecessor? Specifically I'm looking for the equivalent to this page, so that I may view the Xtools page which includes historical graphs of the edit request levels going back 5 years which AnomieBOT, of course, doesn't have. This data would be much appreciated. Thank you so much for any help! Regards, Spintendo  06:22, 5 July 2023 (UTC)
 * It's at, which goes back to 2012. * Pppery * <sub style="color:#800000">it has begun... 16:40, 5 July 2023 (UTC)
 * Thank you. Much appreciated! Spintendo  17:24, 5 July 2023 (UTC)

Lists of lists on Untagged Stubs report
I’m curious if the configuration of the Untagged stubs report can be changed to remove articles whose titles start with “Lists_of”. My argument here is that a decent number of these currently appear on this report (polluting it a bit), and these pages cannot be reasonably expanded without further lists being created. Since set indices and disambiguation pages are already excluded, I’d see the argument for excluding these similar “list of lists” pages. I may have already asked for this, so sorry if this is a repeat request! Michaelwallace22 (talk) 21:40, 12 July 2023 (UTC)


 * @Michaelwallace22: sorry for the delay, now done. Legoktm (talk) 06:00, 11 August 2023 (UTC)

List of bots linking
@Legoktm@0xDeadbeef, it's not immediately clear to readers why some bots are linked and others not at List of bots by number of edits. It looks like it's based on activity, but I think it would be an improvement to link all of them and perhaps just add a "Currently active?" column if we want to communicate that info. Cheers, &#123;{u&#124; Sdkb  }&#125;  talk 23:26, 10 August 2023 (UTC)


 * It uses the same system as List of Wikipedians by number of edits, which says "A user name in black (unlinked) has not been used for editing in the last 30 days." Legoktm (talk) 04:29, 11 August 2023 (UTC)
 * Ah, I see. In that case, I think both lists could use a change — lots of people might be curious why e.g. a top-100 editor has stopped editing and want to check out their userpage, and linking in black makes that harder. (I did add a note of what the black-linking means to the bot list, but I hope that's just an interim step.) &#123;{u&#124; Sdkb  }&#125;  talk 15:24, 12 August 2023 (UTC)

Wikipedia:Database reports/Unused templates (filtered)/Configuration
I've modified the way Template:Attached KML is registered a while back and since then most of the sub templates have been added to articles. Can this exclusion be removed from the report so it can now be tracked? Gonnym (talk) 18:12, 31 July 2023 (UTC)


 * @Gonnym: done. Legoktm (talk) 05:54, 11 August 2023 (UTC)
 * Could you add Category:Wikipedia preloaded templates to the list of filtered (excluded) categories? Gonnym (talk) 17:51, 13 August 2023 (UTC)

Database reports/Pages containing too many maintenance templates
Hello,

The above page stopped updating a couple of months ago, any chance we could get it going again?

Many thanks! Jdcooper (talk) 13:30, 24 August 2023 (UTC)
 * , I left a note for Cewbot's operator, . It may take a few days; it looks like they edit fairly regularly, but not every day. BlackcurrantTea (talk) 13:12, 25 August 2023 (UTC)
 * There's now an updated report. Happy editing! BlackcurrantTea (talk) 14:05, 26 August 2023 (UTC)

Halebot request
Not sure why Halebot is adding a colon to the front end of the Lalbijo2020 file's link on this page, but doing so is a syntax error that has effectively been culled from Wikipedia, and it would be nice for various gnomes to not need to fix it weekly. If the bot or that entry could be modified to keep this from occurring each update, that would be great. Thanks. Zinnober9 (talk) 18:26, 18 August 2023 (UTC)


 * done <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 12:37, 11 September 2023 (UTC)

Linked miscapitalizations includes pages tagged with R avoided double redirect
recently removed the R avoided double redirect rcat from as it was listed in the linked miscapitalizations report. I reverted that edit, as it seems like this is the situation where is supposed to be used; if the correctly-capitalized  redirect were expanded into a full article, the other one would need to be changed to a link to that new article.

Special:WhatLinksHere/Novint falcon shows as transcluding itself, which I assume comes from  (Module:R avoided double redirect verifies that the current article's redirect destination matches the specified article's redirect destination, which I guess must be listed as transcluding). (The edit also removed the parameter to but that one was a link to the correctly capitalized form so I don't think it was the cause.)

I think that all that would be needed to fix this is to change the query on both linked miscapitalizations and linked misspellings to include a  check; if a redirect is linking or transcluding itself it's probably fine. However, I'm not sure how to actually make this change or if there's another aspect to this I'm aware of, or even who's responsible for maintaining the code that updates these reports. --Pokechu22 (talk) 21:50, 9 September 2023 (UTC)
 * , looking at 'what links here' for most things will list a self-transclusion (for lack of a better term). For example, Drought tolerance in barley transcludes Drought tolerance in barley. It does look odd; I don't remember the explanation for it. You might find one in the archives of the technical Village pump. BlackcurrantTea (talk) 05:36, 10 September 2023 (UTC)
 * , hmm. I assume those must come from other templates too then. I notice that has a self-transclusion, but  and  don't. Another interesting set of examples is  and ; only the talkspace one has a self-transclusion (but the mainspace one is also transcluded by the talkspace one). So I guess that means that this is a more general issue.
 * Still, it seems to me that the database report shouldn't count self-transclusion, which is the main issue here. --Pokechu22 (talk) 05:46, 10 September 2023 (UTC)
 * The operators of HaleBot would be the best people to ask. Legotkm's user page says they're intermittently available until later this month. Perhaps can help. BlackcurrantTea (talk) 09:57, 11 September 2023 (UTC)
 * done and should be deployed now. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 14:14, 11 September 2023 (UTC)
 * Thanks! I think the same change also needs to be made on the linked misspellings report too since it has similar logic, though I'm not 100% sure of this. --Pokechu22 (talk) 18:24, 11 September 2023 (UTC)
 * Done and deployed. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 10:17, 12 September 2023 (UTC)

Another case of unneeded listing comes about via redirect tags such as at CityRail. Can that be fixed to take Cityrail out of the report? Dicklyon (talk) 17:38, 12 September 2023 (UTC)
 * That would probably need us to remove "transclusion" type links with SQL queries, which needs some investigation on what needs to be done. I'm quite busy right now, so feel free to put up a pull request if you are able to implement this. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 11:53, 13 September 2023 (UTC)
 * No, I'd have no idea how to implement in that space. Anyone else? Dicklyon (talk) 22:10, 13 September 2023 (UTC)

Format change request
At Database reports/Linked miscapitalizations, the inclusion of the "number" column makes it very hard to see what the diffs are, since the diff tends to align numbers rather than names. It would be equivalent, I think, to be able to sort on article name, rather than the number. Is there any reason to not just do away with the number column? Dicklyon (talk) 16:39, 21 August 2023 (UTC)
 * Using static row numbers, like this, is an easy way to get better diffs. – Jonesey95 (talk) 20:00, 21 August 2023 (UTC)
 * That template should really be the default for all reports. Gonnym (talk) 21:25, 21 August 2023 (UTC)
 * Can someone explain that magic? Dicklyon (talk) 04:12, 22 August 2023 (UTC)
 * Never mind, I now what it's doing. Looks perfect. Dicklyon (talk) 16:04, 22 August 2023 (UTC)
 * @Gonnym: Yeah, MZ said the same a while back. If someone wants to send a PR enabling it for this report that would be appreciated. (Or, if you're feeling courageous, flipping the default.) Otherwise I'll get to it...later. Legoktm (talk) 19:25, 22 August 2023 (UTC)

HaleBot operator, is this a change you'd be willing to make? Dicklyon (talk) 16:04, 22 August 2023 (UTC)

Maybe just do away with the number column? And add a summary at the top with number or articles and total number of links, which would be good for progress tracking? Dicklyon (talk) 05:56, 4 October 2023 (UTC)


 * You know what, I just deployed my change to the codebase that would make all eligible reports use static row numbers. I was holding off waiting for Legoktm to review it first, but since he's on a wikibreak.. I haven't thoroughly tested it, so this might break some reports, let me know and I'll fix. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 12:27, 4 October 2023 (UTC)
 * Well, I didn't look at his contributions when I wrote that, it looks like he's back. It should be fine though. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 12:29, 4 October 2023 (UTC)
 * ✅, see Special:Diff/1178592838 <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 06:31, 6 October 2023 (UTC)

Working on the middle
If you look at the list Database reports/Linked miscapitalizations sorted by number of links, you typically see a whole lot with just one link, and then a bunch with 10 or more. That's because I'm focusing on the ones with 2 to 9 links. The ones with just 1 link accumulate as an indication of what's happening recently. The ones with a lot of links need someone with AWB or JWB to handle efficiently. For the ones with a few links, edting the linking articles in tabs is efficient enough. Dicklyon (talk) 03:52, 7 October 2023 (UTC)

Top new article reviewers report code needs to be updated
There was a recent change to PageTriage, where the logging of reviews is split based on whether the target is an article or a redirect. This is causing the Database reports/Top new article reviewers report to give wrong results. Please change any queries in the code to replace instances of  with   This should fix the problem. -MPGuy2824 (talk) 03:30, 9 November 2023 (UTC)


 * cc @MusikAnimal, who is probably the maintainer of, which generates that report. – Novem Linguae (talk) 06:01, 9 November 2023 (UTC)
 * @MPGuy2824 @Novem Linguae Thanks for the ping! Partially fixed with 80b6552, but I think the counting of redirects is still sort of broken. My understanding (please correct me if I'm wrong): For historical data, we need to still go by, but for where data is available, we should sum where  . Is that correct? &mdash;  MusikAnimal  talk  15:49, 10 November 2023 (UTC)
 * Yes, that is correct. Since this report calculates data over the previous 365 days, we can remove the code that takes care of historical data only after that time. I've set a reminder for myself via W-Ping. Thanks for the quick fix, btw. -MPGuy2824 (talk) 03:11, 11 November 2023 (UTC)

/Blocked users in user group
Good evening fellow Wikipedians, so the database report above is no longer updated since October 6 of last year. The not who was updating it,, hasn't edited since October 12, 2022. Should we archive the report or get another not to take over the updating? Toadette (Happy Thanksgiving!) 18:34, 22 November 2023 (UTC)
 * I suppose I can finally get around to looking into how database report works (no interest in running a bot ever again after the way mine was treated). The query in the configuration is severely out of date - besides the schema changes, it doesn't cull the extendedconfirmed group, currently at 5867 blocks, and I'm sure it was close to that when BernsteinBot was still running - but that's easy enough to fix. —Cryptic 19:07, 22 November 2023 (UTC)

Database reports from searches
I don't know if there's any way to do this efficiently, but there are a couple searches I have devised that reliably turn up a lot of busted formatting. They are not obtained by querying the database directly, but is there any way to get them on a page such as these? Here are a couple examples: Et cetera, et cetera. Usually I fix these myself from JWB but I feel like others would enjoy helping with this as well. Is there a way to set up a bot to do search reports for stuff like these? <b style="font-family: monospace; color:#E35BD8"> jp × g 🗯️</b> 22:08, 29 October 2023 (UTC)
 * , which is  in mainspace, i.e. the string "[1][2]" appearing in the page's source. This almost always means that someone has messed something up and copypasted a sentence from their browser into the edit window, destroying references.
 * in mainspace. This detects when someone has used citation needed in superscript tags.
 * The big daddy of them all:  in mainspace. This gives busted cn attempts, where somebody just typed "[citation needed]" or "(citation needed)" etc into an article instead of invoking the template. I have a huge regex to fix a few dozen of the most common types of this error in my JWB settings.


 * Hi @JPxG: I think we can just have a page that is a collection of these search links and maybe have a bot that updates the hit count daily (to track the approximate number of pages)? The search function gives instant results, which is probably preferable over a page updated periodically by bots. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 10:09, 30 October 2023 (UTC)
 * We can query the search index replicas via Toolforge (see See wikitech:Help:CirrusSearch elasticsearch replicas). It exposes some features which are not available form web UI search. global-search is one of the few tools that use it, but doesn't seem to expose the extra features, and doesn't provide a way to restrict results to enwiki. Would it be useful to have a search report template analogous to database report? – SD0001  (talk) 11:09, 30 October 2023 (UTC)
 * Oooh, given that elasticsearch replicas exist (TIL!) it would be nice if we can make use of the extra features. Though if the web UI search is sufficient in some cases I still don't think bot reports would be necessarily beneficial? <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 11:37, 30 October 2023 (UTC)
 * Rethinking this, its actually probably quite beneficial to have a community maintained list of search queries where a bot would come by and update periodically. Its better at tracking stuff and makes it better for editors to navigate. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 08:59, 23 November 2023 (UTC)

Database reports/Uncategorized templates missed its weekly update
Database reports/Uncategorized templates typically updates once a week on Monday. It is now 25 hours overdue. 's talk page redirects to this page. Pinging and, the listed operators. – Jonesey95 (talk) 17:20, 5 December 2023 (UTC)


 * Sorry, this is my fault. Should be fixed now and I just kicked off a run. I'll be back online in like 6 hours in case it didn't work to debug further. Legoktm (talk) 21:06, 5 December 2023 (UTC)
 * , There are numerous weekly reports that haven't updated since November 26/27. -- DB 1729 talk 01:15, 6 December 2023 (UTC)
 * Yes, I believe he fixed it for all reports. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 01:21, 6 December 2023 (UTC)
 * Great, and so does someone need to "kick off a run" for each of them now? DB 1729 talk 01:25, 6 December 2023 (UTC)
 * I believe when he said "kicked off a run" he meant for all reports. <span style="font-family:Iosevka,monospace">0x Deadbeef →∞ (talk to me) 01:38, 6 December 2023 (UTC)
 * Ok thanks. I can be patient:) I only mentioned it because the one discussed above, Wikipedia:Database reports/Uncategorized templates, updated several hours ago. While the others have not yet updated. DB 1729 talk 01:47, 6 December 2023 (UTC)
 * And some daily reports have not updated since Dec. 2. Hopefully the same fix will have them back on track. Dicklyon (talk) 03:10, 6 December 2023 (UTC)
 * There are still some issues I'm debugging, but more reports should be updating now... Legoktm (talk) 06:27, 6 December 2023 (UTC)
 * OK, I think all the reports are up to date, except the article streak ones. If anything did not get an update, please let me know and I can look again when I wake up in a few hours. Legoktm (talk) 07:31, 6 December 2023 (UTC)
 * Thank you!:) DB 1729 talk 11:13, 6 December 2023 (UTC)
 * @Legoktm - Database reports/Orphans with incoming links has stopped running, and last ran 03:00, 9 December 2023. JoeNMLC (talk) 19:53, 16 December 2023 (UTC)
 * , it's up to date now. That report's done by, run by . If it happens again, he's probably the best person to contact. BlackcurrantTea (talk) 08:54, 17 December 2023 (UTC)

Database reports/Unused templates (filtered)/1 size jumps from day to day
If you look at the history of Database reports/Unused templates (filtered)/1, you can see the size of the report jumping up and down from day to day, starting on 15 November. It should be much more steady. Pages appear on and disappear from the report for no apparent reason. Clues or fixes are welcome. – Jonesey95 (talk) 15:05, 23 November 2023 (UTC)
 * Anyone? Pinging and, the listed operators of HaleBot, the user that updates this report. – Jonesey95 (talk) 16:32, 28 November 2023 (UTC)
 * And now the report has stopped updating. No updates since 2 December. Help? – Jonesey95 (talk) 16:44, 5 December 2023 (UTC)
 * Ugh, that's wild. It might be a few days before I can look in depth. I wonder if one of the DB replicas is out of sync with the others...or maybe something changed and our query is just busted now. Legoktm (talk) 07:29, 6 December 2023 (UTC)
 * This still isn't working properly. Any idea what the issue is? Gonnym (talk) 09:07, 18 December 2023 (UTC)
 * OK so I tracked down T354089, which seems to be that the replica has fallen out of sync with production, causing some weirdness, but there's more to the story, I'm still debugging. Legoktm (talk) 04:45, 29 December 2023 (UTC)
 * @Jonesey95, @Gonnym: I've applied a fix to the query logic, I'm not sure if this will fully address the issue but it should surface some more unused templates. Legoktm (talk) 04:53, 29 December 2023 (UTC)
 * There are 1,675 templates listed on the report at this writing, which is probably about the right number. We'll see if it fluctuates into the 200–300 range, as it has been doing, or if it stays relatively stable. Thanks for continuing to track down this strange problem. It's challenging to debug a problem when you are not convinced that you have found the actual cause of the problem. – Jonesey95 (talk) 14:13, 29 December 2023 (UTC)
 * @Jonesey95, et al: how do the updates over the past few days look - are we OK to call this resolved? Legoktm (talk) 06:32, 3 January 2024 (UTC)
 * So far seems good. Thanks! Gonnym (talk) 09:12, 3 January 2024 (UTC)
 * Yes, the updates appear to be working correctly. I check them daily. Thanks! – Jonesey95 (talk) 14:57, 3 January 2024 (UTC)