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.
I have this problem too, but it is happening on all four of my gmail accounts. Started about a week ago after an update to eMClient. Random, only a couple of times per day. Dbrepair did not fix it.
Then i would next suggest as @gary advised further up this thread to go to “Menu / Accounts”’ and remove and re-add your Gmail account via the automatic account wizard.
If removing and readding your Gmail accounts still makes no difference, and you have a very recent V9 or V10 suggest to next “close eM Client” and rename the eM Client hidden database folder (as per my post further up this thread) and then reopen eM Client and resetup as new via the automatic account wizard and then see if that fixes it.
Also if you want to keep your current Accounts, Settings, Tags, etc (before you close eM Client and rename the database), go to “Menu / File / Export” and choose Settings.xml and check all the boxes and then save that file to your hard-disk. Then after you have renamed the database, “reopen eM Client” and “Skip the setup wizard” and then restore your saved Settings.xml file via “Menu / File / Import” and then see how that goes.
Lastly the other option you could do is, if you have been making regular eM Client backups either automatically via the Settings or manually via the Menu, then you can go to “Menu / File / Restore” and try restoring a recent dated backup (when you know your Gmail accounts were working ok). Then any new mail etc since the backup will update when eM Client recconects
Removing and re-adding the gmail accounts has not helped.
The problem with starting a new database is that only four of my accounts are gmail - the other nine are plain IMAP accounts. As I understand it (which I am not sure that I do!) the rest would not sync and existing local (?) folder content would be lost. But it sounds like we are on the right track.
Forgot to mention - my version is 10.3.2619
I should also mention that I have other computers running EMClient that have most of the same accounts configured, running with no problems. Yet.
If you have messages in eM Client Local folders and you rename the database and then setup a new database to test, “and the new database works ok” with your Gmail accounts, you can then do a partial restore of your Local folder emails either from an eM Client backup.zip file or from you original renamed hidden database folder. See my post below in the following thread.
Removing and re-adding the gmail accounts has not helped.
I should also mention that I have other computers running EMClient that have most of the same accounts configured, running with no problems. Yet.
If your other computers running the same eM Client version with the same accounts have no problems, then either there is a database problem on this specific computer or there is an OS or other external resident problem on this specific computer.
So as removing and readding your Gmail accounts didn’t fix and manually repairing the database also didn’t fix it, then next thing would be to test a new database as I mentioned to see if that is the issue.
If renaming the database and creating a new test one still doesn’t work, then close eM Client and “delete the new hidden database folder” and then “rename the original one back to eM Client again” and reopen eM Client to further troubleshoot it via other options such as the Operations log or Offical support.
OK! Thanks for clarifying, that is the route I will go, but as it isn’t really an urgent problem (all I have to do is keep hitting the “ignore” button every few hours) it may take me a few days to get around to it. I will report back.
Strangely enough, it has started working again - no errors for about 3 days now.