Bonjour, j’ai plusieurs foi par jour le log suivant dans warnings de jeedom :
Erreur sur conso::UpdateTable() : [MySQL] Error code : 01000 (1265). Data truncated for column 'temp_max' at row 1 : REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) SELECT MIN(`timestamp`) AS `timestamp` , `conso_teleinfo`.`rec_date` AS `rec_date`, DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, ((MAX(`hchp`) - MIN(`hchp`)) / 1000) AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000) AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000) AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000) AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000) AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000) AS h3,MAX(hchp) as idx_max_hp, MIN(hchp) as idx_min_hp, MAX(hchc) as idx_max_hc, MIN(hchc) as idx_min_hc, MAX(hchp2) as idx_max_hp2, MIN(hchp2) as idx_min_hp2, MAX(hchc2) as idx_max_hc2, MIN(hchc2) as idx_min_hc2, MAX(hchp3) as idx_max_hp3, MIN(hchp3) as idx_min_hp3, MAX(hchc3) as idx_max_hc3, MIN(hchc3) as idx_min_hc3, id_equipement, FORMAT(MAX(temp),2) AS temp_max, FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d') THEN 0 WHEN 18 = 0 THEN 0 WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 WHEN 18 >= FORMAT(MAX(temp),2) THEN 0 WHEN 18
J’utilise le plugin météo pour les température, j’ai vérifié la conf du plugins sur mes 2 équipements.
Avez vous une idée ? Merci d’avance.
Informations Jeedom
Core : 4.4.12 (V4-stable)
DNS Jeedom : non
Plugin : Suivi Conso
Version : 2024-05-07 01:11:57 (stable)
Statut Démon : Démarré - (2024-12-10 22:57:14)