Tickets :: Comment on [#10383] SQL error in duplicate search

* Your Email Address
* Spam protection	Enter the letters below: ._.. . ..__..___. \| \|\ \| \|[__] \| _\|_\| \\|\__\|\| \| \|
Comment	> /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"] >
Attachment
Watch this ticket