Error: SyntaxError: Unexpected end of JSON input

[MikiRosemberg]

No matter how many times i try, allways get the message "Error: SyntaxError: Unexpected end of JSON input"

I just want to show all de pins from a table with his coordinates but no luck until now.

Am i missing a step?, i just user the region plugin and the query in it. in then format "lat, lng, name, id"

[jeffreykemp]

To diagnose this you'll need to use the browser Network monitor. To do this in Chrome, open the page and press F12. Select the "Network" tab and then refresh the page.

Look for an entry called "wwv_flow.ajax". Copy-and-paste the contents of the Response here.

[MikiRosemberg]

I got tho lines with ww_flow.ajax The first contains the following

{"mapdata":[ {"error":"ORA-20000: Unable to convert data to lat\u002Flong \u0022-25.314914\u0022"}

and the second this:

1. {row: []}
   1. row: []

El mar., 16 de jun. de 2020 a la(s) 20:52, Jeffrey Kemp ( notifications@github.com) escribió:

To diagnose this you'll need to use the browser Network monitor. To do this in Chrome, open the page and press F12. Select the "Network" tab and then refresh the page.

Look for an entry called "wwv_flow.ajax". Copy-and-paste the contents of the Response here. [image: image] https://user-images.githubusercontent.com/15881471/84842476-ce7b3800-b077-11ea-814e-d2121ae6de01.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/jeffreykemp/jk64-plugin-reportmap/issues/116#issuecomment-645084061, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOCRUD4DUVVWPNIBRTTR6C3RXAHUFANCNFSM4N75MSRA .

-- Lic. Miguel A. Rosemberg F. Analista de Sistemas Informáticos

Cel. 0974-111000 LB. 021-280662

[jeffreykemp]

Thanks. I can see two problems here:

1. When an error occurs it is not being displayed correctly (the plugin shows "SyntaxError" when it tries to read the error message).

2. On your database it is unable to convert the string "-25.314914" to a number. I suspect a bug in my code.

[jeffreykemp]

Hi MikiRosemberg,

Can you please install the plugin from the following patch:

https://github.com/jeffreykemp/jk64-plugin-reportmap/tree/Patch-1.3.1

and let me know if this fixes the issue for you?

Thanks very much.

[MikiRosemberg]

It works flawlesly!! Thank you very much! [image: image.png]

El mié., 17 de jun. de 2020 a la(s) 21:14, Jeffrey Kemp ( notifications@github.com) escribió:

Hi MikiRosemberg,

Can you please install the plugin from the following patch:

https://github.com/jeffreykemp/jk64-plugin-reportmap/tree/Patch-1.3.1

and let me know if this fixes the issue for you?

Thanks very much.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/jeffreykemp/jk64-plugin-reportmap/issues/116#issuecomment-645709723, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOCRUDYIZJSDNYCYHPAJGPLRXFS57ANCNFSM4N75MSRA .

-- Lic. Miguel A. Rosemberg F. Analista de Sistemas Informáticos

Cel. 0974-111000 LB. 021-280662

[MikiRosemberg]

First of all, nice work! Just love it!

Just for mention, i try to use the plugin with a SQL Function instead of the select but get the message "ORA-20001 Query must begin with SELECT or WITH"

[jeffreykemp]

Thanks, raised https://github.com/jeffreykemp/jk64-plugin-reportmap/issues/117