Topic on Project:Support desk

1.31.0 Fails on SQL Server

1
Summary last edited by PlavorSeol 15:48, 2 September 2018 5 years ago

Moved to Phabricator

2A00:23C5:6E3A:7100:E153:6A52:D860:12BC (talkcontribs)

I get the following error when installing:

[66d756614475630354e4591a] /mw-config/?page=Install   Wikimedia\Rdbms\DBQueryError from line 1457 of C:\inetpub\wwwroot\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 [mediawiki].[actor] (
actor_id bigint unsigned NOT NULL CONSTRAINT PK_actor PRIMARY KEY IDENTITY(0,1),
actor_user int unsigned,
actor_name nvarchar(255) NOT NULL
)
Function: Wikimedia\Rdbms\Database::sourceFile( C:\inetpub\wwwroot/maintenance/mssql/tables.sql )
Error: 102 [SQLSTATE 42000][Error Code 102][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'unsigned'.
Backtrace:
#0 C:\inetpub\wwwroot\includes\libs\rdbms\database\Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
#1 C:\inetpub\wwwroot\includes\libs\rdbms\database\Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 C:\inetpub\wwwroot\includes\libs\rdbms\database\Database.php(4194): Wikimedia\Rdbms\Database->query(string, string)
#3 C:\inetpub\wwwroot\includes\libs\rdbms\database\Database.php(4129): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)
#4 C:\inetpub\wwwroot\includes\installer\DatabaseInstaller.php(225): Wikimedia\Rdbms\Database->sourceFile(string)
#5 C:\inetpub\wwwroot\includes\installer\DatabaseInstaller.php(248): DatabaseInstaller->stepApplySourceFile(string, string, boolean)
#6 C:\inetpub\wwwroot\includes\installer\MssqlInstaller.php(635): DatabaseInstaller->createTables()
#7 C:\inetpub\wwwroot\includes\installer\Installer.php(1575): MssqlInstaller->createTables(MssqlInstaller)
#8 C:\inetpub\wwwroot\includes\installer\WebInstallerInstall.php(44): Installer->performInstallation(array, array)
#9 C:\inetpub\wwwroot\includes\installer\WebInstaller.php(281): WebInstallerInstall->execute()
#10 C:\inetpub\wwwroot\mw-config\index.php(79): WebInstaller->execute(array)
#11 C:\inetpub\wwwroot\mw-config\index.php(38): wfInstallerMain()
#12 {main}