Wikipedia talk:Database reports/Archive 8

Archive 5

Archive 6

Archive 7

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 quarry: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)

Liz, you can ping me any time. I noticed that Wikipedia: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 Fastily 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! -FASTILY 07:50, 15 September 2022 (UTC)

Fastily, Wikipedia: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. -FASTILY 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 Wikipedia: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)

Wikipedia: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. -FASTILY 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 Wikipedia: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 Wikipedia:New pages patrol/Reports#Unreviewed articles with merge tags. 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#Request:_Report_of_number_of_unreviewed_articles,_grouped_by_creator) 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? – Joe (talk) 10:03, 27 June 2022 (UTC)

Never mind. I've used {{Database report}} to create the report at Wikipedia:New pages patrol/Reports#Unreviewed new articles by creator (top 10). -MPGuy2824 (talk) 09:05, 2 November 2022 (UTC)

That's a really handy template, thanks! – Joe (talk) 09:27, 2 November 2022 (UTC)

Polluted categories

Is there any particular reason why Wikipedia: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 phab: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 bizarrely subnested userpages (configuration) and I quite enjoyed it. The wikilinks formatting options of {{database report}} 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 {{static row numbers}} similar to what Wikipedia:Database reports/Unused templates/2 is using?

I also wonder whether configuration could be moved to a subpage, but for now I just made Wikipedia: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)

Legoktm, 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)

Legoktm, can you please check on Wikipedia:Database reports/Unused templates and Wikipedia:Database reports/Uncategorized templates? The former was updating daily, and the latter was weekly, so it is not overdue yet. MZMcBride was also developing Wikipedia: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. 1910s_in_music_ (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)

Legoktm, if there is any way to get Wikipedia: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 Category:User soft redirects. Regular redirects are often, but maybe not always, in Category:Redirects from moves. – 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 Wikipedia:Database reports/Articles containing links to the user space working again too?--Jac16888 ^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. 0xDeadbeef→∞ (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--Jac16888 ^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--Jac16888 ^Talk 01:02, 17 December 2022 (UTC)

Hi @Legoktm:, 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?--Jac16888 ^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! 0xDeadbeef→∞ (talk to me) 04:34, 1 February 2023 (UTC)

The report was deployed. 0xDeadbeef→∞ (talk to me) 07:41, 1 February 2023 (UTC)

Inclusion of bot

Today's update to Wikipedia: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 Wikipedia: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 Wikipedia: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 <https://developer.mozilla.org/en-US/docs/Web/CSS/counter-set>, 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 | 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 Wikipedia:Featured articles/By length of course, though it just used the overall page size in bytes. --MZMcBride (talk) 07:46, 13 February 2023 (UTC)

@Legoktm and MZMcBride: Wikipedia: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, HJ Mitchell | Penny for your thoughts? 14:13, 13 February 2023 (UTC)

@HJ Mitchell: here you go: Wikipedia: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! HJ Mitchell | 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 Wikipedia: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 Wikipedia: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. 0xDeadbeef→∞ (talk to me) 04:53, 25 February 2023 (UTC)

HaleBot is sleeping

HaleBot'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#HaleBot. Legoktm (talk) 16:17, 28 April 2023 (UTC)

Database updating stopped

It looks like HaleBot (cc Legoktm, 0xDeadbeef) stopped its daily updating of Wikipedia:List of Wikipedians by number of edits subpages a few days ago. Best, {{u|Sdkb}} ^talk 18:21, 28 May 2023 (UTC)

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

Provide link to Commons file?

As the person who cleans out Wikipedia: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 -FASTILY 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 Wikipedia:Database reports/Unused templates (filtered)/Configuration:

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 Wikipedia:Database reports/Unused templates (filtered) but is shown at Wikipedia:Database reports/Unused templates (filtered)/1. Can this be fixed?

Gonnym (talk) 08:01, 1 June 2023 (UTC)

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 HaleBot (cc Legoktm, 0xDeadbeef) has not updated Wikipedia: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)

@Legoktm: 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 Wikipedia: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 Wikipedia:Database_reports#Current_reports (in the last block). That OK Legoktm? — 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 [1], which goes back to 2012. * Pppery * _{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 Wikipedia: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, {{u|Sdkb}} ^talk 23:26, 10 August 2023 (UTC)

It uses the same system as Wikipedia:List of Wikipedians by number of edits#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.) {{u|Sdkb}} ^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)

Wikipedia: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)

Jdcooper, I left a note for Cewbot's operator, Kanashimi. 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 0xDeadbeef→∞ (talk to me) 12:37, 11 September 2023 (UTC)

Linked miscapitalizations includes pages tagged with R avoided double redirect

Dicklyon recently removed the R avoided double redirect rcat from Novint falcon as it was listed in the linked miscapitalizations report. I reverted that edit, as it seems like this is the situation where {{R avoided double redirect}} is supposed to be used; if the correctly-capitalized Novint Falcon 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 Novint falcon as transcluding itself, which I assume comes from {{R avoided double redirect}} (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 {{R from miscapitalisation}} 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 p1 != p2 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)

Pokechu22, 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)

BlackcurrantTea, hmm. I assume those must come from other templates too then. I notice that Wikipedia:Example of a redirect has a self-transclusion, but 48 hours and 48 hours to life don't. Another interesting set of examples is 2. Divisjon and Talk:2. Divisjon; 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 0xDeadbeef can help. BlackcurrantTea (talk) 09:57, 11 September 2023 (UTC)

done and should be deployed now. 0xDeadbeef→∞ (talk to me) 14:14, 11 September 2023 (UTC)

@0xDeadbeef: 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. 0xDeadbeef→∞ (talk to me) 10:17, 12 September 2023 (UTC)

Another case of unneeded listing comes about via redirect tags such as {{Redirect|Cityrail|the former New Zealand rail operator|Tranz Metro}} 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. 0xDeadbeef→∞ (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 Wikipedia: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)

@HaleBot: 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. 0xDeadbeef→∞ (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. 0xDeadbeef→∞ (talk to me) 12:29, 4 October 2023 (UTC)

 Implemented, see Special:Diff/1178592838 0xDeadbeef→∞ (talk to me) 06:31, 6 October 2023 (UTC)

Working on the middle

If you look at the list Wikipedia: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)