Page MenuHomePhabricator

Namespaces for "Educational program" still exist on various wikis
Closed, DuplicatePublic

Description

"Educational program" extension was deprecated and deleted from all wikipedias, but it remains in ns list, see screenshot.

Event Timeline

MBH created this task.Feb 5 2019, 11:53 AM
Restricted Application added subscribers: Base, Aklapper. · View Herald TranscriptFeb 5 2019, 11:53 AM
Krinkle renamed this task from Namespace list in ruwiki still contain "Educational program" ns and its talk to Namespaces for "Educational program" still exist on various wikis.Feb 7 2019, 3:03 AM
Krinkle added a subscriber: Krinkle.

Thanks, that makes sense.

Is the plan to delete these pages and then re-remove the namespaces? At least on ar.wikipedia.org it seems like there are already no pages in this namespace.

Reedy added a comment.Feb 7 2019, 3:13 AM

Thanks, that makes sense.
Is the plan to delete these pages and then re-remove the namespaces? At least on ar.wikipedia.org it seems like there are already no pages in this namespace.

Something like that, yeah (or moving them to another NS/prefix). Needs some input from people that actually care about the pages

I just re-enabled the NS everywhere for ease. If there's wikis that don't need it at all (because the NS have no pages), it's good to just disable it again

Reedy added a comment.Feb 7 2019, 3:53 AM
reedy@deploy1001:~$ cat ep.sql 
SELECT COUNT(*) FROM page WHERE page_namespace IN ( 446, 447 );
reedy@deploy1001:~$ cat ep-pages.sh 
#!/bin/bash
wikis="arwiki cawiki cswiki dewikiversity elwiki enwiki enwikinews eswiki fawiki frwikisource hewiki hewiktionary itwikiversity lvwiki mkwiki nlwiki ptwiki ruwiki srwiki svwiki ukwiki"
for db in ${wikis[@]}; do
    echo "$db"
    mwscript sql.php "$db" ~/ep.sql
done
reedy@deploy1001:~$ ./ep-pages.sh 
arwiki
stdClass Object
(
    [COUNT(*)] => 0
)

cawiki
stdClass Object
(
    [COUNT(*)] => 0
)

cswiki
stdClass Object
(
    [COUNT(*)] => 28
)

dewikiversity
stdClass Object
(
    [COUNT(*)] => 0
)

elwiki
stdClass Object
(
    [COUNT(*)] => 3
)

enwiki
stdClass Object
(
    [COUNT(*)] => 1538
)

enwikinews
stdClass Object
(
    [COUNT(*)] => 0
)

eswiki
stdClass Object
(
    [COUNT(*)] => 12
)

fawiki
stdClass Object
(
    [COUNT(*)] => 4
)

frwikisource
stdClass Object
(
    [COUNT(*)] => 0
)

hewiki
stdClass Object
(
    [COUNT(*)] => 14
)

hewiktionary
stdClass Object
(
    [COUNT(*)] => 0
)

itwikiversity
stdClass Object
(
    [COUNT(*)] => 9
)

lvwiki
stdClass Object
(
    [COUNT(*)] => 2
)

mkwiki
stdClass Object
(
    [COUNT(*)] => 0
)

nlwiki
stdClass Object
(
    [COUNT(*)] => 5
)

ptwiki
stdClass Object
(
    [COUNT(*)] => 30
)

ruwiki
stdClass Object
(
    [COUNT(*)] => 1
)

srwiki
stdClass Object
(
    [COUNT(*)] => 0
)

svwiki
stdClass Object
(
    [COUNT(*)] => 2
)

ukwiki
stdClass Object
(
    [COUNT(*)] => 20
)

reedy@deploy1001:~$
Reedy added a comment.EditedFeb 7 2019, 3:11 PM
In T215262#4934842, @MaxBioHazard wrote:

The database disagrees (and so does your first link)

MariaDB [ruwiki]> select * from page WHERE page_namespace IN ( 446, 447 );
+---------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| page_id | page_namespace | page_title                                                                                                                                 | page_restrictions | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_no_title_convert | page_content_model | page_lang |
+---------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| 5473599 |            447 | Петрозаводский_государственный_университет/Интернет-математика_(2015_весна)                                                                |                   |                0 |           0 | 0.508908381546 | 20151202174353 | 20151202174354     |    74874784 |      436 |                     0 | wikitext           | NULL      |
+---------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
1 row in set (0.00 sec)

https://ru.wikipedia.org/wiki/Education_Program_talk:%D0%9F%D0%B5%D1%82%D1%80%D0%BE%D0%B7%D0%B0%D0%B2%D0%BE%D0%B4%D1%81%D0%BA%D0%B8%D0%B9_%D0%B3%D0%BE%D1%81%D1%83%D0%B4%D0%B0%D1%80%D1%81%D1%82%D0%B2%D0%B5%D0%BD%D0%BD%D1%8B%D0%B9_%D1%83%D0%BD%D0%B8%D0%B2%D0%B5%D1%80%D1%81%D0%B8%D1%82%D0%B5%D1%82/%D0%98%D0%BD%D1%82%D0%B5%D1%80%D0%BD%D0%B5%D1%82-%D0%BC%D0%B0%D1%82%D0%B5%D0%BC%D0%B0%D1%82%D0%B8%D0%BA%D0%B0_(2015_%D0%B2%D0%B5%D1%81%D0%BD%D0%B0)

MBH added a comment.Feb 7 2019, 3:27 PM

Deleted.