[afkw]

Hi Steven,
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)

Thanks, Xavier

• This topic was modified 7 years, 9 months ago by afkw.

[Steven Zahm]

@ Xavier

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?

[afkw]

Steven,

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.

Thanks,
Xavier

[Steven Zahm]

@ Xavier

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.

[afkw]

Steve,

My mistake,

It’s a period in the database and a comma when editing entries manually in the manage section.

Xavier

[Steven Zahm]

@ Xavier

Hmmm, so when its being read from the DB, so the DB is doing the localization conversion… or … maybe this:
http://mark-story.com/posts/view/php-floats-localization-and-landmines

I would really need the accesses I mentioned to figure this out for you.

[afkw]

Steven,

How do I send you the credentials securely ?

Xavier

[Steven Zahm]

@ Xavier

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.

[afkw]

I sent the credential yesterday.

Xavier

[Steven Zahm]

@ Xavier

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!

[Author]

Posts