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

           Summary: en:wikipedia SQL interwiki table
           Product: Wikimedia
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: major
          Priority: Normal
         Component: Interwiki links
        AssignedTo: wikibugs-l@lists.wikimedia.org
        ReportedBy: bbure...@noos.fr


Hi,

I recently noticed that the API for Wikipedia adds [[U+FFFD]] (they eventually
show up like question marks in a little diamond) at the end of all strings
returned by the following API request:
*
http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=interwikimap

My bot bumped on this on <i>en.wikipedia.org</i> and was unable to get the
interwiki list from the site.

Strangely enough this seems to happen only here as other Wikipedia wikis don't
exhibit this behaviour. A few examples:
*
http://fr.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=interwikimap
*
http://pt.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=interwikimap
*
http://zh.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=interwikimap

My guess is that the database table “interwiki” contains extra characters after
each field, on my MediaWiki server this is what I see:
 mysql> desc interwiki ;
 +-----------+---------------+------+-----+---------+-------+
 | Field     | Type          | Null | Key | Default | Extra |
 +-----------+---------------+------+-----+---------+-------+
 | iw_prefix | varbinary(32) | NO   | PRI | NULL    |       |
 | iw_url    | blob          | NO   |     | NULL    |       |
 | iw_local  | tinyint(1)    | NO   |     | NULL    |       |
 | iw_url    | tinyint(1)    | NO   |     | NULL    |       |
 +-----------+---------------+------+-----+---------+-------+
you can confirm that all “prefix” fields in the XML returned by
<i>en.wikipedia.org</i> are exactly 32 characters long so the var in
varbinary() is not used or the code reading that field has a problem.

Thank, Regards,

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to