em Client crash when adding new task

Hi
My em client keep crashing whenever i add any task to it, here is the error i get every time

eM Client (6.0.21372.0)Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 4.0.30319.34209
The following error has occurred:
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such table: task_data.TaskItemContents
   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.DbScheduleRepository.LoadProperty(UInt64 itemId, String propertyName)
   at MailClient.Storage.Data.SQLite.DbScheduleRepositoryItem.get_Calendar()
   at MailClient.Storage.Data.SQLite.DbScheduleRepositoryItem.Copy()
   at MailClient.Storage.Application.Item2.BeginUpdate()    at MailClient.Storage.Application.Schedule.ScheduleItem1.BeginUpdate()
   at MailClient.Storage.Application.Schedule.ScheduleItemCollection1.AddedItems(IEnumerable1 items)
   at MailClient.Storage.Application.ItemCollection2.AddInternal(TItem item, Action1 storeCallback)
   at MailClient.Storage.Application.ItemCollection2.Add(TItem item) &nbsp; &nbsp;at MailClient.UI.Forms.formTask.SaveDataToTask() &nbsp; &nbsp;at MailClient.UI.Forms.formTask.buttonSave\_Click(Object sender, EventArgs e) &nbsp; &nbsp;at System.Windows.Forms.Control.OnClick(EventArgs e) &nbsp; &nbsp;at System.Windows.Forms.Button.OnClick(EventArgs e) &nbsp; &nbsp;at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) &nbsp; &nbsp;at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) &nbsp; &nbsp;at System.Windows.Forms.Control.WndProc(Message& m) &nbsp; &nbsp;at System.Windows.Forms.ButtonBase.WndProc(Message& m) &nbsp; &nbsp;at System.Windows.Forms.Button.WndProc(Message& m) &nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) &nbsp; &nbsp;at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) &nbsp; &nbsp;at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) &nbsp; &nbsp;at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) &nbsp; &nbsp;at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) &nbsp; &nbsp;at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) &nbsp; &nbsp;at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) &nbsp; &nbsp;at System.Windows.Forms.Application.Run(ApplicationContext context) &nbsp; &nbsp;at MailClient.Program.<main>b__4()<br> at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action1 handler)


" rel=“nofollow” target="_blank" title=“Link http//emclientcom/ns/report”>http://emclient.com/ns/report">;

eM Client
6.0.21372.0

false

Microsoft Windows NT 6.1.7601 Service Pack 1
4.0.30319.34209


System.Data.SQLite.SQLiteException
SQL logic error or missing database
no such table: task_data.TaskItemContents
System.Data.SQLite




System.Data.SQLite.dll
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
4ac




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


f6
17f




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


mscorlib
System.Int32
index



8
12




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


e4
112




System.Data.SQLite.dll
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




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


System.Data
System.Data.CommandBehavior
behavior



c
26




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


6
21




MailClient.exe
100685682
MailClient
MailClient.Storage.Data.SQLite.DbScheduleRepository
LoadProperty


mscorlib
System.UInt64
itemId


mscorlib
System.String
propertyName



40
8e




MailClient.exe
100685943
MailClient
MailClient.Storage.Data.SQLite.DbScheduleRepositoryItem
get_Calendar


63
8a




MailClient.exe
100685947
MailClient
MailClient.Storage.Data.SQLite.DbScheduleRepositoryItem
Copy


0
600




MailClient.exe
100670086
MailClient
MailClient.Storage.Application.Item2</type><br> <name>BeginUpdate</name><br> <parameters></parameters><br> </method><br> <offset>2c</offset><br> <nativeoffset>83</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100676996</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Application.Schedule.ScheduleItem1
BeginUpdate


25
22




MailClient.exe
100677101
MailClient
MailClient.Storage.Application.Schedule.ScheduleItemCollection1</type><br> <name>AddedItems</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type></type><br> <name>items</name><br> </parameter><br> </parameters><br> </method><br> <offset>17</offset><br> <nativeoffset>86</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100670152</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Application.ItemCollection2
AddInternal


MailClient

item


mscorlib

storeCallback



ba
220




MailClient.exe
100670151
MailClient
MailClient.Storage.Application.ItemCollection2</type><br> <name>Add</name><br> <parameters><br> <parameter><br> <assembly>MailClient</assembly><br> <type></type><br> <name>item</name><br> </parameter><br> </parameters><br> </method><br> <offset>0</offset><br> <nativeoffset>c</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100692719</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.UI.Forms.formTask</type><br> <name>SaveDataToTask</name><br> <parameters></parameters><br> </method><br> <offset>96e</offset><br> <nativeoffset>1f5d</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100692739</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.UI.Forms.formTask</type><br> <name>buttonSave_Click</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Object</type><br> <name>sender</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.EventArgs</type><br> <name>e</name><br> </parameter><br> </parameters><br> </method><br> <offset>3a</offset><br> <nativeoffset>56</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665327</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Control</type><br> <name>OnClick</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.EventArgs</type><br> <name>e</name><br> </parameter><br> </parameters><br> </method><br> <offset>19</offset><br> <nativeoffset>61</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100667807</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Button</type><br> <name>OnClick</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.EventArgs</type><br> <name>e</name><br> </parameter><br> </parameters><br> </method><br> <offset>2e</offset><br> <nativeoffset>7f</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100667809</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Button</type><br> <name>OnMouseUp</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.MouseEventArgs</type><br> <name>mevent</name><br> </parameter><br> </parameters><br> </method><br> <offset>77</offset><br> <nativeoffset>ab</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665753</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Control</type><br> <name>WmMouseUp</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.MouseButtons</type><br> <name>button</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>clicks</name><br> </parameter><br> </parameters><br> </method><br> <offset>184</offset><br> <nativeoffset>273</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665461</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Control</type><br> <name>WndProc</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> </parameters><br> </method><br> <offset>5fe</offset><br> <nativeoffset>8f18e1</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100667762</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.ButtonBase</type><br> <name>WndProc</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> </parameters><br> </method><br> <offset>ca</offset><br> <nativeoffset>8f5524</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100667814</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Button</type><br> <name>WndProc</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> </parameters><br> </method><br> <offset>3d</offset><br> <nativeoffset>1f</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665839</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Control+ControlNativeWindow</type><br> <name>OnMessage</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> </parameters><br> </method><br> <offset>0</offset><br> <nativeoffset>10</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665840</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Control+ControlNativeWindow</type><br> <name>WndProc</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Message&amp;</type><br> <name>m</name><br> </parameter><br> </parameters><br> </method><br> <offset>8e</offset><br> <nativeoffset>38</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100665822</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.NativeWindow</type><br> <name>DebuggableCallback</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.IntPtr</type><br> <name>hWnd</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>msg</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.IntPtr</type><br> <name>wparam</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.IntPtr</type><br> <name>lparam</name><br> </parameter><br> </parameters><br> </method><br> <offset>25</offset><br> <nativeoffset>5d</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100663535</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.UnsafeNativeMethods</type><br> <name>DispatchMessageW</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.NativeMethods+MSG&amp;</type><br> <name>msg</name><br> </parameter><br> </parameters><br> </method><br> <offset>ffffffff</offset><br> <nativeoffset>0</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100688503</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Application+ComponentManager</type><br> <name>System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.IntPtr</type><br> <name>dwComponentID</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>reason</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>pvLoopData</name><br> </parameter><br> </parameters><br> </method><br> <offset>186</offset><br> <nativeoffset>24c</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100688550</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Application+ThreadContext</type><br> <name>RunMessageLoopInner</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>reason</name><br> </parameter><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.ApplicationContext</type><br> <name>context</name><br> </parameter><br> </parameters><br> </method><br> <offset>1de</offset><br> <nativeoffset>154</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100688549</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Application+ThreadContext</type><br> <name>RunMessageLoop</name><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Int32</type><br> <name>reason</name><br> </parameter><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.ApplicationContext</type><br> <name>context</name><br> </parameter><br> </parameters><br> </method><br> <offset>13</offset><br> <nativeoffset>49</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>System.Windows.Forms.dll</modulename><br> <metadatatoken>100664859</metadatatoken><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.Application</type><br> <name>Run</name><br> <parameters><br> <parameter><br> <assembly>System.Windows.Forms</assembly><br> <type>System.Windows.Forms.ApplicationContext</type><br> <name>context</name><br> </parameter><br> </parameters><br> </method><br> <offset>0</offset><br> <nativeoffset>17</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100675857</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Program</type><br> <name>&lt;Main&gt;b__4</name><br> <parameters></parameters><br> </method><br> <offset>17</offset><br> <nativeoffset>41</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.ExceptionUtils.dll</modulename><br> <metadatatoken>100663314</metadatatoken><br> <assembly>MailClient.ExceptionUtils</assembly><br> <type>MailClient.ExceptionUtils.ExceptionUtils</type><br> <name>Filter</name><br> <parameters><br> <parameter><br> <assembly>MailClient.ExceptionUtils</assembly><br> <type>MailClient.ExceptionUtils.ExceptionUtils+BodyDelegate</type><br> <name>body</name><br> </parameter><br> <parameter><br> <assembly>MailClient.ExceptionUtils</assembly><br> <type>MailClient.ExceptionUtils.ExceptionUtils+FilterDelegate</type><br> <name>filter</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Action1[[System.Exception, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
handler



0
22



0




MailClient.exe
C:\Program Files (x86)\eM Client\MailClient.exe
MailClient.exe
MailClient.exe
6.0.21372.0
eM Client
eM Client
6.0.21372.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.18779 (win7sp1_gdr.150305-1615)
Security Support Provider Interface
Microsoft® Windows® Operating System
6.1.7601.18779
False
False
False
False
False
English (United States)

Hi, this is unfortunately a database issue, some of the database data are corrupt and are no longer accessible for the application, considering the issue only occurs when adding tasks, you may be able to restore the database using this utility:
http://www.emclient.com/tools/dbrepairebuildall.exe .

Let the database check rebuild your database data and let us know if the repair was successful.

I’m afraid that if the tool won’t be able to restore the database data, you’d have to create a new database and synchronize your items with the newly created database.

Thanks for the reply, but the link is not working

Sorry about that, http://www.emclient.com/tools/dbrepairrebuildall.exe , hope this helps.