Hello,
Every try to set up a radius search ends up with a SQL-Errormessage saying:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.lat' in 'field list'
"lat" is my latitude-field.
I also set it up on a fresh Joomla installation and there i get the error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY t1.title ASC LIMIT 25' at line 6
Api-Key is entered and lat and long are created correctly. I´m using Joomla 3.6.5, SEBLOD 3.10 and Address to Coordinates field with the fix from Klas (thx for that) from this Thread:
klickme
Am I doing something wrong or is it a bug?
Did you follow this tutorial?
https://www.seblod.com/resources/tutorials/how-to-set-up-a-search-by-radius
Yes, I read it again and I have also successfully built it before.
Something is obviously wrong with your lat field, check it's storage and storage type, also check it in the #__core_fields database table, sometimes fields get created with wrong storage. Unfortunately in most cases your will need to create new field as it is hard to repair old ones.
The lat field is OK and it is also filled with coordinates in DB.
I want to do the following: in content form I have address to coordinates field which is set to concatenate and storage is Standard>Article>Name_Of_address_to_coordinates_field
But in searchform I need this field to be set to Autocomplete. So I took another address to coordinates field and set it to the same storage as the one in content form.
And this seems not to work. Also with storage set to none.
Do you have a hint?
Greetings
Skepsis
Now it is working but only when lock-icon is unlocked if lat and lng-fields are created.
Greetings
Skepsis