https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,02:48:03
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T02:48:03-00:00"
end of file
- New record : - New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }
"event_date": "2026-05-02T02:48:03-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2b1cdf7970"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2b1cdf7970"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T02:48:04-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:04-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:04-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"8023b9e139"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:04-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T02:48:04-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"8023b9e139"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab : In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
) after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }''{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T02:48:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-02T03:17:49-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:17:49-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:17:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"bb01493de9"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:17:49-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:17:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"bb01493de9"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T03:21:49-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:21:49-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
https://www.api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,03:22:19
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:22:19-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:22:19-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"04f0d1e67b"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:22:19-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T03:22:19-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"04f0d1e67b"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T03:23:20-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:23:20-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:21:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:21:49-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:21:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:23:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:23:20-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T03:23:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-02T07:23:39-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:23:39-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:23:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"5ae6d0df6d"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:23:39-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:23:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"5ae6d0df6d"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T07:29:43-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:29:43-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,07:30:14
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:30:14-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:30:14-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"20c5734d86"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:30:14-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T07:30:14-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"20c5734d86"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T07:30:56-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:30:56-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:29:43-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:29:43-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:29:43-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:30:56-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:30:56-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T07:30:56-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-02T08:40:52-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,08:40:52
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T08:40:53-00:00"
end of file
in amazon 4
After end of Amazon :
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T08:40:53-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"a8efa1e00c"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"a8efa1e00c"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"69bda06412"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"69bda06412"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab : In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
) after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T08:40:53-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-02T09:09:37-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,09:09:37
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T09:09:37-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
- New record :
"event_date": "2026-05-02T09:09:37-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"02b7b03a45"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"02b7b03a45"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"59038665a9"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"59038665a9"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T09:09:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-02T12:06:39-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T12:06:39-00:00"
end of file
in amazon 4
After end of Amazon :
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,12:06:39
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T12:06:39-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"07a50fc098"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"07a50fc098"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"4e811ffc23"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"4e811ffc23"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:06:39-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-02,12:49:15
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T12:49:15-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"35873298e6"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"35873298e6"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"d6276b8be8"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"d6276b8be8"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-02T12:49:15-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-02T12:49:16-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:16-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
In Westlakelab : In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:16-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
) after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:16-00:00" , "event_type": "ping", "value": "n/a" }] }''{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:16-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-02T12:49:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-03T19:49:12-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:49:12-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
https://allautomations.com/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-03,19:49:42
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T19:49:42-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T19:49:42-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"278277b222"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T19:49:42-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T19:49:42-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"278277b222"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:49:12-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:49:12-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:49:12-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-03T19:59:15-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:59:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:59:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:59:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-03T19:59:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-03T20:12:59-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T20:12:59-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T20:12:59-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"24571e80c6"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T20:12:59-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-03T20:12:59-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"24571e80c6"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-04,19:22:49
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T19:22:49-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-04T19:22:50-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T19:22:50-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T19:22:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"9a284813fe"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T19:22:49-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T19:22:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"9a284813fe"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T19:22:50-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '
Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T19:22:50-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T19:22:50-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-04T23:41:20-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-04T23:41:20-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-04,23:41:21
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
- New record :
"event_date": "2026-05-04T23:41:21-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"b3825bbb52"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"b3825bbb52"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2e6c375e7d"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-04T23:41:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2e6c375e7d"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-04T23:41:20-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-05T02:51:48-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-05T02:51:48-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-05,02:51:48
end of file
in amazon 4
After end of Amazon :
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"94943834cf"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"94943834cf"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T02:51:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-05T12:39:21-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-05T12:39:21-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-05T12:39:21-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-05,12:39:21
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"6aba3397b3"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"6aba3397b3"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"8a52a047d1"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-05T12:39:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"8a52a047d1"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-06T00:39:26-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T00:39:26-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T00:39:26-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T00:39:26-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T00:39:26-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-06T07:33:25-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T07:33:25-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T07:33:25-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T07:33:25-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-06T07:33:25-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-06T14:57:25-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T14:57:25-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T14:57:25-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"321212927b"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T14:57:25-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T14:57:25-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"321212927b"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
http://allautomations.com/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-06,17:31:31
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T17:31:31-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T17:31:31-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"adb791d103"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T17:31:31-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-06T17:31:31-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"adb791d103"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-07T11:38:19-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T11:38:19-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T11:38:19-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"aedb6ae35a"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T11:38:19-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T11:38:19-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"aedb6ae35a"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-07T12:22:52-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T12:22:52-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T12:22:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T12:22:52-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T12:22:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-07T22:21:10-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T22:21:10-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T22:21:10-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T22:21:10-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-07T22:21:10-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
http://www.allautomations.net/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-07,23:11:05
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T23:11:05-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T23:11:05-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"c756d41645"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T23:11:05-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-07T23:11:05-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"c756d41645"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:05:15-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-08T00:05:15-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-08,00:05:15
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
- New record :
"event_date": "2026-05-08T00:05:15-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"399096be7e"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"399096be7e"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"c498043f7f"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:05:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"c498043f7f"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
https://allautomations.net/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-08,00:25:48
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:25:48-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:25:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"d1b6556e9d"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:25:48-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:25:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"d1b6556e9d"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:25:49-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:25:49-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:25:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:25:49-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:25:49-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:27:47-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:27:47-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:27:47-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:27:47-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:27:47-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
https://allautomations.com/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-08,00:27:48
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:27:48-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:27:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"33f25827bf"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:27:48-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:27:48-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"33f25827bf"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:36:18-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:36:18-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:36:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:36:18-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:36:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:41:58-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:41:58-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:41:58-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"5ed89f9fbd"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:41:58-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:41:58-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"5ed89f9fbd"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:43:37-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:43:37-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:43:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:43:37-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T00:43:37-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T00:55:12-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:55:12-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:55:12-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2c5da22983"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:55:12-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T00:55:12-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"2c5da22983"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:00:04-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:00:04-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:00:04-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"0f2b0f2d74"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:00:04-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:00:04-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"0f2b0f2d74"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:01:22-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:01:22-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:01:22-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"7348170512"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:01:22-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:01:22-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"7348170512"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:06:05-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:05-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:05-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:05-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:05-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-08,01:06:18
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:06:18-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:06:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"f397324d5a"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:06:18-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T01:06:18-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"f397324d5a"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:06:31-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:31-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:31-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:31-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:06:31-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:07:28-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:28-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:28-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:28-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:28-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T01:07:42-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:42-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:42-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:42-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T01:07:42-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
https://aacdata.net/aacdata.net/api/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-08,10:54:51
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T10:54:51-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T10:54:51-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"238071a948"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T10:54:51-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T10:54:51-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"238071a948"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-08T10:54:52-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T10:54:52-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T10:54:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T10:54:52-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T10:54:52-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T11:03:51-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T11:03:51-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T11:03:51-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T11:03:51-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-08T11:03:51-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-08T11:13:03-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T11:13:03-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T11:13:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"48c3f2747a"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T11:13:03-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-08T11:13:03-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"48c3f2747a"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-09T04:49:21-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T04:49:21-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T04:49:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T04:49:21-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T04:49:21-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', ''
)
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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-09T07:37:33-00:00"
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:37:33-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:37:33-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"94a378b8aa"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:37:33-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:37:33-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"94a378b8aa"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
https://api.aacdata.net/backup/Copy%20of%20sendtoAPI6.php, - New record :
2026-05-09,07:38:57
end of file
- New record : { "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:38:57-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
after 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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:38:57-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"ad3df6a688"}', ' '
)
'{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:38:57-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(133, UNSIGNED) , , CONVERT(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 99999, 0, 0 , 'A', '{ "boat_id": 133, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 610, "event_date": "2026-05-09T07:38:57-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"success":true,"errors":[],"token":"ad3df6a688"}', ' '
)
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(610, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32
end of file
- New record :
"event_date": "2026-05-09T07:39:15-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:39:15-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:39:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:39:15-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:39:15-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file
- New record :
"event_date": "2026-05-09T07:40:14-00:00"
end of file
- New record : { "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:40:14-00:00" , "event_type": "ping", "value": "n/a" }] }
in amazon 1
in amazon 3
in amazon 4
After end of Amazon :
In Westlakelab :
after 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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:40:14-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', 'Not Found404; Not Found'
)
'{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:40:14-00:00" , "event_type": "ping", "value": "n/a" }] }'
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(, UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0 , 'B', '{ "boat_id": , "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": , "event_date": "2026-05-09T07:40:14-00:00" , "event_type": "ping", "value": "n/a" }] }', '{"error":"Invalid JSON payload"}', '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 ' UNSIGNED) , , CONVERT(, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED...' at line 32
end of file