Fwd: RE: [horde] primary keys in turba_objects

[Chuck Hagenbuch]

Perhaps this would be useful to the person actually having the problem...

----- Forwarded message from matt at arrowpoint.org -----
    Date: Fri, 5 Mar 2004 10:23:32 -0500
    From: Matt Mayfield <matt at arrowpoint.org>
Reply-To: Matt Mayfield <matt at arrowpoint.org>
 Subject: RE: [horde] primary keys in turba_objects
      To: 'Chuck Hagenbuch' <chuck at horde.org>

You might try deleting the entries "drop etc...) and then inserting what
should be in there into a blank space in the table.  Also sometimes with
other horde stuff we have had difficulty with encryption and have found
using md5 is more effective than what comes stock

-----Original Message-----
From: horde-bounces at lists.horde.org
[mailto:horde-bounces at lists.horde.org] On Behalf Of Chuck Hagenbuch
Sent: Friday, March 05, 2004 10:13 AM
To: horde at lists.horde.org
Subject: Re: [horde] primary keys in turba_objects

Quoting Francesco Consumi <consumi at istitutodeglinnocenti.it>:

> Everything is working well except Turba: quite every "unique" ID that
turba
> generates for records already exists in table "turba_objects"
>
> Mar 05 09:46:41 HORDE [error] [turba] DB Error: already exists: INSERT
INTO
> turba_objects (object_name, object_email, owner_id, object_id,
object_type)
> VALUES ('xxxx', 'yyy at zzz.it', 'consumi',
'6de441c0d8f9e991b44a3c116d3de35e',
> 'Object') [nativecode=1062 ** Duplicate entry
> '6de441c0d8f9e991b44a3c116d3de35e' for key 1] [on line 215 of
> "/var/www/html/mail/horde/turba/lib/Driver/sql.php"]
>
> how can I solve this problem ?

Well, do those entries really already exist? Is object_id a VARCHAR
field like
it should be? Etc...

-chuck

--
"Regard my poor demoralized mule!" - Juan Valdez
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org

----- End forwarded message -----


-chuck

--
"Regard my poor demoralized mule!" - Juan Valdez