meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

home_automation:domoticz:maintenance [2016/04/25 07:48] – created niziakhome_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
 </code> </code>
 +
 +===== remove strange values form db =====
 +
 +<code bash>
 +sudo service domoticz stop
 +
 +cp domoticz.db domoticz.db.bak
 +
 +sqlite3 domoticz.db
 +</code>
 +
 +<code sql>
 +SELECT * FROM Meter WHERE DeviceRowId=16;
 +SELECT * FROM Meter WHERE DeviceRowId=16 and Value=99999 and Date like "2023-08-16 22:%";
 +DELETE FROM Meter WHERE DeviceRowId=16 and Value=99999 and Date like "2023-08-16 22:%";
 +.quit
 +</code>
 +
 +
 +