[turba] Restoring Address Book Permissions

[Manilal K M]

On 13/11/06, Jan Schneider <jan at horde.org> wrote:
> Zitat von Manilal K M <libregeek at gmail.com>:
>
> > On 11/11/06, Jan Schneider <jan at horde.org> wrote:
> >> 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.
> >>
> > I didn't tried to do anything with horde_datatree_seq. However I
> > removed some entries in horde_datatree which corresponds to the sql
> > source of turba.
>
> That probably broke it.
>
> Jan.

Is there any solution to this issue?