[Geomoose-users] Strange PHP error on Query

Tue May 3 17:26:43 EDT 2011

Don't think that's it it's still not working. I think it is the queryByRect
function itself.

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

> Oh, Doh, yeah, MapServer cannot automatically pick up the extent of a
> PostGIS layer.  You need to specify it manually...
>
> LAYER
>  ... stuff ...
>  EXTENT minx,miny,maxx,maxy
>  ... stuff ...
> END
>
> ------------------------------
> *From:* Stephen Knox <stephenknox73 at gmail.com>
> *To:* Dan Little <danlittle at yahoo.com>
> *Cc:* "geomoose-users at lists.sourceforge.net" <
> geomoose-users at lists.sourceforge.net>
> *Sent:* Tuesday, May 3, 2011 2:25 PM
>
> *Subject:* Re: [Geomoose-users] Strange PHP error on Query
>
>  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/6aa3b460/attachment.html