Bonjour,
depuis 3 jours j’ai cette erreur avec JEEDOM 4.0.62:
|[2021-01-04 05:00:04][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1499","archivePackage":3600,"archiveTime":"2021-01-04 03:00:03"} => [MySQL] Error code : 22007 (1918). Encountered illegal value '' when converting to DECIMAL : REPLACE INTO historyArch(cmd_id,`datetime`,value) SELECT cmd_id,MIN(`datetime`),avg(CAST(value AS DECIMAL(12,2))) as value |||FROM history |||WHERE `datetime` <= :archiveTime |||AND cmd_id=:cmd_id |||AND `value` IS NOT NULL |||GROUP BY UNIX_TIMESTAMP(`datetime`) DIV :archivePackage|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|[2021-01-05 05:00:03][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1499","archivePackage":3600,"archiveTime":"2021-01-05 03:00:03"} => [MySQL] Error code : 22007 (1918). Encountered illegal value '' when converting to DECIMAL : REPLACE INTO historyArch(cmd_id,`datetime`,value) SELECT cmd_id,MIN(`datetime`),avg(CAST(value AS DECIMAL(12,2))) as value |||FROM history |||WHERE `datetime` <= :archiveTime |||AND cmd_id=:cmd_id |||AND `value` IS NOT NULL |||GROUP BY UNIX_TIMESTAMP(`datetime`) DIV :archivePackage|
|[2021-01-06 05:00:03][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1499","archivePackage":3600,"archiveTime":"2021-01-06 03:00:03"} => [MySQL] Error code : 22007 (1918). Encountered illegal value '' when converting to DECIMAL : REPLACE INTO historyArch(cmd_id,`datetime`,value) SELECT cmd_id,MIN(`datetime`),avg(CAST(value AS DECIMAL(12,2))) as value |||FROM history |||WHERE `datetime` <= :archiveTime |||AND cmd_id=:cmd_id |||AND `value` IS NOT NULL |||GROUP BY UNIX_TIMESTAMP(`datetime`) DIV :archivePackage|
Merci par avance de votre aide
