6.0.0-git
2019-03-21

[#8919] view.php fails with postgresql backend
Summary view.php fails with postgresql backend
Queue Ansel
Queue Version FRAMEWORK_3
Type Bug
State Resolved
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester horde (at) albasoft (dot) com
Created 2010-03-18 (3290 days ago)
Due
Updated 2010-03-18 (3290 days ago)
Assigned
Resolved 2010-03-18 (3290 days ago)
Milestone
Patch Yes

History
2010-03-18 17:08:38 Michael Rubinsky Comment #7 Reply to this comment
yea, thanks...I already fixed :)
2010-03-18 17:00:53 horde (at) albasoft (dot) com Comment #6 Reply to this comment
You have left double quotes after LIKE, and it won't work.
It Should be:
image_location LIKE '
instead of
image_location LIKE "'
2010-03-18 16:59:19 Michael Rubinsky Comment #5
Assigned to Michael Rubinsky
State ⇒ Resolved
Priority ⇒ 1. Low
Reply to this comment
Fixed for Ansel 1.1.1, thanks for the report!
2010-03-18 16:58:10 CVS Commit Comment #4 Reply to this comment
Changes have been made in CVS for this ticket:

Correctly quote the search term.
Bug: 8919
Submitted by: horde (at) albasoft (dot) com
http://cvs.horde.org/diff.php/ansel/lib/Ansel.php?rt=horde&r1=1.517.2.73&r2=1.517.2.74&ty=u
2010-03-18 15:40:02 horde (at) albasoft (dot) com Comment #2
New Attachment: ansel-h3-1.1.patch Download
Reply to this comment
Sorry, the patch again
2010-03-18 15:28:48 horde (at) albasoft (dot) com Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ view.php fails with postgresql backend
Queue ⇒ Ansel
Milestone ⇒
Patch ⇒ Yes
Reply to this comment
Gallery view doesn't work when using postgresql as backend. I just get 
an empty page and this error on log:

Mar 18 13:34:41 HORDE [error] [ansel] MDB2 Error: no such field: 
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT image_location, image_latitude, 
image_longitude FROM ansel_images WHERE image_location LIKE "%"]
[Native message: ERROR:  column "%" does not exist]

I think attached patch solves the problem.

Saved Queries