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

[WochteR]

Thank you.
Thus, specification of my versions:

POSTGIS="1.1.0" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS

But, it seems it is mapserver bug as wrote Dirk.

Will it be better to use latest version of mapserver?
4.10.2 (2007-05-07)
or change the code in 
coreplugins\mapquery\server\ServerMapquery.php ?

What is better solution?

wochter


> ------------ Pôvodná správa ------------
> Od: Jacolin Yves <yjacolin at free.fr>
> Predmet: Re: [Cartoweb-users] calling id_recenter from search plugin
> Dátum: 10.5.2007 10:10:16
> ----------------------------------------
> Hi,
> 
> You can try this :
> psql -d <YourDataBase> -U postgres -c "SELECT postgis_full_version()"
> 
> To get your postgis version.
> 
> Y.
> Le Thursday 10 May 2007 09:41:54 WochteR, vous avez écrit :
> > 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
> >
> > _______________________________________________
> > Cartoweb-users mailing list
> > Cartoweb-users at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/cartoweb-users
> 
> 
> 
> -- 
> Yves Jacolin
> ---
> http://softlibre.gloobe.org
> 
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
> 
> 
>