database disk is malformed

Hello I have searched on “database disk is malformed” in the “Ask a question” pane but none of the solutions helped.

There is mention of a database repair tool in https://discourse.emclient.com/emclient/to… but the link does not work.

Environment is Windows 7 fully patched and AV protected. Nothing special at all about the laptop it is very basic with just this e-mail client and MS Office. No previous problems.

I switched off as usual last night and had the error this morning - shown below.No recent back up unfortunately (I know! It seems the daily backup failed around 2 weeks ago).

System.Data.SQLite.SQLiteException: The database disk image is malformed
database disk image is malformed
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at System.Data.SQLite.SQLiteConnection.Open()
at DbRepair.DbTools.OpenConnection(String fileName)
at DbRepair.Form1.CheckCorruption()
at DbRepair.Form1.Check(Object state)

I found another link to DbRepairRebuildAll.exe at https://discourse.emclient.com/emclient/to…

I’ve downloaded it but no instructions or UI? Is it supposed to re run in the same directory as the data files?

Thanks for any help!

I ran the DbRepairRebuildAll.exe in the same directory as the data files and it gave the same errors as above.

Then I looked at sqlite in the logs directory.

entries for today are:

02/02/2013 11:15:54 11 database corruption at line 49444 of [c7c6050ef0]
02/02/2013 11:15:54 11 database corruption at line 49482 of [c7c6050ef0]
02/02/2013 11:15:54 11 statement aborts at 9: [SELECT id FROM contact_index.ContactItems WHERE ((NOT (“flags” & 65536) AND “folder” not in (SELECT “id” FROM folders.Folders WHERE (“flags” & 8))) AND “id” IN (SELECT “parentId” from c
02/02/2013 20:32:09 0 Recovered 174 frames from WAL file H:\D MSP Mail\main.dat-wal
02/02/2013 20:32:09 0 Recovered 27 frames from WAL file H:\D MSP Mail\folders.dat-wal
02/02/2013 20:32:09 11 database corruption at line 49444 of [c7c6050ef0]
02/02/2013 20:32:09 11 database corruption at line 49482 of [c7c6050ef0]
02/02/2013 20:32:09 11 statement aborts at 5: []
02/02/2013 20:32:09 11 statement aborts at 5: [ATTACH DATABASE ‘H:\D MSP Mail\folders.dat’ AS ‘folders’;] unable to open database: H:\D MSP Mail\folders.dat

Hello,
sorry for the delayed reply - are you using any backup or Archiving software? It is the most common cause of similar issues, but I am afraid the only solution is deleting of the database and creating all your accounts again.

Hello, thanks for the reply.

The back up is the in-built Windows 7 one, but as noted above it hasn’t run for some time - actually since 21st January.

I’ve reverted to that version of the database and it seems ok now. I will have to see how it goes though.