search

Piwigo / piwigo-openstreetmap

OpenStreetMap integration for Piwigo
http://piwigo.org/ext/extension_view.php?eid=701
GNU General Public License v3.0
35 stars 35 forks source link

Saved Places: Longitude value not being saved #127

Open digibirdtrek opened 7 years ago

digibirdtrek commented 7 years ago

Saved places longitude is not being saved correctly. It defaults to -99.999999 when either creating a new place or editing. Latitude is being saved correctly.

emja commented 7 years ago

I'm seeing the same problem for both coordinates. It doesn't accept values outside of between 99.999999 to -99.999999.

KakersUK commented 7 years ago

Looks like a problem with the table structure, I've create a pull request #134 to fix this with new installs. You can fix this on your current install by running the following query against your MySQL/MariaDB server.

Replace dbname with the name of your database. ALTER TABLE dbname.piwigo_osm_places MODIFY COLUMN longitude DOUBLE(9,6);

Manuki-San commented 5 years ago

Same issue with longitude value over 99.99999 (Australia). Please correct.