Database Check - Checking for inconsistent data has failed.

Michael_Frisch · November 7, 2014, 10:37pm

Database Check - Checking for inconsistent data has failed. I hit the details button and get the following message "Consistency check failed with following error: SQL logic error or missing database no such table: mail_data.LocalMailContents. I hit cancel button and then it attempts to open eM Client and then give me application error.

Michael_Frisch · November 7, 2014, 10:40pm

I am getting the following error details.
eM Client (6.0.21040.0)
Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 4.0.30319.18408
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): 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(IntPtr 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 MailClient.Program.b__4()
at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action1 handler) <report xmlns="<a href=" http:>" rel="nofollow" target="_blank">http://emclient.com/ns/report">; <product> <name>eM Client</name> <version>6.0.21040.0</version> </product> <silent>false</silent> <environment> <osversion>Microsoft Windows NT 6.1.7601 Service Pack 1</osversion> <frameworkversion>4.0.30319.18408</frameworkversion> </environment> <exception> <type>System.Data.SQLite.SQLiteException</type> <message>SQL logic error or missing database no such table: mail_data.LocalMailContents</message> <source>System.Data.SQLite</source> <stack> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663600</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLite3</type> <name>Prepare</name> <parameters> <parameter> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteConnection</type> <name>cnn</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.String</type> <name>strSql</name> </parameter> <parameter> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteStatement</type> <name>previous</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.UInt32</type> <name>timeoutMS</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.String&</type> <name>strRemain</name> </parameter> </parameters> </method> <offset>265</offset> <nativeoffset>4b2</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663734</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>BuildNextCommand</name> <parameters></parameters> </method> <offset>f6</offset> <nativeoffset>17f</nativeoffset> <frame> <method> <modulename>System.Data.SQLite.dll</modulename> <metadatatoken>100663735</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>GetStatement</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>index</name> </parameter> </parameters> </method> <offset>8</offset> <nativeoffset>12</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>e4</offset> <nativeoffset>112</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>71</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>100663756</metadatatoken> <assembly>System.Data.SQLite</assembly> <type>System.Data.SQLite.SQLiteCommand</type> <name>ExecuteDbDataReader</name> <parameters> <parameter> <assembly>System.Data</assembly> <type>System.Data.CommandBehavior</type> <name>behavior</name> </parameter> </parameters> </method> <offset>0</offset> <nativeoffset>4</nativeoffset> <frame> <method> <modulename>System.Data.dll</modulename> <metadatatoken>100665160</metadatatoken> <assembly>System.Data</assembly> <type>System.Data.Common.DbCommand</type> <name>System.Data.IDbCommand.ExecuteReader</name> <parameters></parameters> </method> <offset>0</offset> <nativeoffset>c</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100685662</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbMailRepository</type> <name>LoadMimePart</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.UInt64</type> <name>messageId</name> </parameter> </parameters> </method> <offset>3c</offset> <nativeoffset>9e</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100677756</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRootMimePart</type> <name>Load</name> <parameters></parameters> </method> <offset>24</offset> <nativeoffset>49</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100677762</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRootMimePart</type> <name>get_ContentType</name> <parameters></parameters> </method> <offset>0</offset> <nativeoffset>8</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100682139</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.UI.Mail.SMimeDecoder</type> <name>isSmime</name> <parameters> <parameter> <assembly>MailClient.Mail</assembly> <type>MailClient.Mail.IMimePart</type> <name>mimeStructure</name> </parameter> </parameters> </method> <offset>0</offset> <nativeoffset>21</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100691326</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.UI.Controls.controlMessageDetail</type> <name>RefreshMessage</name> <parameters></parameters> </method> <offset>73</offset> <nativeoffset>dd</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100691325</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.UI.Controls.controlMessageDetail</type> <name>Refresh</name> <parameters> <parameter> <assembly>MailClient.Mail</assembly> <type>MailClient.Mail.IMail</type> <name>mail</name> </parameter> </parameters> </method> <offset>5c</offset> <nativeoffset>b1</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100691324</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.UI.Controls.controlMessageDetail</type> <name>Refresh</name> <parameters> <parameter> <assembly>MailClient.Mail</assembly> <type>MailClient.Mail.IMail</type> <name>mail</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.Boolean</type> <name>autoMarkAsRead</name> </parameter> </parameters> </method> <offset>7</offset> <nativeoffset>1c</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100691502</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.UI.Controls.controlMessages+MailItemBehaviour</type> <name>selectTimer_Tick</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Object</type> <name>sender</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.EventArgs</type> <name>e</name> </parameter> </parameters> </method> <offset>b</offset> <nativeoffset>71</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100680286</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Timer</type> <name>OnTick</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.EventArgs</type> <name>e</name> </parameter> </parameters> </method> <offset>8</offset> <nativeoffset>14</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100680299</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Timer+TimerNativeWindow</type> <name>WndProc</name> <parameters> <parameter> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Message&</type> <name>m</name> </parameter> </parameters> </method> <offset>21</offset> <nativeoffset>31</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100665822</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.NativeWindow</type> <name>DebuggableCallback</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.IntPtr</type> <name>hWnd</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>msg</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.IntPtr</type> <name>wparam</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.IntPtr</type> <name>lparam</name> </parameter> </parameters> </method> <offset>25</offset> <nativeoffset>5d</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100663535</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.UnsafeNativeMethods</type> <name>DispatchMessageW</name> <parameters> <parameter> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.NativeMethods+MSG&</type> <name>msg</name> </parameter> </parameters> </method> <offset>ffffffff</offset> <nativeoffset>0</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100688501</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Application+ComponentManager</type> <name>System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.IntPtr</type> <name>dwComponentID</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>reason</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>pvLoopData</name> </parameter> </parameters> </method> <offset>186</offset> <nativeoffset>24c</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100688548</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Application+ThreadContext</type> <name>RunMessageLoopInner</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>reason</name> </parameter> <parameter> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.ApplicationContext</type> <name>context</name> </parameter> </parameters> </method> <offset>1de</offset> <nativeoffset>154</nativeoffset> <frame> <method> <modulename>System.Windows.Forms.dll</modulename> <metadatatoken>100688547</metadatatoken> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.Application+ThreadContext</type> <name>RunMessageLoop</name> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Int32</type> <name>reason</name> </parameter> <parameter> <assembly>System.Windows.Forms</assembly> <type>System.Windows.Forms.ApplicationContext</type> <name>context</name> </parameter> </parameters> </method> <offset>13</offset> <nativeoffset>49</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100675804</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Program</type> <name><Main>b__4</name> <parameters></parameters> </method> <offset>17</offset> <nativeoffset>38</nativeoffset> <frame> <method> <modulename>MailClient.ExceptionUtils.dll</modulename> <metadatatoken>100663314</metadatatoken> <assembly>MailClient.ExceptionUtils</assembly> <type>MailClient.ExceptionUtils.ExceptionUtils</type> <name>Filter</name> <parameters> <parameter> <assembly>MailClient.ExceptionUtils</assembly> <type>MailClient.ExceptionUtils.ExceptionUtils+BodyDelegate</type> <name>body</name> </parameter> <parameter> <assembly>MailClient.ExceptionUtils</assembly> <type>MailClient.ExceptionUtils.ExceptionUtils+FilterDelegate</type> <name>filter</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type>System.Action1[[System.Exception, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
handler

0
22

183

MailClient.exe
C:\Program Files (x86)\eM Client\MailClient.exe
MailClient.exe
MailClient.exe
6.0.21040.0
eM Client
eM Client
6.0.21040.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.18526 (win7sp1_gdr.140706-1506)
Security Support Provider Interface
Microsoft® Windows® Operating System
6.1.7601.18526
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

Michael_Frisch · November 7, 2014, 10:59pm

How do I fix this problem? I do not want to restart from scratch.

Paul_Technical_Suppo · November 10, 2014, 10:38am

Hi Michael, I’m afraid this means your database is corrupt, this may be due to a improper initialization of the application or your computer. Do you have a backup of your data? Are you using an IMAP account(s)?
At this point you’ll have to setup a new database, to do so, please go to your local folder > App Data > Roaming, and rename or remove your eM Client folder. After you open the application again, it will create a new database in this folder, allowing you to setup your account again.

Hope this helps,
Paul.

Michael_Frisch · November 10, 2014, 6:31pm

I am not using an IMAP account. I do not have a backup. However, I did find the database in the folder you indicated above. My issue is that I do not want to loose my data. I need your help to fix the problem. That is why I spent the $50 to get it restored. Is there anything you can do to help me?

Paul_Technical_Suppo · November 11, 2014, 1:00pm

Hi Michael, sorry for my belated reply, unfortunately without a backup, there’s unfortunately no option to restore the current database without data loss.
A database file that contains your emails has been corrupt causing this data to become unavailable for reading. There would be a possibility to restore your database, but you would lose all your local email data.

Unfortunately while using eM Client with a POP account and using local storage for your emails, please always keep a backup of your data.

Regards,
Paul.