Crash when opening Calendar Event or Contact

1

I am using the latest version of emClient. I get a crash with SQL error everytime I open a calendar event or a contact. DB checks return no error. The first part of SQL error log is below. If required, I can provide the complete log. Please advice.

eM Client (6.0.19861.0)
Windows: Microsoft Windows NT 6.1.7601 Service Pack 1, Framework: 2.0.50727.5472
The following error has occurred:
System.Data.SQLite.SQLiteException: SQL logic error or missing database
no such table: attachments.Attachments
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.DbRepository1.FindEnumerable.d\_\_5.MoveNext() at MailClient.Storage.Application.Attachment.AttachmentItemCollection2.d__0.MoveNext()
at MailClient.UI.Controls.ControlAttachments.LoadAttachments(IAttachmentsItem attachmentsItem)
at MailClient.UI.Forms.formContact.loadDataFromContact(IContact contact)
at MailClient.UI.Forms.formContact…ctor(ContactItem contact)
at MailClient.UI.Forms.formContact.ShowContactForm(ContactItem contact)
at MailClient.UI.Controls.ControlContactBusinessCards.openContact(ContactItem contact)
at MailClient.UI.Controls.ControlContactBusinessCards.OnMouseDoubleClick(MouseEventArgs e)
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.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.UserControl.WndProc(Message& m)
at MailClient.UI.Controls.ControlContactBusinessCards.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(Int32 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.b__4()
at MailClient.ExceptionUtils.ExceptionUtils.Filter(BodyDelegate body, FilterDelegate filter, Action`1 handler)

2

Hi, this is most likely completely broken database. Go to C:\Users\ your account \AppData\Roaming and rename folder “eM Client”.
Then try to run eM Client again and create your account again and let it all synchronize again.

Have you tried to edit/move your database manually? Or for example to put it on network disk?

Jan

3

Hi Jan
Thank you for the answer.
My default storage location is not under AppData\Roaming but on a different drive on the PC (not a network drive).
Resynchronisation works, but what will happen to my local folders in that case?

Anand

4

your local folders are lost or if you have made backup (file - backup… in eM Client before crash) then you can restore it from it.

Jan