Salut à tous
Depuis la maj du plugin suivi Conso hier soir vers 22h, le démon ne fait que de planter !
Auriez vous une idée du problème svp?
Par avance merci
[2025-01-03 04:30:11] ERROR : Erreur sur la fonction cron30 du plugin : Call to undefined function HP()
[2025-01-03 04:40:03] DEBUG : Synchronisation du Jour.
[2025-01-03 04:40:03] INFO : CrontabJour: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 17 = 0 THEN 0 WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) END AS dju_clim, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND '12-31' AND DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN '01-01' AND DATE_FORMAT(STR_TO_DATE('04-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 17 - FORMAT(AVG(NULLIF(temp,0)),2) WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) END AS dju FROM `conso_teleinfo` INNER JOIN eqLogic ON id=id_equipement where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
[2025-01-03 05:00:05] DEBUG : Synchronisation du Jour.
[2025-01-03 05:00:05] INFO : CrontabJour: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 17 = 0 THEN 0 WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) END AS dju_clim, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND '12-31' AND DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN '01-01' AND DATE_FORMAT(STR_TO_DATE('04-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 17 - FORMAT(AVG(NULLIF(temp,0)),2) WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) END AS dju FROM `conso_teleinfo` INNER JOIN eqLogic ON id=id_equipement where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
