From my exception log: SELECT list is not in GROUP BY clause and contains nonaggregated column 'wiki.rc.rc_actor ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
| Name | Version |
|---|---|
| MediaWiki | 1.34.0 (5a5d2c2) |
| PHP | 7.3.19 (fpm-fcgi) |
| Percona XtraDB Cluster | 5.7.23-23-57-log |
| DynamicPageList3 | 3.3.3 (64e35da0) 13:12, 6 July 2020 |
From my exception logs:
2020-07-16 19:06:37 ... wiki-wiki1: [f00db0a776764240d674a0d8] .... 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 SQL_CALC_FOUND_ROWS SUM(ABS(rc.rc_new_len - rc.rc_old_len)) AS `contribution`,rc.rc_actor AS `contributor`,`wiki1page`.page_len AS `page_len`,GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS `cats`,`wiki1page`.page_namespace AS `page_namespace`,`wiki1page`.page_id AS `page_id`,`wiki1page`.page_title AS `page_title` FROM `wiki1revision` `change_rev`,`wiki1recentchanges` `rc`,`wiki1page` LEFT OUTER JOIN `wiki1categorylinks` `cl_gc` ON ((page_id = cl_gc.cl_from)) WHERE `wiki1page`.page_is_redirect = '0' AND ('Alondra1.Lopez' = change_rev.rev_user_text AND change_rev.rev_page = page_id) AND (`wiki1page`.page_id = rc.rc_cur_id) AND (`wiki1page`.page_namespace NOT IN('5060','5096','5094','5092','5088','5086','5084','5082','5080','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 rc.rc_cur_id,`wiki1page`.page_id LIMIT 500
Function: Wikimedia\Rdbms\DBConnRef::query
Error: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wiki.rc.rc_actor' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (10.42.1.152)
#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)
#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, string, string, string, string, string)
....This SO answer and this more in-depth answer explain what is going on.