Issue With Power Monitoring With Blank IDX

[jneilliii]

          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.

Thanks.

Originally posted by @esrpradeep in https://github.com/jneilliii/OctoPrint-Tasmota/issues/18#issuecomment-1665884834

[jneilliii]

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

Just for the reference pasting the snap of smart plug page

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?

Thanks.