Database error

Jump to navigation Jump to search

A database query error has occurred. This may indicate a bug in the software.

[ZgU0qLuacZ8EVi76fvzkcgAAFQg] /w/index.php?title=Special:CargoQuery&tables=Items%2COpinions&fields=Items.Summary%2COpinions.Position_link%2COpinions.Stance&where=cargo__Opinions.Topic%3D%22American+Recovery+and+Reinvestment+Act+of+2009%22&join_on=Items._pageName%3DOpinions._pageName&order_by=CASE+Stance%0A+++++++++WHEN+%27for%27+THEN+1%0A+++++++++WHEN+%27against%27+THEN+2%0A+++++++++WHEN+%27mixed%27+THEN+3%0A+++++++++END%2C+Date+DESC&format=ddb+outline&offset=100&limit=100&outline_fields=Position_link%2CStance Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 1054: Unknown column 'CASE Stance
WHEN 'for' THEN 1
WHEN 'against' THEN 2
WHEN 'mixed' THEN 3
END' in 'order clause'
Function: CargoQueryPage::reallyDoQuery
Query: SELECT `cargo__Items`.`Summary` AS `Summary`,`cargo__Opinions`.`Position_link` AS `Position link`,`cargo__Opinions`.`Stance` AS `Stance` FROM `cargo__Items` LEFT OUTER JOIN `cargo__Opinions` ON ((`cargo__Items`.`_pageName`=`cargo__Opinions`.`_pageName`)) WHERE (cargo__Opinions.Topic="American Recovery and Reinvestment Act of 2009") ORDER BY `CASE Stance
WHEN 'for' THEN 1
WHEN 'against' THEN 2
WHEN 'mixed' THEN 3
END`,`Date` DESC LIMIT 100,101

Backtrace:

from /home/ngrandy/public_html/w/includes/libs/rdbms/database/Database.php(1618)
#0 /home/ngrandy/public_html/w/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /home/ngrandy/public_html/w/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /home/ngrandy/public_html/w/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /home/ngrandy/public_html/w/includes/libs/rdbms/database/Database.php(1711): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /home/ngrandy/public_html/w/includes/specialpage/QueryPage.php(540): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /home/ngrandy/public_html/w/includes/specialpage/QueryPage.php(726): QueryPage->reallyDoQuery(integer, integer)
#6 /home/ngrandy/public_html/w/extensions/Cargo/includes/specials/SpecialCargoQuery.php(41): QueryPage->execute(NULL)
#7 /home/ngrandy/public_html/w/includes/specialpage/SpecialPage.php(701): SpecialCargoQuery->execute(NULL)
#8 /home/ngrandy/public_html/w/includes/specialpage/SpecialPageFactory.php(1428): SpecialPage->run(NULL)
#9 /home/ngrandy/public_html/w/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#10 /home/ngrandy/public_html/w/includes/MediaWiki.php(904): MediaWiki->performRequest()
#11 /home/ngrandy/public_html/w/includes/MediaWiki.php(562): MediaWiki->main()
#12 /home/ngrandy/public_html/w/index.php(50): MediaWiki->run()
#13 /home/ngrandy/public_html/w/index.php(46): wfIndexMain()
#14 {main}