Hi Chris, Thanks for your quick response. I was reading some comments online which seemed to suggest that omitting these parameters would result in the query returning all available columns but will give it a go.
Kind regards, Pete On Mon, 2011-10-31 at 19:00 +0000, Chris Jackson wrote: > Pete > No expert on this, but did notice all of your result lines in the > layer definitions were hashed out - think you need these enabled for > querying to work. > Chris > > > On 31 Oct 2011 16:15, "Peter Wells" <wel...@faunalia.co.uk> wrote: > > Hi All, > > I'm having some issues with using the above functions and was > wondering > if anyone could help. > > When I use the Identify tool on my layer of interest, I see > the > following in the apache error log: > > [Mon Oct 31 15:54:01 2011] [error] [client 0.0.0.0] PHP > Notice: Trying > to get property of non-object > in /var/www/pmapper/example/pmapper-4.0/incphp/query/squery.php on > line > 136, referer: http://webgis.example.org/pmapper-4.0/map.phtml? > [Mon Oct 31 15:54:01 2011] [error] [client 0.0.0.0] PHP > Notice: Trying > to get property of non-object > in /var/www/pmapper/example/pmapper-4.0/incphp/query/squery.php on > line > 137, referer: http://webgis.example.org/pmapper-4.0/map.phtml? > [Mon Oct 31 15:54:01 2011] [error] [client 0.0.0.0] PHP > Notice: Trying > to get property of non-object > in /var/www/pmapper/example/pmapper-4.0/incphp/query/squery.php on > line > 141, referer: http://webgis.example.org/pmapper-4.0/map.phtml? > [Mon Oct 31 15:54:01 2011] [error] [client 0.0.0.0] PHP Fatal > error: > Call to a member function project() on a non-object > in /var/www/pmapper/example/pmapper-4.0/incphp/query/squery.php on > line > 162, referer: http://webgis.example.org/pmapper-4.0/map.phtml? > > >From looking at the code above, it seems that > $this->qLayer->getShape($qRes->tileindex,$qRes->shapeindex); > is not > returning anything in dumpQueryResults() in qsuery.php but I'm > not sure > why. > > ... and the p.mapper front-end just shows the rotating > 'waiting' symbol > indefinitely. > > My map is in world mercator projection (EPSG:3395) and the > layer > configuration (the one that I'm trying to query) looks like > this: > > LAYER > NAME 'involved_villages_one' > group 'involved_villages' > TYPE point > EXTENT 380000 136000 1360000 1460000 > CONNECTIONTYPE postgis > CONNECTION 'dbname=rfuk host=127.0.0.1 port=5432 > user=mapserver > password=mypassword' > DATA 'the_geom FROM (select the_geom, gid, name from > one_legacy_s3_final_atts_to_be_populated.v__merged_point) as > subquery > USING UNIQUE gid USING srid=32632' > LABELITEM "name" > LABELMAXSCALE 5000000 > TOLERANCE 10 > TOLERANCEUNITS pixels > TEMPLATE void > METADATA > 'DESCRIPTION' 'Villages involved' > 'ows_title' 'iv_one' > #"RESULT_FIELDS" "name" > #"RESULT_HEADERS" "name" > # "RESULT_HYPERLINK" "name" > "LAYER_ENCODING" "UTF-8" > END > PROJECTION > "init=epsg:32632" > END > OPACITY ALPHA # Required for transparency > #MAXSCALE 3200000 > CLASS > NAME 'All villages involved' > STYLE > SYMBOL "rfuk_iv10o" > COLOR 0 0 0 # This color is required but ignored > OUTLINECOLOR 82 80 82 > END > LABEL > POSITION Auto > COLOR 0 0 150 > BACKGROUNDCOLOR 255 255 128 > BACKGROUNDSHADOWCOLOR 150 150 150 > BACKGROUNDSHADOWSIZE 2 2 > BUFFER 2 > TYPE truetype > ENCODING "UTF-8" > FONT FreeSans > SIZE 8 > MAXSIZE 9 > #SIZE small > END #Label > END # Class > END > LAYER > NAME 'involved_villages_two' > group 'involved_villages' > TYPE point > EXTENT 420000 200000 1920000 1260000 > CONNECTIONTYPE postgis > CONNECTION 'dbname=rfuk host=127.0.0.1 port=5432 > user=mapserver > password=mypassword' > DATA 'the_geom FROM (select the_geom, gid, name from > two_legacy_s3_final_atts_to_be_populated.v__merged_point) as > subquery > USING UNIQUE gid USING srid=32633' > LABELITEM "name" > LABELMAXSCALE 5000000 > TOLERANCE 10 > TOLERANCEUNITS pixels > TEMPLATE void > METADATA > 'DESCRIPTION' 'Villages involved' > 'ows_title' 'iv_two' > #"RESULT_FIELDS" "name" > #"RESULT_HEADERS" "name" > # "RESULT_HYPERLINK" "name" > "LAYER_ENCODING" "UTF-8" > END > PROJECTION > "init=epsg:32633" > END > OPACITY ALPHA # Required for transparency > #MAXSCALE 3200000 > CLASS > NAME '' > STYLE > SYMBOL "rfuk_iv10o" > COLOR 0 0 0 # This color is required but ignored > OUTLINECOLOR 82 80 82 > END > LABEL > POSITION Auto > COLOR 0 0 150 > BACKGROUNDCOLOR 255 255 128 > BACKGROUNDSHADOWCOLOR 150 150 150 > BACKGROUNDSHADOWSIZE 2 2 > BUFFER 2 > TYPE truetype > ENCODING "UTF-8" > FONT FreeSans > SIZE 8 > MAXSIZE 9 > #SIZE small > END #Label > END # Class > END > > I've been banging my head against the computer all day and > would very > much appreciate any suggestions anyone might have. > > > > > Kind regards, > > Pete > > > > Peter Wells > > Faunalia UK > 23 Chestnut Close, Burgess Hill, RH15 8HN > www.faunalia.co.uk > Tel: +44 (0)1444 848012 > Mob: +44 (0)7704 781683 > SIP: 1507...@sipgate.co.uk > > ------------------------------------------------------------------------------ > Get your Android app more play: Bring it to the BlackBerry > PlayBook > in minutes. BlackBerry App World™ now supports > Android™ Apps > for the BlackBerry® PlayBook™. Discover just how easy > and simple > it is! http://p.sf.net/sfu/android-dev2dev > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users Kind regards, Pete Peter Wells Faunalia UK 23 Chestnut Close, Burgess Hill, RH15 8HN www.faunalia.co.uk Tel: +44 (0)1444 848012 Mob: +44 (0)7704 781683 SIP: 1507...@sipgate.co.uk ------------------------------------------------------------------------------ Get your Android app more play: Bring it to the BlackBerry PlayBook in minutes. BlackBerry App World™ now supports Android™ Apps for the BlackBerry® PlayBook™. Discover just how easy and simple it is! http://p.sf.net/sfu/android-dev2dev _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
