OBD tracker, disregard, post may be deleted,

fonnie8 years ago

this model used to work well on port 5001
now I get this

2016-09-05 14:51:26  INFO: [20AD0E1D] id: 869152024446923, time: 2016-09-05 14:51:23, lat: 50.89755, lon: 4.40088, speed: 0.1, course: 0.0
2016-09-05 14:52:04 DEBUG: [D8071A5D: 5024 < 109.139.158.168] HEX: 48490d0a
2016-09-05 14:52:18 DEBUG: [D12DE876: 5001 < 188.5.232.177] HEX: 3335393731303034393032323837353b
2016-09-05 14:52:18 DEBUG: [D12DE876: 5001 > 188.5.232.177] HEX: 4f4e
2016-09-05 14:52:18  WARN: Parameter "#3" is not set; SQL statement:
UPDATE devices SET status = ?, lastUpdate = ?, motion = ? WHERE id = ?; [90012-192] - JdbcSQLException (... < QueryBuilder:443 < DataManager:220 < DeviceManager:177 < ...)
2016-09-05 14:52:26 DEBUG: [20AD0E1D: 5024 < 109.140.253.233] HEX: 244d47563030322c3836393135323032343434363932332c2c522c3035303931362c3132353232332c412c353035332e38353239372c4e2c30303432342e30353238372c452c30302c31302c30302c312e33322c302e3039342c2c33312e302c2c3230362c30312c303744312c363546432c32372c2c2c2c2c2c2c2c2c30312c3036352c54696d65723b21
2016-09-05 14:52:26  WARN: Parameter "#3" is not set; SQL statement:
UPDATE devices SET status = ?, lastUpdate = ?, motion = ? WHERE id = ?; [90012-192] - JdbcSQLException (... < QueryBuilder:443 < DataManager:220 < DeviceManager:177 < ...)
2016-09-05 14:52:26  INFO: [20AD0E1D] id: 869152024446923, time: 2016-09-05 14:52:23, lat: 50.89755, lon: 4.40088, speed: 0.1, course: 0.0
2016-09-05 14:53:18 DEBUG: [D12DE876: 5001 < 188.5.232.177] HEX: 3335393731303034393032323837353b
2016-09-05 14:53:18 DEBUG: [D12DE876: 5001 > 188.5.232.177] HEX: 4f4e
2016-09-05 14:53:18  WARN: Parameter "#3" is not set; SQL statement:
UPDATE devices SET status = ?, lastUpdate = ?, motion = ? WHERE id = ?; [90012-192] - JdbcSQLException (... < QueryBuilder:443 < DataManager:220 < DeviceManager:177 < ...)

do I need to change something, somewhere?

best regards

Fonnie

Anton Tananaev8 years ago

Remove "status" and "motion" parameters from SQL queries.