[Geomoose-users] Strange PHP error on Query

[Stephen Knox]

 The data definitely maps OK. I can see it both in GeoMoose as a normal
layer and in Mapserver. I can also see the calculated field with Identify.
The problems just seems to be filtering/querying it.

I wondered whether it's something to do with my version - I am using 2.4RC1
and I saw reference to bugs relating to certain functions in this release on
the mailing list. I am also using Mapserver 5.6.3 for Fedora 14.

The error seems to be coming in on the call to

$queryLayer->queryByRect($queryLayer->getExtent());

in query.php (around line 320)

It's nothing to do with the getExtent function, as I tried putting my own
values in there. I assume from the only related bug
<http://trac.osgeo.org/mapserver/ticket/3691>I could find that this the
error message indicates the layer can't be queried because it's already
open.

Does that help track this down at all?

Steve

On Tue, May 3, 2011 at 1:03 PM, Dan Little <danlittle at yahoo.com> wrote:

> I think the querying it's doing is looking for metadata.  Does this layer
> map okay?  The error you're seeing is essentially "Ack, I'm MapServer and I
> can't figure out what the hell is going on with this layer!"  Some easy
> stuff to try:
>
> 1) Ensure you can map the data.
> 2) Convert your inner query into a view and make sure there is a valid
> entry in geometry_columns for the view.
> 3) Curse aloud to others.
> 4) Repost to mailing list if none of the above works.
>
> ------------------------------
> *From:* Stephen Knox <stephenknox73 at gmail.com>
> *To:* geomoose-users at lists.sourceforge.net
> *Sent:* Monday, May 2, 2011 7:02 PM
> *Subject:* Re: [Geomoose-users] Strange PHP error on Query
>
> Excuse my inexperience but I have another query about getting query
> functionality to work in GeoMoose. It seems to be querying the database for
> a few seconds, then I get no Valid Response and the following error in PHP:
> httpd: mappostgis.c:1882: msPostGISLayerResultsGetShape: Assertion
> `layer->layerinfo != ((void *)0)' failed.
>
> I have the following section of mapbook:
>
>     <service name="search_oas">
>         <url>php/query.php</url>
>         <step type="input">
>
>             <input type="select" name="comparitor0" title="Percentage
> Travel by UG 2001">
>                 <option value="gt">Greater Than</option>
>                 <option value="eq">Equal To</option>
>                 <option value="lt">Less Than</option>
>             </input>
>             <input type="user" name="value0" title=""/>
>             <input type="hidden" name="highlight" value="true"/>
>             <input type="hidden" name="mode" value="search"/>
>
>             <input type="hidden" name="layer0" value="uglines/oas"/>
>             <input type="hidden" name="template0" value="itemquery"/>
>             <input type="hidden" name="zoom_to_first" value="false"/>
>             <input type="hidden" name="fieldname0" value="per_ttw_lu"/>
>         </step>
>     </service>
>
> and the layer definition below:
>
> LAYER
> CONNECTIONTYPE postgis
> NAME "oas"
> CONNECTION "user=postgres password=postgres dbname=lustations
> host=localhost"
> DATA "the_geom from (SELECT gid, the_geom, census_code,  ttw_by_lu,
> (ttw_by_lu::REAL/tot_pop::REAL)*100 as per_ttw_lu, tot_pop FROM oa_data) as
> foo using srid=27700 using unique gid"
> STATUS ON
> TYPE POLYGON
>
> METADATA
> identify_record "identify_oas.html"
> itemquery "oa_itemquery.html"
> END
>
> CLASS
>     STYLE
>         OUTLINECOLOR 0 0 0
>         #COLOR 216 250 138
>         WIDTH 1
>     END
> END
> END
>
> my oa_itemquery.html looks like this:
>
> <!-- MapServer Template -->
> <tr bgcolor="#DEE5EB"><td colspan="2"><b><u>Output Areas</u></b></tr>
> <tr>
> <td align="right"><b>Census Code:</b></td>
> <td>[census_code]</td>
> </tr>
> <tr>
> <td align="right"><b>Percentage travel by LU:</b></td>
> <td>[per_ttw_lu]</td>
> </tr>
> <tr>
> <td>&nbsp;</td>
> <td>&nbsp;</td>
> </tr>
>
>
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geomoose-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20110503/ca3b1fac/attachment.html