Mise à jour Conso et message d'erreur Warning: Division by zero

Bonjour à l’équipe,

Je viens de procéder à la mise à jour et j’ai ce message d’erreur en rouge en haut :
Warning : Division by zero in /var/www/html/plugins/conso/core/class/conso_teleinfo.class.php on line 1607

Warning : Division by zero in /var/www/html/plugins/conso/core/class/conso_teleinfo.class.php on line 1608

image

J’espère que cette information vous sera utile.
A très vite

Sigalou

Merci, Je gère pas actuellement les update qui sont pousser actuellement @superbricolo a tu une idée ?

Cdt
Thibaut

Ps : j’ai changer le tag. Tu tagais un autre plugin :slight_smile:

Tu peux exécuter cette requête

SELECT 	myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				SUM(shc) AS totalhc, 				SUM(shp) AS totalhp, 				ROUND(SUM(shp)+SUM(shc),2) AS total,  				ROUND(SUM(hcprix),2) AS  prixhc, 				ROUND(SUM(hpprix),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				ROUND(SUM(shc)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hc, 				ROUND(SUM(shp)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hp, 				SUM(shc)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hc, 				SUM(shp)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hp,  				ROUND((SUM(shc)+SUM(shp))*100/(res.totalhc+res.totalhp),2) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 , 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 , 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				totalhp, 				totalhc, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				(prix_hc * hc) + (prix_hp * hp)  AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%d%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1) AS prix_hc, 					(SELECT FORMAT(hp,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1 ) AS prix_hp 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (2033,2063,2032) and 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y") 						AND   configuration LIKE "%elect%" 						AND configuration LIKE '%"total":"1"%' 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%d%c%Y") = DATE_FORMAT(j.`rec_date`,"%d%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (2033,2063,2032) and 				DATE_FORMAT(j.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%d%c%Y"), myname ORDER BY istotal DESC 

en modifiant 2033,2063,2032 par la liste des enfants et du père séparé par des virgules.
Et tu me donnes le résultat

??? Tu me fais une blague ? c’est ça ? tu t’entraines pour le 01 avril ?

:smile: Tu me fais bien rire. Non en fait je suis sérieux, j’aurais besoin des données de cette requête pour essayer de comprendre ton erreur.

La requête est à exécuter ici:

Si tu ne comprends pas quelques choses dis moi. Je vais te guider

Peux-tu aussi refaire une sauvegarde de la conf de chacun de tes équipements.

Oui, je sais lancer une requete sql, mais stp, donne moi la requête à lancer. Je te fais tout de suite.

C’est celle que tu a en haut en fonction des id de ton installation.

Cdt
Thibaut

C’est « sauvegarde de la configuration » que je dois faire ?
J’ai cliqué une fois, ça a fonctionné, j’ai refait une seconde fois et j’ai ce message qui est arrivé :
image

Mais la sauvegarde semble avoir fonctionner :

Nota,je vois écrit : « Les paramètres seront dans la liste deroulante « Paramètres disponibles. » une fois la sauvegarde effectuée » mais je ne vois nul part « paramètres disponibles ».

image
ça ?

L’erreur est du a jeedom qui crée pas un dossier dans les fichier du plugin :slight_smile:

Voila la requette :slight_smile:

SELECT 	671, 679,672,676,677,680 AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				SUM(shc) AS totalhc, 				SUM(shp) AS totalhp, 				ROUND(SUM(shp)+SUM(shc),2) AS total,  				ROUND(SUM(hcprix),2) AS  prixhc, 				ROUND(SUM(hpprix),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				ROUND(SUM(shc)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hc, 				ROUND(SUM(shp)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hp, 				SUM(shc)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hc, 				SUM(shp)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hp,  				ROUND((SUM(shc)+SUM(shp))*100/(res.totalhc+res.totalhp),2) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 , 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 , 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				totalhp, 				totalhc, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				(prix_hc * hc) + (prix_hp * hp)  AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%d%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1) AS prix_hc, 					(SELECT FORMAT(hp,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1 ) AS prix_hp 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (2033,2063,2032) and 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y") 						AND   configuration LIKE "%elect%" 						AND configuration LIKE '%"total":"1"%' 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%d%c%Y") = DATE_FORMAT(j.`rec_date`,"%d%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (2033,2063,2032) and 				DATE_FORMAT(j.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%d%c%Y"), myname ORDER BY istotal DESC 

Rien, ça donne rien.

Lequel ? je peux le créer manuellement si besoin

Celui la :
image
(Ressource/backup/param)

cdt
Thibaut

Retest avec celle la :

SELECT 	myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				SUM(shc) AS totalhc, 				SUM(shp) AS totalhp, 				ROUND(SUM(shp)+SUM(shc),2) AS total,  				ROUND(SUM(hcprix),2) AS  prixhc, 				ROUND(SUM(hpprix),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				ROUND(SUM(shc)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hc, 				ROUND(SUM(shp)*100/(res.totalhc+res.totalhp),2) AS total_percent_ecq_hp, 				SUM(shc)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hc, 				SUM(shp)*100/(SUM(shp)+SUM(shc)) AS percent_ecq_hp,  				ROUND((SUM(shc)+SUM(shp))*100/(res.totalhc+res.totalhp),2) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 , 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 , 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				totalhp, 				totalhc, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				(prix_hc * hc) + (prix_hp * hp)  AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%d%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1) AS prix_hc, 					(SELECT FORMAT(hp,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) LIMIT 0,1 ) AS prix_hp 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (671,679,672,676,677,680) and 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y") 						AND   configuration LIKE "%elect%" 						AND configuration LIKE '%"total":"1"%' 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%d%c%Y") = DATE_FORMAT(j.`rec_date`,"%d%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (671,679,672,676,677,680) and 				DATE_FORMAT(j.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE(),"%d%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%d%c%Y"), myname ORDER BY istotal DESC 

Je la découvre en même temps que toi :slight_smile:

il y a une réponse

C’est bon, j’ai créé les 3 dossiers et plus d’erreur. Merci

Ce n’est pas la configuration qui faut sauvegarder, même si ça ne mange pas de pain, mais les équipements comme ici:


Et sinon tu n’as pas coché la case production complémentaire?

Tu as bien la version du 29/03/2020?