Page MenuHomePhabricator
Create Task
Maniphest T251562

Run namespaceDupes.php for es.wikipedia
Closed, ResolvedPublic
Actions

Description

While doing regular orphan talk page maintenance, @Savh and myself discovered that some page titles in the Talk namespace did error as a consecuence of T183612: Setup various namespace aliases for eswiki.

We'd appreciate that you run the namespaceDupes.php maintenance script (dry run for now) to look again for broken and/or dupe namespace names.

Thanks for your assistance.

Related Objects

Event Timeline

MarcoAurelio created this task.Apr 30 2020, 7:40 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 30 2020, 7:40 PM
Reedy subscribed.Apr 30 2020, 7:41 PM
reedy@deploy1001:/srv/mediawiki-staging$ mwscript namespaceDupes.php eswiki
0 pages to fix, 0 were resolvable.

pagelinks from=145052 ns=0 dbk=Media: *** INVALID
pagelinks from=6234734 ns=0 dbk=WP:CAD/procedimiento_C -> Wikipedia:CAD/procedimiento_C DRY RUN
pagelinks from=335054 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=590966 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1328126 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1336120 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1337714 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1401410 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1872801 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1921399 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1955985 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1969120 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=1972156 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2006502 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2031577 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2050248 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2063018 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2111852 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2147919 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2154287 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2154887 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2158982 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2228040 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2231667 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2237214 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2267032 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2275228 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2309974 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2342920 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2342945 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2342955 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2343971 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2344879 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2345050 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2348480 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2370958 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2387223 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2401217 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2404002 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2422236 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2427867 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2433793 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2436198 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2478701 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2479870 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2492674 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2498757 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2507290 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2531194 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2566347 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2606720 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2633201 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2827322 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2864579 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2899458 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2914512 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2918104 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2960422 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=2991222 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3020674 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3070748 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3264281 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3396441 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3508497 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3519259 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3558295 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3592229 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3641657 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3930891 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=3965192 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4115552 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4177382 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4192182 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4208062 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4222453 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4279987 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4338785 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4551600 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4574831 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4610775 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4638229 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4649270 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4665864 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4761485 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4796932 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=4959789 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5080894 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5115212 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5172433 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5356797 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5362661 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5502011 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5606345 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5699298 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5769810 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=5771249 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6008884 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6209328 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6211862 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6225506 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6284291 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6305390 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6385047 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6406164 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6458212 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6501223 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6601656 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=6853600 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=7008988 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=7087823 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=7169602 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=7965357 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=8023068 ns=0 dbk=WP:OTRS -> Wikipedia:OTRS DRY RUN
pagelinks from=546589 ns=0 dbk=WP:PVN -> Wikipedia:PVN DRY RUN
pagelinks from=316491 ns=0 dbk=WP:Políticas -> Wikipedia:Políticas DRY RUN
pagelinks from=748707 ns=0 dbk=WP:Políticas -> Wikipedia:Políticas DRY RUN
pagelinks from=1336120 ns=0 dbk=WP:Referencias -> Wikipedia:Referencias DRY RUN
pagelinks from=6303249 ns=0 dbk=WP:Referencias -> Wikipedia:Referencias DRY RUN
pagelinks from=1175724 ns=0 dbk=WP:Spam -> Wikipedia:Spam DRY RUN
pagelinks from=1461442 ns=0 dbk=WP:Spam -> Wikipedia:Spam DRY RUN
pagelinks from=4199000 ns=0 dbk=WP:Spam -> Wikipedia:Spam DRY RUN
pagelinks from=5962286 ns=0 dbk=WP:Spam -> Wikipedia:Spam DRY RUN
pagelinks from=7260307 ns=0 dbk=WP:Spam -> Wikipedia:Spam DRY RUN
pagelinks from=5335836 ns=0 dbk=WP:Zona_de_pruebas -> Wikipedia:Zona_de_pruebas DRY RUN
pagelinks from=8135424 ns=0 dbk=WP:_PVN -> Wikipedia:PVN DRY RUN
pagelinks from=17159 ns=0 dbk=PR:Cine -> Wikiproyecto:Cine DRY RUN
pagelinks from=146728 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=259887 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=497979 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=522284 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=722787 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=736653 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=825252 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=849352 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=863643 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1022590 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1043093 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1086840 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1109344 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1181890 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1181906 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1186214 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1196435 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1238666 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1362899 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1420600 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1463902 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1532357 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1613551 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1614881 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=1614886 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2429770 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2439365 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2449802 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2449806 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2472665 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2500546 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2538053 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2581946 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2791483 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2819775 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2819796 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=2923515 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
pagelinks from=3045128 ns=0 dbk=PR:LGBT -> Wikiproyecto:LGBT DRY RUN
164 links to fix, 163 were resolvable.

Looks good!
MarcoAurelio added a comment.Apr 30 2020, 8:12 PM

Thanks @Reedy - Looks like most of them can be automatically fixed using the --fix option. Could you do that, and see how many of them would need manual fixing? Thanks

MarcoAurelio moved this task from Backlog to WMF Prod on the Wikimedia-maintenance-script-run board.Apr 30 2020, 8:16 PM
Reedy added a comment.Apr 30 2020, 8:18 PM

No matter how many times I run mwscript namespaceDupes.php eswiki --fix the output is the same...

It doesn't seem to want to fix the pagelinks...

Reedy mentioned this in T251569: `namespaceDupes.php --fix` not fixing links?.Apr 30 2020, 8:19 PM
MarcoAurelio added a comment.Apr 30 2020, 8:23 PM
This comment was removed by MarcoAurelio.
Reedy added a comment.Apr 30 2020, 11:10 PM
reedy@deploy1001:/srv/mediawiki-staging/php-1.35.0-wmf.28/maintenance$ mwscript namespaceDupes.php --wiki=eswiki --fix
0 pages to fix, 0 were resolvable.

pagelinks from=145052 ns=0 dbk=Media: *** INVALID
1 links to fix, 0 were resolvable.

Looks good!
MarcoAurelio added a comment.May 1 2020, 10:26 AM

How to fix that pagelinks from=145052 ns=0 dbk=Media: *** INVALID thing? Thanks.

Reedy closed this task as Resolved.May 1 2020, 1:51 PM
Reedy claimed this task.
In T251562#6099626, @MarcoAurelio wrote:

How to fix that pagelinks from=145052 ns=0 dbk=Media: *** INVALID thing? Thanks.

Manual DB query?

MariaDB [eswiki]> delete from pagelinks where pl_from=145052 AND pl_title = 'Media:';
Query OK, 1 row affected (0.00 sec)

MariaDB [eswiki]> Bye
reedy@deploy1001:~$ mwscript namespaceDupes.php --wiki=eswiki --fix
0 pages to fix, 0 were resolvable.

0 links to fix, 0 were resolvable.

Looks good!
MarcoAurelio added a comment.May 1 2020, 2:31 PM
In T251562#6099943, @Reedy wrote:
In T251562#6099626, @MarcoAurelio wrote:

How to fix that pagelinks from=145052 ns=0 dbk=Media: *** INVALID thing? Thanks.

Manual DB query?

MariaDB [eswiki]> delete from pagelinks where pl_from=145052 AND pl_title = 'Media:';
Query OK, 1 row affected (0.00 sec)

MariaDB [eswiki]> Bye
reedy@deploy1001:~$ mwscript namespaceDupes.php --wiki=eswiki --fix
0 pages to fix, 0 were resolvable.

0 links to fix, 0 were resolvable.

Looks good!

Ah but that required supah powahs. Thanks :-)

MarcoAurelio mentioned this in T254077: Rename some es.wikipedia namespaces.Jun 3 2020, 12:17 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL