Change Details

``` Modifying cul_reason_id field of table cu_log...Wikimedia\Rdbms\DBQueryError from line 1534 of /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php: Error 1265: Data truncated for column 'cul_reason_id' at row 1 Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/wiki/mediawiki/extensions/CheckUser/src/../schema/mysql/patch-cu_log-drop-cul_reason_id_default.sql ) Query: ALTER TABLE `mw_cu_log` CHANGE cul_reason_id cul_reason_id BIGINT UNSIGNED NOT NULL, CHANGE cul_reason_plaintext_id cul_reason_plaintext_id BIGINT UNSIGNED NOT NULL #0 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1518): Wikimedia\Rdbms\Database->getQueryException() #1 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1492): Wikimedia\Rdbms\Database->getQueryExceptionAndLog() #2 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(865): Wikimedia\Rdbms\Database->reportQueryError() #3 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3087): Wikimedia\Rdbms\Database->query() #4 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3026): Wikimedia\Rdbms\Database->sourceStream() #5 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->sourceFile() #6 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(813): Wikimedia\Rdbms\DBConnRef->__call() #7 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(716): Wikimedia\Rdbms\DBConnRef->sourceFile() #8 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(998): DatabaseUpdater->applyPatch() #9 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->modifyField() #10 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(515): DatabaseUpdater->runUpdates() #11 /var/www/wiki/mediawiki/core/maintenance/update.php(203): DatabaseUpdater->doUpdates() #12 /var/www/wiki/mediawiki/core/maintenance/includes/MaintenanceRunner.php(585): UpdateMediaWiki->execute() #13 /var/www/wiki/mediawiki/core/maintenance/doMaintenance.php(99): MediaWiki\Maintenance\MaintenanceRunner->run() #14 /var/www/wiki/mediawiki/core/maintenance/update.php(318): require_once('...') #15 {main} ```

``` Modifying cul_reason_id field of table cu_log...Wikimedia\Rdbms\DBQueryError from line 1534 of /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php: Error 1265: Data truncated for column 'cul_reason_id' at row 1 Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/wiki/mediawiki/extensions/CheckUser/src/../schema/mysql/patch-cu_log-drop-cul_reason_id_default.sql ) Query: ALTER TABLE `mw_cu_log` CHANGE cul_reason_id cul_reason_id BIGINT UNSIGNED NOT NULL, CHANGE cul_reason_plaintext_id cul_reason_plaintext_id BIGINT UNSIGNED NOT NULL #0 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1518): Wikimedia\Rdbms\Database->getQueryException() #1 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1492): Wikimedia\Rdbms\Database->getQueryExceptionAndLog() #2 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(865): Wikimedia\Rdbms\Database->reportQueryError() #3 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3087): Wikimedia\Rdbms\Database->query() #4 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3026): Wikimedia\Rdbms\Database->sourceStream() #5 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->sourceFile() #6 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(813): Wikimedia\Rdbms\DBConnRef->__call() #7 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(716): Wikimedia\Rdbms\DBConnRef->sourceFile() #8 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(998): DatabaseUpdater->applyPatch() #9 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->modifyField() #10 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(515): DatabaseUpdater->runUpdates() #11 /var/www/wiki/mediawiki/core/maintenance/update.php(203): DatabaseUpdater->doUpdates() #12 /var/www/wiki/mediawiki/core/maintenance/includes/MaintenanceRunner.php(585): UpdateMediaWiki->execute() #13 /var/www/wiki/mediawiki/core/maintenance/doMaintenance.php(99): MediaWiki\Maintenance\MaintenanceRunner->run() #14 /var/www/wiki/mediawiki/core/maintenance/update.php(318): require_once('...') #15 {main} ``` --- ``` MariaDB [wikidb]> explain mw_cu_log; +-------------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+---------------------+------+-----+---------+----------------+ | cul_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | cul_timestamp | binary(14) | NO | MUL | NULL | | | cul_reason_id | bigint(20) unsigned | YES | | NULL | | | cul_reason_plaintext_id | bigint(20) unsigned | YES | | NULL | | | cul_type | varbinary(30) | NO | MUL | NULL | | | cul_target_id | int(10) unsigned | NO | | 0 | | | cul_target_text | blob | NO | | NULL | | | cul_target_hex | varbinary(255) | NO | MUL | | | | cul_range_start | varbinary(255) | NO | MUL | | | | cul_range_end | varbinary(255) | NO | | | | | cul_actor | bigint(20) unsigned | NO | MUL | NULL | | +-------------------------+---------------------+------+-----+---------+----------------+ 11 rows in set (0.001 sec) MariaDB [wikidb]> show indexes from mw_cu_log; +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | mw_cu_log | 0 | PRIMARY | 1 | cul_id | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_timestamp | 1 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 1 | cul_type | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 2 | cul_target_id | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 3 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_target_hex | 1 | cul_target_hex | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_target_hex | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_range_start | 1 | cul_range_start | A | 2 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_range_start | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_actor_time | 1 | cul_actor | A | 2 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_actor_time | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 11 rows in set (0.001 sec) ```

``` Modifying cul_reason_id field of table cu_log...Wikimedia\Rdbms\DBQueryError from line 1534 of /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php: Error 1265: Data truncated for column 'cul_reason_id' at row 1 Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/wiki/mediawiki/extensions/CheckUser/src/../schema/mysql/patch-cu_log-drop-cul_reason_id_default.sql ) Query: ALTER TABLE `mw_cu_log` CHANGE cul_reason_id cul_reason_id BIGINT UNSIGNED NOT NULL, CHANGE cul_reason_plaintext_id cul_reason_plaintext_id BIGINT UNSIGNED NOT NULL #0 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1518): Wikimedia\Rdbms\Database->getQueryException() #1 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(1492): Wikimedia\Rdbms\Database->getQueryExceptionAndLog() #2 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(865): Wikimedia\Rdbms\Database->reportQueryError() #3 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3087): Wikimedia\Rdbms\Database->query() #4 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/Database.php(3026): Wikimedia\Rdbms\Database->sourceStream() #5 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->sourceFile() #6 /var/www/wiki/mediawiki/core/includes/libs/rdbms/database/DBConnRef.php(813): Wikimedia\Rdbms\DBConnRef->__call() #7 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(716): Wikimedia\Rdbms\DBConnRef->sourceFile() #8 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(998): DatabaseUpdater->applyPatch() #9 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->modifyField() #10 /var/www/wiki/mediawiki/core/includes/installer/DatabaseUpdater.php(515): DatabaseUpdater->runUpdates() #11 /var/www/wiki/mediawiki/core/maintenance/update.php(203): DatabaseUpdater->doUpdates() #12 /var/www/wiki/mediawiki/core/maintenance/includes/MaintenanceRunner.php(585): UpdateMediaWiki->execute() #13 /var/www/wiki/mediawiki/core/maintenance/doMaintenance.php(99): MediaWiki\Maintenance\MaintenanceRunner->run() #14 /var/www/wiki/mediawiki/core/maintenance/update.php(318): require_once('...') #15 {main} ``` --- ``` MariaDB [wikidb]> explain mw_cu_log; +-------------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+---------------------+------+-----+---------+----------------+ | cul_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | cul_timestamp | binary(14) | NO | MUL | NULL | | | cul_reason_id | bigint(20) unsigned | YES | | NULL | | | cul_reason_plaintext_id | bigint(20) unsigned | YES | | NULL | | | cul_type | varbinary(30) | NO | MUL | NULL | | | cul_target_id | int(10) unsigned | NO | | 0 | | | cul_target_text | blob | NO | | NULL | | | cul_target_hex | varbinary(255) | NO | MUL | | | | cul_range_start | varbinary(255) | NO | MUL | | | | cul_range_end | varbinary(255) | NO | | | | | cul_actor | bigint(20) unsigned | NO | MUL | NULL | | +-------------------------+---------------------+------+-----+---------+----------------+ 11 rows in set (0.001 sec) MariaDB [wikidb]> show indexes from mw_cu_log; +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | mw_cu_log | 0 | PRIMARY | 1 | cul_id | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_timestamp | 1 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 1 | cul_type | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 2 | cul_target_id | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_type_target | 3 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_target_hex | 1 | cul_target_hex | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_target_hex | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_range_start | 1 | cul_range_start | A | 2 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_range_start | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_actor_time | 1 | cul_actor | A | 2 | NULL | NULL | | BTREE | | | NO | | mw_cu_log | 1 | cul_actor_time | 2 | cul_timestamp | A | 6 | NULL | NULL | | BTREE | | | NO | +-----------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 11 rows in set (0.001 sec) ```