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.ScheduleItem
1.BeginUpdate()
at MailClient.Storage.Application.Schedule.ScheduleItemCollection1.AddedItems(IEnumerable
1 items)
at MailClient.Storage.Application.ItemCollection2.AddInternal(TItem item, Action
1 storeCallback)
at MailClient.Storage.Application.ItemCollection2.Add(TItem item) at MailClient.UI.Forms.formTask.SaveDataToTask() at MailClient.UI.Forms.formTask.buttonSave\_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.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 System.Windows.Forms.Application.Run(ApplicationContext context) at MailClient.Program.<main>b__4()<br> at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action
1 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.ScheduleItem
1 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.ItemCollection
2 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&</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&</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&</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&</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&</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&</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&</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><Main>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.Action
1[[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/db repairebuildall.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