When I sign in to eM Client a pop up page from eM Client Operations states that an Error Has Occurred and in brackets it says “Google Settings.”
I have checked my Google Settings and all appears to be OK but I can’t get rid of the pop up error message.
Any suggestions?
When I sign in to eM Client a pop up page from eM Client Operations states that an Error Has Occurred and in brackets it says “Google Settings.
What are your Google account settings ? Blank out anything personal.
Also click the dropdown arrow on the right of Refresh and click “Show Operations”. Then click the “Log tab” and look for any obvious errors and paste them in this thread. Again blank out anything personal.
Here is a copy of the eM Client Operations Log: The Error Page states Google Settings, which I have checked and can find nothing wrong. Do you see an obvois problem?
02:21:34 PM Online state: changed to online due to NetworkAvailability
02:21:34 PM IMAP Synchronizing folder list
02:21:35 PM Google Contacts Synchronizing folder list
02:21:35 PM Google Calendar Synchronizing folder list
02:21:35 PM Google Contacts Synchronizing folder ‘/Contacts’
02:21:35 PM Google Settings Synchronizing tags
02:21:35 PM [email protected] [Google Settings] MailClient.Storage.Application.OperationException
—> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: ‘UNIQUE constraint failed: Categories.name’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteScalar()
at MailClient.Storage.Data.DbCommandExtensions.ExecuteScalarClearParams(IDbCommand command)
at MailClient.Storage.Category.Data.DbCategoryRepository.Store(ICategoryRepositoryItem item)
at MailClient.Storage.Data.DbRepository1.Add[ST](Object senderContext, IEnumerable1 items)
at MailClient.RepositoryExtensions.Add[T,ST](IRepository1 repository, IEnumerable1 items)
at MailClient.Categories.CategoryExtensions.Add(DbRepository1 repository, IEnumerable1 items, IAccountWithCategoriesManagement managementAccount)+MoveNext()
at MailClient.Categories.Common.CategoriesSynchronizer.<>c__DisplayClass49_0.<b__2>d.MoveNext()
— End of stack trace from previous location —
at MailClient.Protocols.Common.RequestIssuer.<>c__DisplayClass13_0.b__0(WorkerStatus ws, CancellationToken ct)
at MailClient.Protocols.Gdata.GenericGapiCommand.Execute(WorkerStatus status)
— End of inner exception stack trace —
at MailClient.Protocols.Gdata.GenericGapiCommand.Execute(WorkerStatus status)
at MailClient.Commands.Command.Process(WorkerStatus status)
EnqueuedStackTrace =
at MailClient.Categories.Common.CategoriesSynchronizer.<>c__DisplayClass49_0.b__0()
at MailClient.Protocols.Common.AccountBase.RunIfOnline[T](Func1 actionIfOnline, Func1 actionIfOffline)
at MailClient.Categories.Common.CategoriesSynchronizer.EnqueueSynchronize(CancellationToken cancellationToken)
at MailClient.Categories.Common.CategoriesSynchronizer.SynchronizeAsync(CancellationToken cancellationToken)
at MailClient.Protocols.Gdata.GdataSettingsAccount.SynchronizeAsync(CancellationToken cancellationToken)
at MailClient.Protocols.Gdata.GdataSettingsAccount.b__25_0()
at MailClient.Protocols.Common.AccountBase.RunIfOnline[T](Func1 actionIfOnline, Func1 actionIfOffline)
at MailClient.Protocols.Gdata.GdataSettingsAccount.Synchronize(SynchronizationPriority priority)
at MailClient.Accounts.BindingAccountBase.Receive()
at MailClient.Accounts.AccountManager.ReceiveAllInternal(Boolean checkIncludeInGlobalOperations)
at MailClient.Accounts.AccountManager.SendAndReceiveAll(Boolean checkIncludeInGlobalOperations)
at MailClient.Program.<>c.b__279_0(Task _)
at System.Threading.Tasks.ContinuationTaskFromTask.InnerInvoke()
at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
at System.Threading.Tasks.Task.ExecuteEntryUnsafe(Thread threadPoolThread)
at System.Threading.Tasks.Task.ExecuteFromThreadPool(Thread threadPoolThread)
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart()
at System.Threading.Thread.StartCallback()
GUIStatus_Exception_Reported = True
02:21:36 PM Google Calendar Synchronizing folder ‘/Calendar’
02:21:36 PM IMAP Synchronizing folder ‘/All Mail’
02:21:37 PM IMAP Downloading messages: For folder /All Mail
02:31:34 PM IMAP Synchronizing folder list
02:31:34 PM Google Contacts Synchronizing folder ‘/Contacts’
02:31:34 PM Google Contacts Synchronizing folder list
02:31:34 PM IMAP Synchronizing folder ‘/All Mail’
02:31:47 PM IMAP Uploading item(s) to folder ‘/All Mail’
02:31:54 PM IMAP Moving item(s) from folder ‘/All Mail’ to folder ‘/Trash’
02:32:34 PM IMAP Uploading item(s) to folder ‘/All Mail’
02:41:34 PM Google Contacts Synchronizing folder ‘/Contacts’
02:41:34 PM IMAP Synchronizing folder list
02:41:34 PM Google Calendar Synchronizing folder list
02:41:34 PM Google Contacts Synchronizing folder list
02:41:34 PM IMAP Synchronizing folder ‘/All Mail’
02:41:35 PM Google Calendar Synchronizing folder ‘/Calendar’
02:51:34 PM Google Contacts Synchronizing folder ‘/Contacts’
02:51:34 PM IMAP Synchronizing folder list
02:51:34 PM Google Contacts Synchronizing folder list
02:51:34 PM IMAP Synchronizing folder ‘/All Mail’
02:52:51 PM Online state: changed to offline due to NetworkAvailability
03:02:49 PM Online state: changed to online due to NetworkAvailability
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: ‘UNIQUE constraint failed: Categories.name’.
atMicrosoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db
Sounds like your local mail database is partially corrupted in some way.
You you could try forcing a repair of the database manually or if that doesn’t work, you may need to “rename your old database” and “create a new mail database” to test.
To force a repair on the database do the following.
(Repair eM Client database manually for Windows)
Close eM Client, and then open a Windows Command Prompt. Not a PowerShell, but a command prompt”. Then paste in this command:- “C:\Program Files (x86)\eM Client\MailClient.exe” /dbrepair
Then reopen eM Client and see if that fixes the problem.
(To repair eM Client database manually for Mac)
“Close eM Client” and then “open the Terminal app via either Launchpad or Utilities” on the Mac. Then Paste and run the following command:- /Applications/eM\ Client.app/Contents/MacOS/eM\ Client /dbrepair
Then reopen eM Client and see if that fixes the problem.
Now if the repair doesn’t work, try renaming your current database to test if that is the problem.
(Rename database for Windows)
If you have Windows, close eM Client and go to the following hidden database folder “C:\Users\yourname\AppData\Roaming\eM Client” and then rename it temporarily to eg: eM Client-old.
Then reopen eM Client and setup as new to test.
(Rename database for Mac)
If you have a Mac, go to your Desktop” and then “click the Go menu” along the top. Then “hold down the Option key” and while holding the option key, click the “Library” menu that appears. Then click the “Application Support” folder, and you will see the eM Client folder. “Users\yourusername\Library\Application Support\eM Client” Finally rename it temporarily to eg: eM Client-old .
Then reopen eM Client and setup as new to test.
This is a database issue.
It can be resolved by removing the Gmail account, then adding it back again.
1 Like
I followed the suggestion and removed the problem Gmail and reinstalled it and that seems to have eliminated the problem.
Thanks all for your help.