[Cartoweb-users] ObjectRecenter from search plugin

[wochter]

Yes!
This problem is present only when I have data stored in postgis.
I tried shapefile and id_recentering works.

thank you

wochter





Oliver Christen  wrote / napísal(a):
> 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
>>
> 
>