Positions data not store in database

jkmazur8 years ago

Im using mySQL database and installed iOS client. The live preview works perfectly, when I set a new device and change name into preview I see it also in database, i see all the tables that's need to be created.

The problem is with positions, when I select:

SELECT * FROM positions i got Empty set (0.00 sec)

But when I call the API with /api/positions i get one position for my device (the latest one), how to save a positions into the database. Did I miss sth in configuration?

[{"deviceId":2,"type":null,"attributes":{"battery":"0","ip":"94.254.***.***"},"id":0,"protocol":"osmand","serverTime":null,"deviceTime":"2016-05-23T10:05:15.000+0000","fixTime":"2016-05-23T10:05:15.000+0000","outdated":false,"valid":true,"latitude":**.****,"longitude":**.*****,"altitude":208.461,"speed":0.0,"course":0.0,"address":"*****"}]
Anton Tananaev8 years ago

Traccar caches data in memory. I think SQL insert failed for some reason, so position hasn't been stored into the database, but Traccar still has it in memory, so API returns data.