[postgis-users] Update to where clause errors

Mon May 26 15:07:05 PDT 2003

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030526/4017dcc9/attachment.html>