[turba] Restoring Address Book Permissions

[Jan Schneider]

Zitat von Manilal K M <libregeek at gmail.com>:

> 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"]

These queries are from the DB package. Any chance that you messed with  
the horde_datatree_seq table?

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/