Hi,
I’m using emClient since June 2022, back then I have imported all my emails from Outlook and all was great until last October when emClient database became corrupted, I did not have recent backup so I have lost about 5 months of emails, lesson learn and weekly backup enabled.
Since October emClient seem to have corrupted database every 4-8 weeks but usually restoring from backup fixes emClient for next few weeks, today how ever this is not working, I’m getting errors and recovery doesn’t work either, I am getting following today:
MailClient.Storage.Data.DatabaseCorruptedException (0x80004005): SQLite Error 11: ‘database disk image is malformed’.
Line: 7
DELETE FROM MailItems WHERE (SELECT COUNT(*) FROM “MailAddresses” WHERE parentId=MailItems.id AND “type” <= 3) <> 3;
at MailClient.Storage.Data.DbRepository1.ImportFromResource(IDbConnection connection, Stream myStream, CancellationToken token) at MailClient.Storage.Data.DbRepository1.ImportFromManifestResource(String resourceName, CancellationToken token)
at MailClient.Storage.Data.DbRepository1.Repair(RepairMode mode, CancellationToken token) at MailClient.Accounts.ItemRepositories.Repair(RepairMode mode, CancellationToken token) at MailClient.DbRepair.ConsistencyChecker.CheckConsistencyForAccount(String accountDirectory, RepairMode mode, CancellationToken token) at MailClient.DbRepair.ConsistencyChecker.<>c__DisplayClass3_0.<Check>b__0(String p) at MailClient.DbRepair.PerAccountExecutor.Execute(String dataStoreLocation, Func2 action)
at MailClient.DbRepair.ConsistencyChecker.Check(RepairMode mode, CancellationToken token)
at MailClient.DbRepair.CheckingProcess.Check(CancellationToken token)
Data:
ResourceName: MailClient.Storage.Mail.Data.DbMailRepository.consistency.sql
after restore:
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘no such rowid: 2456’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteBlob…ctor(SqliteConnection connection, String databaseName, String tableName, String columnName, Int64 rowid, Boolean readOnly)
at MailClient.Storage.Data.DatabaseCopyTool.CopyContents(Table table, Boolean sortDesc)
at MailClient.Storage.Data.DatabaseCopyTool.CopyTableData(Table table)
at MailClient.Storage.Data.DatabaseCopyTool.CopyInternal(String specificTable, Boolean copyIndexesViewsAndTriggers)
at MailClient.DbRepair.CorruptionChecker.CheckCorruption(RepairOptions repairOptions, CancellationToken token)
at MailClient.DbRepair.CheckingProcess.Check(CancellationToken token)
Data:
Table: LocalMailsIndex3_docsize
databaseFile: fb6f9f71-3ee7-4bbc-943b-0d4f52bc4a47\mail_fti.dat
Deleting “AppData\Roaming\eM Client” does not work either.
Is there a way of fixing it, or importing emClient backup back to Outlook?
Thanks,
Tom