You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
@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?
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 #18 (comment)
The text was updated successfully, but these errors were encountered: