[horde] Fwd: RE: Horde Oracle Problems

[Jan Schneider]

----- Weitergeleitete Nachricht von dgottsc at emory.edu -----
      Datum: Fri, 3 Apr 2009 12:08:01 -0400
        Von: "Gottschalk, David" <dgottsc at emory.edu>
    Betreff: RE: [horde] Horde Oracle Problems
         An: Jan Schneider <jan at horde.org>

Jan,
         That entry does exist. Honestly, I have no idea how to look  
into PEAR DB to see how it is managing sequences for Oracle. I tried  
my instance of Horde against MySQL and didn't have this problem at  
all, so I can only assume this is a Oracle related issue. Any other  
tips or ideas? I'm a newbie when it comes to digging into the  
internals of Horde.

Thanks.

David Gottschalk
Emory University
UTS Messaging Team
404.727.9744


-----Original Message-----
From: horde-bounces at lists.horde.org  
[mailto:horde-bounces at lists.horde.org] On Behalf Of Jan Schneider
Sent: Monday, March 30, 2009 5:14 PM
To: horde at lists.horde.org
Subject: Re: [horde] Horde Oracle Problems

Zitat von "Gottschalk, David" <dgottsc at emory.edu>:

> I'm in the process of converting our existing Horde MySQL instance
> into a Oracle database. I've got everything running except for a few
> database related issues, that I cannot seem to tackle. If anyone
> could help me address this I would greatly appreciate it. I get this
> error while trying to add a new task using Nag in Horde:
>
> Mar 26 16:14:50 servername HORDE[11923]: [nag] DB Error: constraint
> violation: INSERT INTO horde_datatree (datatree_id, group_uid,
> datatree_name, datatree_order, datatree_data, user_uid,
> datatree_serialized, datatree_parents) VALUES ('299',
> 'horde.shares.nag', 'removed at emory.edu', NULL, '',
> 'removed at emory.edu', '0', '') [nativecode=ORA-00001: unique
> constraint (WEBMAIL.PRIMARY_4) violated] [pid 11923 on line 617 of
> "/usr/local/apache2/htdocs/horde/lib/Horde/DataTree/sql.php"]

And does datatree_id 299 already exist? Or which column is referenced
by the WEBMAIL.PRIMARY_4 contraint? If yes, then sequences are out of
order. I don't know how PEAR DB is managing sequences for Oracle, you
might want to ask there.

Jan.

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

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

This e-mail message (including any attachments) is for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.  If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this message (including any attachments) is strictly
prohibited.

If you have received this message in error, please contact
the sender by reply e-mail message and destroy all copies of the
original message (including attachments).


----- Ende der weitergeleiteten Nachricht -----


Jan.

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