restore email databases after system rebuild

TomSmith · December 13, 2014, 8:35pm

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.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.Protocols.Common.ItemSynchronizeContext2.RemoveItems(IEnumerable1 obsoleteItems)    at MailClient.Protocols.Common.ItemSynchronizeContext2.Synchronize[T](SynchronizationType synchronizationType, IEnumerable1 items, Func2 getUniqueId, Func3 hasChanged, Func2 isDeleted, Func2 convertItems, Action2 updateItem)
at MailClient.Protocols.AirSync.AirSyncItemSynchronizer2.Synchronize(IItemSynchronizeContext1 synchronizeContext, Folder folder, CancellationToken cancellationToken)
at MailClient.Protocols.Common.ItemSynchronizer2.\<\>c\_\_DisplayClass30.\<\>c\_\_DisplayClass35.<enqueuesynchronize>b__2c(WorkerStatus status, CancellationToken cancellationToken) at MailClient.Protocols.AirSync.AirSyncGenericCommand.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.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart(Object obj) <report xmlns="<a href=" http:>" rel="nofollow" target="_blank">http://emclient.com/ns/report">; <product> <name>eM Client</name> <version>6.0.19849.0</version> </product> <silent>false</silent> <environment> <osversion>Microsoft Windows NT 6.1.7601 Service Pack 1</osversion> <frameworkversion>2.0.50727.5485</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>184</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>d9</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>14a</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>79</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>0</offset> <nativeoffset>27</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100685414</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>cb</offset> <nativeoffset>265</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670053</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRepository1
RemoveByItems

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

151
3af

MailClient.exe
100670054
MailClient
MailClient.Storage.Data.SQLite.DbRepository1</type> <name>Remove</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> </parameters> </method> <offset>1c</offset> <nativeoffset>a0</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670133</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.RepositoryExtensions</type> <name>Remove</name> <genericarguments> <argument> <assembly>MailClient</assembly> <type></type> </argument> <argument> <assembly>MailClient</assembly> <type></type> </argument> </genericarguments> <parameters> <parameter> <assembly>MailClient</assembly> <type></type> <name>repository</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type></type> <name>items</name> </parameter> </parameters> </method> <offset>0</offset> <nativeoffset>69</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100667471</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Protocols.Common.ItemSynchronizeContext2
RemoveItems

mscorlib
System.Collections.Generic.IEnumerable1[[System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</type> <name>obsoleteItems</name> </parameter> </parameters> </method> <offset>ae</offset> <nativeoffset>2f8</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100667474</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Protocols.Common.ItemSynchronizeContext2
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> <name>Synchronize</name> <parameters> <parameter> <assembly>MailClient</assembly> <type></type> <name>synchronizeContext</name> </parameter> <parameter> <assembly>MailClient</assembly> <type>MailClient.Storage.Application.Folder</type> <name>folder</name> </parameter> <parameter> <assembly>MailClient</assembly> <type>System.Threading.CancellationToken</type> <name>cancellationToken</name> </parameter> </parameters> </method> <offset>443</offset> <nativeoffset>f07</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100697149</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Protocols.Common.ItemSynchronizer2+<>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

Paul_Technical_Suppo · December 14, 2014, 6:06pm

Hi, this unfortunately seems to be a database issue, unfortunately some of the database files are corrupted and cannot be accessed by the application.
How did you backup your database? Did you use the built-in backup feature?

Unfortunately at this point it is not possible to restore the original database. To create a new database please navigate to your local folder > App Data > Roaming, and rename or remove the current eM Client database folder.

Open eM Client and the application should automatically create a new database, allowing you to setup your account(s).

Hope this helps.

Paul