Creating Wikimedia account fails with database query error.


Tried creating a new account but failed each time. Possibly a transient issue? I’ll try again later to see.

A database query error has occurred. This may indicate a bug in the software.

[b8566195b0b41fe7239c975c] 2019-03-21 23:09:35: Fatal exception of type “Wikimedia\Rdbms\DBQueryError”

1 Like

I reproduce.

Underlying error is:

Query: INSERT INTO `user_register_track` (ur_user_id,ur_user_name,ur_user_id_referral,ur_user_name_referral,ur_from,ur_date) VALUES ('4641','xxxxxxx','0','','0','2019-03-22 04:20:43')
Function: NewSignupPageSecondaryAuthenticationProvider::beginSecondaryAccountCreation
Error: 1146 Table 'wiki.user_register_track' doesn't exist (localhost)

Strongly suspect that one of the last few additions to the wiki (extensions like CookieWarning, UserAgreement, etc) broke it.

Various online guides say to run update.php routine from CLI, but hasn’t helped.

Might need to add that user_register_track table somehow manually.


Looks like we didn’t RTM


“If you set $wgRegisterTrack = true;, you need to create the user_register_track table in your database; you can do this from command line with php maintenance/sql.php extensions/NewSignupPage/user_register_track.sql”

Done. And now registration works.


Thanks for the help mig5!

0brand2 created