Ok, eM Client Pro, Win 7 SP1. System crashed, and did complete reinstall of Win 7 starting from partition and format.
I have a system backup of the eM Client files from user\xxx\appdata\roaming\emclient.
I have tried numerous variations on install/restore files, restore files then reinstall EMC, install older version of EMC etc etc.
eM Client does it’s ‘checking for corrupted database’ thing, finds no problems, asks for the password, then opens. The various email accounts appear to be there, and downloads begin. Then it blows up. Error details below. It will do this apparently over and over forever.
I really need to be able to recover the email database. Any help appreciated on WHY it won’t run with the restored data.
Thanks
eM Client (6.0.19849.0)Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 2.0.50727.5485
The following error has occurred:
System.Data.SQLite.SQLiteException: 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.DbRepository
1.RemoveByItems[ST](Object senderContext, IEnumerable1 items) at MailClient.Storage.Data.SQLite.DbRepository
1.Remove[ST](Object senderContext, IEnumerable1 items) at MailClient.RepositoryExtensions.Remove[T,ST](IRepository
1 repository, IEnumerable1 items) at MailClient.Protocols.Common.ItemSynchronizeContext
2.RemoveItems(IEnumerable1 obsoleteItems) at MailClient.Protocols.Common.ItemSynchronizeContext
2.Synchronize[T](SynchronizationType synchronizationType, IEnumerable1 items, Func
2 getUniqueId, Func3 hasChanged, Func
2 isDeleted, Func2 convertItems, Action
2 updateItem)
at MailClient.Protocols.AirSync.AirSyncItemSynchronizer2.Synchronize(IItemSynchronizeContext
1 synchronizeContext, Folder folder, CancellationToken cancellationToken)
at MailClient.Protocols.Common.ItemSynchronizer2.\<\>c\_\_DisplayClass30.\<\>c\_\_DisplayClass35.<enqueuesynchronize>b__2c(WorkerStatus status, CancellationToken cancellationToken)<br> at MailClient.Protocols.AirSync.AirSyncGenericCommand.Execute(WorkerStatus status)<br> at MailClient.Commands.Command.Process(WorkerStatus status)<br> at MailClient.Commands.SynchronizationQueue.ThreadWorker(Object threadData)<br> at System.Threading.ThreadHelper.ThreadStart_Context(Object state)<br> at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)<br> at System.Threading.ThreadHelper.ThreadStart(Object obj)<br><br><br><report xmlns="<a href=" http:>" rel="nofollow" target="_blank">http://emclient.com/ns/report">;<br> <product><br> <name>eM Client</name><br> <version>6.0.19849.0</version><br> </product><br> <silent>false</silent><br> <environment><br> <osversion>Microsoft Windows NT 6.1.7601 Service Pack 1</osversion><br> <frameworkversion>2.0.50727.5485</frameworkversion><br> </environment><br> <exception><br> <type>System.Data.SQLite.SQLiteException</type><br> <message>SQL logic error or missing database<br>SQL logic error or missing database</message><br> <source>System.Data.SQLite</source><br> <stack><br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663598</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLite3</type><br> <name>Reset</name><br> <parameters><br> <parameter><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteStatement</type><br> <name>stmt</name><br> </parameter><br> </parameters><br> </method><br> <offset>83</offset><br> <nativeoffset>184</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663597</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLite3</type><br> <name>Step</name><br> <parameters><br> <parameter><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteStatement</type><br> <name>stmt</name><br> </parameter><br> </parameters><br> </method><br> <offset>3c</offset><br> <nativeoffset>d9</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663982</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteDataReader</type><br> <name>NextResult</name><br> <parameters></parameters><br> </method><br> <offset>12f</offset><br> <nativeoffset>14a</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663943</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteDataReader</type><br> <name>.ctor</name><br> <parameters><br> <parameter><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteCommand</type><br> <name>cmd</name><br> </parameter><br> <parameter><br> <assembly>System.Data</assembly><br> <type>System.Data.CommandBehavior</type><br> <name>behave</name><br> </parameter><br> </parameters><br> </method><br> <offset>5d</offset><br> <nativeoffset>79</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663757</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteCommand</type><br> <name>ExecuteReader</name><br> <parameters><br> <parameter><br> <assembly>System.Data</assembly><br> <type>System.Data.CommandBehavior</type><br> <name>behavior</name><br> </parameter><br> </parameters><br> </method><br> <offset>c</offset><br> <nativeoffset>26</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Data.SQLite.dll</modulename><br> <metadatatoken>100663760</metadatatoken><br> <assembly>System.Data.SQLite</assembly><br> <type>System.Data.SQLite.SQLiteCommand</type><br> <name>ExecuteNonQuery</name><br> <parameters></parameters><br> </method><br> <offset>0</offset><br> <nativeoffset>27</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100685414</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Data.SQLite.DbMailRepository</type><br> <name>RemoveOids</name><br> <genericarguments><br> <argument><br> <assembly>MailClient</assembly><br> <type></type><br> </argument><br> </genericarguments><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Object</type><br> <name>senderContext</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.String</type><br> <name>oidList</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type></type><br> <name>items</name><br> </parameter><br> </parameters><br> </method><br> <offset>cb</offset><br> <nativeoffset>265</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100670053</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Data.SQLite.DbRepository
1
RemoveByItems
MailClient
mscorlib
System.Object
senderContext
mscorlib
items
151
3af
MailClient.exe
100670054
MailClient
MailClient.Storage.Data.SQLite.DbRepository1</type><br> <name>Remove</name><br> <genericarguments><br> <argument><br> <assembly>MailClient</assembly><br> <type></type><br> </argument><br> </genericarguments><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Object</type><br> <name>senderContext</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type></type><br> <name>items</name><br> </parameter><br> </parameters><br> </method><br> <offset>1c</offset><br> <nativeoffset>a0</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100670133</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.RepositoryExtensions</type><br> <name>Remove</name><br> <genericarguments><br> <argument><br> <assembly>MailClient</assembly><br> <type></type><br> </argument><br> <argument><br> <assembly>MailClient</assembly><br> <type></type><br> </argument><br> </genericarguments><br> <parameters><br> <parameter><br> <assembly>MailClient</assembly><br> <type></type><br> <name>repository</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type></type><br> <name>items</name><br> </parameter><br> </parameters><br> </method><br> <offset>0</offset><br> <nativeoffset>69</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100667471</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Protocols.Common.ItemSynchronizeContext
2
RemoveItems
mscorlib
System.Collections.Generic.IEnumerable1[[System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</type><br> <name>obsoleteItems</name><br> </parameter><br> </parameters><br> </method><br> <offset>ae</offset><br> <nativeoffset>2f8</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100667474</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Protocols.Common.ItemSynchronizeContext
2
Synchronize
MailClient
MailClient
MailClient.Protocols.Common.SynchronizationType
synchronizationType
mscorlib
items
LinqBridge
getUniqueId
LinqBridge
hasChanged
LinqBridge
isDeleted
LinqBridge
convertItems
LinqBridge
updateItem
31b
abd
MailClient.exe
100666635
MailClient
MailClient.Protocols.AirSync.AirSyncItemSynchronizer2</type><br> <name>Synchronize</name><br> <parameters><br> <parameter><br> <assembly>MailClient</assembly><br> <type></type><br> <name>synchronizeContext</name><br> </parameter><br> <parameter><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Application.Folder</type><br> <name>folder</name><br> </parameter><br> <parameter><br> <assembly>MailClient</assembly><br> <type>System.Threading.CancellationToken</type><br> <name>cancellationToken</name><br> </parameter><br> </parameters><br> </method><br> <offset>443</offset><br> <nativeoffset>f07</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100697149</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Protocols.Common.ItemSynchronizer
2+<>c DisplayClass30+<>c DisplayClass35
<EnqueueSynchronize>b__2c
MailClient
MailClient.Commands.WorkerStatus
status
MailClient
System.Threading.CancellationToken
cancellationToken
d9
1d6
MailClient.exe
100666701
MailClient
MailClient.Protocols.AirSync.AirSyncGenericCommand
Execute
MailClient
MailClient.Commands.WorkerStatus
status
5a
ba
MailClient.exe
100664002
MailClient
MailClient.Commands.Command
Process
MailClient
MailClient.Commands.WorkerStatus
status
15
51
MailClient.exe
100664052
MailClient
MailClient.Commands.SynchronizationQueue
ThreadWorker
mscorlib
System.Object
threadData
8c
109
mscorlib.dll
100668077
mscorlib
System.Threading.ThreadHelper
ThreadStart_Context
mscorlib
System.Object
state
3b
72c311
mscorlib.dll
100667884
mscorlib
System.Threading.ExecutionContext
Run
mscorlib
System.Threading.ExecutionContext
executionContext
mscorlib
System.Threading.ContextCallback
callback
mscorlib
System.Object
state
58
6e
mscorlib.dll
100668078
mscorlib
System.Threading.ThreadHelper
ThreadStart
mscorlib
System.Object
obj
f
49
0
MailClient.exe
C:\Program Files (x86)\eM Client\MailClient.exe
MailClient.exe
MailClient.exe
6.0.19849.0
eM Client
eM Client
6.0.19849.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.18015 (win7sp1_gdr.121129-1432)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.1.7601.18015
False
False
False
False
False
English (United States)
KERNELBASE.dll
C:\Windows\syswow64\KERNELBASE.dll
Kernelbase
Kernelbase
6.1.7601.18015 (win7sp1_gdr.121129-1432)
Windows NT BASE API Client DLL
Microsoft® Windows® Operating System
6.1.7601.18015
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.18637 (win7sp1_gdr.141013-1517)
Security Support Provider Interface
Microsoft® Windows® Operating System
6.1.7601.18637
False
False
False
False
False
English (United States)
CRYPTBASE.dll
C:\Windows\syswow64\CRYPTBASE.dll
cryptbase.dll
cryptbase.dll
6.1.7600.16385 (win7_rtm.090713-1255)
Base cryptographic API DLL
Microsoft® Windows® Operating System
6.1.7600.16385
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.18408 built by: FX451RTMGREL
Microsoft .NET Runtime Execution Engine
Microsoft® .NET Framework
4.0.30319.18408
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.18577 (win7sp1_gdr.140822-1508)
GDI Client DLL
Microsoft® Windows® Operating System
6.1.7601.18577
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.18177 (win7sp1_gdr.130605-1534)
Language Pack
Microsoft® Windows® Operating System
6.1.7601.18177
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)
mscorwks.dll
C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
mscorwks.dll
mscorwks.dll
2.0.50727.5485 (Win7SP1GDR.050727-5400)
Microsoft .NET Runtime Common Language Runtime - WorkStation
Microsoft® .NET Framework
2.0.50727.5485
False
False
False
False
False
English (United States)
MSVCR80.dll
C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_d08cc06a442b34fc\MSVCR80.dll
MSVCR80.DLL
MSVCR80.DLL
8.00.50727.4940
Microsoft® C Runtime Library
Microsoft® Visual Studio® 2005
8.00.50727.4940
False
False
False
False
False
English (United States)
shell32.dll
C:\Windows\syswow64\shell32.dll
SHELL32
SHELL32.DLL.MUI
6.1.7601.17514 (win7sp1_rtm.101119-1850)
Windows Shell Common Dll
Microsoft® Windows® Operating System
6.1.7601.17514
False
False
False
False