[maplab-users] Query map with PostGIS layer

[Mike Leahy]

All,

I have narrowed these problems down at least to the php_mapscript_40.dll.  I 
have the same problem with this DLL using an older version of 
PostGIS/PostgreSQL (compiled by someone else) - the only difference is I 
get "NOTICE" instead of "WARNING" messages with the query attributes table.

It all works fine when I go back to the php_mapscript_36.dll with the old 
PostGIS.  Of course, if I use the php_mapscript_36.dll, I can't use the up-to-
date public releases of PostgreSQL/PostGIS because I get the "Assertion 
Failed" problem when the query is performed.

I'm not sure if there's anything that can be done in this case, except maybe 
wait for another update to the MapScript - I don't suppose this problem has 
been identified/fixed in the Mapserver 4.1-dev package currently posted on the 
downloads site?

Kind regards,
Mike



Quoting Mike Leahy <mgleahy@fes.uwaterloo.ca>:

> Hello all,
> 
> I’ve just now been able to get maps working in MapLab, using PostGIS layers 
> (PostGIS 0.7.5 in PostgreSQL 7.3.4-2, built in cygwin on WinXP).  The maps 
> display fine, and if I do a point query, that also works fine.  However,
> there 
> are two problems that occur when I query multiple objects (i.e., with a box 
> query instead of a point).  First, and more important, is that the ROSA
> applet 
> doesn't seem to like waiting for the map image.  If I go directly to the 
> IMG_URL parameter for the Rosa applet, the image is there, and looks fine.  
> But the applet just gives me a white box, with the navigation controls
> visible.
> 
> Second, I get a series of warning messages in the query attributes, such as 
> the following:
> 
> WARNING: BEGIN: already a transaction in progress WARNING: Closing pre-
> existing portal "mycursor" WARNING: BEGIN: already a transaction in progress
> 
> WARNING: Closing pre-existing portal "mycursor" WARNING: BEGIN: already a 
> transaction in progress WARNING: Closing pre-existing portal "mycursor" 
> WARNING: etc...(I think there are two warnings for every row in the
> attributes 
> table).  
> 
> I can turn off warnings in PHP, but that’s already caused problems before
> when 
> I was getting errors that I couldn’t fix, when all I needed to see were the 
> warnings sent from PostGIS.
> 
> Any suggestions?
> Mike
> 
> ----------------------------------------
> This mail sent through www.mywaterloo.ca
> _______________________________________________
> Maplab-users mailing list
> Maplab-users@dmsolutions.ca
> http://lists.dmsolutions.ca/mailman/listinfo/maplab-users
> 




----------------------------------------
This mail sent through www.mywaterloo.ca