baerbel Posted June 21, 2007 Share Posted June 21, 2007 I am not able to add a new folder to my portfolio no matter which sequence number I use. Here is the error message I am getting - please help. Thanks, Baerbel Kavanaugh Problem with Your Input We had a problem processing your entry: There was a database error, and we were unable to update or create the folder ora8.c:3922:ora_tcl_command: error in `OCIStmtExecute ()': ORA-00001: unique constraint (PHOTONET.SYS_C002557) violated SQL: insert into ph_folders ( user_id, folder_id, title, folder_sequence, creation_date ) select :user_id, :folder_id, :folder_title, :folder_sequence, sysdate from dual Please back up using your browser, correct it, and resubmit your entry. Link to comment Share on other sites More sharing options...
pmj Posted June 21, 2007 Share Posted June 21, 2007 It should be fine now. For some reason, the sequence that hands out IDs for folders lost track of things and handed out already-used IDs. Regulars of this forum may note that this happened a little while ago as well. I should look into this problem more closely. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now