Thread:Project talk:Support desk/Mediwkidi error: Unknown column 'rc moved to ns' in 'field list'/reply

Hi there, I stumbled over this as well after upgrading a 1.19. wiki to 1.21.2.

You're probably trying to update data in you recent changes table in a column which is not existing in your table(or no longer existing). I guess you are trying to update the 1.21.1 database backup in the 1.19 database layout? Or the other way around?

Please check the columns of our "recent changes" table and take a look at your inserts (INSERT INTO) statements for recent changes (in your database backup file) if all columns for the inserst are actually created in your database (either by a CREATE TABLE IF NOT EXISTING) or by the wikimedia installer.

https://www.mediawiki.org/wiki/Manual:Recentchanges_table#rc_moved_to_ns You may create missing columns manually via PHPMYADMIN. I did this along the way and had to add some columns manually based on this: https://www.mediawiki.org/wiki/Manual:Recentchanges_table#Schema_summary For example rc_moved_to_ns and rc_moved_to_title where missing for me amongst others. I have no idea why certain columns were missing in my backup in the first place but the backup was from another user from with I took over...

In case if both database backups contains the same content: Be sure to first install 1.19 mediawikisoftware and import your 1.19 data. then procceed with upgrading to 1.21.1 as described. During the process your 1.19 will changed from the setup routine to the 1.21. database layout.