Online/Offline LastUpdate 0minutes
Why not to the latest version?
Yes sorry v5.4
Have you checked logs for errors and exceptions?
Yes this is the error message:
2022-11-18 16:54:52 INFO: [T49d0b096] disconnected
2022-11-18 16:54:52 INFO: [T611add51] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-11-18 16:54:52 INFO: [T611add51] disconnected
2022-11-18 16:54:52 INFO: [T571c30c8: gt06 < 95.126.115.54] 78780d01035267210250214301da9d7c0d0a
2022-11-18 16:54:52 INFO: [T571c30c8: gt06 > 95.126.115.54] 7878050101daa85a0d0a
2022-11-18 16:54:52 INFO: [T571c30c8] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-11-18 16:54:52 INFO: [T571c30c8] disconnected
2022-11-18 16:54:52 INFO: [T10de2d09] connected
2022-11-18 16:54:52 INFO: [Td5aa409e] connected
2022-11-18 16:54:52 INFO: [T9c82123d: gt06 < 95.126.117.73] 78780d010352672103670980013c70170d0a
2022-11-18 16:54:52 INFO: [T9c82123d: gt06 > 95.126.117.73] 78780501013c2a620d0a
2022-11-18 16:54:52 INFO: [Tddb6f68b] connected
2022-11-18 16:54:52 INFO: [T9c82123d] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-11-18 16:54:52 INFO: [T9c82123d] disconnected
2022-11-18 16:54:52 INFO: [Tb8c86b54: gt06 < 82.132.233.1] 78780d010352887079587956001c5d370d0a
2022-11-18 16:54:52 INFO: [Tb8c86b54: gt06 > 82.132.233.1] 78780501001c12b80d0a
2022-11-18 16:54:52 INFO: [Tcccba735: gt06 < 176.83.212.230] 78780d01035267210322464802ad501f0d0a
2022-11-18 16:54:52 INFO: [Tb8c86b54] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-11-18 16:54:52 INFO: [Tb8c86b54] disconnected
2022-11-18 16:54:52 INFO: [Tcccba735: gt06 > 176.83.212.230] 7878050102ad850a0d0a
2022-11-18 16:54:52 INFO: [Tcccba735] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-11-18 16:54:52 INFO: [Tcccba735] disconnected
2022-11-18 16:54:52 INFO: [T8ac87120: gt06 < 2.140.215.153] 78780d010352672101347367015b04190d0a
2022-11-18 16:54:52 INFO: [T8ac87120: gt06 > 2.140.215.153] 78780501015b3ddb0d0a
Have you searched before asking? This issue has been discussed multiple times. For example:
https://www.traccar.org/forums/topic/incorrect-syntax-near-limit-sqlserverexception/
https://www.traccar.org/forums/topic/error-reported-in-traccar-log/
https://github.com/traccar/traccar/issues/4958
Thanks I have read this info.
So the this error is because of the logs files ? Or should I try to downgrade to 5.1 ?
The error is not because of the log files. If you have a backup, you can downgrade and wait for the next official release.
I restored to 4.10 Im not receiving no error but the gps trackers in the map start to update but in the left bar the devices not appear. I updated to 5.1 and also have the same error. there is no error in log.
In the 4.10 version the devices appears and start to blink green and says last update 0min. In the 5.1 they dont appear only 1 device.
I just update my traccar from 4.10 to 5.4 version. I have setup my sql and everything its displaying.
The Issue that I have its that My GPS trackers over 100 all of them appear offline or suddenly appear online and immediately disconnects, the last Update says 0 minutes.