[turba] Restoring Address Book Permissions

[Jan Schneider]

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.

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