[2022-12-23T03:19:10.186189+00:00] exception.ERROR: [77b3e98f4255562131efd3dc] /wiki/Special:Log?type=messagebundle&user=&page=Translations%3AUser%3AAbijeet_Patro%2FMessageBundle15Jun-Moved%2Fdescription%2 Fen&wpdate=&tagfilter=OAuth+CID%3A+4&tagInvert=1&wpfilters%5B%5D=newusers&wpFormIdentifier=logeventslist Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'change_tag.ct_tag_id' in 'where clause' Function: IndexPager::buildQueryInfo (LogPager) Query: SELECT log_id,log_type,log_action,log_timestamp,log_namespace,log_title,log_params,log_deleted,user_id,user_name,log_actor,logging_actor.actor_user AS `log_user`,logging_actor.actor_name AS `log_us er_text`,comment_log_comment.comment_text AS `log_comment_text`,comment_log_comment.comment_data AS `log_comment_data`,comment_log_comment.comment_id AS `log_comment_cid`,(SELECT GROUP_CONCAT(ctd_name SEP ARATOR ',') FROM `bw_change_tag` JOIN `bw_change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_log_id=log_id ) AS `ts_tags` FROM `bw_logging` JOIN `bw_actor` `logging_actor` ON ((actor_id=log_actor)) LEFTJOIN `bw_user` ON ((user_id=logging_actor.actor_user)) JOIN `bw_comment` `comment_log_comment` ON ((comment_log_comment.comment_id = log_comment_id)) LEFT JOIN `bw_change_tag` ON ((ct_log_id=log_id) AND ct_tag_id = 14) WHERE (log_type NOT IN ('abusefilterprivatedetails','oath','suppress')) AND log_type = 'messagebundle' AND log_namespace = 1198 AND log_title = 'User:Abijeet_Patro/MessageBundle15Jun-Moved/description/en' AND ((log_deleted & 1) = 0) AND (change_tag.ct_tag_id IS NULL) ORDER BY log_timestamp DESC,log_id DESC LIMIT 51 {"exception":"[object] (Wikimedia\\Rdbms\\DBQueryError(code: 0): Error 1054: Unknown column 'change_tag.ct_tag_id' in 'where clause' Function: IndexPager::buildQueryInfo (LogPager) Query: SELECT log_id,log_type,log_action,log_timestamp,log_namespace,log_title,log_params,log_deleted,user_id,user_name,log_actor,logging_actor.actor_user AS `log_user`,logging_actor.actor_name AS `log_user_text`,comment_log_comment.comment_text AS `log_comment_text`,comment_log_comment.comment_data AS `log_comment_data`,comment_log_comment.comment_id AS `log_comment_cid`,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `bw_change_tag` JOIN `bw_change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_log_id=log_id ) AS `ts_tags` FROM `bw_logging` JOIN `bw_actor` `logging_actor` ON ((actor_id=log_actor)) LEFTJOIN `bw_user` ON ((user_id=logging_actor.actor_user)) JOIN `bw_comment` `comment_log_comment` ON ((comment_log_comment.comment_id = log_comment_id)) LEFT JOIN `bw_change_tag` ON ((ct_log_id=log_id) AND ct_tag_id = 14) WHERE (log_type NOT IN ('abusefilterprivatedetails','oath','suppress')) AND log_type = 'messagebundle' AND log_namespace = 1198 AND log_title = 'User:Abijeet_Patro/MessageBundle15Jun-Moved/description/en' AND ((log_deleted & 1) = 0) AND (change_tag.ct_tag_id IS NULL) ORDER BY log_timestamp DESC,log_id DESC LIMIT 51 at /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/Database.php:1543) [stacktrace] #0 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/Database.php(1527): Wikimedia\\Rdbms\\Database->getQueryException() #1 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/Database.php(1501): Wikimedia\\Rdbms\\Database->getQueryExceptionAndLog() #2 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/Database.php(874): Wikimedia\\Rdbms\\Database->reportQueryError() #3 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/Database.php(1635): Wikimedia\\Rdbms\\Database->query() #4 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\\Rdbms\\Database->select() #5 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/libs/rdbms/database/DBConnRef.php(338): Wikimedia\\Rdbms\\DBConnRef->__call() #6 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/pager/IndexPager.php(459): Wikimedia\\Rdbms\\DBConnRef->select() #7 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/pager/IndexPager.php(281): IndexPager->reallyDoQuery() #8 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/logging/LogPager.php(516): IndexPager->doQuery() #9 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/pager/IndexPager.php(563): LogPager->doQuery() #10 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/specials/SpecialLog.php(294): IndexPager->getBody() #11 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/specials/SpecialLog.php(171): SpecialLog->show() #12 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/specialpage/SpecialPage.php(700): SpecialLog->execute() #13 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/specialpage/SpecialPageFactory.php(1456): SpecialPage->run() #14 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/MediaWiki.php(322): MediaWiki\\SpecialPage\\SpecialPageFactory->executePath() #15 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/MediaWiki.php(916): MediaWiki->performRequest() #16 /srv/mediawiki/tags/2022-12-22_14:37:22/includes/MediaWiki.php(571): MediaWiki->main() #17 /srv/mediawiki/tags/2022-12-22_14:37:22/index.php(50): MediaWiki->run() #18 /srv/mediawiki/tags/2022-12-22_14:37:22/index.php(46): wfIndexMain() #19 {main} ","exception_url":"/wiki/Special:Log?type=messagebundle&user=&page=Translations%3AUser%3AAbijeet_Patro%2FMessageBundle15Jun-Moved%2Fdescription%2Fen&wpdate=&tagfilter=OAuth+CID%3A+4&tagInvert=1&wpfilters%5B%5D=newusers&wpFormIdentifier=logeventslist","reqId":"77b3e98f4255562131efd3dc","caught_by":"entrypoint"} []
Since it works without tagInvert=1, this is probably a regression from T174349: Allow tag filter on Special:RecentChanges and Watchlist to be inverted (enable the not operator).
The issue seems to be missing table prefix in AND (change_tag.ct_tag_id IS NULL)