Hello,
Since few days, I face a problem with Gmail calendar synchronisation. I got error message SQLlite 0x80004005 Error 19 ‘constraint failed’. Good to know : it worked for many years without any trouble.
I have same problem on different Windows PCs, one is running eM Client v9 and the other is running v10, then I assume it’s not related to a eM client version.
Thanks for your help
Noël
Since few days, I face a problem with Gmail calendar synchronisation. I got error message SQLlite 0x80004005 Error 19 ‘constraint failed’. Good to know : it worked for many years without any trouble.
Sounds like some sort of corruption in your database affecting the Gmail calendar.
If you can still get into eM Client, suggest to first try repairing the calendar.
To repair the Gmail Calendar, right click on the word Calendar “directly under your Gmail account” and then click “Properties” at the bottom. Then click the “Repair tab” at the top and click Repair. That’s clears all the local Gmail calendar cache and starts synching new.
Now if Repairing the calendar doesn’t work, then suggest next to go to “Menu / Accounts” and then remove your current Gmail account and re-add it as new via the “automatic account wizard”.
Note: If you do remove and readd your account, make a manual backup first via "Menu / Backup incase you need to restore for any reason.
Alternatively if you have been regularly backing up eM Client either automatically via the Settings or manually via the Menu, you could try restoring a recent dated backup when you know the calendar was working ok via “Menu / File / Restore”. Then any new emails and calendar and tasks etc will update when eM Client then recconects.
Lastly “if you don’t have any eM Client backups and you carnt get into eM Client”, then go to the following eM Client hidden database folder and rename it to eg: eM Client-Old and then reopen eM Client and setup as brand new and see if that fixes the Gmail calendar problem.
(Hidden database folder Windows)
C:\Users\username\AppData\Roaming\eM Client
(Hidden database folder Mac)
/Users/Username/Library/Application Support/eM Client