...<br> ----- <br>0 ----- <br>0 ----- <br>the date is 2026-05-09T07:03:38-00:00<br>the transdate is 2026-05-09,00:03:38<br><br>Connected successfully<br><br>in if datapost = ..<br>
<br>{ "boat_id": 26, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 178, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 179, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 181, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 },{ "device_id": 522, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 523, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 520, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 521, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 180, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 }] }<br>IN AMAZON{"success":true,"errors":[],"token":"433fe45898"}Array
(
    [url] => https://boatauto:gTQx9Ym7fMByn6aC7auZ@aacdata.com/webhooks/events
    [content_type] => application/json; charset=utf-8
    [http_code] => 200
    [header_size] => 575
    [request_size] => 1079
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.183141
    [namelookup_time] => 0.00033
    [connect_time] => 0.053187
    [pretransfer_time] => 0.112248
    [size_upload] => 880
    [size_download] => 49
    [speed_download] => 267
    [speed_upload] => 4805
    [download_content_length] => 49
    [upload_content_length] => 880
    [starttransfer_time] => 0.183108
    [redirect_time] => 0
    [redirect_url] => 
    [primary_ip] => 34.203.63.194
    [certinfo] => Array
        (
        )

    [primary_port] => 443
    [local_ip] => 75.103.66.12
    [local_port] => 37288
)
<br>sql = INSERT INTO  `boatauto_test`.`NewDevices2` (
`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(26, UNSIGNED) , , CONVERT(178, UNSIGNED), CONVERT(179, UNSIGNED), CONVERT(180, UNSIGNED), 181, 522, 523, 520, 521, 0, 99999,   99999,   0,   0,  0,  0,  0,  0,  
0,  0, 99999, 0, 0 , 'A', '{ "boat_id": 26, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 178, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 179, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 181, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 },{ "device_id": 522, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 523, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 520, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 521, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 180, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 }] }', '{"success":true,"errors":[],"token":"433fe45898"}', ' '
)Error: INSERT INTO  `boatauto_test`.`NewDevices2` (
`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(26, UNSIGNED) , , CONVERT(178, UNSIGNED), CONVERT(179, UNSIGNED), CONVERT(180, UNSIGNED), 181, 522, 523, 520, 521, 0, 99999,   99999,   0,   0,  0,  0,  0,  0,  
0,  0, 99999, 0, 0 , 'A', '{ "boat_id": 26, "gps": { "lat": 0, "lng": 0 }, "devices": [  { "device_id": 178, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 179, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 181, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 },{ "device_id": 522, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 523, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 520, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 521, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": "n/a" },{ "device_id": 180, "event_date": "2026-05-09T07:03:38-00:00" , "event_type": "ping", "value": 0 }] }', '{"success":true,"errors":[],"token":"433fe45898"}', ' '
)<br>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(178, UNSIGNED), CONVERT(179, UNSIGNED), CONVERT(180, UNSIGNED), 181,...' at line 32<script>window.close();</script>