Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue With Power Monitoring With Blank IDX #201

Open
jneilliii opened this issue Aug 4, 2023 · 1 comment
Open

Issue With Power Monitoring With Blank IDX #201

jneilliii opened this issue Aug 4, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@jneilliii
Copy link
Owner

          I found out the problem!

I opened the energy_data.db using 'DB Browser for SQLite.exe' (https://sqlitebrowser.org/dl/) and noticed the value of 'idx' was empty in the entire column. Since 'idx' was left blank/empty to make the Tasmota switch to work.

'Index
Index of the relay, specifically used for multiple plug relay devices. Leave blank for single relay devices.'

So I manually edited the column for the field 'idx' to '1' in the db. Also, for some reason, the 'total' field was also blank so made it all to '0'. Then I pushed it back to the same location in the pi.
(~/.octoprint/data/tasmota/energy_data.db).

After a refresh, Voilà the graph worked!

I'm sure you can fix this issue! Please help with the same.

image
image

Thanks.

Originally posted by @esrpradeep in #18 (comment)

@jneilliii jneilliii added the bug Something isn't working label Aug 4, 2023
@jneilliii
Copy link
Owner Author

@esrpradeep, please keep the comments in this thread. not the other issue.

below copied from other issue thread...

I found another related problem for the data getting stored to "energy_data.db".

In the Octoprint - using the Tasmota plugin, I can see all these values...

image

Just for the reference pasting the snap of smart plug page

image

But when I open the "energy_data.db" using SQL Lite, I see the "total" as "NULL". I don't why it is getting populating as 'NULL' if there is a valid Total Energy consumption value read by 'Tasmota Plugin'. Is it also related 'idx' value?

image

Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant