[Mapserver-users] Mapserver 3.6.5 -> 3.6.7

Stéphane RIFF stephane.riff at cerene.fr
Tue Jan 20 04:22:54 EST 2004


I use Postgres 7.2 and postgis 0.7.5, php 4.3.2....

I tried to upgrade phpmapscript from 3.6.5 to 3.6.7 and my application 
doesn't work anymore.
I get an error from postgresql :

   *    Warning: MapServer Error in prep_DB(): Error executing POSTGIS 
DECLARE (the actual query)     statement: 'DECLARE mycursor BINARY 
CURSOR FOR SELECT 
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from 
giscontourfrance WHERE the_geom && setSRID('BOX3D(42370.624 
1616618.5,1203176.624 2677218.5)'::BOX3D, 
find_srid('','giscontourfrance','the_geom') )'

Postgresql reports the error ''
*
But when i launch this query from phpPgAdmin :

    *SELECT 
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from 
giscontourfrance WHERE the_geom && setSRID('BOX3D(42370.624 
1616618.5,1203176.624 2677218.5)'::BOX3D, 
find_srid('','giscontourfrance','the_geom') )*

It works....

Can someone point me to use mapserver 3.6.7 because i want to upgrade 
postgresql 7.2.4 to 7.3.*
and only 3.6.7 support pgsql 7.3 ( I don't want to upgrade to mapserver 
4.0.1 now)

Thanks




More information about the mapserver-users mailing list