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)
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.
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?
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.
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.
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.