[postgis-users] WHERE clause errors with PostGIS/MapScript

[David Blasby]

Mike Leahy wrote:
> Hello all,
> 
> We've got MapServer 3.6.6-dev running with support for PostGIS and
> PHP/MapScript running.  We have some spatial data loaded into PostGIS,
> and so far it seems to be working okay.  However, when we use the
> PostGIS map layer in a PHP/MapScript interface created GMapFactory, we
> get a blank map and the following errors in Postmaster console:
> 
> ERROR:  parser: parse error at or near "WHERE"
> ERROR:  parser: parse error at or near "WHERE"
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> 
> We can't seem to find anything in any of the scripts or files included
> in this particular project that includes a "where" clause...does anybody
> else recognize this error, or have any suggestions?

The WHERE clause is put in automatically for you by the 
mapserver-postgis connector.  If you look in the error log for mapserver 
(probably the webserver's error log) you'll get more information about 
the error.

Give us that information and your mapfile and we should be able to 
figure it out.

dave