Bonjour,
Je suis un peu perdu avec cette erreur.
Pouvez vous m’aider ?
Erreur sur conso::UpdateOldDay() : [MySQL] Error code : 22003 (1690). BIGINT value is out of range in '`tmp_field` - `tmp_field`' : 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_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(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('04-15', '%m-%d'), '%m-%d') AND DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') THEN 0 WHEN 17 = 0 THEN 0 WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 WHEN 17
