meta data for this page
Differences
This shows you the differences between two versions of the page.
home_automation:domoticz:maintenance [2016/04/25 07:48] – created niziak | home_automation:domoticz:maintenance [2023/09/12 12:45] (current) – niziak | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Maintenance ====== | ||
- | ====== SQLite database repair | + | |
+ | ===== SQLite database repair ===== | ||
<code bash> | <code bash> | ||
systemctl stop domoticz | systemctl stop domoticz | ||
Line 10: | Line 12: | ||
systemctl start domoticz | systemctl start domoticz | ||
</ | </ | ||
+ | |||
+ | ===== remove strange values form db ===== | ||
+ | |||
+ | <code bash> | ||
+ | sudo service domoticz stop | ||
+ | |||
+ | cp domoticz.db domoticz.db.bak | ||
+ | |||
+ | sqlite3 domoticz.db | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | SELECT * FROM Meter WHERE DeviceRowId=16; | ||
+ | SELECT * FROM Meter WHERE DeviceRowId=16 and Value=99999 and Date like " | ||
+ | DELETE FROM Meter WHERE DeviceRowId=16 and Value=99999 and Date like " | ||
+ | .quit | ||
+ | </ | ||
+ | |||
+ | |||
+ |