SELECT rd_from, page_id FROM redirect LEFT JOIN page ON rd_from = page_id WHERE page_id IS NULL;
The above query should never return a row, but it does - redirect table contains rows with inexistent pages, thus the table is apparently during some action(s) not being updated.
Redirect tables should be cleaned up after fix as well by deleting of improper entries.
Version: unspecified
Severity: normal
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | None | T23962 Run refreshLinks.php --redirects-only on all wikis |
I'm sorry, my mistake. It is a different problem indeed. However, the problem does automatically get solved when bug 16112 is fixed (same script).
Mass-unassigning shell bugs from myself to Rob; I used to do them once, but I
don't have time for them any more.