Topic on Talk:Quarry

Missing columns in revision table?

6
Summary by BDavis (WMF)

The Wiki Replica views have changed to remove *_user and *_user_text fields from all tables. See wikitech:News/Actor storage changes on the Wiki Replicas for more information.

Le Deluge (talkcontribs)

I've just tried to run a query that uses rev_user_text, one of the columns in the revision table, and get a failure with :

Unknown column 'rev_user_text' in 'field list'

It runs fine when I remove SELECT rev_user_text from the query. Is this a temporary glitch, or has rev_user_text been permanently removed?

Edgars2007 (talkcontribs)
BDavis (WMF) (talkcontribs)
This post was hidden by Barkeep49 (history)
TheDJ (talkcontribs)
BDavis (WMF) (talkcontribs)

I created phab:T225007 today to track the need updating the Manual. Part of the issue that has happened here is explained (but maybe not well) on wikitech:News/Actor storage changes on the Wiki Replicas is that the Wiki Replica views have changed in advance of MediaWiki changes. I'm not 100% sure which patches have landed in the MediaWiki code base and which are still pending in Gerrit. There definitely is some documentation lag however because even if the legacy user fields have not been remove from MediaWiki core yet, the actor table and related fields have landed.