Bonjour a tous,
J’ai ce message d’erreur lors de chaque sauvegardes :
|[2021-04-06 05:00:12][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"3385","archivePackage":3600,"archiveTime":"2021-04-06 03:00:12"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-06 05:00:12][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"6756","archivePackage":3600,"archiveTime":"2021-04-06 03:00:12"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-06 05:00:12][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1259","archivePackage":3600,"archiveTime":"2021-04-06 03:00:12"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-06 05:00:12][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1263","archivePackage":3600,"archiveTime":"2021-04-06 03:00:12"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-06 05:00:12][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1264","archivePackage":3600,"archiveTime":"2021-04-06 03:00:12"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-07 05:00:11][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"3385","archivePackage":3600,"archiveTime":"2021-04-07 03:00:11"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-07 05:00:11][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"6756","archivePackage":3600,"archiveTime":"2021-04-07 03:00:11"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-07 05:00:11][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1259","archivePackage":3600,"archiveTime":"2021-04-07 03:00:11"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-07 05:00:11][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1263","archivePackage":3600,"archiveTime":"2021-04-07 03:00:11"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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-04-07 05:00:11][ERROR] : Erreur l'archivage des historiques : {"cmd_id":"1264","archivePackage":3600,"archiveTime":"2021-04-07 03:00:11"} => [MySQL] Error code : 22003 (1264). Out of range value for column '(null)' at row 1 : 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|
Pouvez vous me dire ce qu’il en retourne ??
Merci
