Skip to content

Fixing the “Invalid title in result set” error in MediaWiki

MediaWiki 1.14 introduced a bug (source) with anchor links: using links like [[#this link]] may create invalid rows in the pagelinks table (empty/NULL pl_title value), resulting in a “Invalid title in result set” result at the top of the wanted pages list (Special:WantedPages).
This issue is fixed in MediaWiki 1.15 but the invalid rows aren’t deleted when running the update script (bug 17751).

This can be solved by running the refreshLinks.php maintenance script (maintenance/refreshLinks.php). Be careful though, this script is pretty CPU intensive. On our wiki with around 2700 pages, it took around 3 minutes (which is fairly longer than the time needed by the update script).

Posted in MediaWiki.

One Response

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Mike says


Some HTML is OK

or, reply to this post via trackback.

Sorry about the CAPTCHA that requires JS. If you really don't want to enable JS and still want to comment, you can send me your comment via e-mail and I'll post it for you.

Please solve the CAPTCHA below in order to fight spamWordPress CAPTCHA