Last modified: 2012-12-21 20:36:55 UTC
I have 6 wikis on SiteGround, my host. Five I succesfully upgraded from 1.17 to 1.20. The sixth had the message: Fatal error: Call to undefined method MediaWiki::getVal() in /home/albanyh9/public_html/wikiBio/extensions/InputBox/InputBox.hooks.php on line 55 SO.. SiteGround restored my previous version of the wiki and it shows as v. 1.17.0. All looked good until I tried to add a user. Then I got: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "User::addToDatabase". Database returned error "1054: Unknown column 'user_options' in 'field list' (localhost)". This may or may not be a new problem, as I have not tried to add a user in several months. Because I have several wikis, I could compare fields in a working wiki with the non-working wiki, and the USER table fields are identical, and 'user-options' is NOT found in either the working or non-working USER table. The list goes from user_newtalk to user_properties in both wikis. Updating the database to v 1.2 did NOT work - (Siteground sends me to a utility called Softaculous to do upgrades - it thinks I am upgraded to v 1.2 so I can't try to upgrade again.) Any and all suggestions are well. I need details as I have no idea how, or if I am allowed, to do command line things on my wikis. SiteGround has declared it a database problem and not within their scope of responsibility as the host of the site. Thanks, John JElberfeld@aol.com Any and all suggestions are welcome
To me it simply looks like the InputBox extension is incompatible with MediaWiki 1.20. Hence uninstall InputBox and try again. Also see http://www.mediawiki.org/wiki/Thread:Project:Support_desk/_1.16_1054:_Unknown_column_%27user_options%27_in_%27field_list%27_%28localhost%29_%282%29/reply_%283%29 (which might have been posted by you?).
Thanks for the help. I "commented out" the line in LocalSettings.php that installed the InputBox extension. Then I had to pay SiteGround to upgrade the site to v 1.2 because of complications with the installation utility, Softaculous. The problem with create a new user disappeared. Everything seems to work in the upgraded version. Thank you. John
Glad it works for you now! (Keeping this bug report open as the issue still exists with InputBox.)