[horde] Horde Oracle Problems

[Jan Schneider]

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/