#757 Database errors thrown by user accounts

[Minh Nguyen]

At the vi: Wikipedia, the following error message is
quite common:

----
A database query syntax error has occurred. This could
be because of an illegal search query (see Searching
Wikipedia), or it may indicate a bug in the software.
The last attempted database query was:

SELECT
user_name,user_password,user_newpassword,user_email,user_real_name,user_options,user_rights,user_touched
FROM user WHERE user_id=4

from within function "User::loadFromDatabase". MySQL
returned error "1054: Unknown column 'user_real_name'
in 'field list'".
----

This happens:

1: When logging in (login does not occur)
2: When viewing a page after logging in (so if you are
being remembered by a cookie, you cannot access the
site - you must first delete the cookies)

With case 1, the error is shown on MediaWiki's error
page, so the site is still accessible. With case 2, the
error message is the only thing displayed, so the site
is not accessible.

Additionally, the following error occurs when creating
a new account (the account is never created as a result):

----
A database query syntax error has occurred. This could
be because of an illegal search query (see Searching
Wikipedia), or it may indicate a bug in the software.
The last attempted database query was:

INSERT INTO user
(user_name,user_password,user_newpassword,user_email,
user_real_name, user_rights, user_options) VALUES
('NEWUSERNAME', , , , , , 'quickbar=1 underline=1
hover=1 cols=80 rows=25 searchlimit=20 contextlines=5
contextchars=50 skin=monobook math=1 rcdays=7
rclimit=50 highlightbroken=1 stubthreshold=0
previewontop=1 editsection=1 editsectiononrightclick=0
showtoc=1 showtoolbar=1 date=0 searchNs-1=0 searchNs0=1
searchNs1=0 searchNs2=0 searchNs3=0 searchNs4=0
searchNs5=0 searchNs6=0 searchNs7=0 searchNs8=0
searchNs9=1 searchNs10=0 searchNs11=1')

from within function "User::addToDatabase". MySQL
returned error "1054: Unknown column 'user_real_name'
in 'field list'".
----

Where NEWUSERNAME is the username you've entered for
yourself.

I believe these errors are caused by the new Real Name
preference in MediaWiki 1.3. The database has not been
upgraded to support Real Names yet, so this error is
thrown when the software tries to access real name
information from the database.

As a result of these errors, sysop functions cannot be
carried out, and no one is being given credit for their
work.

[Jerome Jamnicky]

Logged In: YES
user_id=912569

working on it, should be simple to fix

[Jerome Jamnicky]

Logged In: YES
user_id=912569

Fixed now. Somehow the user_real_name field was left out
during the conversion for 4 out of 150 wikis.