![]() | This template was considered for deletion on 25 December 2021. The result of the discussion was "userfy". |
SD0001, I assume that this edit has something to do with this discussion, which just confirms in my mind that trying to run bots on the "toolforge" isn't worth my bother and trouble when it's easy just to run them on my own computer. Any update on the status of this? I ask because Category:Non-talk pages with an edit request template pointed me to Wikipedia:Database reports/Indefinitely semi-protected articles where I saw that Escape the Fate's protection summary "Excessive vandalism: A long history of vandalism, enough is enough; use Error: Protected edit requests can only be made on the talk page. if needed" confused your bot. So I changed the protection to supersede that protection edit summary. Noting that report was last updated on 23 June 2021 – seems this is still not functional at the moment even though this is a standard query and not some new rogue-editor-created query. It only took Quarry 96 seconds to produce a new report but I'm not sure if I can get it in the right format to cut&paste it into Wikipedia:Database reports/Indefinitely semi-protected articles. Maybe you can bypass the "toolforge" and just make Quarry queries directly? wbm1058 ( talk) 19:07, 11 August 2021 (UTC)
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)
@ SD0001: is there any way to support these? I'm trying to convert quarry:query/68246 to a bot-updated report. * Pppery * it has begun... 00:47, 27 October 2022 (UTC)
{{!}}
within the query, the bot will replace it with a pipe. Hopefully there won't be case where we have a query that needs to literally contain {{!}}
. Thanks for bringing it up. –
SD0001 (
talk)
17:55, 27 October 2022 (UTC)
{{
database report/footer}}
counted as the end. Apparently not.
* Pppery *
it has begun...
18:50, 27 October 2022 (UTC)@ SD0001: while using the row_template parameter of this report, it generates output like {{TemplateName|1=20221031,|2=654,|3=1578}}. The issue is with the extra commas for the first two values of the template. - MPGuy2824 ( talk) 10:19, 1 November 2022 (UTC)
output_page
parameter can also now be used to output to a subpage instead (though this is not covered in documentation). Let me know if this is actually useful.As for using row_template to get JSON output, I think a subtle issue is that there's no way to get rid of the extra comma in the last row of the array, so overall it won't be valid JSON! I'm curious as to what data is available in replica dbs which can actually be graphed? –
SD0001 (
talk)
14:15, 20 November 2022 (UTC)
The documentation says Updates can also be manually triggered using the update now button
– but where is the "update now" button? –
Joe (
talk)
10:25, 23 January 2023 (UTC)
extendedconfirmed-show
class to discourage spammy use. But it seems that may have been hiding it from admins as well who technically are not extended confirmed. I added the sysop-show class as well, so you should be able to see it now. –
SD0001 (
talk)
16:52, 23 January 2023 (UTC)Hi, I'm not sure why, but Wikipedia:New_pages_patrol/Reports#AfDs_created_by_NPP_reviewers_in_the_past_week hasn't been updated since 5th March, although it is set for a daily update. I've checked that the query is working properly. - MPGuy2824 ( talk) 03:08, 9 March 2023 (UTC)
If a query result includes a namespace name, and you try to wikilink it to a different namespace, it produces the wrong page. For a simplified example, {{database report|sql=select "Portal:ABC"|wikilinks=1:118}}
should link to
Draft:Portal:ABC, but instead links to
Portal:ABC.
* Pppery *
it has begun...
04:38, 6 May 2023 (UTC)
Please see here and here. Looks like a bug. Or maybe I have a syntax error somewhere? Replag is currently at zero. Anything we can do to fix this? Thanks. – Novem Linguae ( talk) 10:33, 20 June 2023 (UTC)
overwriting rest of page as end template not found
. –
SD0001 (
talk)
17:06, 27 November 2023 (UTC)Might need some nowiki tags for article snippets. Diff. – Novem Linguae ( talk) 05:55, 23 July 2023 (UTC)
Please update the module to use
{{static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-text"
as the table header. Gonnym ( talk) 15:36, 21 August 2023 (UTC)
header_template = static row numbers
along with table_class = wikitable sortable static-row-numbers static-row-header-text
.
Updated docs. –
SD0001 (
talk)
14:45, 27 November 2023 (UTC)I tried a couple variants of this - first just blanking it as documented ( , result); then a space ( , result) and a space and html comment ( , result). Non-logically-blank values do work as expected ( , result). — Cryptic 20:57, 22 November 2023 (UTC)
overflow-wrap: normal
to suppress the default. –
SD0001 (
talk)
13:10, 23 November 2023 (UTC)~~~~ in columns designated in the comments parameter get signed by the bot, and really shouldn't. Example; corresponding log entry for all three rows. I didn't try ~~~ or ~~~~~, but I can't imagine that they'd be handled any better.
There's an argument to suppress external links in these columns, too, since they aren't shown in either log entries or edit summaries (which is what comments is documented for). There's examples of both the bracketed and non-bracketed ( http://example.example) formats in that query. Can't say I feel strongly either way, though. — Cryptic 21:08, 22 November 2023 (UTC)
Some significant technical updates have been made to the bot's handling of scheduled reports, for improving its scalability and stability. The bot should now be able to handle potentially thousands of scheduled reports without missing a beat! A few user-facing improvements as a bonus:
I have the following future improvements on my mind. Let me know if there's any you would like to see, so I can prioritise accordingly.
– SD0001 ( talk) 16:30, 10 December 2023 (UTC)
<nowiki>...</nowiki>
tags. The bot strips the nowikis before sending the query to the database.|silent=
param disables visible output from this template. The {{
database report/footer}} invocation from the bot is also suppressed. This is inspired by @
JPxG's very creative uses of this template!– SD0001 ( talk) 11:04, 10 March 2024 (UTC)
– SD0001 ( talk) 06:38, 15 April 2024 (UTC)
This is a request to change the output for the |last_updated=
parameter to match the time format used in signatures. The current time stamp looks like 1 July 2024 08:19 (UTC)
. The signature time stamp format looks like 08:19, 1 July 2024 (UTC)
. I believe that will make the time format compatible with the "Change UTC-based times and dates, such as those used in signatures, to be relative to local time" gadget. This is probably a change for the bot operator rather than the template, now that I look at the code. Pinging
SD0001, who might know where this code lives. –
Jonesey95 (
talk)
17:20, 1 July 2024 (UTC)
![]() | This template was considered for deletion on 25 December 2021. The result of the discussion was "userfy". |
SD0001, I assume that this edit has something to do with this discussion, which just confirms in my mind that trying to run bots on the "toolforge" isn't worth my bother and trouble when it's easy just to run them on my own computer. Any update on the status of this? I ask because Category:Non-talk pages with an edit request template pointed me to Wikipedia:Database reports/Indefinitely semi-protected articles where I saw that Escape the Fate's protection summary "Excessive vandalism: A long history of vandalism, enough is enough; use Error: Protected edit requests can only be made on the talk page. if needed" confused your bot. So I changed the protection to supersede that protection edit summary. Noting that report was last updated on 23 June 2021 – seems this is still not functional at the moment even though this is a standard query and not some new rogue-editor-created query. It only took Quarry 96 seconds to produce a new report but I'm not sure if I can get it in the right format to cut&paste it into Wikipedia:Database reports/Indefinitely semi-protected articles. Maybe you can bypass the "toolforge" and just make Quarry queries directly? wbm1058 ( talk) 19:07, 11 August 2021 (UTC)
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)
@ SD0001: is there any way to support these? I'm trying to convert quarry:query/68246 to a bot-updated report. * Pppery * it has begun... 00:47, 27 October 2022 (UTC)
{{!}}
within the query, the bot will replace it with a pipe. Hopefully there won't be case where we have a query that needs to literally contain {{!}}
. Thanks for bringing it up. –
SD0001 (
talk)
17:55, 27 October 2022 (UTC)
{{
database report/footer}}
counted as the end. Apparently not.
* Pppery *
it has begun...
18:50, 27 October 2022 (UTC)@ SD0001: while using the row_template parameter of this report, it generates output like {{TemplateName|1=20221031,|2=654,|3=1578}}. The issue is with the extra commas for the first two values of the template. - MPGuy2824 ( talk) 10:19, 1 November 2022 (UTC)
output_page
parameter can also now be used to output to a subpage instead (though this is not covered in documentation). Let me know if this is actually useful.As for using row_template to get JSON output, I think a subtle issue is that there's no way to get rid of the extra comma in the last row of the array, so overall it won't be valid JSON! I'm curious as to what data is available in replica dbs which can actually be graphed? –
SD0001 (
talk)
14:15, 20 November 2022 (UTC)
The documentation says Updates can also be manually triggered using the update now button
– but where is the "update now" button? –
Joe (
talk)
10:25, 23 January 2023 (UTC)
extendedconfirmed-show
class to discourage spammy use. But it seems that may have been hiding it from admins as well who technically are not extended confirmed. I added the sysop-show class as well, so you should be able to see it now. –
SD0001 (
talk)
16:52, 23 January 2023 (UTC)Hi, I'm not sure why, but Wikipedia:New_pages_patrol/Reports#AfDs_created_by_NPP_reviewers_in_the_past_week hasn't been updated since 5th March, although it is set for a daily update. I've checked that the query is working properly. - MPGuy2824 ( talk) 03:08, 9 March 2023 (UTC)
If a query result includes a namespace name, and you try to wikilink it to a different namespace, it produces the wrong page. For a simplified example, {{database report|sql=select "Portal:ABC"|wikilinks=1:118}}
should link to
Draft:Portal:ABC, but instead links to
Portal:ABC.
* Pppery *
it has begun...
04:38, 6 May 2023 (UTC)
Please see here and here. Looks like a bug. Or maybe I have a syntax error somewhere? Replag is currently at zero. Anything we can do to fix this? Thanks. – Novem Linguae ( talk) 10:33, 20 June 2023 (UTC)
overwriting rest of page as end template not found
. –
SD0001 (
talk)
17:06, 27 November 2023 (UTC)Might need some nowiki tags for article snippets. Diff. – Novem Linguae ( talk) 05:55, 23 July 2023 (UTC)
Please update the module to use
{{static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-text"
as the table header. Gonnym ( talk) 15:36, 21 August 2023 (UTC)
header_template = static row numbers
along with table_class = wikitable sortable static-row-numbers static-row-header-text
.
Updated docs. –
SD0001 (
talk)
14:45, 27 November 2023 (UTC)I tried a couple variants of this - first just blanking it as documented ( , result); then a space ( , result) and a space and html comment ( , result). Non-logically-blank values do work as expected ( , result). — Cryptic 20:57, 22 November 2023 (UTC)
overflow-wrap: normal
to suppress the default. –
SD0001 (
talk)
13:10, 23 November 2023 (UTC)~~~~ in columns designated in the comments parameter get signed by the bot, and really shouldn't. Example; corresponding log entry for all three rows. I didn't try ~~~ or ~~~~~, but I can't imagine that they'd be handled any better.
There's an argument to suppress external links in these columns, too, since they aren't shown in either log entries or edit summaries (which is what comments is documented for). There's examples of both the bracketed and non-bracketed ( http://example.example) formats in that query. Can't say I feel strongly either way, though. — Cryptic 21:08, 22 November 2023 (UTC)
Some significant technical updates have been made to the bot's handling of scheduled reports, for improving its scalability and stability. The bot should now be able to handle potentially thousands of scheduled reports without missing a beat! A few user-facing improvements as a bonus:
I have the following future improvements on my mind. Let me know if there's any you would like to see, so I can prioritise accordingly.
– SD0001 ( talk) 16:30, 10 December 2023 (UTC)
<nowiki>...</nowiki>
tags. The bot strips the nowikis before sending the query to the database.|silent=
param disables visible output from this template. The {{
database report/footer}} invocation from the bot is also suppressed. This is inspired by @
JPxG's very creative uses of this template!– SD0001 ( talk) 11:04, 10 March 2024 (UTC)
– SD0001 ( talk) 06:38, 15 April 2024 (UTC)
This is a request to change the output for the |last_updated=
parameter to match the time format used in signatures. The current time stamp looks like 1 July 2024 08:19 (UTC)
. The signature time stamp format looks like 08:19, 1 July 2024 (UTC)
. I believe that will make the time format compatible with the "Change UTC-based times and dates, such as those used in signatures, to be relative to local time" gadget. This is probably a change for the bot operator rather than the template, now that I look at the code. Pinging
SD0001, who might know where this code lives. –
Jonesey95 (
talk)
17:20, 1 July 2024 (UTC)