AtlasOfLivingAustralia / collectory

Metadata registry for the Atlas
https://collections.ala.org.au
Other
0 stars 15 forks source link

Correct coordinate parsing logic for lat & long for several locales #254

Open vjrj opened 2 weeks ago

vjrj commented 2 weeks ago

Although #189 addressed the #188 issue of editing latitude and longitude fields in collections, some users are still experiencing an exception when modifying these fields:

[2024-11-11 09:32:49] [info] Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'latitude' at row 1

This PR proposes a different approach to fully resolve this issue by ensuring latitude and longitude values are consistently converted to valid double formats, independent of user locale. This aims to prevent data truncation errors by enforcing a standard format across all inputs.