OSMAND Timestamp Issue

tremmert2 years ago

Hello,
I am sending data to our server which contains an epoch timestamp. However, the log files of Traccar show an error.

Here is the URL I am posting to:

http://24.199.XXX.XXX:5055/?id=A8404136E185FCCD×tamp=1683235987&lat=32.19497&long=-94.16827

And here is the error I am seeing in the Traccar log:

2023-05-05 17:26:47  INFO: [Tef9d1395] connected
2023-05-05 17:26:47  INFO: [Tef9d1395: osmand < 96.8.134.109] 504f5354202f3f69643d413834303431333645313835464343442674696d657374616d703d31363833323335393837266c61743d33362e3139343937266c6f6e673d2d39342e313638323720485454502f312e310d0a486f73743a2032342e3139392e38312e36353a353035350d0a557365722d4167656e743a20707974686f6e2d72657175657374732f322e33302e300d0a4163636570742d456e636f64696e673a20677a69702c206465666c6174650d0a4163636570743a202a2f2a0d0a436f6e6e656374696f6e3a206b6565702d616c6976650d0a436f6e74656e742d4c656e6774683a20300d0a0d0a
2023-05-05 17:26:47  INFO: [Tef9d1395: osmand > 96.8.134.109] 485454502f312e3120323030204f4b0d0a636f6e74656e742d6c656e6774683a20300d0a0d0a
2023-05-05 17:26:47  WARN: Failed to store position - Data truncation: Incorrect datetime value: '1970-01-01 00:00:00' for column 'fixtime' at row 1 - MysqlDataTruncation (... < QueryBuilder:469 < DatabaseStorage:95 < DefaultDataHandler:47 < ...)
2023-05-05 17:26:47  INFO: [Tef9d1395] id: A8404136E185FCCD, time: 1970-01-01 00:00:00, lat: 0.00000, lon: 0.00000, course: 0.0
2023-05-05 17:26:47  INFO: [Tef9d1395] disconnected
tremmert2 years ago

My query parameter was incorrect. I was using "long" and the document states to use "lon".

Working fine..