The FIX::
You need to have sqlite3 installed on your Pi
CODE: SELECT ALL
sudo apt-get install sqlite3 If you have it you can do the following commands:
CODE: SELECT ALL
cd ~
cd domoticz
sqlite3 domoticz.db
.mode insert
.output dump.sql
.dump
.exit
Remove first line of dumped database:
tail dump.sql -n +2 > dump1.sql
# Make back-up of original just in case:
mv domoticz.db domoticz.bak.db
# Import into fresh database:
sqlite3 domoticz.db < dump1.sql
# Clean-up the temporary files:
rm dump*.sql
https://www.domoticz.com/forum/viewtopic.php?t=10984