Client data base check fails "Checking for inconsistent data" - endless looping

Crashing eM Client
1

Using Windows 8.1 - eM Client Data Base starts automatically, fails check for inconsistent data.  Help?

Here’s a copy of the error log:

eM Client (6.0.20154.0)
Windows: Microsoft Windows NT 6.2.9200.0, Framework: 2.0.50727.8000
The following error has occurred:
System.Data.SQLite.SQLiteException: SQL logic error or missing database
no such table: mail_data.LocalMailContents
   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.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at MailClient.Storage.Data.SQLite.DbMailRepository.LoadMimePart(UInt64 messageId)
   at MailClient.Storage.Data.SQLite.DbRootMimePart.Load()
   at MailClient.Storage.Data.SQLite.DbRootMimePart.get_ContentType()
   at MailClient.UI.Mail.SMimeDecoder.isSmime(IMimePart mimeStructure)
   at MailClient.UI.Controls.controlMessageDetail.RefreshMessage()
   at MailClient.UI.Controls.controlMessageDetail.Refresh(IMail mail)
   at MailClient.UI.Controls.controlMessageDetail.Refresh(IMail mail, Boolean autoMarkAsRead)
   at MailClient.UI.Controls.controlMessages.MailItemBehaviour.selectTimer_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.Run(ApplicationContext context)
   at MailClient.Program.b__4()
at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action`1 handler)

" rel=“nofollow”>http://emclient.com/ns/report">;

eM Client
6.0.20154.0

false

Microsoft Windows NT 6.2.9200.0
2.0.50727.8000


System.Data.SQLite.SQLiteException
SQL logic error or missing database
no such table: mail_data.LocalMailContents
System.Data.SQLite




System.Data.SQLite.dll
100663600
System.Data.SQLite
System.Data.SQLite.SQLite3
Prepare


System.Data.SQLite
System.Data.SQLite.SQLiteConnection
cnn


mscorlib
System.String
strSql


System.Data.SQLite
System.Data.SQLite.SQLiteStatement
previous


mscorlib
System.UInt32
timeoutMS


mscorlib
System.String&
strRemain



265
551




System.Data.SQLite.dll
100663734
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
BuildNextCommand


f6
146




System.Data.SQLite.dll
100663735
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
GetStatement


mscorlib
System.Int32
index



8
12




System.Data.SQLite.dll
100663982
System.Data.SQLite
System.Data.SQLite.SQLiteDataReader
NextResult


e4
118




System.Data.SQLite.dll
100663943
System.Data.SQLite
System.Data.SQLite.SQLiteDataReader
.ctor


System.Data.SQLite
System.Data.SQLite.SQLiteCommand
cmd


System.Data
System.Data.CommandBehavior
behave



5d
7a




System.Data.SQLite.dll
100663757
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteReader


System.Data
System.Data.CommandBehavior
behavior



c
26




System.Data.SQLite.dll
100663756
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteDbDataReader


System.Data
System.Data.CommandBehavior
behavior



0
4




System.Data.dll
100668155
System.Data
System.Data.Common.DbCommand
System.Data.IDbCommand.ExecuteReader


0
c




MailClient.exe
100685477
MailClient
MailClient.Storage.Data.SQLite.DbMailRepository
LoadMimePart


mscorlib
System.UInt64
messageId



3c
be




MailClient.exe
100677587
MailClient
MailClient.Storage.Data.SQLite.DbRootMimePart
Load


24
45




MailClient.exe
100677593
MailClient
MailClient.Storage.Data.SQLite.DbRootMimePart
get_ContentType


0
7




MailClient.exe
100681956
MailClient
MailClient.UI.Mail.SMimeDecoder
isSmime


MailClient.Mail
MailClient.Mail.IMimePart
mimeStructure



0
27




MailClient.exe
100691138
MailClient
MailClient.UI.Controls.controlMessageDetail
RefreshMessage


73
de




MailClient.exe
100691137
MailClient
MailClient.UI.Controls.controlMessageDetail
Refresh


MailClient.Mail
MailClient.Mail.IMail
mail



5c
be




MailClient.exe
100691136
MailClient
MailClient.UI.Controls.controlMessageDetail
Refresh


MailClient.Mail
MailClient.Mail.IMail
mail


mscorlib
System.Boolean
autoMarkAsRead



7
1c




MailClient.exe
100691314
MailClient
MailClient.UI.Controls.controlMessages+MailItemBehaviour
selectTimer_Tick


mscorlib
System.Object
sender


mscorlib
System.EventArgs
e



b
6a




System.Windows.Forms.dll
100685248
System.Windows.Forms
System.Windows.Forms.Timer
OnTick


mscorlib
System.EventArgs
e



8
16




System.Windows.Forms.dll
100685264
System.Windows.Forms
System.Windows.Forms.Timer+TimerNativeWindow
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



20
33




System.Windows.Forms.dll
100669134
System.Windows.Forms
System.Windows.Forms.NativeWindow
DebuggableCallback


mscorlib
System.IntPtr
hWnd


mscorlib
System.Int32
msg


mscorlib
System.IntPtr
wparam


mscorlib
System.IntPtr
lparam



25
56




System.Windows.Forms.dll
100664725
System.Windows.Forms
System.Windows.Forms.UnsafeNativeMethods
DispatchMessageW


System.Windows.Forms
System.Windows.Forms.NativeMethods+MSG&
msg



ffffffff
0




System.Windows.Forms.dll
100668154
System.Windows.Forms
System.Windows.Forms.Application+ComponentManager
System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop


mscorlib
System.Int32
dwComponentID


mscorlib
System.Int32
reason


mscorlib
System.Int32
pvLoopData



17c
24d




System.Windows.Forms.dll
100668201
System.Windows.Forms
System.Windows.Forms.Application+ThreadContext
RunMessageLoopInner


mscorlib
System.Int32
reason


System.Windows.Forms
System.Windows.Forms.ApplicationContext
context



1de
176




System.Windows.Forms.dll
100668200
System.Windows.Forms
System.Windows.Forms.Application+ThreadContext
RunMessageLoop


mscorlib
System.Int32
reason


System.Windows.Forms
System.Windows.Forms.ApplicationContext
context



13
60




System.Windows.Forms.dll
100668126
System.Windows.Forms
System.Windows.Forms.Application
Run


System.Windows.Forms
System.Windows.Forms.ApplicationContext
context



0
17




MailClient.exe
100675632
MailClient
MailClient.Program
<Main>b__4


17
43




MailClient.ExceptionUtils.dll
100663314
MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils
Filter


MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils+BodyDelegate
body


MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils+FilterDelegate
filter


mscorlib
System.Action`1[[System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
handler



0
28



183




MailClient.exe
C:\Program Files (x86)\eM Client\MailClient.exe
MailClient.exe
MailClient.exe
6.0.20154.0
eM Client
eM Client
6.0.20154.0
False
False
False
False
False
Language Neutral


ntdll.dll
C:\WINDOWS\SYSTEM32\ntdll.dll
ntdll.dll
ntdll.dll.mui
6.3.9600.17031 (winblue_gdr.140221-1952)
NT Layer DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)


MSCOREE.DLL
C:\WINDOWS\SYSTEM32\MSCOREE.DLL
mscoree.dll
mscoree.dll
6.3.9600.16384 (winblue_rtm.130821-1623)
Microsoft .NET Runtime Execution Engine
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)


KERNEL32.dll
C:\WINDOWS\SYSTEM32\KERNEL32.dll
kernel32
kernel32
6.3.9600.17031 (winblue_gdr.140221-1952)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)


KERNELBASE.dll
C:\WINDOWS\SYSTEM32\KERNELBASE.dll
Kernelbase.dll
Kernelbase.dll.mui
6.3.9600.17031 (winblue_gdr.140221-1952)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.3.9600.17031
False
False
False
False
False
English (United States)


ADVAPI32.dll
C:\WINDOWS\SYSTEM32\ADVAPI32.dll
advapi32.dll
advapi32.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Advanced Windows 32 Base API
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)


msvcrt.dll
C:\WINDOWS\SYSTEM32\msvcrt.dll
msvcrt.dll
msvcrt.dll
7.0.9600.16384 (winblue_rtm.130821-1623)
Windows NT CRT DLL
Microsoft® Windows® Operating System
7.0.9600.16384
False
False
False
False
False
English (United States)


sechost.dll
C:\WINDOWS\SYSTEM32\sechost.dll
sechost.dll
sechost.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Host for SCM/SDDL/LSA Lookup APIs
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)


RPCRT4.dll
C:\WINDOWS\SYSTEM32\RPCRT4.dll
rpcrt4.dll
rpcrt4.dll.mui
6.3.9600.16384 (winblue_rtm.130821-1623)
Remote Procedure Call Runtime
Microsoft® Windows® Operating System
6.3.9600.16384
False
False
False
False
False
English (United States)


SspiCli.dll
C:\WINDOWS\SYSTEM32\SspiCli.dll
security.dll
security.dll
6.3.9600.16408 (winblue_gdr.130920-1803)
Security Support Provider Interface
Microsoft® Windows® Operating System
&nb

2

Hi,
unfortunately there’s not much to do to fix this issue.
Your database files are corrupt, or missing.

You have to go to your Local folder > App Data > Roaming and delete the eM Client’s database folder, when you open eM Client after you do this, you’ll have a clean database and you’ll have to go through the setup again.

Do you have a backup of your database? Are you using IMAP accounts?

Thank you, sorry for the inconvenience,
Paul.