Page MenuHomePhabricator

ipblocks.ipb_by_text database column has gone missing from English Wikipedia database replica
Closed, DuplicatePublic

Description

The column ipblocks.ipb_by_text has gone missing from the English Wikipedia database replica as of March 2019.

This is the error my script is getting:

pymysql.err.InternalError: (1054, u"Unknown column 'ipb_by_text' in 'field list'")

MariaDB [enwiki_p]> describe ipblocks;
+----------------------+---------------------+------+-----+---------+-------+
| Field                | Type                | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------+-------+
| ipb_id               | int(8)              | NO   |     | 0       |       |
| ipb_address          | varbinary(255)      | YES  |     | NULL    |       |
| ipb_user             | int(8) unsigned     | NO   |     | 0       |       |
| ipb_reason_id        | bigint(20) unsigned | NO   |     | 0       |       |
| ipb_timestamp        | varbinary(14)       | NO   |     |         |       |
| ipb_auto             | tinyint(1)          | NO   |     | 0       |       |
| ipb_anon_only        | tinyint(1)          | NO   |     | 0       |       |
| ipb_create_account   | tinyint(1)          | NO   |     | 1       |       |
| ipb_expiry           | varbinary(14)       | NO   |     |         |       |
| ipb_range_start      | varbinary(255)      | YES  |     | NULL    |       |
| ipb_range_end        | varbinary(255)      | YES  |     | NULL    |       |
| ipb_enable_autoblock | tinyint(1)          | NO   |     | 1       |       |
| ipb_deleted          | tinyint(1)          | NO   |     | 0       |       |
| ipb_block_email      | tinyint(1)          | NO   |     | 0       |       |
| ipb_by_actor         | bigint(20) unsigned | NO   |     | 0       |       |
| ipb_allow_usertalk   | tinyint(1)          | NO   |     | 1       |       |
| ipb_parent_block_id  | int(11)             | YES  |     | NULL    |       |
+----------------------+---------------------+------+-----+---------+-------+
17 rows in set (0.00 sec)

No ipb_by_text there indeed. But https://www.mediawiki.org/wiki/Manual:Ipblocks_table doesn't say it went anywhere and in fact says that MediaWiki 1.33 and newer still has the field.