Database error
A database query error has occurred. This may be a software bug.
[e7b815edd965e95f57c8d58e] 2020-11-01 09:33:47: Fatal exception of type "Wikimedia \ Rdbms \ DBQueryError"
Description
Related Objects
- Mentioned In
- T6402: "Wikimedia\Rdbms\DBQueryError"
- Mentioned Here
- T6402: "Wikimedia\Rdbms\DBQueryError"
Event Timeline
Thanks, @Zppix, for reopening this ticket. I wondered if this task was appropriately closed.
This issue now seems to be resolved since myself and @Paladox are both able to access the page without seeing any error.
If the error persists, please feel free to reopen
You can confirm that this problem has not been solved yet by practicing rudimentary things such as looking at the diff from the page history.
This is a DPL problem, and if you enter a parameter that displays the user name such as adduser or addauthor, such as "addlasteditor = true", an error will occur. Investigate the cause and resolve it.
Assuming DPL is DynamicPageList, I noticed this issue yesterday on another customer wiki and @Paladox ran the trace. I'll try and post the trace results later today
If it is a DPL problem, it is likely upstream (i.e. for the developers to resolve). Unfortunately, Miraheze does not maintain every extension we have installed.
This is a DPL3 issue and not something we can solve at the moment, therefore not a high priority task.
For the record, the log reads:
2020-11-18 07:25:26 mw4 shiropediawiki: [b004753a561c960f43984063] /w/index.php?title=%E5%9F%8E%E3%83%9A%E3%83%87%E3%82%A3%E3%82%A2:%E8%AD%B0%E8%AB%96%E6%89%80&oldid=3252 Wikimedia\Rdbms\DBQueryError from line 1699 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: Error 1054: Unknown column 'rev.rev_user' in 'field list' (db11.miraheze.org) Function: DPL\Query::buildAndSelect Query: SELECT DISTINCT rev.rev_timestamp,rev.rev_user,rev.rev_user_text,rev.rev_comment,`page`.page_namespace AS `page_namespace`,`page`.page_id AS `page_id`,`page`.page_title AS `page_title` FROM `revision` `rev`,`page` INNER JOIN `categorylinks` `cl1` ON ((`page`.page_id = cl1.cl_from AND cl1.cl_to = '進行中の議論')) WHERE ((`page`.page_title like'%議論所/%')) AND (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page = rev.rev_page)) AND `page`.page_is_redirect = 0 AND `page`.page_namespace = 4 AND (`page`.page_id = rev.rev_page) AND (`page`.page_id = rev.rev_page) AND (rev.rev_timestamp = (SELECT MAX(rev_aux_max.rev_timestamp) FROM `revision` AS rev_aux_max WHERE rev_aux_max.rev_page = rev.rev_page)) AND (NOT (`page`.page_title like'議論所/秀逸記事審査認定課')) ORDER BY rev.rev_timestamp DESC LIMIT 500 #0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string) #1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string) #2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #3 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query(string, string, integer) #4 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(286): Wikimedia\Rdbms\DBConnRef->__call(string, array) #5 /srv/mediawiki/w/extensions/DynamicPageList3/classes/Query.php(306): Wikimedia\Rdbms\DBConnRef->query(string, string) #6 /srv/mediawiki/w/extensions/DynamicPageList3/classes/Parse.php(220): DPL\Query->buildAndSelect(boolean) #7 /srv/mediawiki/w/extensions/DynamicPageList3/DynamicPageListHooks.php(252): DPL\Parse->parse(string, Parser, NULL, NULL, boolean) #8 /srv/mediawiki/w/extensions/DynamicPageList3/DynamicPageListHooks.php(231): DynamicPageListHooks::executeTag(string, array, Parser, PPFrame_Hash) #9 /srv/mediawiki/w/includes/parser/Parser.php(3922): DynamicPageListHooks::dplTag(string, array, Parser, PPFrame_Hash) #10 /srv/mediawiki/w/includes/parser/PPFrame_Hash.php(330): Parser->extensionSubstitution(array, PPFrame_Hash) #11 /srv/mediawiki/w/includes/parser/Parser.php(2887): PPFrame_Hash->expand(PPNode_Hash_Tree, integer) #12 /srv/mediawiki/w/includes/parser/Parser.php(1556): Parser->replaceVariables(string) #13 /srv/mediawiki/w/includes/parser/Parser.php(651): Parser->internalParse(string) #14 /srv/mediawiki/w/includes/content/WikitextContent.php(374): Parser->parse(string, Title, ParserOptions, boolean, boolean, integer) #15 /srv/mediawiki/w/includes/content/AbstractContent.php(590): WikitextContent->fillParserOutput(Title, integer, ParserOptions, boolean, ParserOutput) #16 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(263): AbstractContent->getParserOutput(Title, integer, ParserOptions, boolean) #17 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(235): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean) #18 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(215): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string) #19 /srv/mediawiki/w/includes/Revision/RevisionRenderer.php(152): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array) #20 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array) #21 /srv/mediawiki/w/includes/Revision/RenderedRevision.php(197): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array) #22 /srv/mediawiki/w/includes/poolcounter/PoolWorkArticleView.php(216): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput() #23 /srv/mediawiki/w/includes/poolcounter/PoolCounterWork.php(162): PoolWorkArticleView->doWork() #24 /srv/mediawiki/w/includes/page/Article.php(810): PoolCounterWork->execute() #25 /srv/mediawiki/w/includes/actions/ViewAction.php(74): Article->view() #26 /srv/mediawiki/w/includes/MediaWiki.php(527): ViewAction->show() #27 /srv/mediawiki/w/includes/MediaWiki.php(313): MediaWiki->performAction(Article, Title) #28 /srv/mediawiki/w/includes/MediaWiki.php(940): MediaWiki->performRequest() #29 /srv/mediawiki/w/includes/MediaWiki.php(543): MediaWiki->main() #30 /srv/mediawiki/w/index.php(53): MediaWiki->run() #31 /srv/mediawiki/w/index.php(46): wfIndexMain() #32 {main}
Submitted merge request upstream to fix DPL3 entirly. If it is not merged upstream I will end up fully maintaining a forked version of the extension, as it is a very useful extension to have.