Dear Ariel,

I have filed the following Phabricator tasks:
<https://phabricator.wikimedia.org/T103564>,
<https://phabricator.wikimedia.org/T103571>,
<https://phabricator.wikimedia.org/T103575>,
<https://phabricator.wikimedia.org/T103579>, and
<https://phabricator.wikimedia.org/T103583>.

This should cover the most obvious database schemata inconsistencies.

Sincerely Yours,
Kent


On Tue, Jun 23, 2015 at 1:59 AM, Ariel T. Glenn <aglenn@wikimedia.org> wrote:
Hey Kent,

I haven't had a chance to verify all three of the fields as wrong, only
 the first one (which certainly is gone from MW core and should
therefore be gone from the rest).  But yes I'd say these should be
added/changed in Export.php.  I should check to see what our production
databases have going right now.

Would you mind opening a Phabricator task for this so I can get some
other eyeballs on it?  Thanks,

Ariel

Στις 18-06-2015, ημέρα Πεμ, και ώρα 14:40 -0400, ο/η wp mirror έγραψε:
> Dear Ariel,
>
> 0) Context
>
> I am working towards the next release for WP-MIRROR (0.8) and that
> entails updating `mwxml2sql' from 1.24 to 1.26.
>
> 1) Database Schema for `page' table
>
> There are three fields in the `page' table that require attention:
> `page_counter', `page_no_title_convert', and `page_lang'.
>
> These fields are present (YES) or not (NO) in three different places:
>
> MediaWiki 1.26:
> (shell) less maintenance/table.sql
> `page_counter' NO
> `page_no_title_convert' NO
> `page_lang' YES
>
> XML Dump:
> (shell) zless simplewiki-20150603-page.sql.gz
> `page_counter' YES
> `page_no_title_convert' YES
> `page_lang' NO
>
> mwxml2sql:
> (shell) mwxml2sql -m 1.24 -s simplewiki-20150603-stub-articles.sql.gz
> ...
> (shell) less simplewiki-20150603-page.sql-1.24.gz
> `page_counter' YES
> `page_no_title_convert' NO
> `page_lang' NO
>
> 2) XML Dumps
>
> Are there plans to remove `page_counter' and `page_no_title_convert'
> from the XML dumps?
> Are there plans to add `page_lang' to the XML dumps?
>
> 3) mwxml2sql
>
> Do you have any suggestions for how I should update `mwxml2sql' for
> MediaWiki 1.26?
>
> Sincerely Yours,
> Kent
>