Have had hd problems - when em loads checks database etc - says all ok then loads headers but no details

Jon_Hollingworth · March 7, 2015, 11:26am

eM Client (6.0.21372.0)
Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 4.0.30319.34209
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
SQL logic error or missing database
 at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
 at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
 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 MailClient.Storage.Data.SQLite.DbMailRepository.RemoveOids[ST](Object senderContext, String oidList, IEnumerable1 items)    at MailClient.Storage.Data.SQLite.DbRepository1.RemoveByItems[ST](Object senderContext, IEnumerable1 items)    at MailClient.Storage.Data.SQLite.DbRepository1.Remove[ST](Object senderContext, IEnumerable1 items)    at MailClient.RepositoryExtensions.Remove[T,ST](IRepository1 repository, IEnumerable1 items)    at MailClient.Imap.Synchronizer.DeleteNonuploadedItems()    at MailClient.Imap.Synchronizer.GoOnline()    at MailClient.Imap.ImapAccount.GoOnlineInt()    at MailClient.Protocols.Common.SynchronizableAccount.ChangeOnlineState(Boolean online, OfflineReason offlineReason)    at MailClient.Protocols.Common.SynchronizableAccount.GoOnline()    at MailClient.Accounts.MailAccount.GoOnline()    at MailClient.Accounts.AccountManager.TryGoOnline(IAccount account, AccountCountRestriction countRestriction, Boolean showWarning)    at MailClient.Accounts.AccountManager.SetOnlineState(Boolean toOnline, OfflineReason offlineReason)    at MailClient.Accounts.AccountManager.<initializeonlinemode>b__0(Object param0) at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() at System.Threading.ThreadPoolWorkQueue.Dispatch() at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback() <report xmlns="<a href=" http:>" rel="nofollow" target="_blank">http://emclient.com/ns/report">; <product> <name>eM Client</name> <version>6.0.21372.0</version> </product> <silent>false</silent> <environment> <osversion>Microsoft Windows NT 6.1.7601 Service Pack 1</osversion> <frameworkversion>4.0.30319.34209</frameworkversion> </environment> <exception> <type>System.Data.SQLite.SQLiteException</type> <message>SQL logic error or missing database SQL logic error or missing database</message> <source>System.Data.SQLite</source> <stack> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663598</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLite3</type> <name>Reset</name> <parameters> <parameter> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteStatement</type> <name>stmt</name> </parameter> </parameters> </method> <offset>83</offset> <nativeoffset>2c172</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663597</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLite3</type> <name>Step</name> <parameters> <parameter> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteStatement</type> <name>stmt</name> </parameter> </parameters> </method> <offset>3c</offset> <nativeoffset>bb</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663982</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteDataReader</type> <name>NextResult</name> <parameters></parameters> </method> <offset>12f</offset> <nativeoffset>150</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663943</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteDataReader</type> <name>.ctor</name> <parameters> <parameter> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>cmd</name> </parameter> <parameter> <assembly>System.Data</assembly> <type>System.Data.CommandBehavior</type> <name>behave</name> </parameter> </parameters> </method> <offset>5d</offset> <nativeoffset>71</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663757</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>ExecuteReader</name> <parameters> <parameter> <assembly>System.Data</assembly> <type>System.Data.CommandBehavior</type> <name>behavior</name> </parameter> </parameters> </method> <offset>c</offset> <nativeoffset>26</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663760</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>ExecuteNonQuery</name> <parameters></parameters> </method> <offset>6</offset> <nativeoffset>21</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100685726</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbMailRepository</type> <name>RemoveOids</name> <genericarguments> <argument> <assembly>MailClient</assembly> <type></type> </argument> </genericarguments> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Object</type> <name>senderContext</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.String</type> <name>oidList</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type></type> <name>items</name> </parameter> </parameters> </method> <offset>22e</offset> <nativeoffset>506</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670340</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRepository1
RemoveByItems

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

151
37a

MailClient.exe
100670341
MailClient
MailClient.Storage.Data.SQLite.DbRepository`1
Remove

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

1c
9e

MailClient.exe
100670420
MailClient
MailClient.RepositoryExtensions
Remove

MailClient

MailClient

MailClient

repository

mscorlib

items

0
5f

MailClient.exe
100668432
MailClient
MailClient.Imap.Synchronizer
DeleteNonuploadedItems

2c
7e

MailClient.exe
100668441
MailClient
MailClient.Imap.Synchronizer
GoOnline

7b
eb

MailClient.exe
100689861
MailClient
MailClient.Imap.ImapAccount
GoOnlineInt

13
32

MailClient.exe
100666502
MailClient
MailClient.Protocols.Common.SynchronizableAccount
ChangeOnlineState

mscorlib
System.Boolean
online

MailClient
MailClient.Accounts.OfflineReason
offlineReason

c6
178

MailClient.exe
100666500
MailClient
MailClient.Protocols.Common.SynchronizableAccount
GoOnline

14
38

MailClient.exe
100687129
MailClient
MailClient.Accounts.MailAccount
GoOnline

Paul_Technical_Suppo · March 9, 2015, 10:25am

Hi Jon,
this unfortunately seems to be a database problem, some of your data may got corrupt and are no longer accessible for eM Client. Try to run this utility and check if the utility is able to restore your database items for eM Client, http://www.emclient.com/tools/dbrepairrebuildall.exe.

If the database repair is unsuccessful, I’m afraid it won’t be possible to restore your database items.

Do you have any local data saved within the eM Client database? You can setup a new database for the application by navigating to your user folder/App Data/Roaming and rename or remove the current eM Client database folder.

Next time you re-open the application, eM client will setup a clean database allowing you to setup your account or restore from an existing backup.

Hope this helps,
Paul