Run shp2img from the command line to test your mapfile - the mapserver error 
messages will be easier to find at the command line.

Chris

Quoting Paul A Peters <papeters@fes.uwaterloo.ca>:

> All:
> 
> This email is to add further information regarding the email sent by Mike
> Leahy.
> 
> I have included a copy of the .map file we are using. I haven't been able to
> find a useful log file for MapServer, but I have attached the log file for
> the webserver (IIS). Again, I am able to access the database fine, and the
> .map file works well with a shapefile of the same point data, it is just
> getting it to connect via postgis that is our problem.
> 
> We are using Microsoft IIS on Windows XP with a MapServer 3.6.6-dev build
> and MapScript 3.6 built by DMSolutions last Friday. The interface is built
> using MapLab, again by DMSolutions. This also constructs all the php, etc...
> at the same time. It is of course possible that the problem may lie in here
> as well. I am relatively new at this so I am still floundering a bit with
> how the different components interact.
> 
> thanks,
> Paul
> 
> ----------------------.map file
> MAP
>   EXTENT 273346 8670666 281455 8677412
>   FONTSET "./Independencia/etc/fonts.txt"
>   IMAGECOLOR 255 255 255
>   IMAGEQUALITY 100
>   IMAGETYPE PNG
>   INTERLACE TRUE
>   SYMBOLSET "./Independencia/etc/symbols.sym"
>   SHAPEPATH "./Independencia"
>   SIZE 600 500
>   STATUS ON
>   TRANSPARENT FALSE
>   UNITS METERS
>   NAME "Independencia"
> 
>   LEGEND
>     IMAGECOLOR 204 204 255
>     INTERLACE TRUE
>     KEYSIZE 18 12
>     KEYSPACING 5 5
>     LABEL
>       SIZE MEDIUM
>       TYPE BITMAP
>       BUFFER 0
>       COLOR 0 0 89
>       FORCE FALSE
>       MINDISTANCE -1
>       MINFEATURESIZE -1
>       OFFSET 0 0
>       PARTIALS TRUE
>     END
>     OUTLINECOLOR 0 0 0
>     POSITION LL
>     STATUS ON
>     TRANSPARENT FALSE
>     TEMPLATE "c:/msapps/htdocs/mapedit/legend_template.html"
>   END
> 
>   QUERYMAP
>     COLOR 51 100 255
>     SIZE -1 -1
>     STATUS OFF
>     STYLE HILITE
>   END
> 
>   REFERENCE
>     COLOR -1 -1 -1
>     EXTENT 272051 8670801 282750 8677277
>     IMAGE "./vista.gif"
>     OUTLINECOLOR 255 0 0
>     SIZE 100 60
>     STATUS ON
>       MARKER 0
>       MARKERSIZE 0
>       MINBOXSIZE 3
>       MAXBOXSIZE 0
>   END
> 
>   SCALEBAR
>     BACKGROUNDCOLOR 204 204 204
>     COLOR 0 0 0
>     IMAGECOLOR 255 255 255
>     INTERLACE TRUE
>     INTERVALS 5
>     LABEL
>       SIZE MEDIUM
>       TYPE BITMAP
>       BUFFER 0
>       COLOR 0 0 0
>       FORCE FALSE
>       MINDISTANCE -1
>       MINFEATURESIZE -1
>       OFFSET 0 0
>       PARTIALS TRUE
>     END
>     OUTLINECOLOR 0 0 0
>     POSITION LL
>     SIZE 300 8
>     STATUS ON
>     STYLE 0
>     TRANSPARENT FALSE
>     UNITS KILOMETERS
>   END
> 
>   WEB
>     IMAGEPATH "c:/tmp/ms_tmp/"
>     IMAGEURL "/ms_tmp/"
>   END
> 
> 
>   LAYER
>     CONNECTIONTYPE postgis
>     CONNECTION "dbname=edumap"
>     DATA "shape FROM gis_test"
>     GROUP "Independencia"
>     NAME "Escuelas Primarias"
>     SIZEUNITS PIXELS
>     STATUS ON
>     TEMPLATE "ttt.html"
>     TOLERANCE 3
>     TOLERANCEUNITS PIXELS
>     TYPE POINT
>     UNITS METERS
>     CLASS
>       NAME "Escuelas"
>       COLOR 150 0 0
>       MAXSIZE 100
>       MINSIZE 1
>       SIZE 8
>       SYMBOL 2
>     END
>   END
> 
> END
> 
> -----------------------------------
> Last section of webserver log file:
> 
> 21:43:13 127.0.0.1 GET /msapps/htdocs/index.phtml 200
> 21:43:13 127.0.0.1 GET /msapps/htdocs/toolbar_maplab.phtml 200
> 21:43:13 127.0.0.1 GET /msapps/htdocs/toolbar.phtml 200
> 21:43:13 127.0.0.1 GET /msapps/htdocs/action.phtml 200
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_maplab_maplab.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_maplab_mapedit.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/appframeset.phtml 200
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_maplab_mapbrowser.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_maplab_gmapfactory.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_config_info.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_config_xml.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/icon_help.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/dmsglogo.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/maplab_mapedit.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/maplab_mapbrowser.gif 304
> 21:43:13 127.0.0.1 GET /msapps/htdocs/images/maplab_gmapfactory.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/Independencia.phtml 200
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_eye.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/a_pixel.gif 304
> 21:43:18 127.0.0.1 GET /ms_tmp/1053985398_0_0_20_10.png 200
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_redraw.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_pan_north.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_pan_west.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_pan_east.gif 304
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/images/icon_pan_south.gif 304
> 21:43:18 127.0.0.1 GET /ms_tmp/105398539831121.gif 200
> 21:43:18 127.0.0.1 GET /ms_tmp/105398539831122.gif 200
> 21:43:18 127.0.0.1 GET
> /msapps/projects/gmf_apps/Independencia/wrapper/drawmap.php 200
> 
> --------------------------------------
> The errors I am getting are:
> 
> ERROR:  parser: parse error at or near "WHERE"
> ERROR:  parser: parse error at or near "WHERE"
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> 
> 
> 
> 
> Paul A Peters
> http://www.fes.uwaterloo.ca/u/papeters
> 
> 
> 





