Commands out of sync error while calculating distance

Question

I am trying to calculate distance from given Point(lat, long) but when I use an ordering by the distance column I get Commands out of sync; you can't run this command now error.

Here is my query:

SELECT id, name, country_code, postal_code, latitude, longitude, 
    st_distance_sphere(
        point(50.77333, 7.185259), 
        point(latitude, longitude)
    ) AS distance 
FROM place_merged WHERE name LIKE ('ko%') ORDER BY distance

If I remove ORDER BY clause, it executes fine. Is there any way I can calculate distance and get places which are certain distance far from my provided latitude & longitude?

That error has to do with using the same cursor object to perform multiple queries. Show your code. — Barmar, Feb 01 '18 at 18:58
I am running this query inside phpmyadmin, no code involved. — jsan, Feb 01 '18 at 19:00
[search phpmyadmin bugs](https://github.com/phpmyadmin/phpmyadmin/issues?utf8=%E2%9C%93&q=is%3Aissue+commands+out+of+sync) — Barmar, Feb 01 '18 at 19:04

score 0 · Answer 1 · answered Feb 10 '18 at 02:19

0

That is in a Stored Procedure, correct? You failed to DEALLOCATE PREPARE.

answered Feb 10 '18 at 02:19

Rick James

135,179
13
127
222

Commands out of sync error while calculating distance

1 Answers1