<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>I have just installed Mapscript 4.3 at
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://maptools.org/php_mapscript/index.phtml?page=downloads.html">http://maptools.org/php_mapscript/index.phtml?page=downloads.html</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and I have installed Postgres 8.0.0beta1 and
Postgis 0.8.2 under a Win32 platform</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I try to run my application that works under
linux platform I get a strange error:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>**************************************</FONT></DIV>
<DIV><FONT face=Arial size=2><b>Warning</b>: [MapServer
Error]: msDrawMap(): Failed to draw layer named 'lyr_40'.<BR> in
<b>c:\programmi\apache group\apache\htdocs\crs\gisKernel.map</b> on
line <b>441</b><br /><BR><br
/><BR><b>Warning</b>: [MapServer Error]: prep_DB(): Couldnt
recover from a bad query: <BR>'DECLARE mycursor BINARY CURSOR FOR SELECT
type::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
(SELECT the_geom,gid,type,name,poi_id from edtlyr_40_1 WHERE site_id = 1) as foo
WHERE the_geom && setSRID('BOX3D(1405925.84354588
5001310.327485,1406917.73083212 5002055.106963)'::BOX3D, -1 )'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> in <b>c:\programmi\apache
group\apache\htdocs\crs\gisKernel.map</b> on line
<b>441</b><br /></FONT></DIV>
<DIV><FONT face=Arial
size=2>****************************************</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1) I think that this depends from 2 different
postgis version. What version of postgis is compiled with the last mapscript
version?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2) I noticed that the last version of postgis has a
different geometry_columns table. How can I migrate with a pg_dump to a 0.8.2
version?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>RedS</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></FONT></DIV></BODY></HTML>