SQL queries are not compatible with MySQL 5.7's default of `sql_mode=only_full_group_by`
The following simple dpl statement causes this problem:
{{#dpl:
|linksto={{FULLPAGENAME}}
|noresultsheader=\nNone
}}
The backtrace:
2021-09-16 15:31:55 vdcglp02392 wiki-wiki1: [56c059b49d334dc92039d969] /w/index.php?title=User:Mark.Hershberger/dpl-sandbox&action=submit Wikimedia\Rdbms\DBQueryError from line 1603 of .../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 DISTINCT pl.pl_title AS `sel_title`,pl.pl_namespace AS `sel_ns`,`wiki1page`.page_namespace AS `page_namespace`,`wiki1page`.page_id AS `page_id`,`wiki1page`.page_title AS `page_title` FROM `wiki1pagelinks` `pl`,`wiki1page` WHERE `wiki1page`.page_is_redirect = '0' AND (`wiki1page`.page_id=pl.pl_from AND ((pl.pl_namespace=2 AND pl.pl_title LIKE 'Mark.Hershberger/dpl-sandbox'))) AND (`wiki1page`.page_namespace NOT IN('5060','5114','5112','5108','5102','5100','5098','5096','5094','5092','5088','5086','5078','5076','5074','5070','5064','5062','5060','5058','5054','5048','5046','5042','5040','5038','5036','5034','5032','5026','5024','5022','5018','5016','5014','5004','5002','5000')) GROUP BY page_title LIMIT 500
Function: DPL\Query::buildAndSelect
Error: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wiki.pl.pl_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (10.42.27.186)
#0 .../includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 .../includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 .../includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query(string, string, integer)
#3 .../includes/libs/rdbms/database/DBConnRef.php(292): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#4 .../extensions/DynamicPageList/classes/Query.php(306): Wikimedia\Rdbms\DBConnRef->query(string, string)
#5 .../extensions/DynamicPageList/classes/Parse.php(220): DPL\Query->buildAndSelect(boolean)
#6 .../extensions/DynamicPageList/DynamicPageListHooks.php(306): DPL\Parse->parse(string, Parser, NULL, NULL, boolean)
#7 .../includes/parser/Parser.php(3816): DynamicPageListHooks::dplParserFunction(Parser, string, string, string)
#8 .../includes/parser/Parser.php(3519): Parser->callParserFunction(PPFrame_Hash, string, array)
#9 .../includes/parser/PPFrame_Hash.php(254): Parser->braceSubstitution(array, PPFrame_Hash)
#10 .../includes/parser/Parser.php(3330): PPFrame_Hash->expand(PPNode_Hash_Tree, integer)
#11 .../includes/parser/Parser.php(1489): Parser->replaceVariables(string)
#12 .../includes/parser/Parser.php(593): Parser->internalParse(string)
#13 .../includes/content/WikitextContent.php(368): Parser->parse(string, Title, ParserOptions, boolean, boolean, NULL)
#14 .../includes/content/AbstractContent.php(555): WikitextContent->fillParserOutput(Title, NULL, ParserOptions, boolean, ParserOutput)
#15 .../includes/Revision/RenderedRevision.php(264): AbstractContent->getParserOutput(Title, NULL, ParserOptions, boolean)
#16 .../includes/Revision/RenderedRevision.php(236): MediaWiki\Revision\RenderedRevision->getSlotParserOutputUncached(WikitextContent, boolean)
#17 .../includes/Revision/RevisionRenderer.php(215): MediaWiki\Revision\RenderedRevision->getSlotParserOutput(string)
#18 .../includes/Revision/RevisionRenderer.php(152): MediaWiki\Revision\RevisionRenderer->combineSlotOutput(MediaWiki\Revision\RenderedRevision, array)
#19 [internal function]: MediaWiki\Revision\RevisionRenderer->MediaWiki\Revision\{closure}(MediaWiki\Revision\RenderedRevision, array)
#20 .../includes/Revision/RenderedRevision.php(198): call_user_func(Closure, MediaWiki\Revision\RenderedRevision, array)
#21 .../includes/Storage/DerivedPageDataUpdater.php(1290): MediaWiki\Revision\RenderedRevision->getRevisionParserOutput()
#22 .../includes/Storage/PageUpdater.php(725): MediaWiki\Storage\DerivedPageDataUpdater->getCanonicalParserOutput()
#23 .../includes/page/WikiPage.php(1930): MediaWiki\Storage\PageUpdater->saveRevision(CommentStoreComment, integer)
#24 .../includes/EditPage.php(2341): WikiPage->doEditContent(WikitextContent, CommentStoreComment, integer, boolean, User, string, array, integer)
#25 .../includes/EditPage.php(1617): EditPage->internalAttemptSave(array, boolean)
#26 .../includes/EditPage.php(682): EditPage->attemptSave(array)
#27 .../includes/actions/EditAction.php(55): EditPage->edit()
#28 .../includes/actions/SubmitAction.php(38): EditAction->show()
#29 .../includes/MediaWiki.php(511): SubmitAction->show()
#30 .../includes/MediaWiki.php(302): MediaWiki->performAction(Article, Title)
#31 .../includes/MediaWiki.php(854): MediaWiki->performRequest()
#32 .../includes/MediaWiki.php(527): MediaWiki->main()
#33 .../index.php(44): MediaWiki->run()
#34 {main}