database disk image is malformed
Posted: Thursday 29 March 2018 21:23
Dear all,
I have this issue for some time. Today i decided to switch to a new SD card on my Pi3. Full new install and restored the backup from my previous installation.
Now i still get multiple messages the database disk image is malformed.
I already searched to forum but the original post with the exaxt same problem doesn't exist anymore?
http://www.domoticz.com/forum/viewtopic ... 861#p26470
2018-03-29 21:20:01.011 Error: SQL Query("DELETE FROM Temperature WHERE strftime('%s',datetime('now','localtime')) - strftime('%s',Date) > (SELECT p.nValue * 86400 From Preferences AS p WHERE p.Key='5MinuteHistoryDays')") : database disk image is malformed
2018-03-29 21:20:01.103 Error: SQL Query("DELETE FROM Meter WHERE strftime('%s',datetime('now','localtime')) - strftime('%s',Date) > (SELECT p.nValue * 86400 From Preferences AS p WHERE p.Key='5MinuteHistoryDays')") : database disk image is malformed
Can somebody help me with this?
I have this issue for some time. Today i decided to switch to a new SD card on my Pi3. Full new install and restored the backup from my previous installation.
Now i still get multiple messages the database disk image is malformed.
I already searched to forum but the original post with the exaxt same problem doesn't exist anymore?
http://www.domoticz.com/forum/viewtopic ... 861#p26470
2018-03-29 21:20:01.011 Error: SQL Query("DELETE FROM Temperature WHERE strftime('%s',datetime('now','localtime')) - strftime('%s',Date) > (SELECT p.nValue * 86400 From Preferences AS p WHERE p.Key='5MinuteHistoryDays')") : database disk image is malformed
2018-03-29 21:20:01.103 Error: SQL Query("DELETE FROM Meter WHERE strftime('%s',datetime('now','localtime')) - strftime('%s',Date) > (SELECT p.nValue * 86400 From Preferences AS p WHERE p.Key='5MinuteHistoryDays')") : database disk image is malformed
Can somebody help me with this?