Topic on Project:Support desk

Zissouu (talkcontribs)

So I have been running into an issue with a mediawiki installation. I tried rolling back to 1.31.1 from 1.32 since I was running into issues but upon install I recieve this error and I can't seem to resolve it. I appreciate any help and thank you in advance

  • Setting up database... done
  • Creating tables... [b2e8f96f6b18d66046f58c42] /wiki/mw-config/index.php?page=Install Wikimedia\Rdbms\DBQueryError from line 1457 of C:\xampp\htdocs\wiki\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: CREATE TABLE `user` ( user_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, user_name varchar(255) binary NOT NULL default '', user_real_name varchar(255) binary NOT NULL default '', user_password tinyblob NOT NULL, user_newpassword tinyblob NOT NULL, user_newpass_time binary(14), user_email tinytext NOT NULL, user_touched binary(14) NOT NULL default '', user_token binary(32) NOT NULL default '', user_email_authenticated binary(14), user_email_token binary(32), user_email_token_expires binary(14), user_registration binary(14), user_editcount int, user_password_expires varbinary(14) DEFAULT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary Function: Wikimedia\Rdbms\Database::sourceFile( C:\xampp\htdocs\wiki/maintenance/tables.sql ) Error: 1050 Table 'user' already exists (localhost) Backtrace: #0 C:\xampp\htdocs\wiki\includes\libs\rdbms\database\Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string) #1 C:\xampp\htdocs\wiki\includes\libs\rdbms\database\Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #2 C:\xampp\htdocs\wiki\includes\libs\rdbms\database\Database.php(4194): Wikimedia\Rdbms\Database->query(string, string) #3 C:\xampp\htdocs\wiki\includes\libs\rdbms\database\Database.php(4129): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL) #4 C:\xampp\htdocs\wiki\includes\installer\DatabaseInstaller.php(225): Wikimedia\Rdbms\Database->sourceFile(string) #5 C:\xampp\htdocs\wiki\includes\installer\DatabaseInstaller.php(248): DatabaseInstaller->stepApplySourceFile(string, string, boolean) #6 C:\xampp\htdocs\wiki\includes\installer\Installer.php(1575): DatabaseInstaller->createTables(MysqlInstaller) #7 C:\xampp\htdocs\wiki\includes\installer\WebInstallerInstall.php(44): Installer->performInstallation(array, array) #8 C:\xampp\htdocs\wiki\includes\installer\WebInstaller.php(281): WebInstallerInstall->execute() #9 C:\xampp\htdocs\wiki\mw-config\index.php(79): WebInstaller->execute(array) #10 C:\xampp\htdocs\wiki\mw-config\index.php(38): wfInstallerMain() #11 {main} Notice: Uncommitted DB writes (transaction from DatabaseInstaller::stepApplySourceFile). in C:\xampp\htdocs\wiki\includes\libs\rdbms\database\Database.php on line 4543
Ciencia Al Poder (talkcontribs)

Looks like the database you selected already contains a "user" table, and the installer is trying to create it again.

MediaWiki can't be downgraded once you've run the upgrade script. You should restore a backup from before the upgrade.

Reply to "Error in setup"