Power meter counter reset

Moderator: leecollings

Post Reply
DaanT
Posts: 14
Joined: Friday 23 August 2019 10:11
Target OS: Windows
Domoticz version: 2020.2
Location: Belgium
Contact:

Power meter counter reset

Post by DaanT »

Hi,

I was looking at my power consumption and saw a very high usage. Seems like the counter got reset and therefor gave me a very high usage.
Is there any way to correct this jump?

Kind regards
Daan
Attachments
graph.PNG
graph.PNG (47.91 KiB) Viewed 2505 times
log.PNG
log.PNG (20.29 KiB) Viewed 2505 times
User avatar
FireWizard
Posts: 1745
Joined: Tuesday 25 December 2018 12:11
Target OS: Raspberry Pi / ODroid
Domoticz version: Beta
Location: Voorthuizen (NL)
Contact:

Re: Power meter counter reset

Post by FireWizard »

Hi,

Point with your mouse to the value, you want to remove and press the "Shift" + "Left Mouse Key".

That should do the trick.

Regards
DaanT
Posts: 14
Joined: Friday 23 August 2019 10:11
Target OS: Windows
Domoticz version: 2020.2
Location: Belgium
Contact:

Re: Power meter counter reset

Post by DaanT »

Thank you FireWizard.

Kind regards
DaanT
arnaudarduino
Posts: 21
Joined: Wednesday 06 July 2016 22:31
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Power meter counter reset

Post by arnaudarduino »

I have that to, but when klik on it ,ask me to remove. But is not going away.
Somthing with rights or so?
woodbury1379
Posts: 1
Joined: Monday 23 March 2020 15:01
Target OS: OS X
Domoticz version:
Contact:

Re: Power meter counter reset

Post by woodbury1379 »

arnaudarduino wrote: Thursday 26 September 2019 19:24 I have that to, but when klik on it ,ask me to remove McDVOICE
. But is not going away.
Somthing with rights or so?
I think so there is something with rights
maxim009
Posts: 10
Joined: Sunday 24 January 2021 20:37
Target OS: Linux
Domoticz version:
Location: Czech Republic
Contact:

Re: Power meter counter reset

Post by maxim009 »

Hello, I have same problem - so high consumption after counter reset. I've tried SHIFT+"left/right click", and a lot of another combinations and no action. I've clicked on value row and also in graph and nothing happend. Where should I click? Some special setting? (I think I'm the only one administrator of my Domoticz :-) ). Thanks in advance for some hint.
Attachments
Výběr_001.png
Výběr_001.png (90.17 KiB) Viewed 1084 times
User avatar
erem
Posts: 230
Joined: Tuesday 27 March 2018 12:11
Target OS: Raspberry Pi / ODroid
Domoticz version: 2021.1
Location: Amsterdam/netherlands
Contact:

Re: Power meter counter reset

Post by erem »

you can edit the database directly using sqlite3, or if you are on *nix, use sqlitebrowser.
the table containing the offending entry is multimeter_calender.
- stop domoticz
- reset the value to whatever you want
start domoticz
Regards,

Rob
User avatar
waltervl
Posts: 5149
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Power meter counter reset

Post by waltervl »

maxim009 wrote: Tuesday 16 March 2021 7:40 Hello, I have same problem - so high consumption after counter reset. I've tried SHIFT+"left/right click", and a lot of another combinations and no action. I've clicked on value row and also in graph and nothing happend. Where should I click? Some special setting? (I think I'm the only one administrator of my Domoticz :-) ). Thanks in advance for some hint.
That delete function with Shift-left click is only working in the graphs on device log page and not in the device report page. Your screenshot shows the report page..... https://www.domoticz.com/wiki/Managing_ ... Device_Log
So if you want to remove a really old value, older than 1 year, you have to remove it from the database manually.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
maxim009
Posts: 10
Joined: Sunday 24 January 2021 20:37
Target OS: Linux
Domoticz version:
Location: Czech Republic
Contact:

Re: Power meter counter reset

Post by maxim009 »

waltervl wrote: Tuesday 16 March 2021 14:35 That delete function with Shift-left click is only working in the graphs on device log page and not in the device report page. Your screenshot shows the report page..... https://www.domoticz.com/wiki/Managing_ ... Device_Log
So if you want to remove a really old value, older than 1 year, you have to remove it from the database manually.
.. thank you @waltervl - yes, that's it - I was on report page.

erem wrote: Tuesday 16 March 2021 13:57 you can edit the database directly using sqlite3, or if you are on *nix, use sqlitebrowser.
the table containing the offending entry is multimeter_calender.
- stop domoticz
- reset the value to whatever you want
start domoticz
.. thank you @erem - I've edited database directly by sqlitebrowser.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest