[Tickets #10383] SQL error in duplicate search

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10383
------------------------------------------------------------------------------
  Ticket             | 10383
  Created By         | thpo+horde at dotrc.de
  Summary            | SQL error in duplicate search
  Queue              | Turba
  Version            | 3.0.4
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-07-26 07:51) wrote:

/turba/search.php?search_mode=duplicate

2011-07-26T09:47:25+02:00 ERR: HORDE [turba] SQL QUERY FAILED:  
SQLSTATE[42P10]: Invalid column reference: 7 ERROR:  for SELECT  
DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...IS NOT NULL AND a1.object_lastname <> '' ORDER BY a1.object_...
                                                              ^
         SELECT DISTINCT a1.object_id FROM turba_objects a1 JOIN turba_objects
           a2 ON a1.object_lastname = a2.object_lastname AND  
a1.object_firstname
           = a2.object_firstname AND a1.object_id <> a2.object_id WHERE
           a1.owner_id = 'thpo' AND a2.owner_id = 'thpo' AND a1.object_lastname
           IS NOT NULL AND a1.object_lastname <> '' ORDER BY
           a1.object_lastname,a1.object_firstname [pid 9137 on line  
808 of "/usr/share/php/Horde/Db/Adapter/Base.php"]