[horde] Horde Oracle Problems - Please help

[Gottschalk, David]

Well, I was finally able to get past this sequence error issue. Somehow the number in the table changed, and didn't match what already existed. Thanks for that Jan!

I've got a new problem now though. Whenever I try to create a task(s) I get the following error "Access denied saving task: No object requested."

I only get this error while using Oracle for the datatree backend. If I use MySQL for the datatree backend, this error does not occur and the task is created.

There is nothing in the logs to help troubleshoot this issue, and it seems like a bug (I noticed other users reported this as a bug way back in 2004)

Anyways, as always any help would be greatly appreciate as this issue will decide the fate of my project.

Thanks.

David Gottschalk
Emory University
UTS Messaging Team


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