Hi all Pmapper User
I am using ms4w v3.0.6. , mapserver v6.0.3, PHP v5.4.3. and pmapper 4.2.0.
When I run a query on a PostGIS table I can see suggestions but when i click
them no any response.
This is my inline search.xml
--------------------------------------------------------------------------------------------------
<searchlist version="1.0">
<dataroot>$</dataroot>
<searchitem name="Utility_and_services" description="Utility and
services suggest">
<layer type="postgis" name="Utility_and_services">
<field type="s" name="name" description="Utility and
services suggest" wildcard="2">
<definition type="suggest" connectiontype="db"
minlength="1" startleft="1" sort="asc" dependfld="gid">
<dsn
encoding="UTF-8">pgsql://postgres:postgres@localhost:5432/gisdb</dsn>
<sql>SELECT DISTINCT name
FROM public.tbl_utility WHERE name ~* '^[search]' ORDER BY name</sql>
</definition>
</field>
</layer>
</searchitem>
</searchlist>
---------------------------------------------------------------------------------------------------
and i found in chrome console invalid JSON
Invalid JSON: <br />
Warning: pg_query(): Query failed: ERROR: function xmin(box3d) does not
exist
LINE 2: xmin(box3d(geom)),
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts. in
C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 712<br />
<br />
Warning: pg_numrows() expects parameter 1 to be resource, boolean given in
C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 716<br />
{"mode":"search", "queryResult":0}
pm_cjs.js:38
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-td2790207.html#a4025076
<http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-td2790207.html#a4025076>
i tried all above given suggestions but i cant solve this problem.. plz help
me..
suman
--
View this message in context:
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/search-xml-with-postgis-invalidJSON-in-pmapper-v4-2-0-tp4025077.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive
at Nabble.com.
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
