Page MenuHomePhabricator

Page with prefix "Wikipedia:" got somehow in NS 0 in database
Closed, DuplicatePublic

Description

I am writing about this page: https://de.wikipedia.org/w/index.php?title=Wikipedia:Qualit%C3%A4tssicherung/13._November_2014&action=history

In the database (reputation on MWFLabs) I can see that this page in the page table as expected:

MariaDB [dewiki_p]> select page_id,page_namespace,page_title,page_latest from page where page_title='Qualitätssicherung/13._November_2014';
+---------+----------------+---------------------------------------+-------------+
| page_id | page_namespace | page_title                            | page_latest |
+---------+----------------+---------------------------------------+-------------+
| 8447543 |              4 | Qualitätssicherung/13._November_2014  |   138511732 |
+---------+----------------+---------------------------------------+-------------+

BUT also in namespace 0 with prefix Wikipedia:

MariaDB [dewiki_p]> select page_id,page_namespace,page_title,page_latest from page where page_id=8569339;
+---------+----------------+-------------------------------------------------+-------------+
| page_id | page_namespace | page_title                                      | page_latest |
+---------+----------------+-------------------------------------------------+-------------+
| 8569339 |              0 | Wikipedia:Qualitätssicherung/13._November_2014  |   138209237 |
+---------+----------------+-------------------------------------------------+-------------+

-- and it has a useless revision:
select * from revision where rev_page=8569339;

The latter is causing some difficulties, because it says that the template 'Autoarchiv-Erledigt' is included in 'Wikipedia:Qualitätssicherung/13._November_2014'.
(See the API: https://de.wikipedia.org/w/api.php?inprop=protection&maxlag=5&continue=&generator=embeddedin&format=xml&prop=info|imageinfo|categoryinfo&geititle=Vorlage%3AAutoarchiv-Erledigt&geifilterredir=nonredirects&meta=userinfo&indexpageids=&action=query&geilimit=5000&iiprop=timestamp|user|comment|url|size|sha1|metadata&uiprop=blockinfo|hasmsg&geinamespace=0)
But you can only edit the page with id=8447543. As you can see from the edit history the bot is trying that over and over... :)
Please find the reason for that and fix it. Suggestion:

delete from revision where rev_page=8569339 limit 1;
delete from page where page_id=8569339 limit 1;
delete templatelinks where tl_from=8569339 limit 9; -- important for me

Event Timeline

Euku created this task.Feb 5 2015, 12:51 PM
Euku raised the priority of this task from to Normal.
Euku updated the task description. (Show Details)
Euku added a subscriber: Euku.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 5 2015, 12:51 PM