Last modified: 2010-05-15 15:38:22 UTC
MediaWiki generated an error message when adding a new user account from same IP
range as existing accounts (different details, different email address,
different user/pass etc) - weird thing is there were entries in the wiki_user
1: "Create an account or Login" (hyperlink) ->
2: [Fill in all fields] ->
3: "New Account" (button) ->
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". MySQL returned error "1048: Column
'user_id' cannot be null (localhost)".
This sounds like either the table definition is bogus (missing the
autoincrement field option) or MySQL is configured in some very strange
nonstandard way which causes it to behave differently.
(In reply to comment #0)
In order to check if it's the first part of comment #1 or not, please run
DESCRIBE <table>, where <table> is the name of the user table, including the
I ran #>DESC wiki_user; and the auto_increment attribute was indeed missing from
the table definition!
Strange. However - I would not discount the possibility that someone here (inc
myself) could have messed this up.
I have altered the table and the bug no longer occurs.
Please advise if the "WORKSFORME" value of the new Bug Status is incorrect and I
will change it, otherwise my thanks to you both.