Re: [pmapper-users] search.xml with postgis - invalidJSON in pmapper v4.2.0
Dear Suman,
I just had a quick view of you code and I think you should make the name
lower case; and refer to this hint:
:HINT: No function matches the given name and argument types. You might
need
to add explicit type casts.
Please have a look at: http://svn.pmapper.net/trac/wiki/DocManualsearch
Cheers,
Serge
On Sun, Mar 3, 2013 at 5:17 PM, Suman ant_...@yahoo.com wrote:
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-8pgsql://postgres:postgres@localhost:5432/gisdb/dsn
sqlSELECT 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 712br /
br /
Warning: pg_numrows() expects parameter 1 to be resource, boolean given in
C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 716br /
{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
--
Serge
--
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
Re: [pmapper-users] search.xml with postgis - invalidJSON
thanx for help.. sorry it was silly mistake. i typed wrong spelling of option. thanx again for your help. Best Regards, Suman -- View this message in context: http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-tp2790207p4025082.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
Re: [pmapper-users] search.xml with postgis - invalidJSON
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-8pgsql://postgres:postgres@localhost:5432/gisdb/dsn
sqlSELECT 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
i tried all above given suggestions but i cant solve this problem.. plz help
me..
--
View this message in context:
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-tp2790207p4025076.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
Re: [pmapper-users] search.xml with postgis - invalidJSON
this is related to old code in query/squery.php using deprecated Postgis
functions. This was working with Postgis up to version 1.5.x, but not
any more with v2.x where the deprecated functions have been removed.
p.mapper 4.3 should have this fixed thanks to Thomas Raffin. In your
case you need to edit the file
incphp/query/squery.php
and change inside function dumpPGQueryResults xmin to ST_xmin and so
forth. So it should look like
$query = SELECT $unique_field,
ST_xmin(box3d($geom)),
ST_ymin(box3d($geom)),
ST_xmax(box3d($geom)),
ST_ymax(box3d($geom)),
$select
FROM $dbtable
WHERE $queryStr
LIMIT $searchlimit;
The changeset
http://svn.pmapper.net/trac/changeset/1272
lists all parts of the code where this was updated.
In principal it should also just be fine replacing the whole squery.php
with the one of p.mapper 4.3
Armin
On 03/03/2013 11:13 AM, Suman wrote:
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-8pgsql://postgres:postgres@localhost:5432/gisdb/dsn
sqlSELECT 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
i tried all above given suggestions but i cant solve this problem.. plz help
me..
--
View this message in context:
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-tp2790207p4025076.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
--
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
Re: [pmapper-users] search.xml with postgis - invalidJSON
sorry for the delayed response. I tried the two suggested solutions and entering: $ searchJson = str_replace (\ \ ' ', $ searchJson) in x_search.php I will return the correct JSON string. ... Vito d 'Asio, Vito d' Asio. I also solved the problem of the INCLUDE, it was a trivial problem. the file name of the tag IMAGE of reference map contained a point to a typing error. But among the various includes I found it hard to detect. Oddly enough log files of mapserver and pmapper this was not detected. Armin, Thomas Thank you for your help -- View this message in context: http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31394401.html Sent from the pmapper users mailing list archive at Nabble.com. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Hi, Since jQuery 1.4.2 I had to change in incphp/x_ajax/x_search.php the JSON string returned (just before echo): $searchJson = str_replace(\\', ', $searchJson); I have the options_array2json function with addslashes. I think it is the only change I made concerning this issue (simple quotes). Thomas Le 10/04/2011 23:27, Armin Burger a écrit : On 08/04/2011 09:18, moka61 wrote: Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made only in the second part of the key JSON. for p.mapper 4.1 try the following: in incphp/query/search.php-options_array2json() replace line 855 $json .= $sep \ . $k . \: . \. addslashes($v) . \; with $json .= $sep \ . $k . \: . \. $v . \; and see if it solves the problem. I have not found any negative side-effects so far for this workaround. But I guess there should be a clean way to escape reserved JSON characters for both the key and the value of the options (it's not very likely that e.g. fields in shapefiles contain backslashes or double quotes, but who knows) armin -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
On 08/04/2011 09:18, moka61 wrote: Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made only in the second part of the key JSON. for p.mapper 4.1 try the following: in incphp/query/search.php-options_array2json() replace line 855 $json .= $sep \ . $k . \: . \. addslashes($v) . \; with $json .= $sep \ . $k . \: . \. $v . \; and see if it solves the problem. I have not found any negative side-effects so far for this workaround. But I guess there should be a clean way to escape reserved JSON characters for both the key and the value of the options (it's not very likely that e.g. fields in shapefiles contain backslashes or double quotes, but who knows) armin -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made only in the second part of the key JSON. yet information.. I noticed that from version 4.10 if I use the INCLUDE tag in the map file print and export module do not run. In version 4.0 everything worked properly. With the ICLUDE tag is easy to manage and clustering multiple map files. thanks again for the help -- View this message in context: http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31349281.html Sent from the pmapper users mailing list archive at Nabble.com. -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Hi, Concerning the INCLUDE tag in mapfiles, with mapserver 5.4 or 5.6, everything is OK. Thomas. Le 08/04/2011 09:18, moka61 a écrit : Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made only in the second part of the key JSON. yet information.. I noticed that from version 4.10 if I use the INCLUDE tag in the map file print and export module do not run. In version 4.0 everything worked properly. With the ICLUDE tag is easy to manage and clustering multiple map files. thanks again for the help -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Hi mrs. Raffin I am using version 5.6 of Mapserver. With version 4.0 of pmapper using INCLUDE in the mapfile export and print module work. But in version 4.1.0 and 4.1.1 work only if your mapfile is unique and not use INCLUDE tags. example: main map file that call other mapfiles INCLUDE '/home/mapfile/main.map' INCLUDE '/home/mapfile/web.map' INCLUDE '/home/mapfile/reference.map' INCLUDE '/home/sit/mapfile/matrici/suolo/moland.map' INCLUDE '/home/mapfile/endmap.map' is convenient and modular to enable various layers in this way... -- View this message in context: http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31349633.html Sent from the pmapper users mailing list archive at Nabble.com. -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Daniele I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 . Maybe it is a side-effect of another issue. p.mapper uses the standard way of Mapscript for opening a map file, and I don't see any difference between recent versions. I'll check that. When you say it does not work in export and print, does it mean it works for all the other mapping actions? armin On 08/04/2011 10:21, moka61 wrote: Hi mrs. Raffin I am using version 5.6 of Mapserver. With version 4.0 of pmapper using INCLUDE in the mapfile export and print module work. But in version 4.1.0 and 4.1.1 work only if your mapfile is unique and not use INCLUDE tags. example: main map file that call other mapfiles INCLUDE '/home/mapfile/main.map' INCLUDE '/home/mapfile/web.map' INCLUDE '/home/mapfile/reference.map' INCLUDE '/home/sit/mapfile/matrici/suolo/moland.map' INCLUDE '/home/mapfile/endmap.map' is convenient and modular to enable various layers in this way... -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
On 08/04/2011 09:18, moka61 wrote: Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made only in the second part of the key JSON. I know, the problem is that the JSON values afterwards are used by Javascript and there might be an escaping necessary, but the escape backslash has to be escaped itself for correct JSON syntax. I don't know any more why the escaping was just set for the value and not the key of the options pair. I need to make some testing with datasets that have apostrophes... armin -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 . Maybe it is a side-effect of another issue. p.mapper uses the standard way of Mapscript for opening a map file, and I don't see any difference between recent versions. I'll check that. ok, I re-check system. When you say it does not work in export and print, does it mean it works for all the other mapping actions? Yes .Mapping system is working well .Only print and export generate blank html pages whit INCLUDE map file. Thank you for help -- View this message in context: http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31349806.html Sent from the pmapper users mailing list archive at Nabble.com. -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Have you got errors in the php log file? Maybe there could be acces rights errors (/home/sit/mapfile and /home/mapfile). Le 08/04/2011 10:46, moka61 a écrit : I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 . Maybe it is a side-effect of another issue. p.mapper uses the standard way of Mapscript for opening a map file, and I don't see any difference between recent versions. I'll check that. ok, I re-check system. When you say it does not work in export and print, does it mean it works for all the other mapping actions? Yes .Mapping system is working well .Only print and export generate blank html pages whit INCLUDE map file. Thank you for help -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Have you got errors in the php log file? No. php log is the same as the previous post. I rediect here all errors Maybe there could be acces rights errors (/home/sit/mapfile and /home/mapfile). access rights seem to me correct. but I'll do other attempts bye -- View this message in context: http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31350248.html Sent from the pmapper users mailing list archive at Nabble.com. -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search.xml with postgis - invalidJSON
Daniele
I guess it's related to an insufficient escaped apostrophe (could eg. be
the VITO D'ASIO). There were changes in v 4.1 and it especially now
uses a newer version of jQuery which expects syntactically correct JSON.
I'll have a look at it and will try to add a patch soon. Please send me
also via private mail the full JSON string that is reported as invalid.
Regards
Armin
On 07/04/2011 15:06, moka61 wrote:
Hi folks
I downloaded 4.1.1 version stable for an update to the previous.
When I run a query on a PostGIS table I can not display the dropbox.
This is my inline search.xml
--
searchlist version=1.0
dataroot$/dataroot
searchitem name=com description=Capoluoghi
layer type=postgis name=capoluoghi
field type=s name=nome description=capoluoghi
wildcard=2
definition type=options connectiontype=db
sort=asc
dsn
encoding=UTF-8pgsql://user:pass@localhost/base/dsn
sqlSELECT DISTINCT nome, nome FROM
base.centroidi_comune WHERE nome
IS NOT NULL ORDER BY nome/sql
/definition
/field
/layer
/searchitem
/searchlist
---
When view pmapper log I have this result
[07-Apr-2011 14:45:29] P.MAPPER debug info
search.php-getOptionsFromDb()-json
{ ANDREIS:ANDREIS, ARBA:ARBA, . VITO D'ASIO:VITO
D\'ASIO, ZOPPOLA:ZOPPOLA}
[07-Apr-2011 14:53:47] P.MAPPER debug info
XML-//definition
SimpleXMLElement Object
(
[@attributes] = Array
(
[type] = options
[connectiontype] = db
[sort] = asc
)
[dsn] = pgsql://user:paswd@localhost/base
[sql] = SELECT DISTINCT nome, nome FROM base.centroidi_comune WHERE
nome IS NOT NULL ORDER BY nome
)
sems fair...
but in firebug i notice this: invalid JSON
Invalid JSON: {searchJson:{searchitem: com, fields: [{description:
capoluoghi, fldname: nome, fldsize: false, fldsizedesc: false,
fldinline: false, definition: {type:options, selectname:nome,
firstoption:*, size: 0, events:false, options: {
ANDREIS:ANDREIS,
. }}}]}, action:searchitem, divelem:2}
in the previous version 4.0 everything was working properly.
I also noticed that the print and download the map if it is not possible if
the map file using INCLUDE tag with other map file.
Thanks in advance
Daniele
--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
