====== Maintenance ======


===== SQLite database repair =====
<code bash>
systemctl stop domoticz

echo .dump | sqlite3 domoticz.db > /tmp/domoticz.sql
mv domoticz.sb domoticz.sb.bak
sqlite3 -init /tmp/domoticz.sql domoticz.sb

systemctl start domoticz
</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>