[Tickets #10419] missing non-aggregated column in GROUP BY

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10419
------------------------------------------------------------------------------
  Ticket             | 10419
  Created By         | thpo+horde at dotrc.de
  Summary            | missing non-aggregated column in GROUP BY
  Queue              | Content
  Version            | 1.0.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
+New Attachment     | content.diff
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-08-09 16:55) wrote:

2011-08-09T11:30:42+02:00 ERR: HORDE [ansel] SQL QUERY FAILED:  
SQLSTATE[42803]: Grouping error: 7 ERROR:  column "t.tag_name" must  
appear in the GROUP BY clause or be used in an aggregate function
         SELECT t.tag_id AS tag_id, tag_name, COUNT(*) AS count FROM
           "rampage_tagged" tagged INNER JOIN "rampage_objects" objects ON
           tagged.object_id = objects.object_id AND objects.type_id  
IN(3,4) INNER
           JOIN "rampage_tags" t ON tagged.tag_id = t.tag_id GROUP BY t.tag_id
           ORDER BY count DESC LIMIT 20 [pid 31253 on line 808 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]