Last modified: 2013-09-21 15:57:44 UTC
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.
Gerrit change #17894
successfully merged
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 https://gerrit.wikimedia.org/r/82117
Change 82117 merged by Reedy: drop unused fields rc_moved_to_ns/rc_moved_to_title https://gerrit.wikimedia.org/r/82117