HomePhabricator

Fix bug 23600: column "recentchanges.rc_timestamp" should be in GROUP BY

Authored by saper.

Description

Fix bug 23600: column "recentchanges.rc_timestamp" should be in GROUP BY

PostgreSQL error:

Query: SELECT rc_namespace,rc_title,rc_timestamp,COUNT(*) AS edits FROM recentchanges WHERE rc_user_text = 'Dnessett' AND ((rc_new = 1) OR (rc_log_type = 'upload' AND rc_log_action = 'upload')) GROUP BY rc_namespace, rc_title ORDER BY rc_timestamp DESC Function: SpecialNuke::getNewPages Error: 1 ERROR: column "recentchanges.rc_timestamp" must appear in the GROUP BY clause or be used in an aggregate function

Backtrace:

Thanks-To:

Change-Id: I8804b0e88d483c0563bdf304fa6aad8373a14ab3
13:15 [freenode] -!- Tuju [~tuju@176.75.219.213.sta.estpak.ee]
13:15 [freenode] -!- ircname : Juha Tuomala
13:15 [freenode] -!- channels : MediaWiki-General
13:15 [freenode] -!- server : kornbluth.freenode.net [Frankfurt, Germany]
13:15 [freenode] -!- account : Tuju
13:15 [freenode] -!- End of WHOIS