IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Support related problems and questions

Moderators: TerryRogers, Max

Post Reply
cosw
Novice
Posts: 13
Joined: Wed Mar 14, 2018 4:58 pm

IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by cosw »

With my imap account I get always an error by sending or receiving email

"violation of PRIMARY or UNIQUE KEY constraint "PK_SYNCINFO" on table "SYNCINFO. Problematik key value is ("IDUSER" = 1, "SYNCTYPE" = 7, "IDDEVICE" =n-1800044817, "IDDATABASE"=0, "IDLOCALRECORD" = 1082960348

My server has only SSL. I have tested it with different account, new Installation of epim, new database - always the same.
I cannot use epim with IMAP - Accounts. Pop is working correct.

Has someone an idea.
Christian
epistula
Posts: 1
Joined: Tue Mar 20, 2018 10:11 am

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by epistula »

Hi,

I've the same problem too! I use IPIM pro V 7.63 .. is there any update about this error?

thanks, epistula
JGreve
Novice
Posts: 9
Joined: Tue Jun 07, 2016 1:37 pm
Has thanked: 1 time

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by JGreve »

we have the same problems since version 7.62 IMAP is no longer working properly.

We use Outlook again for now, so it works :(
horst
Guru
Posts: 227
Joined: Sun Jan 29, 2012 6:28 pm
Been thanked: 41 times

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by horst »

JGreve wrote: Tue Mar 20, 2018 1:49 pm we have the same problems since version 7.62 IMAP is no longer working properly.

We use Outlook again for now, so it works :(
Version 7.63 Pro works still fine here with IMAP on Web.de
JGreve
Novice
Posts: 9
Joined: Tue Jun 07, 2016 1:37 pm
Has thanked: 1 time

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by JGreve »

Hi,

in 7.63 also gmail works. However, all mail addresses at 1und1 and other providers do not work. Before version 7.60 everything went fine. We think that something has been changed at imap that now leads to errors.

According to Changelog, something has been fixed on IMAP, which leads us to errors.

We can no longer use the mail in EPIM as a company.

Since all companies are mail addresses at 1und1.

We have EPIM Pro / Network 3x and 2x Portable. We hope for a short-term fix in the matter, so that Outlook can leave again.

Best regards
JGreve
Novice
Posts: 9
Joined: Tue Jun 07, 2016 1:37 pm
Has thanked: 1 time

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by JGreve »

addendum:

On GMail the folder Inbox remains empty, but in the folder All messages arrive at mails.

That was not so before.

regards
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by Max »

Thank you, we are investigating the potential problem(s).
Maxim,
EPIM Team
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by Max »

An update: for those, who have issues with receiving/sending/errors on IMAP accounts in 7.63 Pro version, please:
- download and unzip following file: https://www.essentialpim.com/builds/Ess ... roPort.zip
- close EPIM
- replace with this file EssentialPIM.exe in your EPIM installation directory
- start EPIM
This is a silent update that should fix all IMAP issues. We would appreciate confirmation the problems are resolved once you try it.
Maxim,
EPIM Team
BigD
Posts: 3
Joined: Sun Mar 25, 2018 12:22 pm
Has thanked: 1 time

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by BigD »

Just FYI, the problem is still there. Exchanging the .exe hasn't solved it. Any other ideas?
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by Max »

BigD wrote: Tue Mar 27, 2018 9:35 am Just FYI, the problem is still there. Exchanging the .exe hasn't solved it. Any other ideas?
Hello,

thank you very much! Can you send us a log?

To get the logs: enable extended logging in Tools-> Options-> Synchronization, perform the mail synchronization (make sure error re-appears) and then get log for faulty synchronization using Tools-> Options-> Synchronization-> Browse and send it personally to me at ma@essentialpim.... Please refer to this topic for better context.
Maxim,
EPIM Team
BigD
Posts: 3
Joined: Sun Mar 25, 2018 12:22 pm
Has thanked: 1 time

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by BigD »

Hello Maxim,

I did so. You should have my mail in your inbox.

Cheers!
EFvanGelder
Guru
Posts: 139
Joined: Thu Mar 29, 2012 9:02 am
Been thanked: 24 times

Re: IMAP Error: violation of PRIMARY or UNIQUE KEY constraint

Post by EFvanGelder »

I Had the same problem and applied the fix both to a portable version and an installed version of Essential PIM.
(both release 7.63 of course).

Fix applied to the portable version of Essential PIM: The fix resolved the problem, no side effects, everything works as expected.

Fix applied to the installed version of Essential PIM: The fix resolved the problem allright, but it also destroyed my custom settings and license in the process.Is it because the .exe file is in fact a portable version, loking for the .ini files on a different location? Copying the necessary .ini files to the install directory did not resolve the broken custom settings nor the license though.....

I temporarily switched to the portable version, awaiting the next release of the installed version :wink:
Last edited by EFvanGelder on Fri Apr 13, 2018 9:47 am, edited 2 times in total.
With kind regards,
Erik Franciscus van Gelder
Post Reply