In My SQL Database Position not saving

Log File Content......

2015-11-05 00:00:08 DEBUG: [2221F858: 5023 < 37.231.211.156] HEX: 78781f120f0b04151e0ac703322630052417c900156301a3003abc004e8602d552e80d0a
2015-11-05 00:00:08 DEBUG: [2221F858: 5023 > 37.231.211.156] HEX: 7878051202d510340d0a
2015-11-05 00:00:08  WARN: FUNCTION traccar.CURRENT_DATETIME does not exist - MySQLSyntaxErrorException (... < QueryBuilder.java:412 < DataManager.java:329 < DefaultDataHandler.java:27 < ...)
2015-11-05 00:00:08  INFO: [2221F858] id: 7, time: Thu Nov 05 03:00:10 IST 2015, lat: 29.787902222222222, lon: 47.91748055555556, speed: 0.0, course: 355.0
2015-11-05 00:01:28 DEBUG: [2221F858: 5023 < 37.231.211.156] HEX: 78780a13440604000102d6c3320d0a
2015-11-05 00:01:28 DEBUG: [2221F858: 5023 > 37.231.211.156] HEX: 7878051302d678730d0a
2015-11-05 00:04:28 DEBUG: [2221F858: 5023 < 37.231.211.156] HEX: 78780a13440604000102d7d2bb0d0a
2015-11-05 00:04:28 DEBUG: [2221F858: 5023 > 37.231.211.156] HEX: 7878051302d769fa0d0a
2015-11-05 00:05:08 DEBUG: [2221F858: 5023 < 37.231.211.156] HEX: 78781f120f0b0415230ac703322637052417c200156301a3003abc004e8602d847ae0d0a
2015-11-05 00:05:08 DEBUG: [2221F858: 5023 > 37.231.211.156] HEX: 7878051202d8cbd10d0a
2015-11-05 00:05:08  WARN: FUNCTION traccar.CURRENT_DATETIME does not exist - MySQLSyntaxErrorException (... < QueryBuilder.java:412 < DataManager.java:329 < DefaultDataHandler.java:27 < ...)
2015-11-05 00:05:08  INFO: [2221F858] id: 7, time: Thu Nov 05 03:05:10 IST 2015, lat: 29.787906111111113, lon: 47.917476666666666, speed: 0.0, course: 355.0
2015-11-05 00:07:28 DEBUG: [2221F858: 5023 < 37.231.211.156] HEX: 78780a13440604000102d93bc50d0a
2015-11-05 00:07:28 DEBUG: [2221F858: 5023 > 37.231.211.156] HEX: 7878051302d980840d0a
...
2015-11-05 10:15:28 DEBUG: [D2A30ACD: 5023 < 37.231.211.156] HEX: 78781f120f0b05072d1fc7033392520522515400151301a3003abc004fc704d1f23e0d0a
2015-11-05 10:15:28 DEBUG: [D2A30ACD: 5023 > 37.231.211.156] HEX: 7878051204d102c00d0a
2015-11-05 10:15:29  WARN: FUNCTION traccar.CURRENT_DATETIME does not exist - MySQLSyntaxErrorException (... < QueryBuilder.java:412 < DataManager.java:329 < DefaultDataHandler.java:27 < ...)
2015-11-05 10:15:29  INFO: [D2A30ACD] id: 7, time: Thu Nov 05 13:15:31 IST 2015, lat: 29.83969, lon: 47.852846666666665, speed: 0.0, course: 275.0

Anton Tananaev9 years ago

Your topic got into spam folder for some reason. Please next time post a small fragment of the log showing the problem.

As for the problem, it seems like you have some problem with SQL queries in the config.