Hi,
I had some issues with eM Client where it didn’t shut down properly.
I then get this error on the next startup:
–
MailClient.Storage.Data.DatabaseCorruptedException (0x80004005): SQLite Error 10: ‘disk I/O error’.
Line: 66
UPDATE Conversations SET unreadCount = COALESCE((SELECT counts.count FROM unreadCounts counts WHERE counts.conversationId = Conversations.conversationId), 0)
WHERE Conversations.id IN (
SELECT c.id FROM Conversations c LEFT JOIN unreadCounts counts ON counts.conversationId=c.conversationId WHERE c.unreadCount != COALESCE(counts.count, 0)
);
at MailClient.Storage.Data.DbRepository1.ImportFromResource(IDbConnection connection, Stream myStream, CancellationToken token) at MailClient.Storage.Data.DbRepository
1.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__DisplayClass2_0.<Check>b__0(String p) at MailClient.DbRepair.PerAccountExecutor.Execute(String dataStoreLocation, Func
2 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
DatastoreLocation: E:\rayMail\eMClientFiles\
Looking at the sqllite Logs\sqlite.log, I see this:
08/02/2021 19:20:09 266 os_win.c:44458: (23) winRead(E:\eMClientFiles\f82dcdc6-4927-403d-9cee-bf32bea7237e\conversations.dat) - Data error (cyclic redundancy check).
I believe the conversations.dat is corrupt and/or I have a problem on the disk at that location. (I can’t even copy that file to a new drive, though I can move it around)
–
Things I’ve tried:
I’ve moved the file out of the emClient folder and restarted emClient
This created a new conversations.dat file
but now I’m missing all my folders where I organize my emails.
Please help, how do I get back my old emails?
Thank you.