Page MenuHomePhabricator

Installer: Cannot use full-text search in master, tempdb, or model database
Closed, DeclinedPublic

Description

Originally reported on Project:Support desk

MediaWiki 1.28.2. During creation of the database on the installer:

[1d6fe9c27637e0ebbe027033] /wiki/mw-config/index.php?page=Install DBQueryError from line 1054 of C:\inetpub\wwwroot\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 FULLTEXT CATALOG [mediawiki]

Function: MssqlInstaller::setupDatabase

Error: 9966 [SQLSTATE 42000][Error Code 9966][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot use full-text search in master, tempdb, or model database.

Backtrace:

#0 C:\inetpub\wwwroot\wiki\includes\libs\rdbms\database\Database.php(912): Database->reportQueryError(string, integer, string, string, boolean)
#1 C:\inetpub\wwwroot\wiki\includes\installer\MssqlInstaller.php(515): Database->query(string, string)
#2 [internal function]: MssqlInstaller->setupDatabase(MssqlInstaller)
#3 C:\inetpub\wwwroot\wiki\includes\installer\Installer.php(1515): call_user_func(array, MssqlInstaller)
#4 C:\inetpub\wwwroot\wiki\includes\installer\WebInstallerInstall.php(45): Installer->performInstallation(array, array)
#5 C:\inetpub\wwwroot\wiki\includes\installer\WebInstaller.php(279): WebInstallerInstall->execute()
#6 C:\inetpub\wwwroot\wiki\mw-config\index.php(81): WebInstaller->execute(array)
#7 C:\inetpub\wwwroot\wiki\mw-config\index.php(39): wfInstallerMain()
#8 {main}

Event Timeline

Apparently, MediaWiki is trying to issue a "CREATE FULLTEXT CATALOG" sentence on SQLServer database, but it hasn't "changed" to/selected the wiki database first, thus defaulting to master database.

Assuming this hasn't been fixed for 1.29, apparently on 1.29 the error message isn't displayed at all. See Topic:U1h0yoahi7wvfq0y

37a90653f84cd2ed8589461e1c158aceo.png (552×1 px, 37 KB)

Heads-up: As per RFC discussion in August 2019, the previously experimental support for using Oracle or MSSQL as database backends in MediaWiki core has been removed in MediaWiki 1.34, so this task might end up as declined in the future.