Web mail can not be accessed. Log contains an error: Integrity constraint violation: 1062 Duplicate entry ''' for key 'PRIMARY'

Refers to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:03:24 UTC

Modified:

2017-01-16 10:47:47 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Web mail can not be accessed. Log contains an error: Integrity constraint violation: 1062 Duplicate entry ''' for key 'PRIMARY'

Symptoms

Web mail can not be accessed.

Logfile contains the error while accessing the webmail:

ERR: HORDE [imp] SQL QUERY FAILED: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '03ccc987bb84ad942c7bdc1b37a1d5af' for key 'PRIMARY'

Cause

Permission issue.

Resolution

To diagnose the issue, set the parameter '$conf['testdisable']' to "false" in horde configuration file '/usr/share/psa-horde/config/conf.php'

Then check the horde test page: http://webmail.domain.tld/test.php

Make sure that '/usr/share/psa-horde/static writable by the web server user?' at the bottom of the page ingicates 'Yes' . If not, change the permission on '/usr/share/psa-horde/static' directory:

# chmod 755 /usr/share/psa-horde/static
Have more questions? Submit a request
Please sign in to leave a comment.