84 Posts
Skepsis
7 years ago
Topic

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?

Greetings
Skepsis

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
0
Level 1
84 Posts
Skepsis
7 years ago
1
Level 1

Yes, I read it again and I have also successfully built it before.

4229 Posts
Kadministrator
7 years ago
0
Level 2

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.

84 Posts
Skepsis
7 years ago
0
Level 1

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

84 Posts
Skepsis
7 years ago
0
Level 1

Now it is working but only when lock-icon is unlocked if lat and lng-fields are created.

Greetings

Skepsis

Get a VIP membership