[horde] Constraint Violation in horde_prefs

Duane Drake horde at littleduck.org
Thu Apr 13 07:44:20 PDT 2006


I have been running Horde now for about 5 years and after recently  
upgrading via patch to
Horde 3.1, I have noticed the following issue, mostly around the portal page:

Upon login, and with every refresh of the portal, the following error  
in entered in
Horde.log:

Apr 13 10:25:47 HORDE [emergency] [horde] DB Error: constraint  
violation: INSERT INTO
horde_prefs (pref_uid, pref_scope, pref_name, pref_value)  
VALUES('dfreeman', 'kronolith',
'display_cals', 'a:1:{i:0;s:8:\"dfreeman\";}') [nativecode=1062 **  
Duplicate entry
'dfreeman-krono-display_ca' for key 1] [on line 258 of
"/home/httpd/horde/lib/Horde/Prefs/sql.php"]

The portal is usable, but I cannot change the layout for any user  
because of this error.
The layout changes seem to stick in the layout configurator, but are  
not applied when I
return to the portal page.

I am not using the databse session handler, so I did not apply that  
table change in the
upgrading document.

I have versions:

Horde 3.1.1
IMP 4.1.1
Kronolith 2.1.1
Jonah 0.1 CVS
PHP 4.4.2
Mysql 4.1.14

In Mysql, I rebuilt the indexes in horde_prefs, and removed all entries for
pref_scope=kronolith for my own username and I still get the error.

I have approximately 30 users for a small mortgage company and some friends.

Thanks,

Duane Drake



More information about the horde mailing list