User talk:SDZeroBot

Any comments, feature requests, suggestions or questions can be placed here. Thanks – SD0001 (talk) 09:43, 5 September 2020 (UTC)[reply]

thanks for setting up this highly useful page! --Sm8900 (talk) 21:16, 19 June 2020 (UTC)[reply]

Glad you found it useful! – SD0001 (talk) 09:14, 28 September 2020 (UTC)[reply]

Hey,

I just came across User:SDZeroBot/G13 eligible sorting a few days ago and noticed it hadn't updated in a few days. Just thought I'd leave you a note. Liz ^{Read! Talk!} 20:52, 26 September 2020 (UTC)[reply]

And User:SDZeroBot/G13 soon sorting hasn't updated since 9/23 either. Liz ^{Read! Talk!} 20:54, 26 September 2020 (UTC)[reply]

G13 soon sorting is only set to update twice a week (I'm not even sure if that page is useful given the sheer size), the one seems to have run today. There have been way too many 500 errors from ORES servers from the past few days and I don't know what's causing them. – SD0001 (talk) 12:28, 27 September 2020 (UTC)[reply]

It's phab:T263910. – SD0001 (talk) 18:56, 27 September 2020 (UTC)[reply]

Thanks for the information, SD0001. I was just told about these pages by MusikAnimal because I couldn't understand why Wikipedia:Database reports/Stale drafts has been coming up empty for the past few weeks when it used to list hundreds of stale drafts every morning about 1 am (my time zone). Since your bot has been active, editors have been preemptively going in and deleting drafts when they reach the six month period, without waiting for the database report each morning. So, I've been doing it as well for the past 2 days.

It's confusing that there are now 4 or 5 pages/categories that list stale (or soon-to-be-stale) drafts and none of them are entirely complete as far as I can see. Since I've been looking at the lists for the past two days, I found that none of them list the exact same stale drafts and other editors keep tagging drafts that are older than 6 months that aren't on any of the lists! I guess it's because there are so many thousands of drafts at this point and user sandboxes, too. It's amazing that they can even categorize them all. Thank you again for cluing me in on the updating frequency. Liz ^{Read! Talk!} 20:39, 27 September 2020 (UTC)[reply]

I've been meaning to take a look again at these reports and make them more useful for people seeking to rescue worthy stuff. I've been told User:SDZeroBot/G13 Watch has been useful because of the excerpts. The plan is to add excerpts on both these reports, and reduce the scope of G13 soon to only include pages whose last edit date falls in a period of one day which is about (6 months minus 1 week) before current. – SD0001 (talk) 07:29, 28 September 2020 (UTC)[reply]

And I now notice here I wrote the same comment on this talk page and your user page! My apologies for being repetitive.

Since you are checking this bot's talk page, we've started this conversation and I've been looking through stale drafts recently, maybe I'll be more specific about what my comment above refers to: Why does Category:AfC G13 eligible soon submissions and User:SDZeroBot/G13 eligible sorting have different stale draft contents? Over the past couple of days, I keep finding G13 eligible pages that your bot has found that aren't listed in the G13 category. Are you drawing from different sources of data? It seems like the two pages would have similar content, with the category being larger and this specific bot page just listing drafts that had just expired from their six month period. Thanks for any insight you can offer. Liz ^{Read! Talk!} 00:49, 30 September 2020 (UTC)[reply]

Oh, I hope this will be considered "constructive criticism" but I have a comment about User:SDZeroBot/G13 eligible sorting. In the past hour, it just updated and posted eligible G13 stale drafts but it includes stale drafts that were "saved" during the day by an editor who made an edit to the page. So, instead of the last edit on some of the drafts being March 29, 2020, it is September 29, 2020. This is only happening to a few of them. But they still all get listed as eligible so I'm not sure what the "cutoff" time is for the bot to check their editing history. This is another reason not to use batch delete because it's necessary to check the edit history of each draft listed to see if it has been edited today.

Any way, sorry for all of the feedback...I usually work with categories but en.wiki has had a big lag time and the database report for empty categories hasn't been updated in a few days so I've been looking at drafts instead. Liz ^{Read! Talk!} 01:03, 30 September 2020 (UTC)[reply]

Liz, the AfC categories don't contain any drafts which don't have any AFC templates on them (which is technically natural since some template needs to be there that can apply the category). Anyway, a couple of days back I set up User:SDZeroBot/G13 eligible which IMO is a better format. I see now that User:SDZeroBot/G13 eligible sorting has stopped updating – oops, that was inadvertent, sorry if anyone was still looking at it. But I went ahead and stopped it for real to reduce the redundancy we already have (category, DB report, etc).

it just updated and posted eligible G13 stale drafts but it includes stale drafts that were "saved" during the day by an editor That must have been due to database replag. I amended the code so that it no longer relies solely on the database (which may be lagging), so this should not recur. Thanks for pointing that out. Any way, sorry for all of the feedback lol! I actually love to hear feedback. – SD0001 (talk) 11:25, 4 October 2020 (UTC)[reply]

Well, User:SDZeroBot/G13 eligible is an improvement over User:SDZeroBot/G13 eligible sorting because it contains more information about the draft than just a link.

The earlier version of User:SDZeroBot/G13 soon, where you could sort by date, was more useful to me than ordering them on the list by quality...I'm not even sure how you or a bot can quantify/judge draft quality, that is really quite impressive. The quality aspect is more useful to editors working in the AFC area, rather than my work which is deleting expired or inappropriate content (vandalism, duplicates, tests, spam). I hope editors in AFC are aware of your wonderful new pages and that it helps them prioritize their limited time to review drafts. What you've put together is really remarkable and I wish I understood more of the intelligence behind the topic sorting. Liz ^{Read! Talk!} 00:33, 6 October 2020 (UTC)[reply]

Doesn't the header of the page basically tell how it's done? It's nothing fancy – put the ones tagged as {{promising draft}} at the top, ones which are rejected, too short, declined as "blank" or as "test" at the bottom. Among the remaining, the sourced ones are put above the unsourced ones. Further tie-breakers include the ORES quality prediction (which uses machine learning, but it's an imperfect model that turns up lot of weird results), and then the page size (bigger ones come higher up). – SD0001 (talk) 12:07, 15 October 2020 (UTC) Now that I think of it, I can think of another metric which could be used in the future – the proportion of unreliable/deprecated/blacklisted sources used on the page, which can be detected using the way User:Headbomb/unreliable does it. – SD0001 (talk) 12:11, 15 October 2020 (UTC)[reply]

Hi, SD0001,

On User:SDZeroBot/G13 soon sorting page, could you make a list for the parent categories like Culture and Geography/Regions like you have for the STEM category (that includes all of the STEM subcategories)? It makes it much easier to browse when there is one large, parent category that contains all of the subcategories in it.

I realize that this is opposite to your original purpose of sorting G13s by topic but I'm using the page to look for expiring stale drafts in a more general way. If you don't want to incorporate this change, I understand. All of the new SDZeroBot pages are something that we are all getting used to. Liz ^{Read! Talk!} 16:47, 5 October 2020 (UTC)[reply]

Well the page is already more than 1MB in size, duplicating the entries in the parent categories would turn up the size over 2MB, essentially rendering the page unnavigable. The STEM category does not include the list items from STEM subcategories. – SD0001 (talk) 12:00, 15 October 2020 (UTC)[reply]

Another comment, I'm not sure you'll see, is there is a problem with User:SDZeroBot/G13 Watch. For example, it posts at 00:00 UTC on Oct. 11, drafts that expire on Oct. 11th. But by posting the drafts that expire at the end of the day that they expire, the drafts posted had been deleted when it was posted. So, it just contained a list of links to already deleted drafts.

If you could post, on Oct. 11th, the drafts that are due to expire on Oct. 12th, it would be more useful. Thank you. Liz ^{Read! Talk!} 01:09, 12 October 2020 (UTC)[reply]

Yes that's what G13 Watch is supposed to do. It is list of pages which have already been nominated for G13; used by a few folks like Calliopejen. (The way it's generated is quite different from the other pages – it's a bit unstable and prone to failures as seems to have happened today). – SD0001 (talk) 12:00, 15 October 2020 (UTC)[reply]

Something going on at Draft:Bamtang Games, the bot has thrice edited the date today. The first and third edits were wrong, as that's the date it was moved from draft to main. The 2nd edit in the middle was correct with the date I moved it from mainspace to draft. -- ferret (talk) 00:20, 20 October 2020 (UTC)[reply]

FWIW it was moved from mainspace to draftspace both in July and August. The repeated edits were because the bot first processed the July moves for trial. Later when approved for full run, it processed the August moves then the July moves. It was set up to replace any existing tag because there existed a lot of wrongly dated tags added by another editor. In any case, this task finished many days back so obviously this won't happen again. – SD0001 (talk) 06:55, 26 October 2020 (UTC)[reply]

User:SDZeroBot/G13_soon hasn't been updated in a couple of days. I assume the bot is down. ~Kvng (talk) 16:29, 22 October 2020 (UTC)[reply]

further, it seems to be randomly tagging pages without any justification causing the timer to reset. See the following example, [1] supplied by 2pou (talk · contribs)/ It's several days later now. If it is continuing to do this, I shall block the bot. This is of importance to those few of us who work on the articles in this particular situation, which is essential part of the AfC process. DGG ( talk ) 00:58, 26 October 2020 (UTC)[reply]

Oh, I didn't mean to imply it was random. Apologies, DGG. I think it is just carrying out a one-time passthrough based on this approved task: Wikipedia:Bots/Requests for approval/SDZeroBot 5. -2pou (talk) 04:28, 26 October 2020 (UTC).[reply]

but the approved task is having unfortunate side effects, in destroying the usefulness of Category:AfC G13 eligible soon submissions, a critical category used by several active reviewers. I'm blocking the bot pending further discussion. .Can tthe status of this cateogry before the task run be restored, or is the information lost? DGG ( talk ) 05:13, 26 October 2020 (UTC)[reply]

DGG, the bot's task (which was one-time) has long since finished, there's nothing to be gained in blocking it now. Please unblock. Regarding the issue at hand, I replied at WT:WPAFC#Category:AfC_G13_eligible_soon_submissions. There's no way to restore the category itself to how it was before. But a list of titles that would have been on the category are available at User:SD0001/AfC G13 eligible Oct 2020 or special:permalink/984263470. In hindsight, I agree that this task may have been a net negative, but I had no idea that so many of the pages the bot would tag would be in Category:AfC G13 eligible soon submissions. – SD0001 (talk) 06:51, 26 October 2020 (UTC)[reply]

I think I understand,Before I unblock, I would like assurances that future entries into that category will proceed as before. If not , it would seem necessary to rework and reorganize the structures here in consultation with all those who would be affected . � DGG ( talk ) 17:47, 26 October 2020 (UTC)[reply]

DGG, there was a recent discussion about these moves here with BD2412. It apparently came out of a Village Pump discussion. Liz ^{Read! Talk!} 22:36, 26 October 2020 (UTC)[reply]

I remain somewhat confused bout what was don�e, and why, but I'm unblocking. DGG ( talk ) 02:28, 27 October 2020 (UTC)[reply]

Hi, I got notified of an AfD discussion (Wikipedia:Articles for deletion/Rodney Ferguson) in which I was the one who initiated. It's true that I expanded the article before nominating, but it doesn't make much sense to leave a talk page notification for the nominator. Eagles 24/7 (C) 02:21, 18 November 2020 (UTC)[reply]

Okay – I didn't anticipate the same person both expanding an article and nominating for deletion. Let me see what I can do. – SD0001 (talk) 04:58, 18 November 2020 (UTC)[reply]

I'm not sure rare anomalies of this sort are worth the coding. I think this particular one happens about 2 or 3 times a year. Anyway, as I see it, the notice confirms the system has recognized the request DGG ( talk ) 07:03, 18 November 2020 (UTC)[reply]

Fixed users who've already edited the AFD (by the time SDZeroBot gets to it) won't be notified from now. – SD0001 (talk) 18:17, 19 November 2020 (UTC)[reply]

Delighted to learn that SDZeroBot has won the m:Coolest Tool Award in the Newcomer tools category! I don't know much about how this award is organised or decided, but thanks to everyone who recommended it or voted for it. – SD0001 (talk) 09:32, 12 December 2020 (UTC)[reply]

I didn't know about it before the CTAs. Hopefully this will help it reach more people, because it's such a great tool. --Zack (talk) 14:53, 17 December 2020 (UTC)[reply]

Hi, this edit posted to a redirect. --Redrose64 🌹 (talk) 15:06, 6 February 2021 (UTC)[reply]

Thanks for the heads-up, Redrose64. Fixed shouldn't happen again. – SD0001 (talk) 20:47, 6 February 2021 (UTC)[reply]

SD0001, could you remove User:SDZeroBot/AfD notifier/log from Category:Pages using duplicate arguments in template calls? it looks like the problem is {{history|1=German exonyms (Transylvania)|List of German exonyms for places in Transylvania|2=h}} which has two |1= parameters (one named and one unnamed). thank you. Frietjes (talk) 19:22, 18 June 2021 (UTC)[reply]

Having a sort category for Culture/Food and drink lets me find AfCs that are right in my wheelhouse, that I can often assess almost from my own knowledge base. Thanks for this! —valereee (talk) 16:09, 17 August 2021 (UTC)[reply]

SDZeroBot's task "AfD notifications" failed to run per the configuration specified at Wikipedia:Bot activity monitor/Configurations. Detected only 0 edits in the last 24 hours, whereas at least 1 was expected. If/when the issue is fixed, please change the section title (e.g. append " - Fixed") or remove this section completely. When that is done, this notice will be reposted if the bot task is still broken or is re-broken. If your bot is behaving as expected, then you may want to modify the activity configuration instead. Or to unsubscribe from bot failure notifications, remove the |notify= parameter from the {{/task}} template. Thanks! – SDZeroBot (talk) 01:20, 24 August 2021 (UTC)[reply]

This occurred to this edit in Template:Afd2. Have updated the regex. – SD0001 (talk) 16:07, 25 August 2021 (UTC)[reply]

Moved from User talk:SD0001 § SDZeroBot glitches

 – – SD0001 (talk) 12:01, 9 September 2021 (UTC)

Hello, SD0001,

Once again, SDZeroBot has a hard time handling months that have a different number of days. Tonight, User:SDZeroBot/G13 eligible, which usually has 0 titles listed, has over 400 drafts it identifies as "eligible" for deletion. Except that they are not eligible, they'll be eligible on September 1st or September 2nd. But SDZeroBot thinks that every month has the same number of days. Because February had 28 days but August has 31 days, it is identifying drafts as being eligible before they are because, I guess, it thinks that August 30 is actually September 2.

This is less of a problem now than it is in February when there are fewer days and the bot just skips daily reports for three days in order to catch up. Then, DGG, who regularly scans the report to rescue promising drafts, is frustrated because SDZeroBot just jumps three days ahead and omits those days so he misses three days worth of draft reports and the drafts are simply deleted by patrolling admins.

This is a regular problem and has been since the bot's operation started a year ago. Since most months have 30 or 31 days, editors and admins who work with the G13 Eligible Soon list just adjust to the bot's quirks. But when there is a three day difference, this becomes a larger problem. I hate to nag you about this, because I'm so grateful for the work that the bot does, but you really need to find a way to fix this aberration, maybe by asking other technically-minded editors and admins who work with bots. If any of them have this talk page on their Watchlist and have any ideas for solutions, it would be greatly appreciated before we get to the end of September and this happens again. Thank you. Liz ^{Read! Talk!} 01:18, 31 August 2021 (UTC)[reply]

This seems to be a new issue. If I recall correctly, we were only having calendar-related issues with User:SDZeroBot/G13 soon. G13 eligible is more simple in that it just lists anything that's >6 months old. It doesn't assume anything about the number of days in a month (beyond what the programming language internally does).

The issue appears to stem from JavaScript's datetime computation:
> new Morebits.date()
Morebits.date {_d: Tue Aug 31 2021 16:37:54 GMT+0530 (India Standard Time)}

> new Morebits.date().subtract(6, 'months')
Morebits.date {_d: Wed Mar 03 2021 16:38:08 GMT+0530 (India Standard Time)} // ???

The 2nd result is bizarre.

Thankfully, in SQL the date math makes more sense (quarry:query/58105):

> SELECT NOW()
2021-08-31T11:13:31

> SELECT NOW() - INTERVAL 6 MONTH
2021-02-28T11:13:46

I'll shift the six-month-subtraction from the JS part to the SQL part. Thanks for the bug report!

Regarding the date issues with G13 soon, I'll see if I can take a shot at them tonight. – SD0001 (talk) 11:17, 31 August 2021 (UTC)[reply]

Looking at User:SDZeroBot/G13 soon, I realise that in the list of old links in the header, the dates are all off by 1 (eg. 30 August report is linked as "29 August") – result of copy-pasting the code for User:SDZeroBot/Recent AfC declines (where the off-by-1 actually makes sense) 🤦‍♂️ – SD0001 (talk) 18:03, 31 August 2021 (UTC)[reply]

Have made the changes for the G13 soon report. Will test it out tomorrow night before putting up live. – SD0001 (talk) 19:15, 31 August 2021 (UTC)[reply]

Well, Explicit and I primarily work with the G13 Soon page although I check the G13 Eligible page daily in case we miss anything. It looks like SDZeroBot stopped reports yesterday and then started up again today. We already had a G13 Soon report for March 9th and then it started up today with a report for March 7th. It was actually nice to be a few days ahead, I know DGG probably appreciated this since he reviews the report ahead of the six month expiration date. Right now though, SDZeroBot has issued 3 reports for March 7th, this one on 8/28, and two today that look identical. Should we use the latest one because you say the dates were off by a day? Just ignore the previous March 7, March 8 and March 9 reports and then the bot will resume with a new March 8th report today?

I appreciate your speedy response to my query. The bot is reliable 99% of the time so when there is a glitch, it stands out. Thanks again! Liz ^{Read! Talk!} 23:12, 1 September 2021 (UTC)[reply]

There is something odd about that March 7th G13 Soon report, there are typically about ~200 drafts that expire daily and that list is over 400 drafts! Maybe there was a lot of AFC activity and drafts reviewed that particular day but it sure stands out. I rarely have seen a list with 400+ drafts, maybe once or twice before. Liz ^{Read! Talk!} 23:19, 1 September 2021 (UTC)[reply]

We already had a G13 Soon report for March 9th and then it started up today with a report for March 7th
That again arises from the date math. From now on, this will not occur - rather, the bot will skip create multiple reports in a day or none at all, to keep pace with the calendar. That is, there would no report on next year's Sep 1 and Sep 2, and multiple reports at the end of Feb / start of March. So that there is exactly one report for each calendar day the drafts were last edited.
Should we use the latest one because you say the dates were off by a day?
They should all be correct, though yeah the latest one will have less entries as it skips the ones that have been edited in the last few days. – SD0001 (talk) 04:32, 2 September 2021 (UTC)[reply]

There are two reason I work ahead of the date.one is so I have a chance for some life in the intervals, or if not life outside WP, at least life for somthing else in WP, by taking a day or two away from the list; the other is that I only work with articles that have at least some possibilities, and they need at least a little thinking. I can delete at the rate of 2 or 3 a minute as fast as the script will run, but I cannot think at that speed. I try to catch two things for articles in fields I can handle--ones that were misreviewed and actually show or could easily show notability , and drafts which were never even looked at. Most of those are because they seem boring, but some are because they seem difficult. I hope now that we have temporarily caught up with the afc backlog, that 5 months from now, there will start being many fewer of these. (fwiw, as others have also found, reviewing quality during the rapid catchup drive seems to be the same quality as ordinary. I expected otherwise, and am vey glad my prediction was wrong.). DGG ( talk ) 06:02, 3 September 2021 (UTC)[reply]

FYI, some of the extracts placed on NPP sorting subpages, like User:SDZeroBot/NPP sorting/Culture/Biography causes them to be placed in Category:Pages with templates in the wrong namespace. —⁠andrybak (talk) 13:09, 11 October 2021 (UTC)[reply]

Template:Database report has been nominated for deletion. You are invited to comment on the discussion at the entry on the Templates for discussion page. -- 65.92.246.142 (talk) 03:14, 19 December 2021 (UTC)[reply]

It is extremely misleading for a bot to rate an article GA (even though such ratings are inadmissible), when that is a rating always decided by the community at the GAN process. I suggest it be removed entirely, possibly replaced by A class ratings. Aza24 (talk) 05:11, 28 December 2021 (UTC)[reply]

Re this Aza24 (talk) 05:12, 28 December 2021 (UTC)[reply]

(talk page watcher) @Aza24: Out of Ahmad ibn Isa ibn Zayd, Armorial of railways in Great Britain, Dark Ages (Europe), Black-topped pottery, and List of castles in Jordan, which did you have in mind? --Redrose64 🌹 (talk) 09:47, 28 December 2021 (UTC)[reply]

Well the whole point of GA and FA recognition is going through a review in those respective venues, so there is never a need for a bot to make that evaluation, even if informally. Lists should presumably always be rated list class; Ahmad ibn Isa ibn Zayd and Black-topped pottery are perhaps B and the others are either lists or at AFD (Dark Ages (Europe)). Aza24 (talk) 23:20, 28 December 2021 (UTC)[reply]

I suppose it would make sense to add a * mark to GA and FA ratings for clarification. The bot merely reports back whatever ratings it gets from ORES so I don't think removing it or replacing it with A-class would be appropriate. In any case, these are only used on WP:NPPSORT and WP:AFCSORT; the people who review those pages would know better than to take the predictions at face value. – SD0001 (talk) 10:54, 10 January 2022 (UTC)[reply]

In this edit made by your bot, the {{bots}} template was already placed with |deny=all set. I don't know if this has been fixed in future versions of the code. Both {{nobots}} and {{bots}} are templates which are to say to a bot whether to not or to edit a page. Dreamy Jazz ^{talk to me | my contributions} 00:44, 5 January 2022 (UTC)[reply]

It respects {{nobots}}, but not bots|deny=all and other variations. Will try to add the support for those when I get time. (I see you posted on GitHub as well - if you can file a pull request that'd be great!) – SD0001 (talk) 10:53, 10 January 2022 (UTC)[reply]

I don't know how common my approach is, but when I send something to AfD, I would use the standard template notice only for relatively new editors. If it's a regular with experience in the area, I'd just leave a short note about the AfD, I reckon that's less impersonal. Even with new editors, it's sometimes better to go for a handwritten note, like here, where the AfD is not about deletion at all, but about redirecting or merging. Well, it turns out that instead of making things a little bit better, my approach makes them worse, because the bot will invariably come along and slap on the template anyway. – Uanfala (talk) 01:41, 10 January 2022 (UTC)[reply]

Hmm. I suppose it would be better for the bot to check if the talk page has a link to the AFD. It currently checks for text that looks like the standard section header for AfD notifications. So until the change is done in the bot, the nasty trick would be to place <!-- ==Nomination of [[Languages of the Indian subcontinent]] for deletion== --> on the talk page along with your message. – SD0001 (talk) 11:00, 10 January 2022 (UTC)[reply]

Hello. According to the QPQ check, I have 24 DYKs. However, according to your DYK nominations count link, I only have 21. I was wondering why this was miscounting as I am sure the 24 count is correct. Thanks! --MrLinkinPark333 (talk) 17:55, 25 May 2022 (UTC)[reply]

MrLinkinPark333, 21 nominations seems to be correct, I checked the QPQ Check list and found Template:Did you know nominations/Chip Rives, nominated by another editor, Template:Did you know nominations/Spyridon Louis, nominated by another editor then taken over by you, and Template:Did you know nominations/Julie Sauvé, nominated by another editor. TSventon (talk) 06:42, 26 May 2022 (UTC)[reply]

Ah I see. In that case, the QPQ check tool needs to be swapped with the DYK nominations count tool (or something similar) in the DYK toolbox. QPQs are now needed for a total of 5+ nominations made by an individual user instead of a total of 5+ DYK credits by an individual user. MrLinkinPark333 (talk) 20:21, 26 May 2022 (UTC)[reply]

By the way SD0001, should your DYK nominations counts be listed at User:SDZeroBot? TSventon (talk) 06:54, 26 May 2022 (UTC)[reply]

Have added it to the user page. – SD0001 (talk) 04:01, 3 June 2022 (UTC)[reply]

Just checking to see if User:FunnyKills Bot is you. Cheers. CambridgeBayWeather, Uqaqtuq (talk), Huliva 11:29, 11 June 2022 (UTC)[reply]

@CambridgeBayWeather No, it isn't. – SD0001 (talk) 12:28, 11 June 2022 (UTC)[reply]

Thanks. Page deleted and blocked. CambridgeBayWeather, Uqaqtuq (talk), Huliva 12:44, 11 June 2022 (UTC)[reply]

Hi it looks like the bot hasn’t updated the NPP sort since 8 June. Mccapra (talk) 16:14, 12 June 2022 (UTC)[reply]

(talk page watcher) @Mccapra: See WP:REPLAG also WP:VPT#System problem? --Redrose64 🌹 (talk) 22:37, 12 June 2022 (UTC)[reply]

SDZeroBot's task "AfD notifications" failed to run per the configuration specified at Wikipedia:Bot activity monitor/Configurations. Detected only 0 edits in the last 24 hours, whereas at least 1 was expected. If/when the issue is fixed, please change the section title (e.g. append " - Fixed") or remove this section completely. When that is done, this notice will be reposted if the bot task is still broken or is re-broken. If your bot is behaving as expected, then you may want to modify the task configuration instead. Or to unsubscribe from bot failure notifications, remove the |notify= parameter from the {{/task}} template. Thanks! – SDZeroBot (talk) 01:20, 17 June 2022 (UTC)[reply]

Wouldn't it make more sense to have the Good Article counter list the count in reverse count. In my case I have 218 Good Articles from GANs, so it would be more logical to list 218 on top of the list with the most recent Good Article received, for example John Johnson (inventor) (2022-06-17). The first Good Article I received of Conclusion of the American Civil War (2009-03-08) should be as number 1 (not # 218). Can the counter be programmed to facilitate this counter number in a reverse numbering? Number 1 logically should be at the bottom and the highest number (i.e. #218) at the top of the list with the most recent Good Article received. How does that sound? --Doug Coldwell (talk) 17:46, 24 June 2022 (UTC)[reply]

@Doug Coldwell Fair enough,  Done – SD0001 (talk) 09:03, 25 June 2022 (UTC)[reply]

Great! --Doug Coldwell (talk) 09:37, 25 June 2022 (UTC)[reply]

I suspect this is a case of not recognizing an alternative AFD notification template. Editor is notified via Template:AfD-notice-NPF which is used from page curation and generates different text than Template:Afd notice. Bot notice was delivered a short while later. Whpq (talk) 03:15, 29 August 2022 (UTC)[reply]

Is it possible to have WP:WBGAN include all promotions, instead of cutting off at 14, as it currently does? This would be helpful in assessing user reviews vs. nominations. Thanks. Mike Christie (talk - contribs - library) 23:45, 27 September 2022 (UTC)[reply]

SD0001, if this is not possible, could it be extended at least a bit further? I have proposed a bot that would need this information to function well. I was hoping this would be as simple as removing the current limit, which appears to be 500 rows. Mike Christie (talk - contribs - library) 13:25, 3 October 2022 (UTC)[reply]

@Mike Christie There are 4748 users who have written GAs – listing them all would make the page too big. SDZeroBot maintains the public database s54328__goodarticles_p on toolsdb (and updates the on-wiki list daily by querying it) – which does contain nominator data of all GAs. If your bot is hosted on Toolforge, you can also query this database directly instead of parsing the wiki page. – SD0001 (talk) 16:34, 3 October 2022 (UTC)[reply]

Thanks for the pointer to the database -- that's clearly the best option for me. I am a bit surprised that 4748 is too many records for a daily refresh; WP:GAN has about 1,000 lines and can get refreshed every twenty minutes. Anyway, thanks for the help. Mike Christie (talk - contribs - library) 16:58, 3 October 2022 (UTC)[reply]

Why my pages were nominated for deletation? জাবিরটটক (talk) 08:08, 4 November 2022 (UTC)[reply]

How Can I avoid this nomination of deletation? জাবিরটটক (talk) 07:33, 5 November 2022 (UTC)[reply]

Why "Translation of Quran into Hebrew Language" was nominated for deletation process? জাবিরটটক (talk) 07:28, 5 November 2022 (UTC)[reply]

Hi জাবিরটটক, the reason they are nominated for deletion can be found on the discussion pages linked from your talk page: Wikipedia:Articles for deletion/Quran translations into Bengali language and Wikipedia:Articles for deletion/Quran translations into Hebrew language. SDZeroBot didn't open the nominations, it just notified you about them since you worked on the articles. – SD0001 (talk) 11:19, 5 November 2022 (UTC)[reply]

Hi -- I'm working on a replacement for the GAN functions of Legobot (BRFA here) and I just noticed this page. Do you construct it by scanning the GA nominee category, or by reading WP:GAN? If the latter, would you be able to test if it works with User:ChristieBot/GAN existing format, which, if the bot is approved, will be the new contents of GAN? It's very similar to the existing format but it's not quite identical and I wanted to check that the change, if it happens, wouldn't break your code. If you build it by scanning the category, there's nothing to worry about, of course. Thanks. Mike Christie (talk - contribs - library) 14:07, 4 November 2022 (UTC)[reply]

Hi @Mike Christie, it's built by scanning the category. – SD0001 (talk) 18:58, 4 November 2022 (UTC)[reply]

Great; thanks. Mike Christie (talk - contribs - library) 18:59, 4 November 2022 (UTC)[reply]

Thank you for the very useful {{Database report}}. I'm working through my old Quarry queries which detect various anti-patterns in Wikipedia pages, and setting up those which are still relevant to run weekly. Everything is running smoothly and I've already fixed plenty of articles as a result. One suggestion: would it be sensible and easy to add a little technical information such as query duration? I'll be using this to tweak the run frequency (e.g. change quick jobs to daily and expensive ones to monthly). I can get a good estimate from Quarry, but it might highlight SQL inefficiencies for everyone's benefit. The time of last run (as in date+UTC rather than duration) might also be convenient, though it's easily obtained from page history. Thanks again, Certes (talk) 12:04, 19 November 2022 (UTC)[reply]

@Certes  Done – the bot will now write query_runtime and last_updated params to its {{database report/footer}} call. Feel free to edit that template if you want to tweak the formatting. (It would have been good to put the timestamp just below the update button, but that area is created by the main template whose params are harder for bot to modify.) – SD0001 (talk) 05:53, 20 November 2022 (UTC)[reply]

@SD0001: This is something I have craved for a while. I am so glad you've made it! It works even better than if I'd made it myself. A couple questions:

• Is it possible to specify a footer? That is, a control sequence that you can put at the end of a page, and have it not update past there? On something like Template:Signpost/Number of issues I have wrapped the whole thing in <onlyinclude> tags, so that transcluding the page just gives the number as the output, but this required some clever jiggery-pokery with the row template.
• Is there a way to specify the offset from the interval? For example, if you want it to be every week, but indexed to the beginning of the month.
• How often should I be running them? At Template:Signpost/Number_of_articles, for example, the number will only change once every couple of weeks when we publish... but I have it set to just run every day (because I don't want to have to manually run the thing every time I run the already-onerous publishing script). I don't want to put undue strain on the bot, though: is this an actual concern, or should I just feel free to set the interval to 1 by default? jp×g 21:47, 27 January 2023 (UTC)[reply]

1. Would it be useful to have the report written to a subpage of the page where configuration exists? That way, it can be directly transcluded. This is already possible per this thread, though not documented!
2. Not really, but the check on whether to update is based on SDZeroBot's last edit to the page. So if you web-trigger an update on 1st of the month, then with |interval=7, subsequent updates will take place on 8th, 15th, and so on. Though I wouldn't be opposed to having a cron-based schedule option (without support for hours and minutes as the bot processes periodic updates just once a day), eg. |cron=*/7 * *.
3. Since the query runtime there is just 2-3 seconds, it's totally fine. Only issue would be the edit history pollution.

– SD0001 (talk) 11:12, 28 January 2023 (UTC)[reply]

Hello! There's currently 3 nominations at User:SDZeroBot/GAN sorting that are listed as [failed to parse]: Walter Nash, Polson Logging Co. 2 and Cross Island MRT line. These are not the ones hidden in the Additional nominations collapsible sections, so I'm not sure why they are tagged this way. Thanks! MrLinkinPark333 (talk) 21:11, 11 March 2023 (UTC)[reply]

In the first two cases, the GA nominee template is in a section and not on the top of the talk page as per guidelines.
In the third one, {{GAnominee}} is used instead of {{GA nominee}} – this can be easily handled in the bot's code so I've pushed up a fix. – SD0001 (talk) 06:46, 12 March 2023 (UTC)[reply]

Personally, I don't think this page should be deleted. The subject has a relatively large internet presence and has millions of streams on some of his songs. While not all of his projects are particularly notable, I think it is important that this page remain entact. SaltieChips (talk) 13:35, 31 March 2023 (UTC)[reply]

Hello - I find the "SDZeroBot/G13 soon sorting" information quite helpful, but the information has not been updated since 27 March 2023. I checked the 'err' link, but it is blank. Is there a way to start this service running again? Thanks. DaffodilOcean (talk) 16:27, 9 April 2023 (UTC)[reply]

It has run today. The last scheduled update on April 3 got skipped due to toolforge maintenance downtime. The NFS was down so the error logs are empty as well. – SD0001 (talk) 12:55, 10 April 2023 (UTC)[reply]

Perfect - thanks for update, and thanks for this tool. I quite like the tool and find it super useful. DaffodilOcean (talk) 13:17, 10 April 2023 (UTC)[reply]

Hello, SD0001,

There seems to be a problem with several bots today and that includes SDZeroBot. Is this a system issue? I also ran into this with HaleBot. Thanks for any help you can provide. Liz ^{Read! Talk!} 01:32, 19 April 2023 (UTC)[reply]

This same problem happened with HaleBot and so bot operator Legoktm moved the bot over to a different "platform" because there is a problem with the "grid" (?). And now HaleBot issued its report. Maybe this would help with SDZeroBot. Liz ^{Read! Talk!} 04:05, 19 April 2023 (UTC)[reply]

This should be fixed now. I was in the middle of migrating away from the Grid when the supposed issue with grid occurred. Not sure if that was actually responsible. All SDZeroBot jobs now run on Kubernetes. – SD0001 (talk) 03:58, 21 April 2023 (UTC)[reply]

Last edit to User:SDZeroBot/NPP sorting is April 18. * Pppery * _{it has begun...} 15:05, 21 April 2023 (UTC)[reply]

Should be fixed now. – SD0001 (talk) 17:52, 21 April 2023 (UTC)[reply]

Hello, SD0001,

For some reason, SDZeroBot didn't issue its 00:00 UTC CSD G13 reports tonight. The ones I look at are User:SDZeroBot/G13 eligible and User:SDZeroBot/G13 soon. It's been active today. so the bot isn't down, it just seems to be having some issues with expiring draft reports. Thanks in advance for any solutions you can offer! Liz ^{Read! Talk!} 00:20, 7 May 2023 (UTC)[reply]

Hello, SD0001,

For some reason, SDZeroBot issued User:SDZeroBot/G13 eligible tonight but not User:SDZeroBot/G13 soon. It has continued to issue its regular reports so this seems to be an anomaly. But if we could get the latest User:SDZeroBot/G13 eligible report for tonight, that would be welcome. Thank you. Liz ^{Read! Talk!} 01:43, 17 May 2023 (UTC)[reply]

Hello, SD0001,

Thank you! Looks like things are back to normal. Much appreciated. Liz ^{Read! Talk!} 17:55, 17 May 2023 (UTC)[reply]

Hello, SD0001,

Okay, tonight there was a User:SDZeroBot/G13 soon report but no User:SDZeroBot/G13 eligible report! Before, it was the other way around. This is less urgent as we really need User:SDZeroBot/G13 soon and use those reports every day while User:SDZeroBot/G13 eligible is kind of a bonus. But it might be worth figuring out what's going on. Thanks. Liz ^{Read! Talk!} 02:17, 22 May 2023 (UTC)[reply]

It seems to be a transient issue with the new kubernetes platform. The job just failed to even start up at the scheduled time - no error and no failure email. – SD0001 (talk) 12:04, 23 May 2023 (UTC)[reply]

Hello, SD0001,

Same old issue. Two days without reports. I figured that SDZeroBot would skip one G13 soon report because November had 30 days while May has 31 but now it's skipped two days. I'll add that I'm also seeing issues with other bots whose reports I rely on like AnomieBOT III, HaleBot and others. Things haven't been the same since the replag on s1. Even when it got "caught up", we never saw the backlog of pages/articles that should exist after 5 days with no reports. I'm not sure that everything was restored if they just patched up a solution. Luckily, with SDZeroBot, we have a 7 day lead time so missing reports aren't a dire situation until next week but I thought I'd let you know. Many thanks! Liz ^{Read! Talk!} 00:18, 2 June 2023 (UTC)[reply]

@Liz This isn't related to the replag or the the end-of-the-month disparity, but the same issue from 22 May - the new kubernetes platform just didn't start up the job! I have opened phab:T338006 regarding this. – SD0001 (talk) 06:25, 2 June 2023 (UTC)[reply]

Oh, okay, well, thank you for looking into this. It's odd that it would only affect some reports and not others. Thanks again. Liz ^{Read! Talk!} 20:42, 2 June 2023 (UTC)[reply]

Three days now without a G13 soon or G13 eligible report. I'm starting to get a little nervous. Though if I remember rightly, when the bot kicks in, it issues reports to catch up. Fingers crossed. Liz ^{Read! Talk!} 00:10, 3 June 2023 (UTC)[reply]

Okay, it's been 4 days now. We are working on the May 4th report and the last report that was issued was for May 7th. I made a comment on the phab ticket but it doesn't look like it is getting much response. Do you have any suggestions of what we could do without the report? There used to be a Stale Drafts Database report but I think that was discontinued after SDZeroBot's excellent work started. There is a category for G13 expiring drafts but, for some reason, it only seems to include about 60% of the drafts that appear in SDZeroBot's report. Liz ^{Read! Talk!} 00:18, 4 June 2023 (UTC)[reply]

@Liz I can still run the trigger reports manually - which I have done now. It created 3 reports - one for each day which was missed. – SD0001 (talk) 10:35, 4 June 2023 (UTC)[reply]

Whew! Disaster averted. Thank you very much. Although I have noticed that the G13 lists are shorter than in the past. I guess we have fewer new editors joining the project. Or some editor has swept through the Draft space with AWB correcting commas and we'll end up with 1,000 drafts expiring over one hour sometime during the summer. That's always fun when it happens. ;-) Thanks again for being available and your responsiveness. Liz ^{Read! Talk!} 16:56, 4 June 2023 (UTC)[reply]

The issue is that the platform is too busy at exactly midnight. I have changed the job schedules to run few minutes after midnight instead. – SD0001 (talk) 17:17, 5 June 2023 (UTC)[reply]

I want this for use in fawiki where can i copy Wikipedia:Database reports/Drafts with categories Baratiiman (talk) 12:00, 7 May 2023 (UTC)[reply]

@Baratiiman SDZeroBot only runs on enwiki. The SQL code is available on the page which you can use to setup a bot on your wiki. – SD0001 (talk) 13:35, 23 May 2023 (UTC)[reply]

Was making use of Wikipedia:Database reports/Long pages/Talk to find long Talk pages that might benefit from archiving, but I had limited success because the report includes subpages, which may include existing archives, RfCs, etc.. Could we get a second, similar report that includes only Talk pages that are top level, not subpages? Thanks. -- Netoholic @ 06:24, 8 July 2023 (UTC)[reply]

Hi, you would want to reach out to @JPxG instead, who set up those pages. – SD0001 (talk) 08:56, 8 July 2023 (UTC)[reply]

Thanks for teh ping. @Netoholic: Try Wikipedia:Database reports/Long pages/Talk (no subpages), this may be the netohol you crave? jp×g 09:24, 8 July 2023 (UTC)[reply]

Absolutely amazing. Thank you! -- Netoholic @ 23:01, 8 July 2023 (UTC)[reply]

Would it be possible to add the section name to the edit summary while updating a database report? -MPGuy2824 (talk) 10:18, 21 July 2023 (UTC)[reply]

Not easily. The bot doesn't know what section it's editing - there can be multiple reports in the same section, or no sections at all. – SD0001 (talk) 10:17, 28 July 2023 (UTC)[reply]

Moved to Wikipedia talk:User scripts/Most imported scripts § New script not included

Hey, the bot hasn't updated WP:AFDSORT in a while. It looks like it's trying to fill it up with more than 2MiB of data. My guess is an AfD nom is causing a problem (maybe Wikipedia:Articles for deletion/List of Air Nippon destinations?). Could you look into this please? SWinxy (talk) 22:38, 24 August 2023 (UTC)[reply]

Yes, the issue is that this AfD includes 119 articles, each of which is supposed to appear on AFDSORT. Worse, most of these articles are sorted under multiple topics, so the nomination text is repeated 315 times. And as the nomination text is very long, AFDSORT going over the 2 MiB limit. – SD0001 (talk) 18:38, 25 August 2023 (UTC)[reply]

@SWinxy I've put in a hacky fix to exclude this particular AfD nomination text being included so AFDSORT is back up now! – SD0001 (talk) 18:47, 25 August 2023 (UTC)[reply]

Yay! Thank you! SWinxy (talk) 19:17, 25 August 2023 (UTC)[reply]

@SD0001, AfD notifier doesn't seem to recognize {{AfD-notice-NPF}}, resulting in the bot giving notifications to people who have already been notified. See example at User talk:RockyMasum#Deletion discussion about Zubaida Rahman. CLYDE ^{TALK TO ME}/_{STUFF DONE} 16:22, 2 September 2023 (UTC)[reply]

Fixed. – SD0001 (talk) 06:31, 3 September 2023 (UTC)[reply]

FYI @SD0001, User:SDZeroBot/NPP sorting has not updated for a week now. This is a bit unfortunate as the NPP backlog drive has just started. Can this possibly be updated? Thanks a lot, Schminnte (talk • contribs) 13:38, 1 October 2023 (UTC)[reply]

Looked into it but it's not clear what the issue is – bot is randomly stopping in the middle of the process with no errors logged. Will take a look again later today. – SD0001 (talk) 07:14, 3 October 2023 (UTC)[reply]

It's updated now. Thanks a lot! Schminnte (talk • contribs) 15:17, 3 October 2023 (UTC)[reply]

Interesting. Seems like the issue temporarily resolved on its own. Anyway, have found the root cause now and have fixed it. – SD0001 (talk) 13:08, 4 October 2023 (UTC)[reply]

@SD0001: For NPP sorting pages (such as this), would it be possible to separate the creator and creator edit counts into two separate columns, so that reviewers can more easily sort to find more or less experienced authors (which should nominally correlate with more or less challenging reviews)? Thanks, I love your tool(s)! Iazyges Consermonor Opus meum 17:05, 15 October 2023 (UTC)[reply]

@Iazyges I've made it such that the creator field sorts by the edit count, rather than alphabetically. This is similar to how the class field actually sorts by the class (GA > B > C). As for splitting it into two columns, that would make the table wider - which is more of a problem nowadays as many folks are using vector-2022 which provides lesser horizontal space. – SD0001 (talk) 18:18, 15 October 2023 (UTC)[reply]

Hello SD0001,

When checking Pending AfC submissions and the draft I'm working on, Draft:V (programming language), I noticed it took a large dramatic drop. There were no edits of the draft, so the change seems likely the result of the algorithms used by the bot. The days in question are 27 September 2023 to 28 September 2023. I'm curious as to what could be the reasons or if it's anything to be concerned about.

Additionally, and this might not be under your area, but the "Prior AfD" listed is not to the present V language. What's linked to, is to a different programming language, from 2008. The present one in the draft is from 2019. These different languages, though sharing the same letter, need to be disconnected from each other. Thanks for your work and consideration in advance.Wukuendo (talk) 04:08, 1 November 2023 (UTC)[reply]

Hi, I just stumbled over your GAN-counting tool and noticed that, at least for my results, the entry for Serious Sam: The First Encounter shows it as having passed GA on 1970-01-01 (0 epoch time) instead of 2023-10-30. I assume that the incorrect date is stored in some database, but I couldn't immediately find the origin. Curiously, I couldn't find comparable entries on the spot-checked results of a few other users. IceWelder [✉] 15:33, 4 February 2024 (UTC)[reply]

Fixed – SD0001 (talk) 16:59, 4 February 2024 (UTC)[reply]

I read the title as "epic fail" at first. lol –Novem Linguae (talk) 20:38, 5 February 2024 (UTC)[reply]

I thought at first this had something to do with EpochFail, the creator of ORES. – SD0001 (talk) 05:41, 6 February 2024 (UTC)[reply]

	The Technical Barnstar
	{{Database report}} is amazing and replaced one of the bot tasks I maintained. Thanks for your work on it! Galobtter (talk) 00:07, 6 April 2024 (UTC)[reply]

As far as I can tell the GA counts don't work for users with apostrophes in their usernames. This retrieves nothing, for example. Looking in the database it appears that the nominator for this record is stored as 'Tim O&'. Mike Christie (talk - contribs - library) 10:37, 14 April 2024 (UTC)[reply]

It's a problem with the signature rather than the username itself. Per diff, the user page link in the signature is written as User:Tim O'Doherty which MediaWiki is able to parse fine, but the bot's title parser discards the text after # thinking it to be a URL fragment. – SD0001 (talk) 13:56, 14 April 2024 (UTC)[reply]

I don't know if this would help, but I could give you a list of the correct usernames for the GAs in question. Or make the historical_GA_reviews table in ganfilter publicly readable so you could use it to fix these? Mike Christie (talk - contribs - library) 14:13, 14 April 2024 (UTC)[reply]

@Mike Christie I think all the 8 GAs attributed to Tim_O& are by Tim O'Doherty. I have fixed this manually in the db. Let me know if something still looks wrong. – SD0001 (talk) 17:21, 17 April 2024 (UTC)[reply]

Will do. I can't check from where I am now but I think there were others "where nominator like '%&'" which it would be nice to fix too. Tim was the important one though since he's active so thanks for fixing that. Mike Christie (talk - contribs - library) 17:23, 17 April 2024 (UTC)[reply]

Yeah, it seems everyone with an apostrophe in the username also has a signature containing html entities. I have made a fix for that so html entities are decoded before username parsing. – SD0001 (talk) 18:35, 3 May 2024 (UTC)[reply]

Hello, SD0001,

I'm not sure what happened here. None of the drafts on this page showed up on the relevant User:SDZeroBot/G13 soon page for the day they should have. Things are a little off for the past few days as the editors who regularly deal with G13 drafts, me, Explicit and Hey man im josh, have not been available as much as usual. My mom is on hospice care so I work on Wikipedia when she is sleeping, Explicit, for some reason, has been absent from the project and Hey man im josh doesn't edit on the weekends. So, there has been a bit of a backlog on dealing with expiring drafts. But that's okay, they aren't urgent. But I still don't know why these drafts from Nov. 2/3 didn't show up on G13 soon page. Any ideas why they were "hidden" from us until the day after they expired?

There has been a trend though of a declining number of expiring drafts on the daily G13 soon lists (usually about ~150 drafts) but that has boomeranged in May 2024 because of a AFC backlog drive that occurred in Novembere 2023. So we are seeing higher numbers that we were a few weeks ago.

I hope you are having a good weekend. Liz ^{Read! Talk!} 03:36, 5 May 2024 (UTC)[reply]

Hello, again,

I had noticed that this G13 soon page stated that there were 338 drafts listed at the top of the page but there were clearly weren't that many drafts listed on this page. I often do a search on this page by hour (00:00, 01:00, etc.) and there was no way that 338 pages were included on this page given those numbers which were just 4 or 5 drafts/hour. Can you think of a reason why there would be 338 drafts listed at the top but not that many drafts included on the page and only show up the next day on the G13 eligible page for that date? I should say that I've only seen this kind of glitch happen a few times but it has happened occasionally so I thought I'd ask. Liz ^{Read! Talk!} 05:00, 5 May 2024 (UTC)[reply]

I just noticed that G13 eligible for this day says there are 217 drafts on the report but it only lists 5 drafts even though if you look at the page history for that day it shows a huge amount of content has been added. Why would this content be hidden from view? I see you are editing but haven't responded yet, should I go post on your personal user talk page? Thanks. Liz ^{Read! Talk!} 03:50, 6 May 2024 (UTC)[reply]

I had a busy weekend as I was travelling to attend the Wikimedia Hackathon and just got back. I'll take a look when I have some time. Sorry to hear about your mom, do take care of her. – SD0001 (talk) 13:23, 8 May 2024 (UTC)[reply]

Oh, that sounds like fun, did you have a good time? Despite my lack of programming skills, I attended some hackathons back in 2008-2012 and always enjoyed myself though I wasn't much help to my team.

Turns out that Explicit was only gone for a week so he is back on G13 patrol. But it still seems unusual that the drafts listed on those pages didn't match the counts for the page. Luckily, this doesn't happen often with dependable SDZeroBot but it does make me wonder what went wrong. Thanks for the reply. Liz ^{Read! Talk!} 03:53, 9 May 2024 (UTC)[reply]

Hello, SD0001,

If you ignore all of the "road" articles, which are restored drafts, all of the 20+ drafts should have appeared on a User:SDZeroBot/G13 soon list for 6/3 but for some reason, didn't show up on the daily list. I've looked over all of these drafts and they don't seem to have much in common. Do you know what SDZeroBot would leave these drafts off of the G13 soon list? Thanks. Liz ^{Read! Talk!} 01:36, 4 June 2024 (UTC)[reply]

Smells like a replication lag issue at first glance, but I don't see any current evidence of it at https://replag.toolforge.org/ –Novem Linguae (talk) 07:21, 4 June 2024 (UTC)[reply]

Please see this error message, which started appearing every once in a while a couple of weeks ago. It was happening all the time for a day or so, and then it mostly fixed itself. Is it possible for the bot to avoid updating the page when it encounters this timeout? It is better to have an old report than a completely missing one. Thanks for anything you can do. – Jonesey95 (talk) 02:29, 4 July 2024 (UTC)[reply]

@SD0001:, likewise on Wikipedia:Database reports/Uncategorized templates today, which made the table on Wikipedia:Database reports break. Manually hitting Update Table Now opens the toolforge page as normal, but then it spins endlessly. I tried restoring the July 12 list, but either the bot knows and reverts me, or someone is manually retrying this list every few minutes and it keeps timing out, as I've been reverted twice. Zinnober9 (talk) 04:24, 14 July 2024 (UTC)[reply]

@SD0001 Timed-out again today breaking this Database report page again. Zinnober9 (talk) 15:46, 16 July 2024 (UTC)[reply]

I actually came here to whine about the same thing. Well, more precisely, to ask where you prefer feature requests go, so I could ask for a {{database report}} parameter to append "(timestamp) (errormessage)" instead of replacing whatever was already there. —Cryptic 18:40, 23 July 2024 (UTC)[reply]

Will try to take a look this week. – SD0001 (talk) 13:55, 11 August 2024 (UTC)[reply]

@SD0001: FYI, four of the last five updates to Wikipedia:Database reports/Uncategorized templates by SDZeroBot (either periodic or web triggered) timed out. DH85868993 (talk) 04:28, 9 August 2024 (UTC)[reply]

The bot's error message on this page seems to have broken the table on WP:DBR for some reason... 88.97.195.160 (talk) 18:45, 16 September 2024 (UTC)[reply]

It was the unbalanced table tags in this version, which shouldn't happen. Not that I can think of a good way to fix it: the opening table tag is in Wikipedia:Database reports/Uncategorized templates/Header, which - correctly - only gets transcluded on the report page if the query is successful. I haven't experimented much with the header/row templates that {{database report}} supports, so maybe there's a better way to do it.

Anyway, the reason this broke WP:DBR is because {{DBR row}} gets its "last updated" column by transcluding the report, with the expectation that the report page has a timestamp stuck inside a <onlyinclude> tag pair. Which is as horrifying as it sounds, but there's really no better way to do it - there's a magic word to get the timestamp of an arbitrary page, but it won't update unless the page it's used on is edited. The template can deal with reports that don't have that onlyinclude'd timestamp, or even most misformattings, but apparently can't handle misnested tables. —Cryptic 20:57, 16 September 2024 (UTC)[reply]

Setting skip_table=y and using header_template and footer_template should probably work. The current setup is too complex for me to understand.

I think H:LST would be better than the onlyinclude tag pair which is indeed horrific – in case of unexpected input, nothing would transclude with LST rather than everything. Also, using REVISIONTIMESTAMP does register a dependency in templatelinks – so the page it's used on will get purged when the other one is edited. – SD0001 (talk) 17:02, 18 September 2024 (UTC)[reply]

I couldn't get REVISIONTIMESTAMP to update on its own when I experimented with it - purging the page didn't work, and IIRC even null-editing it didn't. Transcluding a section would work better, yes, but migrating to it isn't worth coordinating with all the other bots, some of which are effectively unmaintained. This should keep the main table from breaking again; supporting {{DBR row}}'s foibles isn't worth the effort either. —Cryptic 01:41, 19 September 2024 (UTC)[reply]

@Cryptic: {{REVISIONTIMESTAMP}}, like the other page revision data variables, gets its value from the most recent entry in the page history. Therefore, it is only updated if an entry is added to the page history - a true WP:NULLEDIT won't do that, and a purge certainly won't. --Redrose64 🌹 (talk) 06:22, 19 September 2024 (UTC)[reply]

While pondering some arcane issues, it occurred to me that it might be possible and/or desirable to use database report templates for heavy lifting (e.g. as a foundation for other bots, or even for webapps elsewhere). This raises some vague security issues, e.g. if the page is vandalized the whole thing goes kablooey. Luckily, being a genius, I realized that this is precisely why WP:TPE exists. Would it be possible to give this bot TPE perms such that sensitive DBR pages could be TE-protected and the bot could roam happily? jp×g🗯️ 01:14, 7 July 2024 (UTC)[reply]

I think the other bots and webapps would do some validation to ensure the data looks as expected. The bot can edit through ECP protection which I think should be enough, especially if the bot-updated data is being transcluded from another hidden-away page. From what I've seen extendedconfirmed editors don't go randomly messing around in project or template namespaces. I'd prefer to see the first such vandalism to occur at ECP so it can be used as a justification for TPE. – SD0001 (talk) 08:00, 7 July 2024 (UTC)[reply]

Howdy,

You recently left me a note on my talk page about Armenian–Azerbaijani cultural relations, linking to this Xtools page and saying that I had been a significant contributor. Xtools is, for some reason, attributing 40% of the page's content to me. This representation is incorrect; my contributions were to tag and remove copyvio, but the website appears to simply attribute all content that was revdel'd to the individual who made the next undeleted revision.

I'm not sure if there is anything you can do on your end, but the data for your notification pipeline does appear to have a (likely systematic) error.

— Red-tailed hawk _(nest) 22:34, 17 September 2024 (UTC)[reply]

Thanks for the note. There's indeed nothing much I can do about this. The data comes from WikiWho API (XTools is just another consumer of WikiWho data), which has a bug tracker here. – SD0001 (talk) 17:45, 21 October 2024 (UTC)[reply]

A suggestion for improving the usability of the /NPP sorting. Currently, clicking on articles opens them in the same tab, which disrupts the workflow, particularly for those reviewing or managing multiple articles in succession. It would be more user-friendly if these links opened in a new tab by default. - The9Man ^Talk 07:52, 27 October 2024 (UTC)[reply]

That's not possible in wikitext. Would require using some custom JavaScript. – SD0001 (talk) 19:02, 27 October 2024 (UTC)[reply]

PetScan does this in its search results lists. The HTML emitted by the script has <a>...</a> elements with the usual attributes like href= title= etc. but also has the special attribute target="_blank" (see HTML 5.2 spec). --Redrose64 🌹 (talk) 23:28, 27 October 2024 (UTC)[reply]

Yes, that attribute can't be generated by wikilinks or external links. Nor does wikitext support manually using <a> tags. But it's possible to write a user script which appends that attribute on links in specific pages. – SD0001 (talk) 11:22, 28 October 2024 (UTC)[reply]

Okay, thanks. - The9Man ^Talk 18:34, 31 October 2024 (UTC)[reply]

Hello, SD0001,

We didn't get an updated report today for User:SDZeroBot/G13 soon. We got one for User:SDZeroBot/G13 eligible but not G13 soon. Can you generate one? Many thanks. Liz ^{Read! Talk!} 01:33, 28 October 2024 (UTC)[reply]

Still hasn't updated, SD0001. Liz ^{Read! Talk!} 08:25, 28 October 2024 (UTC)[reply]

Updated now. Issue was because of WP:VPT#Server lag. – SD0001 (talk) 11:19, 28 October 2024 (UTC)[reply]

Many thanks, SD0001! Liz ^{Read! Talk!} 18:44, 28 October 2024 (UTC)[reply]

Hello, SD0001,

There was no User:SDZeroBot/G13 soon report tonight. Is this because there isn't an "April 31st"? Or is there another problem? Thanks. Liz ^{Read! Talk!} 00:49, 1 November 2024 (UTC)[reply]

Yes, it's because April has only 30 days. – SD0001 (talk) 05:04, 1 November 2024 (UTC)[reply]

Should have run a couple of hours ago but apparently didn’t. Thanks Mccapra (talk) 05:05, 28 October 2024 (UTC)[reply]

Triggered a run manually. Issue was because of WP:VPT#Server lag. – SD0001 (talk) 11:19, 28 October 2024 (UTC)[reply]

Hi, I would like to ask where should I go if I want to see a record of suggested deleted articles before 2024? Gratitude! Lsimplehappy (talk) 11:49, 19 December 2024 (UTC)[reply]

I saw this diff today and was wondering if it might need a fix in the bot's code to avoid peppering linter errors in various places. Low priority though. Thanks! –Novem Linguae (talk) 21:57, 6 November 2024 (UTC)[reply]

Looks like the bot should either remove paragraph breaks or put each paragraph in its own <small> tag. – SD0001 (talk) 13:54, 7 November 2024 (UTC)[reply]

The bot could also use {{smalldiv}} or a div tag equivalent instead of <small>...</small>. I can do a sample edit if one is needed for demonstration. – Jonesey95 (talk) 13:48, 8 November 2024 (UTC)[reply]

Another approach might be to replace \n with {{pb}} or <br />. –Novem Linguae (talk) 18:46, 8 November 2024 (UTC)[reply]

Fixed to remove the \n altogether. Turns out that a single newline character causes a paragraph break only inside a table. The bot only keeps the first paragraph so there aren't supposed to be any paragraph breaks. – SD0001 (talk) 05:47, 9 November 2024 (UTC)[reply]

SD0001, Jonesey95: The problem is back. I meticulously fixed it and the bot promptly wrecked it again. —Anomalocaris (talk) 19:24, 5 May 2025 (UTC)[reply]

Hi SD0001. Would you be willing to add Wikipedia:New pages patrol/Header to the top of your bot's NPP sorting pages? I use the sorted pages quite a lot (thanks, by the way!) and would find it helpful to be able to quickly navigate back to the main NPP pages when I'm done with a particular list. – Joe (talk) 08:08, 25 November 2024 (UTC)[reply]

Hi, I have added it to User:SDZeroBot/NPP sorting/header. – SD0001 (talk) 16:24, 26 November 2024 (UTC)[reply]

Thanks! – Joe (talk) 12:19, 1 January 2025 (UTC)[reply]

Wikipedia:New pages patrol/Reports/Easy reviews#Probable "draftify because of no sources" candidates does not update on querying the bot. Killarnee (talk) 12:44, 25 November 2024 (UTC)[reply]

There have some intermittent issues with Toolforge today (phab:T380844) because of which it may have been skipped. I don't think there's any issue specific to that report. – SD0001 (talk) 16:26, 26 November 2024 (UTC)[reply]

Wikipedia:Database reports/Transclusions of non-existent templates refuses to update today. I've manually asked it to update a few times throughout today, and it times out each time. Causing a paragraph WP:Lint error and a table mess on Wikipedia:Database reports due to this. Zinnober9 (talk) 00:28, 7 December 2024 (UTC)[reply]

Nevermind, has since cleared up. Zinnober9 (talk) 02:12, 7 December 2024 (UTC)[reply]

Hello, User:SD0001,

SDZeroBot didn't issue its G13 reports tonight. It's published other pages so I'm not sure what the problem is with these ones. Thanks for manually kick things into gear. Liz ^{Read! Talk!} 02:03, 21 December 2024 (UTC)[reply]

Just an update, User:SD0001, the 10/21/24 UTC reports still haven't been issued. I hope they get generated before tomorrow. Thanks. Liz ^{Read! Talk!} 08:14, 21 December 2024 (UTC)[reply]

This is because of phab:T382625 / phab:T368098. I triggered the jobs manually twice – they errored out due to maxlag each time. – SD0001 (talk) 08:44, 21 December 2024 (UTC)[reply]

Where's the query? This seems like something that should never take more than a few seconds to complete. (Or am I misunderstanding what went wrong?) —Cryptic 15:43, 21 December 2024 (UTC)[reply]

What's going wrong is that the bot is not able to edit the wiki because it honors maxlag, due to the high lag on production replicas. – SD0001 (talk) 16:40, 21 December 2024 (UTC)[reply]

Appears to have worked now. – SD0001 (talk) 16:54, 21 December 2024 (UTC)[reply]

Thank you for the update, User:SD0001. This is affecting other bots as well. I make use of GalaxyBot's reports and it just issued one at 18:00 UTC but hasn't produced one since and it issues hourly reports so I don't think the situation is resolved yet. But as long as WMF developers are aware of it and are working on the problem, it's a matter of having patience and reminding them if too much time passes without a solution. Liz ^{Read! Talk!} 21:23, 21 December 2024 (UTC)[reply]

I think the system has fallen at least one report behind schedule. It didn't produce a report for June 28, 2024 yesterday. Liz ^{Read! Talk!} 16:53, 22 December 2024 (UTC)[reply]

I'm interested in doing a cleanup of category loops across Wikipedia, and for that I seek to have User:SDZeroBot/Category cycles at least monthly. –LaundryPizza03 (dc̄) 01:47, 11 January 2025 (UTC)[reply]

@LaundryPizza03 I have done a one-time rerun of the script. Periodic run is more complex to set up because this script uses a mixture of runtimes (mysql cli, C++, node.js) for performance due to the volume of data it processes.

For the record, there are currently about 9.1 million parentcat–subcat relationships, and 3558 category cycles involving a total of 7133 category pages. – SD0001 (talk) 18:08, 11 January 2025 (UTC)[reply]

Turns out that the Toolforge node.js image can run C++. I ported over the mysql cli usage to node.js so that everything can run in one image now. I have set up a cron job to refresh the report every 3 months. – SD0001 (talk) 19:31, 11 January 2025 (UTC)[reply]

Hello, SD0001,

I can usually figure out how to correct formatting errors but this got me stuck right here. Any ideas? I'm not even sure how to read this table. Liz ^{Read! Talk!} 02:38, 9 March 2025 (UTC)[reply]

That was probably a mismatched syntax error, such as an unclosed table or table cell, in one of the transcluded excerpts. It appears that subsequent revisions were OK. Stuff like this is why a bunch of us annoying gnomes are going around fixing Linter errors, even on Drafts and old pages. – Jonesey95 (talk) 02:38, 10 March 2025 (UTC)[reply]

I would say unclosed table. The MediaWiki table markup does not have any provision for explicitly closing table cells, other than the double pipe that is used when the markup for two or more cells are on the same line of page source. This apparent omission is probably intentional, and I suspect that it is related to the HTML specs, where an unpaired <td> is not illegal - it's implicitly closed by the next <td>, <th>, <tr>, </tr> or </table> tag. This is a common feature of elements that were introduced before HTML 4. --Redrose64 🌹 (talk) 19:11, 10 March 2025 (UTC)[reply]

When the bot creates User:SDZeroBot/AfD sorting, it appears to wrap each nomination in <small>...</small> tags. When the nomination contains multiple paragraphs, the <small>...</small> tags are wrapping block content instead of in-line content. This causes Linter "misnested tag" errors that you can see on the Page information page.

The easiest option would be to forgo the small tags altogether, just displaying everything at normal size. Another option would be to wrap the whole nomination in {{smalldiv}}, but this runs the risk of breaking if there is a pipe in the nomination, so it is probably not advisable. You could use a div tag with font-size:85%, which would cause a line break after the AFD stats. Or you could add font-size:85% to the style declaration at the top of each table. That would make all of the text in the table small, which may be the best overall outcome.

Let me know if you have any questions. – Jonesey95 (talk) 15:40, 17 March 2025 (UTC)[reply]

Could your bot do something different on User:SDZeroBot/Pending AfC submissions when it reaches the "end point" of a draft's example excerpt when that cut off point is within a template? Case in point, Draft:Jose Duarte Camacho was cut mid ref and is appearing very very wrong with multiple drafts following it incorrectly appearing in Camacho's excerpt cell. The next "new row" entry is the first after another draft's excerpt contained a }} and broke the death cycle. I can't permanently fix it manually in the table since the bot would restore the original broken version next page update, so hoping the bot can be adjusted to avoid this mess. Thank you for considering, Zinnober9 (talk) 14:32, 6 April 2025 (UTC)[reply]

I've been trying to get User:Certes/Reports/Short descriptions for improvement to update, but submitting the request leads to the error "Something bad happened :( The reports may or may not have been updated or are being updated. Please check the page history in a while" after the usual amount of time expected for the query to go through, with no edits made to the page. Suntooooth, it/he (talk/contribs) 11:54, 13 April 2025 (UTC)[reply]

I limited the report to 1,000 pages and it ran. Does that help? – Jonesey95 (talk) 15:38, 17 April 2025 (UTC)[reply]

I made some other improvements. It would be helpful for someone to add an explanation at the top of the page to say what this report is supposed to look for. – Jonesey95 (talk) 16:03, 17 April 2025 (UTC)[reply]

It looks like it's worked, yeah! I don't know the specifics of what it's looking for (too short + starting with disallowed characters are the two things I know it looks for, but I don't know if there's anything else), but the description you've added seems adequate. Thanks for your work on this, I'll reply again if there's any problems! Suntooooth, it/he (talk/contribs) 09:25, 18 April 2025 (UTC)[reply]

When there's something to report, SDZeroBot puts template {{Database report/footer}} at the bottom of the report. For example:

{{Database report/footer|count=1|query_runtime=12.66|last_updated=17:30, 18 April 2025 (UTC)}}

However, when there's nothing to report, this template is not included. Example: Special:Diff/1286301679.

Page Wikipedia:Database reports is constructed using Template:DBR row, which extracts the value of parameter last_updated from an invocation of {{Database report/footer}} using template {{Template parameter value}} (as of Special:Diff/1286575815). However, Template:DBR row cannot do so when the footer is completely removed, leading to unrelated wikitext being transcluded (example: Template categories containing articles), because the other branch of the #if: (see Special:Diff/1286575852) expects a timestamp wrapped in <onlyinclude>...</onlyinclude>. For example, at the very end of the first line of Wikipedia:Database reports/Articles by size:

Articles ranked by total size, principal mainspace. -- [[User:Community Tech bot|Community Tech bot]] ([[User talk:Community Tech bot|talk]]) <onlyinclude>00:12, 15 April 2025 (UTC)</onlyinclude>

Could you please adjust SDZeroBot's database report generation to include the footer even if count is zero? Something like Special:Diff/1286246308/1286578263. —⁠andrybak (talk) 19:38, 20 April 2025 (UTC)[reply]

@SD0001 Bump, this is still an issue. Wikipedia:Database reports/Template categories containing articles is usually empty, which is causing Wikipedia:Database reports to display wrong and report (Paragraph wrapping workaround) syntax errors due to the missing footer. Thank you. Zinnober9 (talk) 23:01, 12 May 2025 (UTC)[reply]

 Done in 7b4579. – SD0001 (talk) 12:03, 13 May 2025 (UTC)[reply]

Hello all. I've submitted an updated version for review. Jhaghazs (talk) 11:44, 7 May 2025 (UTC)[reply]

Jhaghazs: Does your updated version address the issue of malformed <small>...</small> markup discussed above in #Database report linter errors? —Anomalocaris (talk) 17:41, 7 May 2025 (UTC)[reply]

No, they just mean they've submitted an updated version of Draft:Athanasios Tsakalidis. I take it they're informing the bot because it notified them about its AfD. – SD0001 (talk) 15:38, 8 May 2025 (UTC)[reply]

SD0001: Thank you for the clarification. There are now 113 misnested <small> tags in User:SDZeroBot/AfD sorting. —Anomalocaris (talk) 09:52, 9 May 2025 (UTC)[reply]

Observation: each time I check the page [2], need to scroll to the bottom. It is getting long. Probably not intended for manual review.. not sure what you recommend with displaying JSON time series on-wiki, other than something on Toolforge or a personal system. Even then the page will in time exceed length and need archiving. -- GreenC 21:54, 27 May 2025 (UTC)[reply]

The tool was only intended to collect data, with essentially no UI to expose it. (If you are seeing anything other than a dense JSON blob, it's your browser doing the pretty-printing.) We are still waiting for someone else to build a nice visualisation tool into which the data can be fed ;) – SD0001 (talk) 19:14, 29 May 2025 (UTC)[reply]

@GreenC That being said, I can reverse the output order so that the recent dates are listed first. Done in 46e16a51. – SD0001 (talk) 13:54, 30 May 2025 (UTC)[reply]

Thanks, that is helpful. I guess for now I can also archive the page when it gets too long. -- GreenC 15:24, 30 May 2025 (UTC)[reply]

Solution: Extension:Chart .. the data needs to be hosted on Commons in a .tab file, and would have a limited size (determined by Commons) per file. A .tab file is JSON with some required header and footer fields. I've done this before, for a different project. What do you think about hosting the data on Commons in JSON .tab files, so it is accessible to Extension:Chart for visualizing the data? -- GreenC 17:47, 3 June 2025 (UTC)[reply]

Hi, why does User:Raph Williams65/self-transcluded templates list Type text? This is line 707 on this morning's run, and not only does it not transclude itself, it doesn't transclude anything else either. I was intending to WP:CSD#G2 the page, if it was not used anywhere. --Redrose64 🌹 (talk) 06:43, 1 June 2025 (UTC)[reply]

It appears that page was copied without attribution from User:Jonesey95/self-transcluded-templates, which has documentation explaining the not quite accurate title. I agree with the CSD. – Jonesey95 (talk) 12:37, 1 June 2025 (UTC)[reply]

Greetings, at report Wikipedia:Database reports/Long stubs, there is an option for Update the table now. This is in addition to the scheduled Updating database report: periodic update. Occasionally a "web triggered" manual request is ran just before, or shortly after the scheduled report, or multiple times in a row. Wondering if that "web triggered" can somehow be limited? Perhaps only allow 1 request per hour? Or X times per day? Because I am "technology challenged", I'm asking for discussion here. Regards, JoeNMLC (talk) 20:00, 12 June 2025 (UTC)[reply]

Why would you want the updating to be limited? I see no evidence in the history of that page that the update feature is being used excessively. – Jonesey95 (talk) 13:13, 13 June 2025 (UTC)[reply]

Letting you know that the Wikipedia:Database reports/Indefinitely blocked IPs table broke yesterday due to an error: SQL Error: ER_NO_SUCH_TABLE: Table 'enwiki_p.ipblocks' doesn't exist. Clicking Update the table now does not correct this. Zinnober9 (talk) 10:23, 25 June 2025 (UTC)[reply]

I've fixed it. Zinnober9: the botop doesn't write the queries for pages that look like that (the highlit "Edits made within the table area will be removed on the next update!" and link to "Update the table now"); individual users do. You can usually find out who by looking at the page history and finding the last person besides SDZeroBot to edit it.

Possible feature request: maintain an onwiki list of {{database report}} queries that fail their scheduled run. I was the one who migrated that query, as well as Wikipedia:Database reports/Blocked users in user groups (which has been broken for the better part of two weeks), and was watching neither because, well, no interest in their subject matter; IIRC, in both cases someone asked for them to be replaced because the previous bot wasn't working. Watching a log for a:visited colored links would be way less onerous than having to watch the queries themselves and getting a watchlist entry every day for each of them. (I can't think of a usecase to include web-requested runs offhand; if you click on that, you'll see the problem right away.) —Cryptic 11:07, 25 June 2025 (UTC)[reply]

Done; failing reports will be categorised into Category:SDZeroBot database report failures. If you prefer a page instead, you know which template to use to generate one :) – SD0001 (talk) 14:16, 25 June 2025 (UTC)[reply]

Hello SD0001, SDZeroBot's AfD notifier might currently fail to recognize multiblocks, or has a different issue that led to it notifying a globally locked and twice-indefinitely-blocked account here. Best regards, ~ ToBeFree (talk) 04:07, 29 June 2025 (UTC)[reply]

Indeed, fixed here. Detection of locks still works, but this account is not locked – it's instead globally blocked, which the bot doesn't check because ... I didn't know global blocks are a thing. Is it a recent development? – SD0001 (talk) 19:37, 29 June 2025 (UTC)[reply]

@SD0001: Could you please update User:SDZeroBot/Category cycles again? It updated as planned on July 1 and I've spent most of the last week taking a whack at it and would appreciate a new list to clear. My eventual goal is to get to the point where the number of cycles is small enough that all of them fit in the list and I don't have to ask for "unearthing updates" like this. Thank you. * Pppery * _{it has begun...} 01:06, 10 July 2025 (UTC)[reply]

I've enqueued the job. Should be done in about 4 minutes. – SD0001 (talk) 06:36, 10 July 2025 (UTC)[reply]

Thanks. It looks like I've accomplished my goal since the list only went up to /10; I was expecting far more, but I guess my clearing work from before was better than I expected it to be. * Pppery * _{it has begun...} 17:48, 10 July 2025 (UTC)[reply]

Moved from User talk:SD0001 § Reporting bot for "Wikipedia:Database reports/Long stubs" report

 – – SD0001 (talk) 15:48, 14 July 2025 (UTC)

Greetings, The last "periodic update" for Wikipedia:Database reports/Long stubs was 18:44, 11 July 2025 SDZeroBot. Since then, I've done the "Web triggered" request. Error is [SQL Error: : Query execution was interrupted (max_statement_time exceeded) - SDZeroBot applies a timeout of 600 seconds on all queries.]. Today I ran "Update the table now" three times & still same error. Regards, JoeNMLC (talk) 20:33, 13 July 2025 (UTC)[reply]

It looks like the report was refreshed one hour after you posted the above note. This could have been a temporary outage. – Jonesey95 (talk) 00:50, 14 July 2025 (UTC)[reply]

@Jonesey95 - from History, the last good update "Updating database report: periodic update" without error was on 12:34, 7 July 2025. Since then, there were no more periodic Bot updates without error. Also, when I do consecutive "Web triggered" requests, those (error) requests are not making a new History entry, rather just overlaying the previous run's Timestamp. JoeNMLC (talk) 13:25, 14 July 2025 (UTC)[reply]

I see what you mean. Figuring out why the periodic updates have stopped does seem to be a job for SD0001. – Jonesey95 (talk) 14:55, 14 July 2025 (UTC)[reply]

The bot attempts the update but if it results in the same error, the edit will be a null edit, so isn't visible in page history. Moreover, if there are 3 consecutive failures, periodic updates are disabled as there's no point in spending 10 minutes on a query that we know will not complete. This query seems to run in < 10 minutes only occasionally by fluke; it should be optimized if possible – try asking at WP:RAQ. – SD0001 (talk) 15:40, 14 July 2025 (UTC)[reply]

Thanks. I posted there. – Jonesey95 (talk) 15:56, 14 July 2025 (UTC)[reply]

	The Original Barnstar
	<3 Qqzx55zqw (talk) 17:28, 27 July 2025 (UTC)[reply]

Some academic biographies get entered under STEM, but many stay under biographies and are hard to find. How about searching for "professor" and (maybe) "researcher" and adding then as Academics under STEM? It would not be foolproof, but I think would help. Ldm1954 (talk) 20:25, 5 September 2025 (UTC)[reply]

I think academic biographies are already listed both under STEM and under biographies. – SD0001 (talk) 04:14, 6 September 2025 (UTC)[reply]

They are buried in biographies, and not all are in STEM. A separate, additional classification would be very useful. Ldm1954 (talk) 07:40, 6 September 2025 (UTC)[reply]

Biographies currently has 5334 pages, of which 291 have "professor", 92 "researcher", 167 "academic" and 153 "scholar". STEM has 783. As one example Yu Bo (scholar) is in Biography but not STEM. Having a duplicate category as I propose will nake reviewing easier. Ldm1954 (talk) 08:00, 6 September 2025 (UTC)[reply]

The bot has not updated this page since the middle of July, unlike for the other listings that I have checked (which are updated regularly). Would it be possible to fix this somehow, please, SD0001?

As a new page patroller focussing on bios, I would find it useful to be working from an up-to-date version rather than a version with lots of entries that have already been reviewed. Dionysodorus (talk) 12:55, 7 September 2025 (UTC)[reply]

Hmm, it's unusual that no one noticed it being broken for that long. I wonder if this particular list is not much used due to its size. The last update produced around 2 MB of wikitext, which is close to the max article size limit. I think it's been running into the limit since then. I'll try configuring it to use shorter excerpts for biographies. – SD0001 (talk) 13:44, 7 September 2025 (UTC)[reply]

SD0001, have you noticed that there is also some kind of error whereby the table includes one entry, i.e. List of Clark Atlanta University people, that then subsumes within it a large number of subsequent entries that should be separate items in the table? This also makes the page harder to use. Dionysodorus (talk) 13:54, 7 September 2025 (UTC)[reply]

I noticed it, that kind of error occasionally occurs when a page contains some very unexpected markup. It should go away in the next report once the page is fixed. The bot tries to handle many scenarios but it's impossible to handle everything.
Anyway, I see the biographies page is back up now with smaller excerpts. – SD0001 (talk) 14:06, 8 September 2025 (UTC)[reply]

Brilliant: thank you very much for your help. Dionysodorus (talk) 14:10, 8 September 2025 (UTC)[reply]

SD0001, the bot also hasn't archived User:SDZeroBot/AfD sorting for a week. Dionysodorus (talk) 08:32, 12 September 2025 (UTC)[reply]

Back up as of 17 September. There was a huge AfD covering hundreds of pages that was causing internal API responses to exceed the 12 MB limit. – SD0001 (talk) 20:01, 19 September 2025 (UTC)[reply]

Thanks! Dionysodorus (talk) 20:09, 19 September 2025 (UTC)[reply]

Here: [3] and here [4] it's been deleting everything after the template end sign "|}" but it's either not being recognized or the bot wants to see something else. Conyo14 (talk) 17:41, 19 September 2025 (UTC)[reply]

@Conyo14 As the edit summary says, it's overwriting the rest of the page as {{database report end}} is missing. Also, I'd recommend putting the hot article list on a subpage to prevent the bot from polluting the edit history of the WikiProject main page. – SD0001 (talk) 18:45, 19 September 2025 (UTC)[reply]

SDZeroBot seems to not be updating Wikipedia:Database reports/Possibly out-of-process deletions#G6 automatically, despite it having the same interval param as the others. It's updating the other reports just fine.

(While I'm at it, it would be nice for the bot to update all of the reports on a page at once if they have the same interval param; usually it does but sometimes one drifts out of sync). * Pppery * _{it has begun...} 17:42, 20 September 2025 (UTC)[reply]

It will work now. The metadata database didn't have an entry for this and a few other reports on that page due to a bug. I've run a script to repair the db. – SD0001 (talk) 11:13, 22 September 2025 (UTC)[reply]

This is the metadata tracked by the bot if anyone's interested: quarry:query/97390. – SD0001 (talk) 10:02, 23 September 2025 (UTC)[reply]

Greetings, The last time SDZeroBot ran "Periodic update" was 16:28, 24 September 2025. Does the bot need to be "Restarted"? Or is there a bug keeping it from running? Meanwhile either myself, or another editor are doing the "Web triggered" instead, and that runs Okay. Regards, JoeNMLC (talk) 16:20, 27 September 2025 (UTC)[reply]

Periodic updates are only run if it's been 24 hours since the last update (including web-triggered updates). The bot checks for new reports to update every 1-2 hours. – SD0001 (talk) 18:34, 27 September 2025 (UTC)[reply]

Hi SD0001. I hope you're doing well. Since you operated this bot regarding GAN outstanding nomination and old nominations. Is it possible to create a bot to automate the data in progress section of October 2025 GAN backlog drive? I hope for positive response. Thank You! Fade258 (talk) 13:26, 3 October 2025 (UTC)[reply]

User:Mike Christie's bot might be a better fit for such a task. – SD0001 (talk) 14:00, 3 October 2025 (UTC)[reply]

Thank you so much for your help. I will ask there. Fade258 (talk) 14:12, 3 October 2025 (UTC)[reply]

Please can i know how to contribute more to wikipedia regards books and authors that can actually help people in learning new things@SDZeroBot Emilydaniel (talk) 21:28, 9 November 2025 (UTC)[reply]

Hi SDZeroBot

I hope you are doing well. I noticed that you were among the editors who participated in the deletion discussion for the Wikipedia page on Zaheer Farooqui, as listed at Wikipedia:Articles for deletion/Zaheer Farooqui. I am reaching out to seek your guidance on the appropriate way to request a review of the deletion and explore the possibility of restoring the article.

Since the page was deleted, I have come across additional independent and reliable news coverage that was not included in the earlier version of the article. This includes reporting by established news organisations on Zaheer Farooqui’s work as Chairman of the Purkazi Nagar Panchayat, particularly relating to local governance, education initiatives, and community development. Some of this coverage appears to post-date the earlier AfD discussion and may be relevant to the notability concerns that were raised at the time.

My intention is to ensure that any further steps fully align with Wikipedia’s content policies, including WP and sourcing guidelines. Before taking action, I wanted to seek community input and advice from experienced editors like yourself on the most appropriate process—whether that be a deletion review, draft recreation, or another recommended approach.

If you are willing, I would greatly appreciate any guidance you can offer on how best to proceed. Your insight would be very helpful in ensuring that any future submission is policy-compliant and constructive.

Thanks and regards Wikicon07 (talk) 02:49, 12 January 2026 (UTC)[reply]

@Wikicon07: SDZeroBot (talk · contribs) is a bot and does not participate in discussions, deletion or otherwise. I suggest that you read WP:DRV. --Redrose64 🌹 (talk) 23:44, 12 January 2026 (UTC)[reply]

Hi @Redrose64

It is too much to ask but could you please convince Wikipedia authorities to stop the redirection of this page and reinstate it. The page has no controversies and is about a politician who has a settled ground base. The person has genuine media coverage as well. Since no content was added to it for a long time, it was sent for a deletion review and was eventually deleted. There is a plenty of news about the person and will be more in the coming days that must be there on wikipedia. Kindly help.

Regards Wikicon07 (talk) 07:35, 14 January 2026 (UTC)[reply]

I am talking about this page:

Wikipedia:Articles for deletion/Zaheer Farooqui Wikicon07 (talk) 07:38, 14 January 2026 (UTC)[reply]

It was not sent for a deletion review, it was put through the proper articles for deletion (AfD) process. I shall not unilaterally overturn a valid AfD. To get that AfD (and the actions consequent upon it) to be reversed, you need to follow the proper deletion review (DRV) procedure, and await the outcome. --Redrose64 🌹 (talk) 23:31, 15 January 2026 (UTC)[reply]

Sure. I will definitely abide by your suggestions. Thanks. Wikicon07 (talk) 15:44, 25 January 2026 (UTC)[reply]

For some of the Wikipedia:Database reports, the corresponding "big" cleanup is completed, and only rare new issues of the same sort need to be fixed. In such reports, the count parameter in {{Database report/footer}} is almost always zero. It would be useful for people who add such reports to their watchlist, if the bot included the count in its edit summaries. This will make checking if the report has issues to fix much easier.

Side note: most of the time, just seeing the byte size change of the page is enough, but sometimes the bot does an update from count=small non-zero number to the same count=small non-zero number, so the byte size doesn't change or doesn't change noticeably. This means that users who look at an entry in their watchlist have to check the diff regardless. Thankfully, navigation popups make it easy enough, hence low priority. If this requires heavy refactoring in the current code or is difficult for whatever other reason, it's fine, please don't spend time on this request. —⁠andrybak (talk) 22:08, 14 February 2026 (UTC)[reply]

Query time would be handy too. I've got a lot of queries that are only still on my watchlist in case they suddenly start taking much longer to complete; this would save me from even having to look at the diff, and an increase would be immediately obvious looking at the history page. —Cryptic 01:43, 15 February 2026 (UTC)[reply]