Page MenuHomePhabricator

Wrong namespace entry for page "User talk:mountainhead" at commons
Closed, DuplicatePublic

Description

rc api call

https://commons.wikimedia.org/w/api.php?rcprop=user%7Ccomment%7Ctimestamp%7Ctitle%7Cids%7Csizes%7Credirect%7Cloginfo%7Cflags%7Ctags&list=recentchanges&action=query&indexpageids=&continue=&rcnamespace=0&rctype=new&rcshow=!redirect%7C!bot&rclimit=100&meta=userinfo&uiprop=blockinfo%7Chasmsg&maxlag=5&format=jsonfm

gives a wrong namespaceresult for "User talk:mountainhead" at commons ("ns": 0) :

{
                "type": "new",
                "ns": 0,
                "title": "User talk:mountainhead",
                "pageid": 75898401,
                "revid": 335082426,
                "old_revid": 0,
                "rcid": 1177906396,
                "user": "Willy1018",
                "new": "",
                "oldlen": 0,
                "newlen": 326,
                "timestamp": "2019-01-16T21:36:47Z",
                "comment": "Some of your [[Commons:Deletion requests/Files in Category:Logos of companies|uploads have been nominated for deletion]].",
                "tags": [
                    "VisualFileChange"
                ]
            },

Event Timeline

Xqt created this task.Jan 19 2019, 3:51 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 19 2019, 3:51 PM
Restricted Application added a project: Growth-Team. · View Herald TranscriptJan 19 2019, 4:02 PM
Reedy added a subscriber: Reedy.Jan 19 2019, 4:02 PM
reedy@deploy1001:~$ mwscript namespaceDupes.php --wiki=commonswiki | grep "mountainhead"
id=75898401 ns=0 dbk=User_talk:mountainhead *** dest title exists and --add-prefix not specified

Hmm.. This page is redirect, namespace looks correctly..

Xqt added a comment.Jan 19 2019, 4:31 PM

namespace looks correctly..

Can't follow: "User talk:" shouldn't be namespace 0 but 2! even it is a redirect page,

Xqt added a comment.EditedJan 19 2019, 4:47 PM

It is a bit strange: https://commons.wikimedia.org/w/index.php?title=User_talk:Mountainhead&oldid=335082426 is a talk page in case sensitive which should not exists,

namespace looks correctly..

Can't follow: "User talk:" shouldn't be namespace 0 but 2! even it is a redirect page,

I think on it to https://commons.wikimedia.org/w/index.php?title=User_talk:Mountainhead points to correct namespace.

It is a bit strange: https://commons.wikimedia.org/w/index.php?title=User_talk:Mountainhead&oldid=335082426 is a talk page in case sensitive which should not exists,

It is problem with revision. I think to page should be deleted and reverted back.

JJMC89 added a subscriber: JJMC89.Jan 19 2019, 7:19 PM
Reedy added a comment.Jan 19 2019, 9:20 PM

There does seem to be a handful of these

reedy@deploy1001:~$ mwscript namespaceDupes.php --wiki=commonswiki | grep "User_talk"
id=42550208 ns=0 dbk=User_talk:Bilorv *** dest title exists and --add-prefix not specified
id=61799531 ns=0 dbk=User_talk:D'Ranged_1 *** dest title exists and --add-prefix not specified
id=38059166 ns=0 dbk=User_talk:Djpillone *** dest title exists and --add-prefix not specified
id=33211804 ns=0 dbk=User_talk:Dralwik *** dest title exists and --add-prefix not specified
id=75898401 ns=0 dbk=User_talk:mountainhead *** dest title exists and --add-prefix not specified
Reedy added a comment.Jan 19 2019, 9:22 PM

It is problem with revision. I think to page should be deleted and reverted back.

? It's numerous page entries

MariaDB [commonswiki]> select * from page where page_namespace = 0 AND page_title IN ('User_talk:mountainhead', 'mountainhead', 'Mountainhead');
+----------+----------------+------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| 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 |
+----------+----------------+------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| 75898401 |              0 | User_talk:mountainhead |                   |                0 |           1 | 0.996685278024 | 20190116213647 | NULL               |   335082426 |      326 |                     0 | wikitext           | NULL      |
+----------+----------------+------------------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
1 row in set (0.00 sec)

MariaDB [commonswiki]> select * from page where page_namespace = 3 AND page_title IN ('User_talk:mountainhead', 'mountainhead', 'Mountainhead');
+----------+----------------+--------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| 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 |
+----------+----------------+--------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+
| 19359439 |              3 | Mountainhead |                   |                0 |           0 | 0.712974527625 | 20190119191624 | 20190119191624     |   335480709 |       43 |                     0 | wikitext           | NULL      |
+----------+----------------+--------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+-----------------------+--------------------+-----------+