the date is 2026-05-09T04:23:18-00:00
the transdate is 2026-05-08,21:23:18
Connected successfully
in if datapost = ..
{ "boat_id": 36, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 216, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" } , { "device_id": 215, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" }] }
IN AMAZONIN WESTLAKELAB
sql = INSERT INTO `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`baro` ,
`freq` ,
`rebootfreq` ,
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW`
)
VALUES (
CONVERT(36, UNSIGNED) , , CONVERT(216, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(215, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 99999, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'B', '{ "boat_id": 36, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 216, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" } , { "device_id": 215, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"11d473923e"}', 'Not Found404; Not Found'
)Error: INSERT INTO `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`baro` ,
`freq` ,
`rebootfreq` ,
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW`
)
VALUES (
CONVERT(36, UNSIGNED) , , CONVERT(216, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(215, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 99999, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'B', '{ "boat_id": 36, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 216, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" } , { "device_id": 215, "event_date": "2026-05-09T04:23:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"11d473923e"}', 'Not Found404; Not Found'
)
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' CONVERT(216, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(215, UNSIGNED), 0, 0, ...' at line 32