Page MenuHomePhabricator

New user account creation fails after upgrade from MW 1.39 to 1.43
Closed, InvalidPublicBUG REPORT

Description

Steps to replicate the issue (include links if applicable):

  • The existing zeus-de wiki which runs on MW 1.39 and the authentication is performed by PluggableAuth & SimpleSAMLphp extensions
  • This wiki is upgraded to 1.43
  • No errors during php maintenance/run.php update.php script

What happens?:

When a new user attempts to log in, the authentication fails to create the new account and the following error occurs:

[15592ba0da4f92abb1956378] /index.php?title=Spezial:Anmelden&returnto=ZEUS-Wiki%3AZEuS+LehrPr%C3%BCfungsPlanung
Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?
Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.
Error 1054: Unknown column 'user_is_temp' in 'field list'
Function: MediaWiki\User\User::addToDatabase
Query: INSERT IGNORE INTO `zeus_de`.`user`
(user_name,user_password,user_newpassword,user_email,user_email_authenticated,user_real_name,user_token,user_registration,user_editcount,user_touched, user_is_temp) VALUES ('Celia-elena.berari',",",",NULL,",'c4e0988619039273f8f40466d106dfc5','20250915074518',0,'20250915074518',0)
Backtrace:
from /var/www/html/includes/libs/rdbms/database/Database.php(1198)
#0 /var/www/html/includes/libs/rdbms/database/Database.php(1182): Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1 /var/www/html/includes/libs/rdbms/database/Database.php(1156): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)

What should have happened instead?:

No error should occur, the new user account should be saved in the database as in the previous version MW 1.39.

Software version (on Special:Version page; skip for WMF-hosted wikis like Wikipedia):

MediaWiki 1.43.3
PHP 8.1.33 (apache2handler)
ICU 76.1
MySQL 8.4.6
Elasticsearch 7.10.2

PluggableAuth 7.5.0 (e0e3a6f), 26. Apr. 2025
SimpleSAMLphp 7.0.1 (4e87de2), 1. Jul. 2025

Other information (browser name/version, screenshots, etc.):

Event Timeline

Indeed this zeus-de wiki is using shared database:

$wgSharedTables = [ 'actor', 'user', 'user_groups', 'user_properties', 'interwiki' ];

We missed to remove temporarily $wgSharedTables from LocalSettings.php during upgrade.

Would now help to rerun the update.php script with the --doshared parameter or is too late, is the upgrade is already compomised?

S0ring claimed this task.

The database wasn't compomised, after running only the update.php script with the --doshared parameter the shared tables were touched and the new users could successfully log in and they were created in the database.

A_smart_kitten changed the task status from Resolved to Invalid.Sep 16 2025, 10:34 AM
A_smart_kitten removed S0ring as the assignee of this task.
A_smart_kitten subscribed.

<changing status to reflect that there wasn't a bug fixed here within the MediaWiki codebase>