Crashing with .net error - can anyone help please?

EMclient was working fine but now I am getting the following error whenever I try to send an email or receive one.

I have:

added and removed .net 3.5 / 4 from Features of Windows 8.1

uninstalled and reinstalled emclient

Can anyone suggest what I should do as this message is too complicated for me to understand!

Many thanks

eM Client (6.0.23421.0)
Windows: Microsoft Windows NT 6.2.9200.0, Framework: 4.0.30319.34209
The following error has occurred:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> 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 System.Data.SQLite.SQLiteTransaction.Commit()
   at MailClient.Storage.Data.SQLite.DbRepository1.Add[ST](Object senderContext, IEnumerable1 items, Action1 storeCallback)    at MailClient.Storage.Application.ItemCollection2.AddInternal(TItem item, Action1 storeCallback)    at MailClient.Storage.Application.ItemCollection2.Add(TItem item)
   at MailClient.UI.Forms.formSendMail.<>c__DisplayClass4a.b__47()
at MailClient.UI.Forms.FormLongOperation.<>c__DisplayClass2.b__0(Object param0)
— End of inner exception stack trace —
at MailClient.UI.Forms.FormLongOperation.InitOperation(IWin32Window owner, String name, MethodInvoker operation, Boolean ignoreTheme)
at MailClient.UI.Forms.formSendMail.Send(Boolean massMail)
at MailClient.UI.Forms.formSendMail.toolStripMainSend_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at MailClient.Common.UI.Controls.ToolStripEx.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 MailClient.Program.b__4()
at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action`1 handler)

" rel=“nofollow”>http://emclient.com/ns/report">;

eM Client
6.0.23421.0

false

Microsoft Windows NT 6.2.9200.0
4.0.30319.34209


System.Reflection.TargetInvocationException
Exception has been thrown by the target of an invocation.
MailClient




MailClient.exe
100681548
MailClient
MailClient.UI.Forms.FormLongOperation
InitOperation


System.Windows.Forms
System.Windows.Forms.IWin32Window
owner


mscorlib
System.String
name


System.Windows.Forms
System.Windows.Forms.MethodInvoker
operation


mscorlib
System.Boolean
ignoreTheme



117
200




MailClient.exe
100693640
MailClient
MailClient.UI.Forms.formSendMail
Send


mscorlib
System.Boolean
massMail



6d5
cdc




MailClient.exe
100693664
MailClient
MailClient.UI.Forms.formSendMail
toolStripMainSend_Click


mscorlib
System.Object
sender


mscorlib
System.EventArgs
e



0
6




System.Windows.Forms.dll
100667402
System.Windows.Forms
System.Windows.Forms.ToolStripItem
RaiseEvent


mscorlib
System.Object
key


mscorlib
System.EventArgs
e



0
52




System.Windows.Forms.dll
100680542
System.Windows.Forms
System.Windows.Forms.ToolStripButton
OnClick


mscorlib
System.EventArgs
e



17
40




System.Windows.Forms.dll
100667386
System.Windows.Forms
System.Windows.Forms.ToolStripItem
HandleClick


mscorlib
System.EventArgs
e



3b
92




System.Windows.Forms.dll
100667395
System.Windows.Forms
System.Windows.Forms.ToolStripItem
HandleMouseUp


System.Windows.Forms
System.Windows.Forms.MouseEventArgs
e



c7
16f




System.Windows.Forms.dll
100667378
System.Windows.Forms
System.Windows.Forms.ToolStripItem
FireEventInteractive


mscorlib
System.EventArgs
e


System.Windows.Forms
System.Windows.Forms.ToolStripItemEventType
met



48
88




System.Windows.Forms.dll
100667377
System.Windows.Forms
System.Windows.Forms.ToolStripItem
FireEvent


mscorlib
System.EventArgs
e


System.Windows.Forms
System.Windows.Forms.ToolStripItemEventType
met



cb
8ceb9c




System.Windows.Forms.dll
100666965
System.Windows.Forms
System.Windows.Forms.ToolStrip
OnMouseUp


System.Windows.Forms
System.Windows.Forms.MouseEventArgs
mea



6f
b1




System.Windows.Forms.dll
100665753
System.Windows.Forms
System.Windows.Forms.Control
WmMouseUp


System.Windows.Forms
System.Windows.Forms.Message&
m


System.Windows.Forms
System.Windows.Forms.MouseButtons
button


mscorlib
System.Int32
clicks



184
273




System.Windows.Forms.dll
100665461
System.Windows.Forms
System.Windows.Forms.Control
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



5fe
8f1eed




System.Windows.Forms.dll
100665975
System.Windows.Forms
System.Windows.Forms.ScrollableControl
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



3a
29




System.Windows.Forms.dll
100666993
System.Windows.Forms
System.Windows.Forms.ToolStrip
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



e7
49




MailClient.Common.UI.dll
100663395
MailClient.Common.UI
MailClient.Common.UI.Controls.ToolStripEx
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



0
11




System.Windows.Forms.dll
100665839
System.Windows.Forms
System.Windows.Forms.Control+ControlNativeWindow
OnMessage


System.Windows.Forms
System.Windows.Forms.Message&
m



0
10




System.Windows.Forms.dll
100665840
System.Windows.Forms
System.Windows.Forms.Control+ControlNativeWindow
WndProc


System.Windows.Forms
System.Windows.Forms.Message&
m



8e
38




System.Windows.Forms.dll
100665822
System.Windows.Forms
System.Windows.Forms.NativeWindow
DebuggableCallback


mscorlib
System.IntPtr
hWnd


mscorlib
System.Int32
msg


mscorlib
System.IntPtr
wparam


mscorlib
System.IntPtr
lparam



25
5d




System.Windows.Forms.dll
100663535
System.Windows.Forms
System.Windows.Forms.UnsafeNativeMethods
DispatchMessageW


System.Windows.Forms
System.Windows.Forms.NativeMethods+MSG&
msg



ffffffff
0




System.Windows.Forms.dll
100688504
System.Windows.Forms
System.Windows.Forms.Application+ComponentManager
System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop


mscorlib
System.IntPtr
dwComponentID


mscorlib
System.Int32
reason


mscorlib
System.Int32
pvLoopData



186
24c




System.Windows.Forms.dll
100688551
System.Windows.Forms
System.Windows.Forms.Application+ThreadContext
RunMessageLoopInner


mscorlib
System.Int32
reason


System.Windows.Forms
System.Windows.Forms.ApplicationContext
context



1de
154




System.Windows.Forms.dll
100688550
System.Windows.Forms
System.Windows.Forms.Application+ThreadContext
RunMessageLoop


mscorlib
System.Int32
reason


System.Windows.Forms
System.Windows.Forms.ApplicationContext
context



13
49




MailClient.exe
100675735
MailClient
MailClient.Program
<Main>b__4


17
38




MailClient.ExceptionUtils.dll
100663314
MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils
Filter


MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils+BodyDelegate
body


MailClient.ExceptionUtils
MailClient.ExceptionUtils.ExceptionUtils+FilterDelegate
filter


mscorlib
System.Action`1[[System.Exception, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]
handler



0
22





System.Data.SQLite.SQLiteException
SQL logic error or missing database
SQL logic error or missing database
System.Data.SQLite




System.Data.SQLite.dll
100663598
System.Data.SQLite
System.Data.SQLite.SQLite3
Reset


System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt



83
18c




System.Data.SQLite.dll
100663597
System.Data.SQLite
System.Data.SQLite.SQLite3
Step


System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt



3c
da




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


12f
150




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


Hi Andrew,
the error is actually with your database. Your database is located in C:\Users\your windows user account\AppData\Roaming\eM Client.
Delete this folder and then start eM Client.
Now you will need to either restore your data from a back up through ‘File > Restore…’ or set up your accounts and settings again.

Regards,
Olivia

I deleted the folder and then restored from the most recent backup same issue. I went back to an older backup and that’s got it working again.

Thanks for your help Olivia!

Andrew

No problem, glad all is working again.

Best wishes,
Olivia

Hi Olivia,

Hope you don’t mind a question on this one?

From Andrews post it appears that the backup he first restored from was corrupt, he went back to the previous and that was ok. This could mean that he loses data.

It was my understanding from a previous reply from eM staff that the backup routine would not backup corrupt data?

David

Hi David,
for a backup to be created the data should be fine of course, but it’s possible that the error to the database happened during the last back up or the backup file itself was corrupted afterwards.
The backup always saves your whole database, including emails, account setting and all the rules etc. The backup functions doesn’t choose which data to save and which not.
Hope this is a bit clearer now.

Best regards,
Olivia

Unfortunately it is clear!

The backup cannot be relied on for the reasons you have enumerated!

The whole point of a backup is so there is a ‘good copy’ available should anything go wrong with the appication or O/S etc.

I will revert to using the manual built-in function of ‘exporting to eml’

May I request that an option be added to the standard backup to include eml data format.

David

Hi David,
corrupted backup isn’t as common a thing as you seem to be worried about, if there is a problem with the database you can usually find out right away, so to feel safe, keep last 2 backups.
But either way, for any feature requests you need to start an Idea thread, so other users can vote on it and our developers can view it when they go to the forum to consider what features to add.

Regards,
Olivia

David,
you misunderstood, I asked you to set up an “idea” type thread for your idea about exporting to eml files, so it might one day be considered (even if it is not planned at the time), not like a problem thread in response to me.
If you are a PRO user and the PRO support gave you a different information, that might be more relevant to your case than what I advice to the free users whose computers I do not have access to.
I deleted your post as it did not document any actual solvable issue and out of context it would be irrelevant on the forum. You may voice your concern, but please do it as a truly separate post.

Olivia