[Cartoweb-dev] Re: Recenter and recenter after search

[Oliver Christen]

Hi
which version of mapserver do you have ?

regards
Oliver


> Hi Everybody!
>
> I don't know WHY, but recenter function doesn't work. It seems nobody had
> the same problem before.
> And I'm becoming crazy!!
>
>
> Search works fine, but when i click on results to recenter the map i get
> the following error (development mode) :
> (REcentering doesn't work also from locate plugin ....)
> *********************************************************************************
> CartoWeb version: 3.4.0 [$Revision: 1.7 $]
> class:   SoapFaultWrapper
> message:   MapServer error: Error in msDrawMap(): Failed to draw layer
> named 'impianti'.
>
> Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> "id"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
> from (select the_geom, id, oid, gid, azioni, destinazio from
> impianti_fiumicino) as foo  WHERE (id IN ) and (the_geom && setSRID(
> 'BOX3D(2283484.66666667 4625899,2300067.33333333
> 4638336)'::BOX3D,find_srid('','impianti_fiumicino','the_geom') ))'
>
> Postgresql reports the error as 'ERROR:  syntax error at or near ")" at
> character 219
> '
>
> 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#'
> **************************************************************************************
>
> where "impianti" is my layer and impianti_fiumicino is my Postgis table...
>
>
> Any idea?
>
> Thanks in advance
>
> Vinc
>