[turba] Restoring Address Book Permissions

Manilal K M libregeek at gmail.com
Fri Nov 10 21:55:50 PST 2006


Hi,
 I am using LDAP based Global Address Book, Personal Address Book and
SQL based 4 address books.  I have already added permission to these
SQL based address books. Recently some of the users were unable to
view the 2 SQL based address book. I thought it might be the problem
with the permission system. So I visited the permission system and in
the detailed view of permissions the two SQL address books are
missing. But in the top drop-down box all the address books are
displayed. So I tried to add the permissions but I got  the following
error in horde:
"CRM Contacts (sql_crm_contacts)" was not created: DB Error:
constraint violation.

The following lines appeared in the horde.log:

Nov 11 00:51:57 HORDE [error] [turba] DB Error: constraint violation:
UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1062
** Duplicate entry '3448' for key 1] [on line 468 of
"/usr/local/lib/php/Horde/DataTree/sql.php"]
Nov 11 00:51:57 HORDE [error] [turba] DB Error: constraint violation:
UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1062
** Duplicate entry '3448' for key 1] [on line 468 of
"/usr/local/lib/php/Horde/DataTree/sql.php"]
Nov 11 00:51:57 HORDE [debug] [turba] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 275 of
"/usr/local/lib/php/Horde/DataTree/sql.php"]

Nov 11 00:51:57 HORDE [error] [horde] DB Error: constraint violation:
UPDATE horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1062
** Duplicate entry '3448' for key 1] [on line 468 of
"/usr/local/lib/php/Horde/DataTree/sql.php"]
Nov 11 00:51:57 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'horde.perms'  [on line 144 of
"/usr/local/lib/php/Horde/DataTree/sql.php"]


How can I restore the permissions ?
regards
Manilal


More information about the turba mailing list