Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
10/23/2014 at 11:58 am #307918
I noticed that most of our entries point to the same location, i.e. in the middle of a field, somewhere 70km south of the city.
I tried to edit (connections:manage) an entry to check the address, that is to say: click on ‘Georeference’ and then compare the address and the location on the displayed map.
It points to the right location, adjusting coordinates in the boxes above the map.
I save the entry. When looking at the entry again on the website, it still points to same wrong location.
Here is the directory: afkw.org/annuaire
Just did a few tests and it appears that the right coordinates are saved, but when they are recalled for display the coordinates are either truncated of the fractional value or rounded to the nearest integer (43, -80)
10/23/2014 at 1:00 pm #307926
- This topic was modified 9 years, 4 months ago by afkw.
Looking at the page source it seems the decimal separator is a comma. If I change it to a period before showing the map, the map pin shows in the correct location.
This needs to be a period or the query for the address will get truncated to the nearest integer when it is converted to a float for the query.
Can you tell me at what point the lat/lng start using the comma decimal separator?10/24/2014 at 9:47 pm #308071
The lat/long are fine in the SQL database and in connection/manage entries.
I don’t know where else to look.
I suspect it could be due to the French localization, but so far, I can’t find where to customize it.
It’s not in the Date and language settings in WP.
Xavier10/25/2014 at 11:50 am #308097
Well, this is a new one. If it is fine in the DB and when you edit the entry, I honestly have no clue where the localization conversion is occurring. If it was the DB doing the conversion as the data is read, then when you edit the entry those fields would show the comma instead of the period… and that would have been my guess as to what’s going on.
In order to track this down, I will need access, temporarily, to the WP admin as an admin, FTP access and access to phpMyAdmin.10/26/2014 at 11:58 am #308116
It’s a period in the database and a comma when editing entries manually in the manage section.
Xavier10/27/2014 at 11:11 am #308171
Hmmm, so when its being read from the DB, so the DB is doing the localization conversion… or … maybe this:
I would really need the accesses I mentioned to figure this out for you.10/27/2014 at 1:01 pm #308216
How do I send you the credentials securely ?
Xavier10/28/2014 at 12:08 pm #308358
They can be sent using the contact link at the bottom of the page. When you send the details, please paste a link to this forum thread so I can relate the two.10/29/2014 at 1:49 pm #308464
I sent the credential yesterday.
Xavier10/29/2014 at 4:46 pm #308487
Yes, I did receive it. I unfortunately ran out of time today, I need a larger block of time for debugging thing like this. You’re first up for when I start tomorrow. Apologies for the delay!
You cannot reply to this support topic. Please open your own support topic.