[Tickets #10635] missing columns 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/10635
------------------------------------------------------------------------------
  Ticket             | 10635
  Created By         | thpo+horde at dotrc.de
  Summary            | missing columns in GROUP BY
  Queue              | Ansel
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-10-12 07:54) wrote:

ansel/lib/Faces/Base.php:getSignatureMatches()

The GROUP BY has to have all select-columns. Please add the missing
  f.gallery_id and f.face_signature.

Here is the related error message:

2011-10-12T09:44:38+02:00 ERR: HORDE [ansel] SQL QUERY FAILED:  
SQLSTATE[42803]: Grouping error: 7 ERROR:  column "f.gallery_id" must  
appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT i.face_id, f.face_name, f.image_id, f.gallery_id, f.f...
                                                    ^
         SELECT i.face_id, f.face_name, f.image_id, f.gallery_id,
           f.face_signature FROM ansel_faces_index i, ansel_faces f WHERE
           f.face_id = i.face_id AND i.face_id <> 1 GROUP BY i.face_id,
           f.face_name, f.image_id HAVING count(i.face_id) > 0 ORDER BY
           count(i.face_id) DESC LIMIT 20 [pid 1455 on line 812 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]