[Tickets #8609] Re: Can't delete faces

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8609
------------------------------------------------------------------------------
  Ticket             | 8609
  Updated By         | Michael Rubinsky <mrubinsk at horde.org>
  Summary            | Can't delete faces
  Queue              | Ansel
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Not A Bug
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2009-10-29 13:55) wrote:

> The faces are not being deleted, I'm no longer getting the errors.  
> The last post was the results of the different tabs from FireBug. It  
> seems like it's doing everything correctly, the faces just stay.

I'm out of ideas. All the code that deletes the face is being  
run...and from the lack of error messages being thrown, it looks like  
it's being run successfully.

> Furthermore, I was looking at the postgresql log while trying to  
> delete the faces, I didn't get an error there but I did recieve the  
> following error when selecting a picture to view, not just the face.  
> Wondering if this is causing some state data to not be loaded. Just  
> a wild guess though:
> ERROR:  column "%" does not exist at character 109
> STATEMENT:  SELECT DISTINCT image_location, image_latitude,  
> image_longitude FROM ansel_images WHERE image_location LIKE "%"

The only time the code that executes this statement is run is when you  
are attempting to geotag an image, from the map_edit.php page. If all  
you did, as you say, is to view an image, and you got this error, then  
something is pretty badly broken on your install.