Out of range value for longitude

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

Out of range value for longitude #153

Closed samwilson closed 5 years ago

samwilson commented 6 years ago

When trying to save a new place via /admin.php?page=plugin&section=piwigo-openstreetmap%2Fadmin%2Fadmin.php&tab=place I get the following error:

Warning: [mysql error 1264] Out of range value for column 'longitude' at row 1 INSERT INTO osm_places (name, latitude, longitude) VALUE ('Rottnest', '-32.0037', '115.5082'); in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 845

samwilson commented 6 years ago

I'm assuming this is because the latitude and longitude columns are double(8,6) but should be something like double(9,6).

xbgmsharp commented 5 years ago

fixed by #156