database disk image is malformed Topic is solved

[jjnj]

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?

[waaren]

viewtopic.php?t=10984

[jannl]

Normally a csv export import fixes this. Please search the forum (or internet) for the exact steps