[Cartoweb-users] HELP: timeout_async _toolTips(no result)

[Oliver Christen]

hi Andreas

I suggest you try to print out the sql query.
to do that, look in QueryableLayer.php, in function getXySqlQuery, and
replace:

        return sprintf('SELECT %s FROM %s ' .
                       "WHERE %s && setSRID('%s'::box3d, %s) ".
                       "AND Distance(%s, GeometryFromText( '".
                       "POINT(%s %s)', %d ) ) < %s",
                       $this->getReturnedAttributes(),
                       $this->dbTableName,
                       $this->dbGeomColumnName,
                       $bbox3D,
                       $this->srid,
                       $this->dbGeomColumnName,
                       $geoX,
                       $geoY,
                       $this->srid,
                       $toleranceGeo);

by:

        $sql = sprintf('SELECT %s FROM %s ' .
                       "WHERE %s && setSRID('%s'::box3d, %s) ".
                       "AND Distance(%s, GeometryFromText( '".
                       "POINT(%s %s)', %d ) ) < %s",
                       $this->getReturnedAttributes(),
                       $this->dbTableName,
                       $this->dbGeomColumnName,
                       $bbox3D,
                       $this->srid,
                       $this->dbGeomColumnName,
                       $geoX,
                       $geoY,
                       $this->srid,
                       $toleranceGeo);

        print $sql;

        return $sql;

you will get an error, because of the print command, but it will also
display what the sql look like and you can try to make the same request in
phpPgAdmin (or in command line) to try to see if it works directly in
postgres.


regards
Oliver


> Hi List!
>
> It's seems like I have got rid of timeout_async _toolTips errors.
>
> All I get is AjaxPlugins.ToolTips: sending request for coords
> 16.666116706666667, -20.433233650833333...
> Request sent with url
> :./Trumpet.php?toolTips=1&geoX=16.666116706666667&geoY=-20.433233650833333&charSet=utf-8&#9001;=
> AjaxPlugins.ToolTips: no result
>
> What could be the problem?
>
> Any help please!
>
> Best regards,
> Andreas Mtota
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>