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 | ||
| + | </ | ||
| + | |||
| + | |||
| + | |||