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

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

Saved Queries