Hosts Offline. Ping Works

[BigProgrammer2000]

I set up the container using Docker Compose and a custom MySQL. I created the database with lagident/init-mysqldb.sql.
The hosts entered are all marked as offline in the table. However, points are displayed in the graph. For me, this means that the ping itself is working.

The following is in the logs:

Error saving stats for 127.0.0.1: Error 1292 (22007): Truncated incorrect DOUBLE value: ''
Error saving stats for 192.168.9.10: Error 1292 (22007): Truncated incorrect DOUBLE value: ''
Error saving stats for 192.168.17.10: Error 1292 (22007): Truncated incorrect DOUBLE value: ''
[GIN] 2025/12/24 - 14:08:53 | 200 |    2.034189ms |       10.8.1.50 | GET      "/api/statistics"

[nook24]

Maybe there is something wrong with the default values of your statistics table. Try to recreate the table and restart your container:

lagident/init-mysqldb.sql

Lines 29 to 46 in 3e0f7db

	CREATE TABLE IF NOT EXISTS `statistics` (
	`target_uuid` CHAR(36) NOT NULL PRIMARY KEY,
	`state` VARCHAR(10) NOT NULL,
	`sent` BIGINT UNSIGNED NOT NULL DEFAULT 0,
	`recv` BIGINT UNSIGNED NOT NULL DEFAULT 0,
	`last` DOUBLE DEFAULT 0,
	`loss` DOUBLE DEFAULT 0,
	`sum` DOUBLE DEFAULT 0,
	`max` DOUBLE DEFAULT 0,
	`min` DOUBLE DEFAULT NULL,
	`avg15m` DOUBLE DEFAULT 0,
	`avg6h` DOUBLE DEFAULT 0,
	`avg24h` DOUBLE DEFAULT 0,
	`timestamp` BIGINT(20) NOT NULL
	)
	ENGINE = InnoDB
	DEFAULT CHARSET = utf8
	COLLATE = utf8_general_ci;

[BigProgrammer2000]

I recreated the table, but it makes no difference. The error is still the same.

Here is the table structure: