Facebook
From lukaz1987, 4 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 182
  1. https://www.domoticz.com/forum/viewtopic.php?t=26616
  2.  
  3.  
  4. Fixed ..... was a problem with the Database.
  5. Noticed this as i wanted to change a switch but changes where not taken over / saved.
  6.  
  7. Used the following solution found at: https://www.domoticz.com/forum/viewtopi ... 84#p105022
  8.  
  9. Code: Select all
  10.  
  11. apt-get install sqlite3
  12.  
  13. cd ~
  14. cd domoticz
  15. sqlite3 domoticz.db
  16. .mode insert
  17. .output dump.sql
  18. .dump
  19. .exit
  20.  
  21. sqlite3 -init dump.sql repaired.db
  22.  
  23. You can then move the domoticz.db and replace it with repaired.db (rename using: mv repaired.db domoticz.db)
  24.  
  25. After this all was running back as usual.