restore email databases after system rebuild

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)<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="&lt;a href=" http:>" rel="nofollow" target="_blank"&gt;http://emclient.com/ns/report"&gt;;<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.DbRepository1
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.ItemSynchronizeContext2
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.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><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.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

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