[Tickets #10616] datatype mismatch in geolocation DB query

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10616
------------------------------------------------------------------------------
  Ticket             | 10616
  Created By         | thpo+horde at dotrc.de
  Summary            | datatype mismatch in geolocation DB query
  Queue              | Ansel
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-10-07 16:18) wrote:

There is a problem with the datatypes uses in a query, which  
postgresql complains about:

A fatal error has occurred
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist:  
character varying > integer LINE 1: ..._location FROM ansel_images  
WHERE image_latitude > 0 AND im... ^ HINT: No operator matches the  
given name and argument type(s). You might need to add explicit type  
casts.

1. Ansel_View_Gallery->html() /srv/horde4/ansel/view.php:56
2. Ansel_View_GalleryRenderer_Gallery->html()  
/srv/horde4/ansel/lib/View/Gallery.php:132
3. include() /srv/horde4/ansel/lib/View/GalleryRenderer/Gallery.php:131
4. Ansel_View_Ansel->renderWidgets()  
/srv/horde4/ansel/templates/view/gallery.inc:170
5. Ansel_View_Ansel->_renderWidgets() /srv/horde4/ansel/lib/View/Ansel.php:55
6. Ansel_Widget_Geotag->html() /srv/horde4/ansel/lib/View/Ansel.php:77
7. Ansel_Storage->getImagesGeodata()  
/srv/horde4/ansel/lib/Widget/Geotag.php:74
8. Ansel_Storage->listImages() /srv/horde4/ansel/lib/Storage.php:1151

Details
The full error message is logged in Horde's log file, and is shown  
below only to administrators. Non-administrative users will not see  
error details.

Ansel_Exception Object
(
     [details] =>
     [message:protected] => SQLSTATE[42883]: Undefined function: 7  
ERROR:  operator does not exist: character varying > integer
LINE 1: ..._location FROM ansel_images  WHERE image_latitude > 0 AND im...
                                                              ^
HINT:  No operator matches the given name and argument type(s). You  
might need to add explicit type casts.
     [string:Exception:private] =>
     [code:protected] => 42883
     [file:protected] => /srv/horde4/ansel/lib/Storage.php
     [line:protected] => 1108
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] => /srv/horde4/ansel/lib/Storage.php
                     [line] => 1151
                     [function] => listImages
                     [class] => Ansel_Storage
                     [type] => ->
                     [args] => Array
                         (
                             [0] => Array
                                 (
                                     [fields] => Array
                                         (
                                             [0] => image_id as id
                                             [1] => image_id
                                             [2] => image_latitude
                                             [3] => image_longitude
                                             [4] => image_location
                                         )

                                     [filter] => Array
                                         (
                                             [0] => Array
                                                 (
                                                     [property] => latitude
                                                     [op] => >
                                                     [value] => 0
                                                 )

                                             [1] => Array
                                                 (
                                                     [property] => id
                                                     [op] => IN
                                                     [value] => Array
                                                         (
                                                             [0] => 2
                                                             [1] => 3
                                                         )

                                                 )

                                         )

                                 )

                         )

                 )

             [1] => Array
                 (
                     [file] => /srv/horde4/ansel/lib/Widget/Geotag.php
                     [line] => 74
                     [function] => getImagesGeodata
                     [class] => Ansel_Storage
                     [type] => ->
                     [args] => Array
                         (
                             [0] => Array
                                 (
                                     [0] => 2
                                     [1] => 3
                                 )

                         )

                 )

             [2] => Array
                 (
                     [file] => /srv/horde4/ansel/lib/View/Ansel.php
                     [line] => 77
                     [function] => html
                     [class] => Ansel_Widget_Geotag
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [3] => Array
                 (
                     [file] => /srv/horde4/ansel/lib/View/Ansel.php
                     [line] => 55
                     [function] => _renderWidgets
                     [class] => Ansel_View_Ansel
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [4] => Array
                 (
                     [file] => /srv/horde4/ansel/templates/view/gallery.inc
                     [line] => 170
                     [function] => renderWidgets
                     [class] => Ansel_View_Ansel
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [5] => Array
                 (
                     [file] =>  
/srv/horde4/ansel/lib/View/GalleryRenderer/Gallery.php
                     [line] => 131
                     [args] => Array
                         (
                             [0] =>  
/srv/horde4/ansel/templates/view/gallery.inc
                         )

                     [function] => include
                 )

             [6] => Array
                 (
                     [file] => /srv/horde4/ansel/lib/View/Gallery.php
                     [line] => 132
                     [function] => html
                     [class] => Ansel_View_GalleryRenderer_Gallery
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [7] => Array
                 (
                     [file] => /srv/horde4/ansel/view.php
                     [line] => 56
                     [function] => html
                     [class] => Ansel_View_Gallery
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

         )