Page MenuHomePhabricator

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

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

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

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.