Tickets :: [#8919] view.php fails with postgresql backend

6.0.0-beta1

7/22/25

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	03/18/2010 (5605 days ago)
Due
Updated	03/18/2010 (5605 days ago)
Assigned
Resolved	03/18/2010 (5605 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	Yes

03/18/2010 05:08:38 PM	Michael Rubinsky	Comment #7	Reply to this comment
yea, thanks...I already fixed :)

03/18/2010 05:00:53 PM	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 "'

03/18/2010 04:59:19 PM	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!

03/18/2010 04:58:10 PM	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

03/18/2010 04:56:05 PM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in Git for this ticket: Properly quote the search term. ~~Bug: 8919~~ http://git.horde.org/diff.php/ansel/lib/Storage.php?rt=horde-git&r1=240ff73e2a3bcfe5e5649e5d9153d87b25471d36&r2=40df1aeabe36f7c5539f0571c96574a067c408d3

03/18/2010 03:40:02 PM	horde (at) albasoft (dot) com	Comment #2 New Attachment: ansel-h3-1.1.patch	Reply to this comment
Sorry, the patch again

03/18/2010 03:28:48 PM	horde (at) albasoft (dot) com	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ view.php fails with postgresql backend Queue ⇒ Ansel Milestone ⇒ Patch ⇒ Yes State ⇒ Unconfirmed	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.