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