[turba] Restoring Address Book Permissions

[Manilal K M]

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.

regards
Manilal