Forum Domoticz en français

voici les message d erreur que j ai

[code
sqlite> Error: near line 1: no such table: Meter_Calendar
...> Error: near line 2: no such table: Meter_Calendar
...> Error: near line 3: no such table: Meter_Calendar
...> Error: near line 4: no such table: Meter_Calendar
...> Error: near line 5: no such table: Meter_Calendar
...> Error: near line 6: no such table: Meter_Calendar
...> Error: near line 7: no such table: Meter_Calendar
...> Error: near line 8: no such table: Meter_Calendar
...> Error: near line 9: no such table: Meter_Calendar
...> Error: near line 10: no such table: Meter_Calendar
...> Error: near line 11: no such table: Meter_Calendar
...> Error: near line 12: no such table: Meter_Calendar
...> Error: near line 13: no such table: Meter_Calendar
...> Error: near line 14: no such table: Meter_Calendar
...> Error: near line 15: no such table: Meter_Calendar
...> Error: near line 16: no such table: Meter_Calendar
...> Error: near line 17: no such table: Meter_Calendar
...> Error: near line 18: no such table: Meter_Calendar
...> Error: near line 19: no such table: Meter_Calendar
...> Error: near line 20: no such table: Meter_Calendar
...> Error: near line 21: no such table: Meter_Calendar
...> Error: near line 22: no such table: Meter_Calendar
...> Error: near line 23: no such table: Meter_Calendar
...> Error: near line 24: no such table: Meter_Calendar
...> Error: near line 25: no such table: Meter_Calendar
...> Error: near line 26: no such table: Meter_Calendar
...> Error: near line 27: no such table: Meter_Calendar
...> Error: near line 28: no such table: Meter_Calendar
...> Error: near line 29: no such table: Meter_Calendar
...> Error: near line 30: no such table: Meter_Calendar
...> Error: near line 31: no such table: Meter_Calendar
...>
...> sqlite>
][/code]

OK c'est une erreur de ma part ici , il fallait taper :

- ouvrir la base de données avec sqlite3 :
ensuite exécuter le fichier sql manuellement :

Ca devrai être mieux.
Colle la log ici.

A+

voici le log[code
# /home/pi/EAU/updateConsoEau.sh 2015 07

- PART 1 Get the data from website for 2015-07

/home/pi/EAU/2015-07.dat generated

- PART 2 Update .dat file

/home/pi/EAU/2015-07.dat Updated

- PART 3 Generate SQL
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-01'; INSE RT INTO `Meter_Calendar` VALUES ('888', '36.2', '470.497', '2015-07-01' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-02'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.9', '470.845', '2015-07-02' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-03'; INSE RT INTO `Meter_Calendar` VALUES ('888', '17.9', '471.024', '2015-07-03' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-04'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.2', '471.366', '2015-07-04' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-05'; INSE RT INTO `Meter_Calendar` VALUES ('888', '29.2', '471.658', '2015-07-05' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-06'; INSE RT INTO `Meter_Calendar` VALUES ('888', '36.1', '472.019', '2015-07-06' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-07'; INSE RT INTO `Meter_Calendar` VALUES ('888', '33.4', '472.353', '2015-07-07' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-08'; INSE RT INTO `Meter_Calendar` VALUES ('888', '47', '472.823', '2015-07-08' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-09'; INSE RT INTO `Meter_Calendar` VALUES ('888', '72', '473.543', '2015-07-09' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-10'; INSE RT INTO `Meter_Calendar` VALUES ('888', '72', '474.264', '2015-07-10' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-11'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.2', '474.576', '2015-07-11' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-12'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.9', '474.895', '2015-07-12' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-13'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.9', '475.215', '2015-07-13' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-14'; INSE RT INTO `Meter_Calendar` VALUES ('888', '31.1', '475.526', '2015-07-14' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-15'; INSE RT INTO `Meter_Calendar` VALUES ('888', '40.7', '475.934', '2015-07-15' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-16'; INSE RT INTO `Meter_Calendar` VALUES ('888', '32', '476.254', '2015-07-16' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-17'; INSE RT INTO `Meter_Calendar` VALUES ('888', '41.6', '476.67', '2015-07-17' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-18'; INSE RT INTO `Meter_Calendar` VALUES ('888', '27.6', '476.946', '2015-07-18' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-19'; INSE RT INTO `Meter_Calendar` VALUES ('888', '30.2', '477.248', '2015-07-19' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-20'; INSE RT INTO `Meter_Calendar` VALUES ('888', '57.5', '477.823', '2015-07-20' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-21'; INSE RT INTO `Meter_Calendar` VALUES ('888', '81.8', '478.642', '2015-07-21' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-22'; INSE RT INTO `Meter_Calendar` VALUES ('888', '25.9', '478.9', '2015-07-22' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-23'; INSE RT INTO `Meter_Calendar` VALUES ('888', '26.3', '479.163', '2015-07-23' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-24'; INSE RT INTO `Meter_Calendar` VALUES ('888', '30.7', '479.47', '2015-07-24' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-25'; INSE RT INTO `Meter_Calendar` VALUES ('888', '21', '479.68', '2015-07-25' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-26'; INSE RT INTO `Meter_Calendar` VALUES ('888', '17.3', '479.853', '2015-07-26' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-27'; INSE RT INTO `Meter_Calendar` VALUES ('888', '28.8', '480.142', '2015-07-27' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-28'; INSE RT INTO `Meter_Calendar` VALUES ('888', '40.8', '480.55', '2015-07-28' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-29'; INSE RT INTO `Meter_Calendar` VALUES ('888', '39.2', '480.942', '2015-07-29' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-30'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.6', '481.289', '2015-07-30' );
DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-31'; INSE RT INTO `Meter_Calendar` VALUES ('888', '34.6', '481.635]]', '2015-07-31' );
update DeviceStatus set lastupdate = '2015-07-31 12:41:17' where id = 888;

- PART 4 Update the db

File size is NOT zero -> DB update needed
Stoping Domoticz !
Domoticz stopped
Update DB START
Update Values
Update Status
Update DB END
Starting Domoticz !
2015-09-17 12:41:30.088 Domoticz V2.3011 (c)2012-2015 GizMoCuz
2015-09-17 12:41:30.089 Build Hash: 765fe41, Date: 2015-09-13 08:04:58
2015-09-17 12:41:30.091 System: Raspberry Pi
2015-09-17 12:41:30.092 Startup Path: /home/pi/domoticz/
domoticz: Domoticz is starting up....
Domoticz started

### END ###

# sudo /etc/init.d/domoticz.sh stop
# sqlite3 /home/pi/domoticz/domoticz.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read /home/pi/EAU/previous.generated.2015-07.sql

sqlite> .quit
# sudo /etc/init.d/domoticz.sh start
2015-09-17 12:42:49.212 Domoticz V2.3011 (c)2012-2015 GizMoCuz
2015-09-17 12:42:49.214 Build Hash: 765fe41, Date: 2015-09-13 08:04:58
2015-09-17 12:42:49.215 System: Raspberry Pi
2015-09-17 12:42:49.217 Startup Path: /home/pi/domoticz/
domoticz: Domoticz is starting up....
][/code]

Dans le lignes sql il semble y avoir des espaces entre le E et le R dans INSE RT:

DELETE FROM `Meter_Calendar` WHERE devicerowid=888 and date = '2015-07-24'; INSE RT INTO`Meter_Calendar` VALUES ('888', '30.7', '479.47', '2015-07-24' );


c'est pareil sur le fichier sql ? le probleme vient peu etre de là ?

Tu as des données si tu fait :
Sinon ton device est bien configuré ? voir ici : http://domotique.web2diz.net/?p=138

Tu peux poster le contenu de l'url suivante :

http: //<IP>:<PORT>/json.htm?type=devices&rid=888

voici mon script comme tu vois j ai recréé un compteur quand a url elle marche pas

Ok !

je penses que ton problème viens de cette/ces ligne(s) :

890|32.2|493.571]]|2015-08-31

peux tu tester ceci :
tu arrete domoticz et tu colles le résultat ici .

Une fois domoticz redémarré tu regardes la page des compteurs si il n'y a pas du mieux...

Tu as bien la dernière version du script qui date du 28/10 ?

A+

la commande ne marche pas

voici le contenu de l'url suivante :

http://192.168.0.30:8080/json.htm?type=devices&rid=890

Pour la comande c'est une faute de frape il faut tapper :
sqlite > delete from Meter_Calendar where Counter like '%]]%'

C'est bizarre on dirait qu'il y a des information supplémentaires sur ton compteur ...
(le tien à gauche)
j’avoue que la je seche un peu, pourtant ca fonctione chez pas mal de personne...

Hello!!

J'ai remarqué un truc bizzare depuis l'une des dernieres mises à jour. Dans mes logs mes valeurs s'affichaient avant en metre/cube. Maontenant les valeurs s'affichent en litres?????
Quelqu'un d'autres a t'il ce meme comportement???

Avant l'affichage était pourtant correct:


J'ai vérifier dans les paramètres mais rien de ce coté

Salut,

et le valeur te sembles correctes par rapport à ta consommation réelle ?

Voici ma page de réglage pour les compteur, je ne vois pas la possibilité (pour moi) de régler l'unité pour la consommation d'eau. C'est peut être le cas pour toi ?