[pmapper-users] search.xml with postgis - invalidJSON

[moka61]

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
--

$




pgsql://user:pass@localhost/base
SELECT DISTINCT nome, nome FROM 
base.centroidi_comune WHERE nome
IS NOT NULL ORDER BY nome 
 
 



---
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

-- 
View this message in context: 
http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31342230.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

[Armin Burger]

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
> --
> 
>  $
>   
>   
>wildcard="2">
>sort="asc">
>encoding="UTF-8">pgsql://user:pass@localhost/base
>   SELECT DISTINCT nome, nome FROM 
> base.centroidi_comune WHERE nome
> IS NOT NULL ORDER BY nome
>   
>   
>   
>  
>  
> ---
> 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

Re: [pmapper-users] search.xml with postgis - invalidJSON

[moka61]

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

[Thomas RAFFIN]

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

[moka61]

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

[Armin Burger]

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

[Armin Burger]

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

[moka61]

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

[Thomas RAFFIN]

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

[moka61]

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

[Armin Burger]

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

[Thomas RAFFIN]

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

[moka61]

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

[Suman]

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 
--
 

$





pgsql://postgres:postgres@localhost:5432/gisdb
SELECT DISTINCT name FROM 
public.tbl_utility WHERE name ~*
'^[search]' ORDER BY name

 



---
 

and i found in chrome console invalid JSON

Invalid JSON: 
*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*

*Warning*:  pg_numrows() expects parameter 1 to be resource, boolean given
in *C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php* on line *716*
{"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

[Armin Burger]

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
> --
> 
>  $
>
>  
>  
>  
>   minlength="1" startleft="1" sort="asc" dependfld="gid">
>   encoding="UTF-8">pgsql://postgres:postgres@localhost:5432/gisdb
>   SELECT DISTINCT name FROM 
> public.tbl_utility WHERE name ~*
> '^[search]' ORDER BY name
>   
>  
>  
>  
>  
> ---
>
> and i found in chrome console invalid JSON
>
> Invalid JSON: 
> *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*
> 
> *Warning*:  pg_numrows() expects parameter 1 to be resource, boolean given
> in *C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php* on line *716* />
> {"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

[Suman]

Thank you for the quick response. 

Now works fine for type Suggest but for type option it dose not work. 


This is my inline search.xml 
--
 




pgsql://postgres:postgres@localhost:5432/template_postgis_20
SELECT DISTINCT name FROM 
public.tbl_utility WHERE name ~*
'^[search]' ORDER BY name

 







pgsql://postgres:postgres@localhost:5432/template_postgis_20
SELECT DISTINCT ward_no 
FROM public.tbl_ward1 WHERE ward_no IS
NOT NULL ORDER BY ward_no

 


--
 

in ms_error.txt file i saw this log

[Sun Mar 03 17:02:18 2013].56000 getSymbol(): Symbol definition error.
Parsing error near (gid):(line 525)
[Sun Mar 03 17:02:18 2013].56000 msDrawMap(): rendering using outputformat
named png8 (AGG/PNG8).

and also i found in chrome console invalid JSON 

SyntaxError
get stack: function () { [native code] }
arguments: null
caller: null
length: 0
name: ""
prototype: Object
__proto__: function Empty() {}

message: "Unexpected token }"
set stack: function () { [native code] }
arguments: null
caller: null
length: 1
name: ""
prototype: Object
__proto__: function Empty() {}

__proto__: Error
constructor: function SyntaxError() { [native code] }
name: "SyntaxError"
stack: undefined
__proto__: d

thanx a lot again..

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-tp2790207p4025079.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

[Suman]

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

[pmapper-users] search.xml with postgis - invalidJSON in pmapper v4.2.0

[Suman]

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 
--
 

$





pgsql://postgres:postgres@localhost:5432/gisdb
SELECT DISTINCT name
FROM public.tbl_utility WHERE name ~* '^[search]' ORDER BY name

  



---
 

and i found in chrome console invalid JSON 

Invalid JSON: 
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

Warning:  pg_numrows() expects parameter 1 to be resource, boolean given in
C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 716
{"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

  
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

Re: [pmapper-users] search.xml with postgis - invalidJSON in pmapper v4.2.0

[Serge Claudio Rafanoharana]

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  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
>
> --
> 
> $
>
> 
> 
> 
>  minlength="1" startleft="1" sort="asc" dependfld="gid">
>  encoding="UTF-8">pgsql://postgres:postgres@localhost:5432/gisdb
> SELECT DISTINCT name
> FROM public.tbl_utility WHERE name ~* '^[search]' ORDER BY name
> 
> 
> 
> 
> 
>
> ---
>
> and i found in chrome console invalid JSON
>
> Invalid JSON: 
> 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
> 
> Warning:  pg_numrows() expects parameter 1 to be resource, boolean given in
> C:\ms4w\apps\newbrt\biratnagar\incphp\query\squery.php on line 716
> {"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 in pmapper v4.2.0

[Suman]

thanx for your reply but i have got the solution.. it was from armin. 

http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-search-xml-with-postgis-invalidJSON-td2790207.html

  

thanx for your support.

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-tp4025077p4025081.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