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

Plugins Energie
1

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

2

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:

3

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

4

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

5

: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:

image
image494×703 137 KB

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

6

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

7

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

8

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

Cdt
Thibaut

9

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 :

image
image709×86 7.36 KB

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 ».

10

image
ça ?

11

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

12

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
13

Rien, ça donne rien.

image
image1057×568 109 KB

14

Lequel ? je peux le créer manuellement si besoin

15

Celui la :
image
(Ressource/backup/param)

cdt
Thibaut

16

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:

17

il y a une réponse

image
image1059×167 22.4 KB

18

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

19

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

image
image1917×682 408 KB

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

20

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