edit

The "Sweet Sixteen"

edit

Quarry: Page links updated is NULL and can't purge

# Page links updated is NULL and can't purge
01 User talk:1r3gr37n0n
02 User talk:68.148.238.76
03 User talk:71.129.57.41
04 User talk:HOTPOCKETSG
05 User talk:Heelo1
06 User talk:Jaeh0317
07 User talk:Lilyonthevalley
08 User talk:Mightym53821
09 User talk:Ttylxox1000
10 User talk:Vd437
11 User talk:Vishal.gkamath
12 Wikipedia:Articles_for_deletion/2009_Sulu_kidnapping_crisis
13 Wikipedia:Articles_for_deletion/2009_Sulu_kidnapping_crisis_(2nd_nomination)
14 Wikipedia:Articles_for_deletion/2009_Sulu_kidnapping_crisis_(3rd_nomination)
15 Wikipedia:Articles_for_deletion/333:_A_Bibliography_of_the_Science-Fantasy_Novel
16 Wikipedia:Articles_for_deletion/3_Libras_(song)
edit

The "Super Six"

edit

Quarry: Page links last updated before 202001 (and not NULL)

# page_links_updated page
1 20190320001746 User talk:195.175.037.8
2 20190320001800 User talk:195.175.037.08
3 20190320001808 User talk:195.175.037.6
4 20190320001816 User talk:203.160.001.146
5 20190320001824 User talk:61.220.150.002
6 20190408022739 User talk:195.175.037.008

These six all seem to have been fixed by making an edit replacing {{OW}} with {{Blanked IP talk}} (e.g., DIFF)

User:BD2412/Archive 051 § IP Talk Page Blanking

This was not a permanent fix, and I don't understand why it worked. Maybe someone else actually did the purge I did below – see Page links last updated before 20240220

edit

The "Magnificent Seven"

edit
# page_links_updated page_namespace page_title page_id page_latest page_touched title
1 20230731115644 0 ᾼ͂ 37366923 1118444191 20240126004918
2 20230731115659 0 ῌ͂ 37366939 1118444204 20240126004918
3 20230731115711 0 Ϊ̀ 37366949 1118444208 20240126004918
4 20230731115722 0 Ϊ͂ 37366956 1118444216 20240126004918
5 20230731115732 0 Ϋ̀ 37366967 1118444219 20240126004918
6 20230731115741 0 Ϋ͂ 37366974 1118444226 20240126004918
7 20230731115748 0 ῼ͂ 37366988 1118444239 20240126004918

These seem to have been introduced by a m:User:Maintenance script run.

I made four edits on 12 August 2023 to deal with issues caused by this bot's run.

Wikipedia:Village pump (technical)/Archive 201#Character only exists in lowercase; blue link leads to nonexistent page (brief 27 November 2022 discussion)

The 40 script edits made on 27 November 2022, all without leaving a redirect: Uppercasing title for Unicode upgrade

My bot was hung up on these seven, repeatedly failing to purge them by page_title, but I was able to successfully purge them by pageids using the API sandbox.

edit

The "Elite Eight"

edit

They're baaaccckkk!

# page_links_updated page page_id page_latest page_touched
1 20230922235521 User talk:195.175.037.008 11429643 891457819 20230922235521
2 20230922235521 User talk:195.175.037.8 11429792 133587951 20240122213253
3 20230922235521 User talk:195.175.037.08 11429818 133588202 20240122213253
4 20230922235521 User talk:195.175.037.6 11429822 133588217 20240122213253
5 20230922235521 User talk:203.160.001.146 11927597 140271565 20240122213257
6 20230922235521 User talk:61.220.150.002 11927623 140271786 20240122213257
7 20231124113143 Ϊ́ 3208957 1118444153 20240320151810
8 20231125075343 Ϋ́ 21375485 1118444154 20240320152903
edit

The "Lucky Thirteen"

edit

Quarry: Page links last updated before 20240220 (and not NULL) The "Super Six" and "Magnificent Seven" have merged!

# page_links_updated page page_id page_latest page_touched
1 20230922235521 User talk:195.175.037.008 11429643 891457819 20230922235521
2 20230922235521 User talk:195.175.037.8 11429792 133587951 20240122213253
3 20230922235521 User talk:195.175.037.08 11429818 133588202 20240122213253
4 20230922235521 User talk:195.175.037.6 11429822 133588217 20240122213253
5 20230922235521 User talk:203.160.001.146 11927597 140271565 20240122213257
6 20230922235521 User talk:61.220.150.002 11927623 140271786 20240122213257
7 20240212160510 Ϋ͂ 37366974 1118444226 20240420164722
8 20240212160510 Ϋ̀ 37366967 1118444219 20240420164722
9 20240212160510 Ϊ͂ 37366956 1118444216 20240420164722
10 20240212160510 Ϊ̀ 37366949 1118444208 20240420164722
11 20240212160510 ῌ͂ 37366939 1118444204 20240420164722
12 20240212160510 ᾼ͂ 37366923 1118444191 20240420164722
13 20240212160510 ῼ͂ 37366988 1118444239 20240420164722

My bot was hung up on the "Super Six", repeatedly failing to purge them by page_title, but I was able to successfully purge them by pageids using the API sandbox.

My bot was hung up on the "Magnificent Seven", repeatedly failing to purge them by page_title, but I was able to successfully purge them by pageids using the API sandbox.

mysqli_result Object
(
   [current_field] => 0
   [field_count] => 1
   [lengths] => 
   [num_rows] => 7
   [type] => 0
)

[warnings] => The value passed for "titles" contains invalid or non-normalized data. Textual data should be valid, NFC-normalized Unicode without C0 control characters other than HT (\t), LF (\n), and CR (\r).