FYI,

It seems that the entries missing from the redirect table into page have been fixed in production. I tested this on db1047:

select count(*) from page left join redirect on page_id = rd_from where page_is_redirect != 0 and rd_from is null;

+----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (39.33 sec)

Can anyone check it on the Toolserver?

G

On Wed 27 Mar 2013 11:46:30 AM EDT, Giovanni Luca Ciampaglia wrote:

Thanks Ariel, it seems that the numbers are very low though: 23 redirects that don't have page_is_redirect set and 5 with page_is_redirect set but that don't appear in redirect.

As long as I can spare myself from going through the pagelinks table I can live with that :-)

Cheers

Giovanni

On Wed 27 Mar 2013 03:32:29 AM EDT, Ariel T. Glenn wrote:

...

Στις 26-03-2013, ημέρα Τρι, και ώρα 20:11 -0400, ο/η Giovanni Luca Ciampaglia έγραψε:

...

Hi all,

I am wondering if the NOTE on the manual page of the redirect table [1] still applies and, if this is the case, how many data are missing and what would be the best way to incorporate the pagelinks table, since it seems to lack the information about whether a link is a redirect or not.

[1] https://www.mediawiki.org/wiki/Manual:Redirect_table

Cheers

It looks like there are still some issues; see

https://bugzilla.wikimedia.org/show_bug.cgi?id=39011

Ariel

-- Giovanni Luca Ciampaglia

☞ http://www.inf.usi.ch/phd/ciampaglia/ ✆ (812) 287-3471 ✉ glciampagl@gmail.com