[Cartoweb-users] ObjectRecenter from search plugin

[Oliver Christen]

Can you reproduce this problem with the demoCW3 project?
I just tried and it seems to work fine, but then the demo do not use 
postgres, so maybe the problem is linked to some postgis thing.
If you can confirm this, it may help for pinpointing more precisely what may 
go wrong.

regards
Oliver

>
> 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.
>
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>