https://bugzilla.wikimedia.org/show_bug.cgi?id=20150
Summary: RevisionDelete does not work under Postgres
Product: MediaWiki
Version: 1.16-svn
Platform: All
OS/Version: All
Status: NEW
Keywords: postgresql
Severity: normal
Priority: Normal
Component: Revision deletion
AssignedTo: [email protected]
ReportedBy: [email protected]
Blocks: 384
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?
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
