I did a redesign of one of my sites and imported all my seblod content types which worked fine but my address to coordinates search stopped working.
Its a doctor search and all required fields (latitide, longitude, address, Country...) are in the database. Address to coordinates field works fine when adding new doctors (generating coodinates from address) but the search & List type is not.
The get request to Google Maps look like this:
| GET |
https://maps.googleapis.com/maps/api/js/AuthenticationService.Authenticate?1shttps://mydomain.de/arztsuche?addresstocoordinatesfield=10245+Berlin%2C+Deutschland&umkreis=10&country=Deutschland&longitude=13.4554471&latitude=52.5019332
&latitude=&longitude=&search=mysearchtype&task=search=&myapikey=&callback=moreapikeystuff&token=1234 |
As you can see the longitude and latitude fields showing twice here? There are hidden in the search form and match & stage is set to none.
Does anybody know where i can look for wrong setting?
(latest joomla and seblod and all fields are up to date)
Ok when using standard search template the second latitude/longitude in search string is gone.
But now i get an error message when searching:
|
Error Code: 1054 |
|
| Error Message | Unknown column 't1.latitude' in 'field list' |
| Error File | /var/www/html/libraries/joomla/database/driver/mysqli.php:665 |
All fields are placed in search view and list view as well.
I can see the autocomplete address to coordinates field is filling coordinates to my latitude an longitude fields in search form.
But there is no filtering.
These are the fields in Search form:
Address to Coordinates
autocomplete
type: all
country: germany
latitude and longitude field
city and zip code field
storage: standard
Match & Stage: Radius lower than, Latitude and Longitude field are inserted and radius field)
Radius
Select numeric field
storage: none
Match & Stage: none
Country
Select simple field (i use this in Content Type as well, so its filled)
storage: standard
Match & Stage: Any Words exact
Latitude
Text field (i use this in Content Type as well, so its filled)
Storage: standard (dezimal 10.8)
Match & Stage: none
Longitude
Text field (i use this in Content Type as well, so its filled)
Storage: standard (dezimal 11.8)
Match & Stage: none
Button Submit
In my List view i added Latitude and Longitude field (hidden).