[Mapserver-users] Strange PostGIS/MapServer behaviour
Alexander Pucher
pucher at atlas.gis.univie.ac.at
Tue Mar 25 05:14:30 EST 2003
This is a multi-part message in MIME format.
--------------000505080204000405020303
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Hi,
I'm using MapServer 3.6 along with PostGIS 0.7.3.
When working on my application code, from time to time I get the
following error:
---
*Warning*: MapServer Error in prep_DB(): Error executing POSTGIS DECLARE
(the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
myclass::text,asbinary(force_collection(force_2d()),'XDR'),OID::text
from WHERE && setSRID('BOX3D(93965 204396.645,705057
585565.355)'::BOX3D, 31297 )'
Postgresql reports the error 'ERROR: parser: parse error at or near "" '
---
I have tracked it down to the case that it happens when I move the line
'dl('php_mapscript_36.so');' to another place, but still it remains
before the '$map = ms_newMapObj($cfg_map_file);' line in the code!!
The strange thing about this is that the app doesn't work anymore, even
if I undo all the changes until the initial state. I have to get the
file from the backup to make it work again ?!?
I have tried to execute the PostGIS query manually and it works, so this
shouldn't be the problem:
select the_geom from
(select bez_p.the_geom,bez_p.oid,temp_20030325103702.value,
case when temp_20030325103702.value > 0.1 then 1
when temp_20030325103702.value between 0.05 and 0.1 then 2
when temp_20030325103702.value between 0 and 0.05 then 3
when temp_20030325103702.value between -0.05 and 0 then 4
else 5
end as myclass from bez_p,temp_20030325103702
where bez_p.bezirk_id = temp_20030325103702.id)
as foo using SRID=31297
Any suggestions?
alex
--
________________________________________________________
Institut fuer Geographie und Regionalforschung
Universitaet Wien
Kartografie und Geoinformation
Departement of Geography and Regional Research
University of Vienna
Cartography and GIS
Universitaetstr. 7, A-1010 Wien, AUSTRIA
Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: alexander.pucher at univie.ac.at
FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
--------------------------------------------------------
Virtual Map Forum: http://www.gis.univie.ac.at/vmf
--------------------------------------------------------
An eye for an eye, and soon the whole world is blind -- Mahatma Gandhi
--------------000505080204000405020303
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
Hi,<br>
<br>
I'm using MapServer 3.6 along with PostGIS 0.7.3. <br>
When working on my application code, from time to time I get the
following error:<br>
<br>
---<br>
<br>
<b>Warning</b>: MapServer Error in prep_DB(): Error executing POSTGIS
DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR
FOR SELECT
<a class="moz-txt-link-freetext" href="myclass::text,asbinary(force_collection(force_2d(">myclass::text,asbinary(force_collection(force_2d(</a>)),'XDR'),<a class="moz-txt-link-freetext" href="OID::text">OID::text</a>
from WHERE && setSRID('BOX3D(93965 204396.645,705057
585565.355)'::BOX3D, 31297 )' <br>
<br>
Postgresql reports the error 'ERROR: parser: parse error at or near
"" '<br>
<br>
---<br>
<br>
I have tracked it down to the case that it happens when I move the line
'dl('php_mapscript_36.so');' to another place, but still it remains
before the '$map = ms_newMapObj($cfg_map_file);' line in the code!!<br>
The strange thing about this is that the app doesn't work anymore, even
if I undo all the changes until the initial state. I have to get the
file from the backup to make it work again ?!?<br>
I have tried to execute the PostGIS query manually and it works, so
this shouldn't be the problem:<br>
<br>
select the_geom from <br>
(select bez_p.the_geom,bez_p.oid,temp_20030325103702.value,<br>
case when temp_20030325103702.value > 0.1 then 1 <br>
when temp_20030325103702.value between 0.05 and 0.1 then 2 <br>
when temp_20030325103702.value between 0 and 0.05 then 3 <br>
when temp_20030325103702.value between -0.05 and 0 then 4 <br>
else 5 <br>
end as myclass from bez_p,temp_20030325103702 <br>
where bez_p.bezirk_id = temp_20030325103702.id) <br>
as foo using SRID=31297<br>
<br>
Any suggestions?<br>
<br>
alex<br>
<pre class="moz-signature" cols="72">--
________________________________________________________
Institut fuer Geographie und Regionalforschung
Universitaet Wien
Kartografie und Geoinformation
Departement of Geography and Regional Research
University of Vienna
Cartography and GIS
Universitaetstr. 7, A-1010 Wien, AUSTRIA
Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: <a class="moz-txt-link-abbreviated" href="mailto:alexander.pucher at univie.ac.at">alexander.pucher at univie.ac.at</a>
FTP: <a class="moz-txt-link-freetext" href="ftp://ftp.gis.univie.ac.at">ftp://ftp.gis.univie.ac.at</a>
WWW: <a class="moz-txt-link-freetext" href="http://www.gis.univie.ac.at/karto">http://www.gis.univie.ac.at/karto</a>
--------------------------------------------------------
Virtual Map Forum: <a class="moz-txt-link-freetext" href="http://www.gis.univie.ac.at/vmf">http://www.gis.univie.ac.at/vmf</a>
--------------------------------------------------------
An eye for an eye, and soon the whole world is blind -- Mahatma Gandhi
</pre>
</body>
</html>
--------------000505080204000405020303--
More information about the mapserver-users
mailing list