If I do reset geolocation I get the following error in db.log

[2019/01/29 10:57:59 +0100] index.php(6916): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `location_id` = ?' at line 1), Query: UPDATE `devices_locations` set WHERE `location_id` = ?

I'm runnung the latest trunk svn as of right now. with all DB schemas up to date.

/T

On 16/01/2019 16.57, Tommy Nevtelen via observium wrote:

Hi

When I clear geolocation for a device openstreetmap shows not found and it places it to the default in the middle of the Atlantic. Now for some reason all our stuff is being placed there. This also means that most devices are in Unknown in the Devices-> Location menu.

But if I take the API request and clean it up, remove *** and amp; stuff it gives the correct answer, see the second screenshot.


The url requested for this is: https://nominatim.openstreetmap.org/search?format=json&accept-language=en&addressdetails=1&limit=1&q=Brussels+Belgium

Running the latest pro version from trunk but had the issue before, just upgraded to see if it would go away.

/T


_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium