Page MenuHomePhabricator

Error during install of 1.28.1 with MSSQL server: Implicit conversion from data type varchar to varbinary(max) is not allowed.
Open, Needs TriagePublic

Description

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

Event Timeline

Jhuff05 created this task.Apr 27 2017, 5:39 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 27 2017, 5:39 PM
Aklapper renamed this task from error durring install of 1.28.1 with MSSQL server to Error during install of 1.28.1 with MSSQL server: Implicit conversion from data type varchar to varbinary(max) is not allowed..Apr 27 2017, 6:09 PM
Reedy updated the task description. (Show Details)