Hi, Have you tried to run the SQL queries from logfile directly? I wonder if for example this part is correct and finds any data:
WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry && setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 469022.416275488)'::BOX3D,28992) ) Just a guess, but perhaps odd table name makes some trouble. How about reneming or copying the table temporarily to something wiht more simple name, like "test"? -Jukka Rahkonen- DeDuikertjes wrote: Dear list, yesterday I reported problems with my WFS server. I could not fix that up till now. I have another possibly related problem. My WMS is set up allright, getcapabilities is ok, I can see the map, pan zoom, etc, no problems. When I do an Identify (GetFeatureInfo request), I get back an exception-report, with no items in (so essentially an ampty exception report). The query just doesn't seem to find the data. Clicking inside a feature and outside does differ (outside doesn't give an exception report). I've enabled debugging and this is the output when I do a GetFeatureInfo request: [Fri Jun 26 13:21:11 2009].498623 CGI Request 1 on process 1525 [Fri Jun 26 13:21:11 2009].518710 msPOSTGISLayerOpen called datastatement: tc_vlak_geometry from "NL.IMRO.0026.SVBBU-0001" using unique geoidn using srid=28992 [Fri Jun 26 13:21:11 2009].518735 MSPOSTGISLayerOpen -- shared connection not available. [Fri Jun 26 13:21:11 2009].523422 msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) [Fri Jun 26 13:21:11 2009].523453 msPOSTGISLayerFreeItemInfo called [Fri Jun 26 13:21:11 2009].523466 msPOSTGISLayerWhichShapes called [Fri Jun 26 13:21:11 2009].523490 msPOSTGISLayerParseData: unique column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, table_name="NL.IMRO.0026.SVBBU-0001" [Fri Jun 26 13:21:11 2009].523796 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from "NL.IMRO.0026.SVBBU-0001" WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry && setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 469022.416275488)'::BOX3D,28992) ) [Fri Jun 26 13:21:11 2009].535912 msPOSTGISLayerFreeItemInfo called [Fri Jun 26 13:21:11 2009].535925 msPOSTGISLayerClose datastatement: tc_vlak_geometry from "NL.IMRO.0026.SVBBU-0001" using unique geoidn using srid=28992 [Fri Jun 26 13:21:11 2009].535931 msPOSTGISLayerClose -- closing query_result [Fri Jun 26 13:21:11 2009].536007 msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) [Fri Jun 26 13:21:11 2009].536017 msConnPoolClose(host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) [Fri Jun 26 13:21:11 2009].538905 msPOSTGISLayerOpen called datastatement: tc_vlak_geometry from "NL.IMRO.0026.SVBBU-0001" using unique geoidn using srid=28992 [Fri Jun 26 13:21:11 2009].538914 MSPOSTGISLayerOpen -- shared connection not available. [Fri Jun 26 13:21:11 2009].543298 msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) [Fri Jun 26 13:21:11 2009].543314 msPOSTGISLayerFreeItemInfo called [Fri Jun 26 13:21:11 2009].543319 in msPOSTGISLayerGetItems (find column names) [Fri Jun 26 13:21:11 2009].543329 msPOSTGISLayerParseData: unique column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, table_name="NL.IMRO.0026.SVBBU-0001" [Fri Jun 26 13:21:11 2009].545217 msPOSTGISLayerInitItemInfo called [Fri Jun 26 13:21:11 2009].545230 msPOSTGISLayerGetShape called for record = 0 [Fri Jun 26 13:21:11 2009].545239 msPOSTGISLayerParseData: unique column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, table_name="NL.IMRO.0026.SVBBU-0001" [Fri Jun 26 13:21:11 2009].545253 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT "geoidn"::text,"idealisatie"::text,"tc_multi_geometry"::text,"tc_lijn_geometry"::text,"tc_punt_geometry"::text,asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR') from "NL.IMRO.0026.SVBBU-0001" WHERE geoidn = 0 [Fri Jun 26 13:21:11 2009].547105 msFreeMap(): freeing map at 0x943d518. [Fri Jun 26 13:21:11 2009].547114 msPOSTGISLayerClose datastatement: tc_vlak_geometry from "NL.IMRO.0026.SVBBU-0001" using unique geoidn using srid=28992 [Fri Jun 26 13:21:11 2009].547119 msPOSTGISLayerClose -- query_result is NULL [Fri Jun 26 13:21:11 2009].547124 msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) Just as with the WFS problem, there is no data returning. The WFS does show the exposed columns, never any data in. I've not a clue of how to proceed, or how to get extra debug info. Please help ! MArco [Fri Jun 26 13:21:11 2009].547132 msConnPoolClose(host=localhost user=tc_check dbname=80.101.100.35,0x9457b38) _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users