Page MenuHomePhabricator

Error: 1048 Column 'user_email' cannot be null
Open, Needs TriagePublic

Description

Seeing:

2020-06-12 03:35:33 mw4 awesomegameswiki: [7c2c033d8182f50d885b189c] /w/api.php   Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: UPDATE  `user` SET user_name = 'xxx',user_real_name = '',user_email = NULL,user_email_authenticated = NULL,user_touched = 'xxx',user_token = 'xxx',user_email_token = 'xxx',user_email_token_expires = NULL WHERE user_id = 'xxx' AND user_touched = 'xxx'
Function: User::saveSettings
Error: 1048 Column 'user_email' cannot be null (db6.miraheze.org)

#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(2186): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/w/includes/user/User.php(3990): Wikimedia\Rdbms\Database->update(string, array, array, string)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(3966): User->{closure}(Wikimedia\Rdbms\DatabaseMysqli, string)
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection(string, Closure)
#6 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(635): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#7 /srv/mediawiki/w/includes/user/User.php(4025): Wikimedia\Rdbms\DBConnRef->doAtomicSection(string, Closure)
#8 /srv/mediawiki/w/includes/api/ApiOptions.php(187): User->saveSettings()
#9 /srv/mediawiki/w/includes/api/ApiOptions.php(137): ApiOptions->commitChanges()
#10 /srv/mediawiki/w/includes/api/ApiMain.php(1598): ApiOptions->execute()
#11 /srv/mediawiki/w/includes/api/ApiMain.php(537): ApiMain->executeAction()
#12 /srv/mediawiki/w/includes/api/ApiMain.php(508): ApiMain->executeActionWithErrorHandling()
#13 /srv/mediawiki/w/api.php(87): ApiMain->execute()
#14 {main}

in the logs.

Event Timeline

Restricted Application added subscribers: RhinosF1, Reception123, Aklapper. · View Herald Transcript

Change 605232 had a related patch set uploaded (by Paladox; owner: Paladox):
[mediawiki/core@master] Add null check to $this->mEmail in saveSettings()

https://gerrit.wikimedia.org/r/605232

Change 605232 abandoned by Paladox:

[mediawiki/core@master] Set mEmail to default to ''

Reason:

https://gerrit.wikimedia.org/r/605232