em client in loop

Paul_sprain · November 4, 2015, 5:09pm

eM Client (6.0.23421.0)Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 4.0.30319.18063
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such table: mail_fti.SubjectIndex
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.ExecuteScalar()
at MailClient.Storage.Data.SQLite.DbMailRepository.Store(IMailRepositoryItem mail)
at MailClient.Storage.Data.SQLite.DbRepository1.Add[ST](Object senderContext, IEnumerable1 items, Action1 storeCallback)    at MailClient.Storage.Data.SQLite.DbRepository1.Add[ST](Object senderContext, IEnumerable1 items)    at MailClient.RepositoryExtensions.Add[T,ST](IRepository1 repository, IEnumerable`1 items)
at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.FetchNewMessages(ConnectionContext context, String selectPath, UInt32 idLow, UInt32 idHigh, String idList, Boolean useUid, UInt32 messageCountEstimate)
at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.ExecuteInternal(WorkerStatus status)
at MailClient.Imap.Synchronizer.ImapCommand.Execute(WorkerStatus status)
at MailClient.Commands.Command.Process(WorkerStatus status)
at MailClient.Commands.SynchronizationQueue.ThreadWorker(Object threadData)
at System.Threading.ThreadHelper.ThreadStart_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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)

" rel=“nofollow” target="_blank">
System.Data.SQLite.dll

System.Data.SQLite.dll

System.Data.SQLite.dll

System.Data.SQLite.dll

System.Data.SQLite.dll

System.Data.SQLite.dll

System.Data.SQLite.dll

MailClient.exe

MailClient.exe

MailClient.exe

MailClient.exe

MailClient.exe

MailClient.exe

MailClient.exe

MailClient.exe

mscorlib.dll

mscorlib.dll

mscorlib.dll

mscorlib.dll

mscorlib.dll
href="http://emclient.com/ns/report" class="inline-onebox-loading" rel="nofollow noopener">http://emclient.com/ns/report">;

eM Client
6.0.23421.0

false

Microsoft Windows NT 6.1.7601 Service Pack 1
4.0.30319.18063

System.Data.SQLite.SQLiteException
SQL logic error or missing database
no such table: mail_fti.SubjectIndex
System.Data.SQLite

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
4b2

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

f6
17f

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

mscorlib
System.Int32
index

8
12

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

e4
112

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

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

System.Data
System.Data.CommandBehavior
behave

5d
71

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

System.Data
System.Data.CommandBehavior
behavior

c
26

100663761
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteScalar

6
21

100685659
MailClient
MailClient.Storage.Data.SQLite.DbMailRepository
Store

MailClient
MailClient.Storage.Data.IMailRepositoryItem
mail

42e
a1f

100670223
MailClient
MailClient.Storage.Data.SQLite.DbRepository1</type> <name>Add</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></type> <name>items</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type></type> <name>storeCallback</name> </parameter> </parameters> </method> <offset>d5</offset> <nativeoffset>237</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670222</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRepository1
Add

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

0
39

100670304
MailClient
MailClient.RepositoryExtensions
Add

MailClient

MailClient

MailClient

repository

mscorlib

items

0
5f

100668630
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
FetchNewMessages

MailClient
MailClient.Imap.ConnectionContext
context

mscorlib
System.String
selectPath

mscorlib
System.UInt32
idLow

mscorlib
System.UInt32
idHigh

mscorlib
System.String
idList

mscorlib
System.Boolean
useUid

mscorlib
System.UInt32
messageCountEstimate

20b
4bf

100668628
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
ExecuteInternal

MailClient
MailClient.Commands.WorkerStatus
status

185
3e9

100668462
MailClient
MailClient.Imap.Synchronizer+ImapCommand
Execute

MailClient
MailClient.Commands.WorkerStatus
status

0
1d

100664033
MailClient
MailClient.Commands.Command
Process

MailClient
MailClient.Commands.WorkerStatus
status

15
53

100664086
MailClient
MailClient.Commands.SynchronizationQueue
ThreadWorker

mscorlib
System.Object
threadData

8c
11a

100669195
mscorlib
System.Threading.ThreadHelper
ThreadStart_Context

mscorlib
System.Object
state

25
9b

100668963
mscorlib
System.Threading.ExecutionContext
RunInternal

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

mscorlib
System.Boolean
preserveSyncCtx

70
a6

100668962
mscorlib
System.Threading.ExecutionContext
Run

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

mscorlib
System.Boolean
preserveSyncCtx

0
15

100668961
mscorlib
System.Threading.ExecutionContext
Run

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

2b
40

100669192
mscorlib
System.Threading.ThreadHelper
ThreadStart

mscorlib
System.Object
obj

f
4d

0

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

ntdll.dll
C:\Windows\SysWOW64\ntdll.dll
ntdll.dll
ntdll.dll.mui
6.1.7600.16385 (win7_rtm.090713-1255)
NT Layer DLL
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

MSCOREE.DLL
C:\Windows\SYSTEM32\MSCOREE.DLL
mscoree.dll
mscoree.dll
4.0.40305.0 (Main.040305-0000)
Microsoft .NET Runtime Execution Engine
Microsoft® .NET Framework
4.0.40305.0
False
False
False
True
False
English (United States)

KERNEL32.dll
C:\Windows\syswow64\KERNEL32.dll
kernel32
kernel32
6.1.7601.17965 (win7sp1_gdr.121004-0333)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.1.7601.17965
False
False
False
False
False
English (United States)

KERNELBASE.dll
C:\Windows\syswow64\KERNELBASE.dll
Kernelbase
Kernelbase
6.1.7601.17965 (win7sp1_gdr.121004-0333)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.1.7601.17965
False
False
False
False
False
English (United States)

ADVAPI32.dll
C:\Windows\syswow64\ADVAPI32.dll
advapi32.dll
advapi32.dll.mui
6.1.7600.16385 (win7_rtm.090713-1255)
Advanced Windows 32 Base API
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

msvcrt.dll
C:\Windows\syswow64\msvcrt.dll
msvcrt.dll
msvcrt.dll
7.0.7601.17744 (win7sp1_gdr.111215-1535)
Windows NT CRT DLL
Microsoft® Windows® Operating System
7.0.7601.17744
False
False
False
False
False
English (United States)

sechost.dll
C:\Windows\SysWOW64\sechost.dll
sechost.dll
sechost.dll.mui
6.1.7600.16385 (win7_rtm.090713-1255)
Host for SCM/SDDL/LSA Lookup APIs
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

RPCRT4.dll
C:\Windows\syswow64\RPCRT4.dll
rpcrt4.dll
rpcrt4.dll.mui
6.1.7600.16385 (win7_rtm.090713-1255)
Remote Procedure Call Runtime
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

SspiCli.dll
C:\Windows\syswow64\SspiCli.dll
security.dll
security.dll
6.1.7601.19007 (win7sp1_gdr.150915-0600)
Security Support Provider Interface
Microsoft® Windows® Operating System
6.1.7601.19007
False
False
False
False
False
English (United States)

CRYPTBASE.dll
C:\Windows\syswow64\CRYPTBASE.dll
cryptbase.dll
cryptbase.dll
6.1.7601.19018 (win7sp1_gdr.150928-1507)
Base cryptographic API DLL
Microsoft® Windows® Operating System
6.1.7601.19018
False
False
False
False
False
English (United States)

mscoreei.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll
mscoreei.dll
mscoreei.dll
4.0.30319.17929 built by: FX45RTMREL
Microsoft .NET Runtime Execution Engine
Microsoft® .NET Framework
4.0.30319.17929
False
False
False
True
False
English (United States)

SHLWAPI.dll
C:\Windows\syswow64\SHLWAPI.dll
SHLWAPI
SHLWAPI.DLL.MUI
6.1.7600.16385 (win7_rtm.090713-1255)
Shell Light-weight Utility Library
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

GDI32.dll
C:\Windows\syswow64\GDI32.dll
gdi32
gdi32
6.1.7601.18898 (win7sp1_gdr.150617-0600)
GDI Client DLL
Microsoft® Windows® Operating System
6.1.7601.18898
False
False
False
False
False
English (United States)

USER32.dll
C:\Windows\syswow64\USER32.dll
user32
user32
6.1.7601.17514 (win7sp1_rtm.101119-1850)
Multi-User Windows USER API Client DLL
Microsoft® Windows® Operating System
6.1.7601.17514
False
False
False
False
False
English (United States)

LPK.dll
C:\Windows\syswow64\LPK.dll
LanguagePack
LanguagePack
6.1.7601.18985 (win7sp1_gdr.150901-1452)
Language Pack
Microsoft® Windows® Operating System
6.1.7601.18985
False
False
False
False
False
English (United States)

USP10.dll
C:\Windows\syswow64\USP10.dll
Uniscribe
Uniscribe
1.0626.7601.18454 (win7sp1_gdr.140424-1533)
Uniscribe Unicode script processor
Microsoft® Uniscribe Unicode script processor
1.0626.7601.18454
False
False
False
False
False
English (United States)

IMM32.DLL
C:\Windows\system32\IMM32.DLL
imm32
imm32
6.1.7601.17514 (win7sp1_rtm.101119-1850)
Multi-User Windows IMM32 API Client DLL
Microsoft® Windows® Operating System
6.1.7601.17514
False
False
False
False
False
English (United States)

MSCTF.dll
C:\Windows\syswow64\MSCTF.dll
MSCTF
MSCTF.DLL.MUI
6.1.7600.16385 (win7_rtm.090713-1255)
MSCTF Server DLL
Microsoft® Windows® Operating System
6.1.7600.16385
False
False
False
False
False
English (United States)

clr.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll
clr.dll
clr.dll
4.0.30319.18063 built by: FX45RTMGDR
Microsoft .NET Runtime Common Language Runtime - WorkStation
Microsoft® .NET Framework
4.0.30319.18063
False
False
False
True
False
English (United States)

MSVCR110_CLR0400.dll
C:\Windows\system32\MSVCR110_CLR0400.dll
msvcr110_clr0400.dll
msvcr110_clr0400.dll
11.00.50709.17929 built by: FX45RTMREL
Microsoft® C Runtime Library
Microsoft® Visual Studio® 11 Beta
11.00.50709.1

Olivia_Rust · November 5, 2015, 9:59am

Hello Paul,
looks like your database has been corrupted.
Go to C:\Users\ your windows account\AppData\Roaming\eM Client and delete the content of this folder.
Start up eM Client with a new database and either synchronize your accounts again or restore your data from a previous backup.

Best regards,
Olivia