Which version of PostGIS are you using? There is a bug in PostGIS
1.3.1 and SVN that was fixed a few days ago that affects Leopard.
PostGIS had a function with a commonly used name, and this function
was added to the Leopard libSystem. This gets used in PostGIS instead
of its own, causing Postgres to crash.
Either install PostGIS from the latest SVN, or install my latest
PostGIS if you are using my binaries.
If that's not the problem, try looking in the console and system logs,
as well as the Apache logs. A library problem may just appear as an
unidentified error at the PHP level, and digging into system logs may
be needed to identify the problem.
On Dec 1, 2007, at 1:52 PM, Fawcett, David wrote:
I am testing out a new install of PostGIS and MapServer on OS X
Leopard. I built a map file to display a simple ten point layer
coming from PostGIS.
I get the following error:
msDrawMap(): Image handling error. Failed to draw layer named
'basemap'. prepare_database(): Query error. Couldnt recover from a
bad query: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),the_geom::text
from ten_points_layer WHERE the_geom && setSRID('BOX3D(146545.5
4814000,804891.5 5472346)'::BOX3D,
find_srid('','ten_points_layer','the_geom') )'
Here is the layer definition:
LAYER
NAME basemap
STATUS DEFAULT
TYPE POLYGON
CONNECTIONTYPE POSTGIS
CONNECTION "host=localhost dbname=mydb user=myuser
password=mypass port=5432"
DATA "the_geom FROM ten_points_layer using unique the_geom"
CLASS
COLOR 255 255 255
OUTLINECOLOR 181 181 181 #An OUTLINECOLOR with no COLOR
gives same effect as old POLYLINE
END
PROJECTION
"init=epsg:26915"
END
END
Any ideas? I am also having trouble getting QGIS to display the
layer.
Thanks,
David.
-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/
"Time is an illusion - lunchtime doubly so."
- Ford Prefect
