[Cartoweb-users] ObjectRecenter from search plugin

[vosky]

The same problem :-(
After cartoweb cvs uprade, idRecenter doesn't work...
If I use:
http://10.3.8.68/cartoweb3/htdocs/bystrica.php?id_recenter_layer=hranice_ku&id_recenter_ids=2

I get this:

Failure  
Class : SoapFaultWrapperMessage : MapServer error: Error in msDrawMap():
Failed to draw layer named 'hranice_ku'.
Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
"id"::text,"gid"::text,"nazov_ku"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from hranice_ku WHERE (gid IN ) and (the_geom && setSRID(
'BOX3D(-434046.142857143 -1243041,-398961.857142857
-1218482)'::BOX3D,find_srid('','hranice_ku','the_geom') ))' 

Postgresql reports the error as 'CHYBA:  syntaktická chyba pri alebo v
blízkosti ")"
LINE 1: ...)),'NDR'),gid::text from hranice_ku WHERE (gid IN ) and (the...
                                                             ^
'

More Help:

Error with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are : 
(1) 'geometry_column from geometry_table' 
(2) 'geometry_column from (sub query) as foo using unique column name using
SRID=srid#' 

Make sure you put in the 'using unique  column name' and 'using SRID=#'
clauses in.

For more help, please see http://postgis.refractions.net/documentation/ 

Did someone solve it?





WochteR wrote:
> 
> Hello,
> I upgraded cartoweb from cvs and now I obtain this issue, when I want to
>     display searched object on map.
> I use function ObjectRecenter in Search.ajax.js
> 
> function ObjectRecenter(Layer,Id) {
> 
>     $('id_recenter_layer').value = Layer;
>     $('id_recenter_ids').value = Id;
> 
>     CartoWeb.trigger('Location.Recenter');
> 
> It worked good before upgrade.
> 
> Hehe is the issue:
> 
>  Failure
> 
> Class : SoapFaultWrapper
> Message : MapServer error: Error in msDrawMap(): Failed to draw layer
> named 'zastavba'.
> 
> Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> "vyznamnost"::text,"gid"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
> from rovce_zastavba WHERE (gid IN ) and (the_geom && setSRID(
> 'BOX3D(-469330.214285714 -1273120,-464958.785714286
> -1270060)'::BOX3D,find_srid('','rovce_zastavba','the_geom') ))'
> 
> Postgresql reports the error as 'CHYBA:  syntaktická chyba pri alebo v
> blízkosti ")"
> LINE 1: ...),gid::text from rovce_zastavba WHERE (gid IN ) and (the...
>                                                          ^
> 
> 
> Could you help me please?
> 
> thanx
> 
> wochter
> 
> 
> 
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
> 
> 

-- 
View this message in context: http://www.nabble.com/ObjectRecenter-from-search-plugin-tf4376909.html#a12588377
Sent from the cartoweb-users mailing list archive at Nabble.com.