[Tickets #8610] Searching for similar Faces error "MDB2 Error: no such field" using postgresql

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8610
------------------------------------------------------------------------------
  Ticket             | 8610
  Created By         | tx4587 at crawford.homeunix.net
  Summary            | Searching for similar Faces error "MDB2 Error: no such
                     | field" using postgresql
  Queue              | Ansel
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


tx4587 at crawford.homeunix.net (2009-09-28 19:24) wrote:

Looks like the following log entry may give details. I'm using  
Postgresql 8.4.1 and have not tried this on MySQL:

Sep 28 16:15:43 HORDE [error] [ansel] MDB2 Error: no such field:  
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT COUNT(*) as face_matches, 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 <> 12 GROUP BY i.face_id HAVING face_matches > 0 ORDER BY  
face_matches DESC LIMIT 20 OFFSET 0]
[Native message: ERROR:  column "face_matches" does not exist at  
character 215]
  [pid 10376 on line 1053 of  
"/var/www/html/horde-webmail-1.2.4/ansel/lib/Faces.php"]
Sep 28 16:15:43 HORDE [debug] [ansel] MDB2 Error: no such field:  
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT COUNT(*) as face_matches, 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 <> 12 GROUP BY i.face_id HAVING face_matches > 0 ORDER BY  
face_matches DESC LIMIT 20 OFFSET 0]
[Native message: ERROR:  column "face_matches" does not exist at  
character 215]
  [pid 10376 on line 176 of  
"/var/www/html/horde-webmail-1.2.4/lib/Horde/Notification.php"]
Sep 28 16:15:43 HORDE [debug] [ansel] SQL query by  
Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start,  
alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text,  
alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed =  
0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze <=  
?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid = ? OR  
alarm_uid = ?) ORDER BY alarm_start, alarm_end [pid 10376 on line 148  
of "/var/www/html/horde-webmail-1.2.4/lib/Horde/Alarm/sql.php"]

The error messages is displayed across the top of the page, and in the  
log entry above.