6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/5/26
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers