This is followup of T119752: Review schema changes for T119495 in which the sql script executed was from an older patchset and made the added columns not-nullable.
Please correct it by making it nullable as follows
ALTER TABLE /*_*/cx_translations MODIFY translation_source_revision_id INT UNSIGNED NULL, MODIFY translation_target_revision_id INT UNSIGNED NULL;
There is no gerrit patch related to this since the patchset https://gerrit.wikimedia.org/r/#/c/255662 has correct script.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T76456 Language Engineering tracker of trackers (tracking) | |||
| Open | None | T127695 Design polishing for Content Translation | |||
| Resolved | • santhosh | T95886 for ContentTranslation MT, store information about source content, machine-translated content and user-edited content | |||
| Resolved | • santhosh | T111905 Design the technical infrastructure for parallel corpora storage and api (tracking) | |||
| Open | None | T102107 Enable Content Translation in Catalan Wikipedia for all logged-in users | |||
| Open | None | T102966 Allow to continue published translations (when they have no additional modifications) | |||
| Resolved | • santhosh | T119495 Save the revision id of source and published article in cx_translations table | |||
| Resolved | jcrespo | T121509 Correct the schema to make revision id columns of cx_translations nullable |
Current state, check that it is right:
mysql -h x1-master wikishared -e "SHOW CREATE TABLE cx_translations\G"
*************************** 1. row ***************************
Table: cx_translations
Create Table: CREATE TABLE `cx_translations` (
`translation_id` int(11) NOT NULL AUTO_INCREMENT,
`translation_source_title` varbinary(512) NOT NULL,
`translation_target_title` varbinary(512) NOT NULL,
`translation_source_language` varbinary(36) NOT NULL,
`translation_target_language` varbinary(36) NOT NULL,
`translation_source_url` blob NOT NULL,
`translation_target_url` blob,
`translation_status` enum('draft','published','deleted') DEFAULT NULL,
`translation_start_timestamp` varbinary(14) NOT NULL,
`translation_last_updated_timestamp` varbinary(14) NOT NULL,
`translation_progress` tinyblob NOT NULL,
`translation_started_by` int(11) DEFAULT NULL,
`translation_last_update_by` int(11) DEFAULT NULL,
`translation_source_revision_id` int(10) unsigned DEFAULT NULL,
`translation_target_revision_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`translation_id`),
UNIQUE KEY `cx_translation_pair` (`translation_source_title`,`translation_source_language`,`translation_target_language`),
KEY `cx_translation_languages` (`translation_source_language`,`translation_target_language`)
) ENGINE=InnoDB AUTO_INCREMENT=95914 DEFAULT CHARSET=binary