Last modified: 2013-06-01 12:54:16 UTC
See URL field. The update.php script fails: ...batch conversion of user_options: A database query syntax error has occurred. The last attempted database query was: "SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_id = '9' AND rev_id = '3494' LIMIT 1 " from within function "Revision::fetchFromConds". Database returned error "1054: Unknown column 'rev_sha1' in 'field list' (foobar.barfoo.com) It's running convertUserOptions.php before creating the rev_sha1 field from revision table. It calls $user->saveSettings(); (convertUserOptions.php:82) which is doing $this->getUserPage()->invalidateCache(); (User.php:3102) which does $revision = WikiPage::factory( $this )->getRevision(); (Title.php:4517) update.php needs to be changed to move the rev_sha1 creation before calling convertUserOptions.php
(In reply to comment #0) > update.php needs to be changed to move the rev_sha1 creation before calling > convertUserOptions.php Indeed. I logged a bug for this on the 25th May ;) *** This bug has been marked as a duplicate of bug 48820 ***
