Author: overlordq
Description:
If you click show/hide on a revision to hide it you get a database error:
A database error has occurred
Query: SELECT log_type,log_action,log_user,log_namespace,log_title,log_params,log_comment,log_id,log_deleted,log_timestamp,user_name,user_editcount,ts_tags FROM logging INNER JOIN mwuser ON ((user_id=log_user)) INNER JOIN log_search ON ((ls_log_id=log_id)) LEFT JOIN tag_summary ON ((ts_log_id=log_id)) WHERE log_type = 'delete' AND log_action = 'revision' AND ls_field = 'rev_id' AND ls_value = '1532' AND (log_type != 'suppress') AND log_namespace = '0' AND log_title = 'Main_Page' AND ((log_deleted & 9) != 9) AND (user_id = log_user) GROUP BY ls_log_id ORDER BY log_timestamp DESC LIMIT 26
Function: IndexPager::reallyDoQuery (LogPager)
Error: 1 ERROR: column "logging.log_type" must appear in the GROUP BY clause or be used in an aggregate function
Is there a reason behind the group-by on that field?
Version: 1.16.x
Severity: normal