Topic on Project:Support desk

Update From 1.38.4 To 1.39 Ends With An SQL Error

2
Gustav.zone (talkcontribs)

Hello


We got this error after automatic upgrade to v 1.39:

Deprecated: Caller from MediaWiki\User\UserOptionsManager::loadOptionsFromDb ignored an error originally raised from MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds: [1054] Unknown column 'rev_actor' in 'field list' in /path/to/rootdir/includes/debug/MWDebug.php on line 381

MediaWiki internal error.

Original exception: [Y4sC-agvWrsHVKR4EV9SnQABNxQ] /Esileht Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Error 1054: Unknown column 'rev_actor' in 'field list'

Function: MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds

Query: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `zudn_revision` JOIN `zudn_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `zudn_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `zudn_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `zudn_page` ON ((page_id = rev_page)) LEFT JOIN `zudn_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 22052 LIMIT 1


Can we do something before the update to fix this issue or is it caused by the installer (Installatron in this case)?

Would manual update work?


Thank you

Gustav

Bawolff (talkcontribs)

Did you run update.php? This is the type of error you would get if update.php was not run. (Although you would probably have to be going from a version earlier than 1.38)


Note: mediawiki does not have a builtin auto upgrade feature.

Reply to "Update From 1.38.4 To 1.39 Ends With An SQL Error"