[Mapserver-users] Postgresql error after upgrading to 7.3.2

[h.aue at plan-gis.de]

hi,

i'm using mapserver 3.6.5 on a debian linux box. everything worked fine when i used data (geometry+attributes) from a postgresql 7.2.1 database with postgis 0.7.5 on the mapserver. now that i upgraded to pg 7.3.2 i get the following error messages:

-------
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'),id::text from (select k.id, k.the_geom, k.alk, k.area, k.fl_tlw, k.fl_pot, k.stand, k.kontrolle, k.aktz, k.info, k.ktermin, k.name_vorh, k.name_gene, k.name_eige, k.vorn_eige, k.name_nutz, k.vorn_nutz, k.nutz_a, k.nutz_b, k.nutz_c, k.massnahme, k.kategorie, k.massinfo from v_webkoman3 as k)as foo WHERE the_geom && setSRID('BOX3D(3478900 6080400,3479700 6081200)'::BOX3D, -1 )' 

Postgresql reports the error 'ERROR: Unable to identify an operator '&&' for types 'geometry' and 'box3d' You will have to retype this query using an explicit cast '

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 uniq in /var/www/vhosts/webkoman/maplab-2.0rc2/projects/gmf_apps/wkm/wkm.php on line 254

Fatal error: Call to a member function on a non-object in /var/www/vhosts/webkoman/maplab-2.0rc2/projects/gmf_apps/wkm/wkm.php on line 258
-------

In wkm.php the lines are as follows:
254:
$imgMainMap = $oMapSession->oMap->draw();

258:
$urlMainMap = $imgMainMap->saveWebImage(IMAGE_TYPE, 0, 0, -1);


Do you know what could be the problem?

Best regards,

Hendrik