The fields rc_moved_to_ns and rc_moved_to_title of the recentchanges table are always set to 0 and empty string. The comment in tables.sql is "These may no longer be used, with the new move log."
Please drop that unused fields from the database.
Thanks.
Version: 1.20.x
Severity: enhancement
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | Umherirrender | T36960 drop unused fields recentchanges.rc_moved_to_ns and recentchanges.rc_moved_to_title | |||
| Resolved | • Marostegui | T249973 db1110 has 5 important database drifts that are unique to the host |
Hmm, wondering if this would welcome any work to cover this in some upgrade scripts, seeing user confusion in https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_moved_to_ns and https://www.mediawiki.org/wiki/Thread:Project:Support_desk/Database_error_after_updating_to_1.21.1
Those fields were removed from the general tables.sql, but not for the mssql, postgres nor oracle versions:
https://git.wikimedia.org/blob/mediawiki%2Fcore.git/REL1_21/maintenance%2Fmssql%2Ftables.sql#L519
https://git.wikimedia.org/blob/mediawiki%2Fcore.git/REL1_21/maintenance%2Fpostgres%2Ftables.sql#L415
https://git.wikimedia.org/blob/mediawiki%2Fcore.git/REL1_21/maintenance%2Foracle%2Ftables.sql#L419
Field is defaultable, that means, you can remove it from your insert statement and that will not break. Thats why wmf can still use this columns.
The message sounds like it is used in a select or insert and not in the database. That can only be happen, when downgrad your installation from 1.21 to 1.20.
Change 82117 had a related patch set uploaded by Martineznovo:
drop unused fields rc_moved_to_ns/rc_moved_to_title