...
-----
0 -----
0 -----
the date is 2026-05-09T06:23:17-00:00
Connected successfully
in if datapost = ..
{ "boat_id": 42, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 257, "event_date": "2026-05-09T06:23:17-00:00" , "event_type": "ping", "value": "n/a" }] }
301 Moved Permanently
301 Moved Permanently
nginx/1.18.0 (Ubuntu)
Array
(
[url] => http://boatauto:VJ2xd8TYZQYCFfeGLFB9@aacdata.com/webhooks/events
[content_type] => text/html
[http_code] => 301
[header_size] => 219
[request_size] => 366
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.105201
[namelookup_time] => 0.000481
[connect_time] => 0.052827
[pretransfer_time] => 0.053007
[size_upload] => 167
[size_download] => 178
[speed_download] => 1691
[speed_upload] => 1587
[download_content_length] => 178
[upload_content_length] => 167
[starttransfer_time] => 0.105149
[redirect_time] => 0
[redirect_url] => https://aacdata.com/webhooks/events
[primary_ip] => 34.203.63.194
[certinfo] => Array
(
)
[primary_port] => 80
[local_ip] => 75.103.66.12
[local_port] => 41630
)
sql = INSERT INTO `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`baro` ,
`freq` ,
`rebootfreq` ,
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW`
)
VALUES (
CONVERT(42, UNSIGNED) , , CONVERT(257, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'A', '{ "boat_id": 42, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 257, "event_date": "2026-05-09T06:23:17-00:00" , "event_type": "ping", "value": "n/a" }] }', '
301 Moved Permanently
301 Moved Permanently
nginx/1.18.0 (Ubuntu)
', ' '
)Error: INSERT INTO `boatauto_test`.`NewDevices` (
`boatid` ,
`macid` ,
`deviceid1` ,
`deviceid2` ,
`deviceid3` ,
`deviceid4` ,
`deviceid5` ,
`deviceid6` ,
`deviceid7` ,
`deviceid8` ,
`deviceid9` ,
`value1` ,
`value2` ,
`value3` ,
`volts` ,
`button` ,
`pump1` ,
`pump2` ,
`pump3` ,
`ipaddress` ,
`signalst` ,
`baro` ,
`freq` ,
`rebootfreq` ,
`env` ,
`datatopost` ,
`server_outputA` ,
`server_outputW`
)
VALUES (
CONVERT(42, UNSIGNED) , , CONVERT(257, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0, 0, 0, 0, 99999, 99999, 0, 0, 0, 0, 0, 0,
0, 0, 0, , , 'A', '{ "boat_id": 42, "gps": { "lat": 0, "lng": 0 }, "devices": [ { "device_id": 257, "event_date": "2026-05-09T06:23:17-00:00" , "event_type": "ping", "value": "n/a" }] }', '
301 Moved Permanently
301 Moved Permanently
nginx/1.18.0 (Ubuntu)
', ' '
)
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(257, UNSIGNED), CONVERT(0, UNSIGNED), CONVERT(0, UNSIGNED), 0, 0, 0,...' at line 32