Topic on Project:Support desk

DBQueryError, Cannot use full-text search in master, tempdb, or model database.

2
Zeenglishking (talkcontribs)

Environment: SQLSMS 2008R2 - Windows Server 2012 - IIS8 - PHP 5.5

I've been trying to set up MediaWiki 1.28.2 on our server with our above environment . After installing the php_sqlsrb_55_nts.dll and php_pdo_sqlsrb_55_nts.dll drivers to identify SQLSMS and then running successfully through the steps of installation, the installer halts at "setting up database..." and I get the below stack trace. I've had a lengthy google and haven't found anything the same, only similar looking but different error. No link to the wiki as it is (will be) internal.

Help is appreciated.

Cheers.

ST:

[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}

Ciencia Al Poder (talkcontribs)

Apparently, MediaWiki is trying to issue a "CREATE FULLTEXT CATALOG" sentence on SQLServer database, but it hasn't "changed" to the wiki database first. This is obvious a bug in MediaWiki.

I've reported task T168118 for you.

Note that SQLServer support in MediaWiki is very low, I'd recommend using mysql instead.