Re: [Cartoweb-users] calling id_recenter from search plugin

[WochteR]

Thanx folks,

I have installed:
MapServer version 4.8.1
And I dont know how to check version of postgis.

What version of mapserver and postgis have I install to eliminate this bug?
The last version of mapserver is: 4.10.2 (2007-05-07)
and postgis: [2007/01/11] 


Thanx 
wochter




> ------------ Pôvodná správa ------------
> Od: Dirk Jesko <ml.dje at geocontent.de>
> Predmet: Re: [Cartoweb-users] calling id_recenter from search plugin
> Dátum: 10.5.2007 08:51:38
> ----------------------------------------
> Hi,
> 
> sounds like the same problem I had. If it is the same, it is a bug in 
> mapserver version 4.10 and possibly some 4.8. Have a look at the 
> attached ServerMapquery.php. I added some quotes in line 179 which 
> solved the problem. Try changing your 
> coreplugins\mapquery\server\ServerMapquery.php.
> 
> 
> Regards,
> Dirk
> 
> 
> 
> WochteR wrote:
> > Hi,
> > I have troubles with recentering an object.
> > Plugin search works fine, but when I clicked on result I obtain this 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 kzarovce_zastavba WHERE (gid = 'gid IN (620)') and (the_geom && setSRID(
> 'BOX3D(-469330.214285714 -1273120,-464958.785714286
> -1270060)'::BOX3D,find_srid('','kzarovce_zastavba','the_geom') ))' 
> >
> > Postgresql reports the error as 'ERROR:  invalid input syntax for integer:
> "gid IN (620)"
> > '
> >
> > 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.
> > --------------------------
> >
> > It is very mysterious, because on my laptop it works good.
> > This issue is displayed from server where I moved working cartoweb project.
> > Need I change anything in php.ini or something else?
> > I don't know what to do...
> >
> > Thanx for advice
> >
> > wochter
> > _______________________________________________
> > Cartoweb-users mailing list
> > Cartoweb-users at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/cartoweb-users
> >
> >   
> 
> 
>