Hello,
Depuis 3h du matin, chaque 3h, j’ai le warning suivant :
Erreur sur conso::UpdateTable() : [MySQL] Error code : 01000 (1265). Data truncated for column 'temp_max' at row 3 : REPLACE INTO conso_jour (
timestamp,rec_date,periode,hp,hc,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) SELECT MIN(
timestamp) AS
timestamp,
conso_teleinfo.
rec_dateAS
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(hchp) as idx_max_hp, MIN(hchp) as idx_min_hp, MAX(hchc) as idx_max_hc, MIN(hchc) as idx_min_hc, 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
Jeedom : 4.0.61
Version plugin : 2020-08-31 09:21:44
Hardware : Odroid-C4
OS : Armbian 5.6.15
Si quelqu’un a une idée, je suis preneur