Horde Webmail SQLSTATE 23000 Duplicate Entry

Created:

2016-11-16 13:08:11 UTC

Modified:

2017-08-16 18:28:25 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Horde Webmail SQLSTATE 23000 Duplicate Entry

Applicable to:

  • Plesk for Windows
  • Plesk 11.x for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Linux

Symptoms

While working with Horde Webmail the following error message displayed, refreshing the page clears it:

A fatal error has occurred
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0f1ff313f7d5dc65958843d70148d9f6' for key 'PRIMARY'
Details have been logged for the administrator.

Horde logfile /var/log/psa-horde/psa-horde.log ( %plesk_dir%\ mp\\horde\\horde.log on Windows) can contain the following:

2013-10-02T16:25:14+00:00 ERR: HORDE [imp] SQL QUERY FAILED: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'fdca4edc9d6d3cf250506f34beac38b2' for key 'PRIMARY'  
INSERT INTO horde_cache (cache_id, cache_timestamp, cache_expiration,
cache_data) VALUES ('fdca4edc9d6d3cf250506f34beac38b2', 1380731114,
1380732914, '0') [pid 6280 on line 553 of "D:\\Parallels\\Plesk\\Webmail\\horde\\pear\\pear\\Horde\\Db\\Adapter\\Base.php"]

Cause

SQL cache for Horde requests works incorrectly.

Resolution

In order to resolve you need to disable SQL cache for horde requests in

/usr/share/psa-horde/config/conf.php - on Linux

%plesk_dir%\\Webmail\\horde\\horde\\config\\conf.php - on Windows

from:

$conf['cache']['driver'] = 'Sql';

to

$conf['cache']['driver'] = '';
Have more questions? Submit a request
Please sign in to leave a comment.