Problem with geopoint. Getting error .dist does not exist and java.lang.RuntimeException:

General
1

I am trying to filter my geopoints and everything was working but now it all of a sudden just stopped and giving me an error.
The error I am receiving is
Server reported an error: Optional(“java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION D0E557B6-3964-9832-FFBD-57D86FCF0E00.dist does not exist”)
faultcode: Optional(“Server.Processing”)

My code is below for filtering the data

let queryOptions = QueryOptions()
queryOptions.relationsDepth = 1;
let dataQuery = BackendlessDataQuery()
dataQuery.queryOptions = queryOptions;
let theclause = "distance( " + coordinate1 + ", " + coordinate2 + “, AddressGeoPoint.latitude, AddressGeoPoint.longitude ) < mi(20)”
dataQuery.whereClause = theclause
Please help figure out why making no changes to my code and it stopped working. When I remove the whereClause the code works with no problem.

2

Im pretty sure this is on Backendless side, SMDH! I hope this doesn’t happen when Im in full production.

3

Could you please post here the final value of the “theclause” variable?

Also, please let us know your application ID.

Mark

4

My app Id is

D0E557B6-3964-9832-FFBD-57D86FCF0E00
This is what my code ends up looking like

distance( 37.33233141, -122.0312186, AddressGeoPoint.latitude, AddressGeoPoint.longitude ) < mi(20)

I’ve also tried entering in some test code from your documentation. I used

dataQuery.whereClause = "distance( 38.866224, -121.541816, AddressGeoPoint2.latitude, AddressGeoPoint2.longitude ) < mi(200)"

Thank you for your help, I do appreciate your response and really like this form. It makes you guys stick out.

5

Hey mark is there any update on what this could be?

Thank You.

6

Hey mark this issue is still happening, Any thoughts?

7

Hi, Thomas!

You’ve posted several issues that were caused by a common problem. It is now fixed. Can you check all of your unsolved issues and write for each of them whether it is fixed or not. That will help us with issue-tracking.
Thank you

8

This issue is now resolved, Thank you for the help. Was this something that I did or is there a way to prevent this in the future?

9

This was an internal error. Please let us know if it happens again though.