Wikimedia Bugzilla is closed!

Using Cite and <ref> tags invalid rows are created in the pagelinks table.

These rows are invalid because they have a pl_title = ''.

This -may- break Special:MostLinkedPages page (a fix was put in to stop invalid titles breaking the page) - see #18943, #17751 and #17713 for more information on this flavor of issue.

To identify broken pages:

SELECT page.*
FROM
  wikidb.page page left join
  wikidb.pagelinks p on page.page_id = p.pl_from
where p.pl_title = '';


To reproduce:
1. Run the query above to ensure you have no broken page titles
2. Edit a page and add <ref name="test">http://google.com, a search engine</ref>
3. Re-run the query

I'm not confident this is a bug with the Cite extension or whether it is the engine but thought it most appropriate here.

I am assuming blank rows are an issue because issue #17713 says "Invalid database rows worry me" in regards to rows with an empty pl_title