While attempting to install mediawiki version 1.28.1 on a windows server, PHP 5.6.30, MS SQL Server (10.50.6529) (table.sql in /maintenance/mssql has been modified for the oi_name nvarchar(220) and oi_archive_name nvarchar(220) to eliminate the index greater than 1024 error)
Receive a 500 error, website cannot display the page.
The debug log shows a variety of errors:
[DBQuery] SQL ERROR: [SQLSTATE 42000][Error Code 257][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query. [SQLSTATE 42000][Error Code 8180][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared #0 C:\inetpub\wwwroot\wcr69\includes\libs\rdbms\database\Database.php(912): Database->reportQueryError(string, integer, string, string, boolean) #1 C:\inetpub\wwwroot\wcr69\includes\db\DatabaseMssql.php(672): Database->query(string) #2 C:\inetpub\wwwroot\wcr69\includes\cache\localisation\LCStoreDB.php(84): DatabaseMssql->insert(string, array, string) #3 C:\inetpub\wwwroot\wcr69\includes\cache\localisation\LocalisationCache.php(1028): LCStoreDB->finishWrite() #4 C:\inetpub\wwwroot\wcr69\includes\cache\localisation\LocalisationCache.php(462): LocalisationCache->recache(string) #5 C:\inetpub\wwwroot\wcr69\includes\cache\localisation\LocalisationCache.php(379): LocalisationCache->initLanguage(string) #6 C:\inetpub\wwwroot\wcr69\includes\cache\localisation\LocalisationCache.php(294): LocalisationCache->loadSubitem(string, string, string) #7 C:\inetpub\wwwroot\wcr69\languages\Language.php(2583): LocalisationCache->getSubitem(string, string, string) #8 C:\inetpub\wwwroot\wcr69\includes\cache\MessageCache.php(875): Language->getMessage(string) #9 C:\inetpub\wwwroot\wcr69\includes\cache\MessageCache.php(831): MessageCache->getMessageForLang(Language, string, boolean, array) #10 C:\inetpub\wwwroot\wcr69\includes\cache\MessageCache.php(772): MessageCache->getMessageFromFallbackChain(Language, string, boolean) #11 C:\inetpub\wwwroot\wcr69\includes\Message.php(1188): MessageCache->get(string, boolean, Language) #12 C:\inetpub\wwwroot\wcr69\includes\Message.php(802): Message->fetchMessage() #13 C:\inetpub\wwwroot\wcr69\includes\Message.php(902): Message->toString() #14 C:\inetpub\wwwroot\wcr69\includes\title\MalformedTitleException.php(49): Message->text() #15 C:\inetpub\wwwroot\wcr69\includes\title\MediaWikiTitleCodec.php(302): MalformedTitleException->__construct(string, string) #16 C:\inetpub\wwwroot\wcr69\includes\Title.php(3404): MediaWikiTitleCodec->splitTitleString(string, integer) #17 C:\inetpub\wwwroot\wcr69\includes\Title.php(352): Title->secureAndSplit() #18 C:\inetpub\wwwroot\wcr69\includes\MediaWiki.php(80): Title::newFromURL(NULL) #19 C:\inetpub\wwwroot\wcr69\includes\MediaWiki.php(136): MediaWiki->parseTitle() #20 C:\inetpub\wwwroot\wcr69\includes\MediaWiki.php(766): MediaWiki->getTitle() #21 C:\inetpub\wwwroot\wcr69\includes\MediaWiki.php(512): MediaWiki->main() #22 C:\inetpub\wwwroot\wcr69\index.php(43): MediaWiki->run() #23 {main} [exception] [cc57f1c92d228e7bc39ed639] /wcr69/index.php DBQueryError from line 1054 of C:\inetpub\wwwroot\wcr69\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: INSERT INTO [l10n_cache] (lc_lang,lc_key,lc_value) VALUES ('en','fallback','b:0;') - List Item