I started this week with creating missing redirects that were NOT converted.
It turns out they are ALL redirects in MAIN that link to pages in another NameSpace (worth looking into)
i just ran a query on the old wiki install DB
PHP Code:
select page.page_id, page.page_title, page.page_is_redirect, redirect.rd_namespace, redirect.rd_title
from wiki_page as page
LEFT JOIN wiki_redirect as redirect ON ( page.page_id = redirect.rd_from)
WHERE redirect.rd_namespace = '110'
And it turns out i SHOULD have
3869 redirects, going from main to namespace 110
when running a query to see how many actually ARE in the wiki..
PHP Code:
Select title, pagetext from vb3_post where pagetext LIKE '[REDIRECT]D20%'
and
PHP Code:
Select title, pagetext from vb3_post where pagetext LIKE '[REDIRECT][srd%'
the [REDIRECT]D20:xxxxxxxx pages are a total of 93 (this are links to pagetitles)
and the [REDIRECT][srd]xxxxxxxxxx are a total of 253 (these are link to properly build links of namespace SRD)
so doing a quick math: 3869 - (93 + 253) = TOO MANY
what i want to do is to have a php script (or a mysql query if that is enough) where the remaining redirects are insterted in the right places in the DB.
for me this is a lot to puzzle who what and where, probably for you not.
or point me in the right direction, which tables/fields have to be updated to insert a redirect.