Page MenuHomePhabricator

Error: 1176 Key 'page_random' doesn't exist in table 'image'
Open, Needs TriagePublic

Description

Hi, we are getting:

/wiki/Inconsapevole_di_esserlo   Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/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: SELECT  page_namespace,page_title  FROM `page`,`image`  FORCE INDEX (page_random)  WHERE page_namespace = '6' AND page_is_redirect = '0' AND (page_random > '0.153958225014') AND (img_name = page_title) AND img_major_mime = 'image'  ORDER BY page_random LIMIT 1  
Function: RandomImage::pickFromDatabase
Error: 1176 Key 'page_random' doesn't exist in table 'image' (mediawiki-internal-db-master-db5.miraheze.org)

#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1899): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array)
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(333): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /srv/mediawiki/w/extensions/RandomImage/RandomImage.class.php(216): Wikimedia\Rdbms\DBConnRef->selectRow(array, array, array, string, array)
#7 /srv/mediawiki/w/extensions/RandomImage/RandomImage.class.php(167): RandomImage->pickFromDatabase()
#8 /srv/mediawiki/w/extensions/RandomImage/RandomImage.class.php(68): RandomImage->pickImage()
#9 /srv/mediawiki/w/extensions/RandomImage/RandomImage.class.php(262): RandomImage->render()
#10 [internal function]: RandomImage::renderHook(string, array, Parser, PPFrame_Hash)
#11 /srv/mediawiki/w/includes/parser/Parser.php(4293): call_user_func_array(string, array)
#12 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(328): Parser->extensionSubstitution(array, PPFrame_Hash)
#13 /srv/mediawiki/w/includes/parser/Parser.php(3330): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#14 /srv/mediawiki/w/includes/parser/Parser.php(1489): Parser->replaceVariables(string)
#15 /srv/mediawiki/w/includes/parser/Parser.php(593): Parser->internalParse(string)
#16 /srv/mediawiki/w/includes/content/WikitextContent.php(368): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer)
#17 /srv/mediawiki/w/includes/content/AbstractContent.php(555): WikitextContent->fillParserOutput(Title, integer, ParserOptions, boolean, ParserOutput)
#18 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(264): AbstractContent->getParserOutput(Title, integer, ParserOptions, boolean)
#19 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(236): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#20 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(215): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string)
#21 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(152): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#22 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#23 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(198): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#24 /srv/mediawiki/w/includes/poolcounter/PoolWorkArticleView.php(196): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#25 /srv/mediawiki/w/includes/poolcounter/PoolCounterWork.php(125): PoolWorkArticleView->doWork()
#26 /srv/mediawiki/w/includes/page/Article.php(791): PoolCounterWork->execute()
#27 /srv/mediawiki/w/includes/actions/ViewAction.php(63): Article->view()
#28 /srv/mediawiki/w/includes/MediaWiki.php(511): ViewAction->show()
#29 /srv/mediawiki/w/includes/MediaWiki.php(302): MediaWiki->performAction(Article, Title)
#30 /srv/mediawiki/w/includes/MediaWiki.php(900): MediaWiki->performRequest()
#31 /srv/mediawiki/w/includes/MediaWiki.php(527): MediaWiki->main()
#32 /srv/mediawiki/w/index.php(44): MediaWiki->run()
#33 {main}

Under MediaWiki 1.34 and php7.3

Event Timeline

The maintainer's user page ( https://www.mediawiki.org/wiki/User:Robchurch ) states "I am not currently involved in developing the MediaWiki software or extensions." so this task might get WONTFIXed / declined: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/RandomImage/