[2024-06-13 10:50:28] Formatted data: {"countingData":{"imei":"48B02D2E843F","temp":40,"rssi":-98,"msg_version":1,"error":"null","counts":[{"person_ed":1,"person_de":2,"bicycle_ed":3,"bicycle_de":4,"timestamp":"2024-03-03 10:00:00"}]}}
[2024-06-13 10:50:28] Data written to file: data.txt
[2024-06-13 10:50:33] HTTP POST result: Error PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ","
LINE 1: ...cle_de":4,"timestamp":"2024-03-03 10:00:00"}]}}','','','',,)
                                                                     ^ in /var/www/floema/api/data/sensors_ai.php:138
Stack trace:
#0 /var/www/floema/api/data/sensors_ai.php(138): PDO->exec('INSERT INTO msg...')
#1 /var/www/floema/api/data/sensors_ai.php(62): insertRawData(Array, Object(PDO))
#2 {main}<br/>[GEO]2024-06-13 11:50:28_R:0_I:0_E:1_A:_T:_U:
[2024-06-13 10:50:33] HTTP response code: HTTP/1.1 200 OK
[2024-06-13 11:01:30] Data written to file: data.txt
[2024-06-13 11:01:30] Data to send: countingData=%7B%22imei%22%3A%2248B02D2E843F%22%2C%22temp%22%3A40%2C%22rssi%22%3A-102%2C%22msg_version%22%3A1%2C%22error%22%3A%22null%22%2C%22counts%22%3A%5B%7B%22person_ed%22%3A1%2C%22person_de%22%3A2%2C%22bicycle_ed%22%3A3%2C%22bicycle_de%22%3A4%2C%22timestamp%22%3A%222024-03-03+10%3A00%3A00%22%7D%5D%7D
[2024-06-13 11:01:35] HTTP POST result: [GEO]2024-06-13 12:01:30_R:1_I:2_E:0_A:2_T:10_U:M
[2024-06-13 11:01:35] HTTP response code: HTTP/1.1 200 OK
[2024-06-13 13:58:13] Received non-POST request.
[2024-06-13 14:04:15] Received non-POST request.
[2024-06-14 00:18:15] Received non-POST request.
[2024-06-14 00:18:15] Received non-POST request.
[2024-06-14 00:18:18] Received non-POST request.
[2024-06-14 00:18:19] Received non-POST request.
[2024-06-14 00:18:32] Received non-POST request.
[2024-06-14 00:18:33] Received non-POST request.
[2024-06-24 11:12:23] Data written to file: data.txt
[2024-06-24 11:12:23] Data to send: countingData=%7B%22imei%22%3A%2248B02D2E843F%22%2C%22temp%22%3A40%2C%22rssi%22%3A-105%2C%22msg_version%22%3A1%2C%22error%22%3A%22null%22%2C%22counts%22%3A%5B%7B%22person_ed%22%3A1%2C%22person_de%22%3A0%2C%22bicycle_ed%22%3A0%2C%22bicycle_de%22%3A0%2C%22timestamp%22%3A%222002-40-30+10%3A90%3A00%22%7D%5D%7D
[2024-06-24 11:12:28] HTTP POST result: Error PDOException: SQLSTATE[22008]: Datetime field overflow: 7 ERROR:  date/time field value out of range: "2002-40-30 10:90:00"
LINE 1: ...6, count7, count8, count9)  VALUES (112161,58,1,0,'2002-40-3...
                                                             ^ in /var/www/floema/api/data/sensors_ai.php:175
Stack trace:
#0 /var/www/floema/api/data/sensors_ai.php(175): PDO->exec('INSERT INTO msg...')
#1 /var/www/floema/api/data/sensors_ai.php(64): insertParsedData(Array, '112161', Object(PDO))
#2 {main}<br/>[GEO]2024-06-24 12:12:23_R:1_I:1_E:1_A:2_T:10_U:M
[2024-06-24 11:12:28] HTTP response code: HTTP/1.1 200 OK
[2024-12-09 10:04:16] Received non-POST request.
[2024-12-09 10:04:16] Received non-POST request.
[2024-12-13 05:45:52] Received non-POST request.
[2024-12-13 05:45:52] Received non-POST request.
[2025-03-05 16:07:22] Received non-POST request.
[2025-03-05 20:16:48] Received non-POST request.
[2025-03-06 08:15:00] Received non-POST request.
[2025-07-06 10:31:50] Received non-POST request.
[2025-07-09 04:54:33] Received non-POST request.
[2025-07-09 06:53:46] Received non-POST request.
[2025-07-09 08:08:55] Received non-POST request.
[2025-07-12 04:27:07] Received non-POST request.
[2025-07-12 09:08:34] Received non-POST request.
[2025-08-04 02:56:17] Received non-POST request.
[2025-08-09 11:33:42] Received non-POST request.
[2025-08-09 14:16:53] Received non-POST request.
[2025-08-09 15:10:01] Received non-POST request.
[2025-08-09 19:40:40] Received non-POST request.
[2025-08-15 02:44:05] Received non-POST request.
[2025-09-09 18:09:21] Received non-POST request.
[2025-09-09 19:49:23] Received non-POST request.
[2025-09-15 16:47:09] Received non-POST request.
[2025-09-15 23:10:26] Received non-POST request.
[2025-09-15 23:46:45] Received non-POST request.
[2025-09-21 16:36:08] Received non-POST request.
[2025-10-08 23:51:53] Received non-POST request.
[2025-10-09 05:47:05] Received non-POST request.
[2025-10-14 20:09:06] Received non-POST request.
[2025-10-15 03:10:11] Received non-POST request.
[2025-10-20 13:04:53] Received non-POST request.
[2025-10-20 16:20:15] Received non-POST request.
[2025-11-07 23:47:45] Received non-POST request.
[2025-11-13 20:48:50] Received non-POST request.
[2025-11-14 00:19:51] Received non-POST request.
[2025-11-14 02:21:29] Received non-POST request.
[2025-11-20 01:15:56] Received non-POST request.
[2025-11-20 02:30:05] Received non-POST request.
[2025-12-11 13:35:17] Received non-POST request.
[2025-12-11 15:01:12] Received non-POST request.
[2025-12-11 16:16:23] Received non-POST request.
[2025-12-11 19:25:45] Received non-POST request.
[2025-12-18 23:26:26] Received non-POST request.
[2025-12-19 04:59:15] Received non-POST request.
[2025-12-22 18:02:23] Received non-POST request.
[2025-12-24 08:12:37] Received non-POST request.
[2025-12-24 12:11:46] Received non-POST request.
[2026-01-12 06:06:51] Received non-POST request.
[2026-01-18 14:17:16] Received non-POST request.
[2026-01-18 18:32:36] Received non-POST request.
[2026-01-18 21:46:41] Received non-POST request.
[2026-01-24 05:16:39] Received non-POST request.
[2026-01-24 10:14:20] Received non-POST request.
[2026-02-02 10:09:57] Received non-POST request.
[2026-02-09 16:12:23] Received non-POST request.
[2026-02-13 23:26:48] Received non-POST request.
[2026-02-13 23:42:44] Received non-POST request.
[2026-02-14 04:11:13] Received non-POST request.
[2026-02-14 04:57:58] Received non-POST request.
[2026-02-14 20:25:13] Received non-POST request.
[2026-02-14 20:55:15] Received non-POST request.
[2026-02-14 23:03:58] Received non-POST request.
[2026-02-25 21:56:11] Received non-POST request.
[2026-02-25 22:37:11] Received non-POST request.
[2026-03-19 00:03:39] Received non-POST request.
[2026-03-19 03:58:16] Received non-POST request.
[2026-03-19 05:59:25] Received non-POST request.
[2026-03-19 08:09:39] Received non-POST request.
[2026-03-24 21:15:43] Received non-POST request.
[2026-03-29 22:57:24] Received non-POST request.
[2026-04-15 14:31:21] Received non-POST request.
[2026-04-15 16:17:29] Received non-POST request.
[2026-04-15 19:46:34] Received non-POST request.
[2026-04-15 19:55:45] Received non-POST request.
[2026-04-16 00:38:30] Received non-POST request.
[2026-04-16 00:53:31] Received non-POST request.
[2026-04-16 07:29:16] Received non-POST request.
[2026-04-16 07:58:55] Received non-POST request.