Page MenuHomePhabricator

MSSQL Database error "bit is invalid for sum operator" on Special:WantedPages
Open, Needs TriagePublic


Installed software
MediaWiki 1.27.1
PHP 5.6.30 (cgi-fcgi)
MS SQL Server 10.50.6529

During testing of a SQL Server based MEDIAWIKI installation, We encountered an error documented below. I know this should not be a surprise, since CARGO is not guaranteed to work with SQL Server. We are hoping someone will create a fix for this page.

The Problem was discovered when we selected "Wanted Pages" from the "Special Pages" Page as detailed below:
A database query error has occurred. This may indicate a bug in the software.

SELECT TOP 51 pl_namespace AS [namespace],pl_title AS [title],COUNT(*) AS [value] FROM [wiki].[pagelinks] LEFT JOIN [wiki].[page] [pg1] ON ((pg1.page_namespace = pl_namespace) AND (pg1.page_title = pl_title)) LEFT JOIN [wiki].[page] [pg2] ON ((pg2.page_id = pl_from)) WHERE (pg1.page_namespace IS NULL) AND (pl_namespace NOT IN ( '2', '3' )) AND (pg2.page_namespace != '8') GROUP BY pl_namespace,pl_title HAVING (COUNT(*) > 0) AND (COUNT(*) > SUM(pg2.page_is_redirect)) ORDER BY value DESC
Function: WantedPagesPage::reallyDoQuery
Error: 8117 [SQLSTATE 42000][Error Code 8117][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Operand data type bit is invalid for sum operator. [SQLSTATE 42000][Error Code 8180][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared.

#0 C:\inetpub\wwwroot\WCR\includes\db\Database.php(901): DatabaseBase->reportQueryError('[SQLSTATE 42000...', 8117, 'SELECT TOP 51 ...', 'WantedPagesPage...', false) #1 C:\inetpub\wwwroot\WCR\includes\db\DatabaseMssql.php(427): DatabaseBase->query('SELECT TOP 51 ...', 'WantedPagesPage...') #2 C:\inetpub\wwwroot\WCR\includes\specialpage\QueryPage.php(422): DatabaseMssql->select(Array, Array, Array, 'WantedPagesPage...', Array, Array) #3 C:\inetpub\wwwroot\WCR\includes\specialpage\QueryPage.php(575): QueryPage->reallyDoQuery(51, 0) #4 C:\inetpub\wwwroot\WCR\includes\specials\SpecialWantedpages.php(48): QueryPage->execute(NULL) #5 C:\inetpub\wwwroot\WCR\includes\specialpage\SpecialPage.php(479): WantedPagesPage->execute(NULL) #6 C:\inetpub\wwwroot\WCR\includes\specialpage\SpecialPageFactory.php(576): SpecialPage->run(NULL) #7 C:\inetpub\wwwroot\WCR\includes\MediaWiki.php(282): SpecialPageFactory::executePath(Object(Title), Object(RequestContext)) #8 C:\inetpub\wwwroot\WCR\includes\MediaWiki.php(745): MediaWiki->performRequest() #9 C:\inetpub\wwwroot\WCR\includes\MediaWiki.php(519): MediaWiki->main() #10 C:\inetpub\wwwroot\WCR\index.php(43): MediaWiki->run() #11 {main}

Event Timeline

Jhuff05 created this task.Mar 20 2017, 3:26 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 20 2017, 3:26 PM
matmarex renamed this task from Error on "Wanted Pages" to Error on "Wanted Pages" with MSSQL.Mar 20 2017, 3:27 PM
matmarex added a project: Wikimedia-Rdbms.
Krinkle renamed this task from Error on "Wanted Pages" with MSSQL to MSSQL Database error on Special: Wanted Pages.Jul 18 2019, 7:42 PM
Krinkle renamed this task from MSSQL Database error on Special: Wanted Pages to MSSQL Database error "bit is invalid for sum operator" on Special:WantedPages.
Krinkle edited projects, added MediaWiki-Special-pages; removed Wikimedia-Rdbms.