stephanyhoffelt Posted September 15, 2007 Share Posted September 15, 2007 I get this error message when I hit the link to upload a single photo: 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, ph_folder_id_sequence.nextval, :folder_title, :folder_sequence, sysdate from dual Link to comment Share on other sites More sharing options...
michaeljlawson Posted September 15, 2007 Share Posted September 15, 2007 Same thing happens to me: 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...
michaeljlawson Posted September 15, 2007 Share Posted September 15, 2007 That happened while trying to create a new folder Link to comment Share on other sites More sharing options...
joshroot Posted September 15, 2007 Share Posted September 15, 2007 Hi guys. Sorry for the problems, I'll have someone look into it as quickly as possible. Please be patient though, as it is the weekend. Link to comment Share on other sites More sharing options...
joshroot Posted September 15, 2007 Share Posted September 15, 2007 We think that it is fixed now, let me know if anyone is still seeing the issue. Link to comment Share on other sites More sharing options...
stephanyhoffelt Posted September 15, 2007 Author Share Posted September 15, 2007 I am still getting the error message when I try to upload. No worries though, is the weekend afterall it will wait until Monday. Link to comment Share on other sites More sharing options...
joshroot Posted September 15, 2007 Share Posted September 15, 2007 I can't recreate the same image uploading problem. Can you please post whatever error message you are seeing? Link to comment Share on other sites More sharing options...
michaeljlawson Posted September 16, 2007 Share Posted September 16, 2007 I have verified that creating a new folder works again. Thanks. Link to comment Share on other sites More sharing options...
baerbel Posted September 17, 2007 Share Posted September 17, 2007 I STILL HAVE THE PROBLEM: 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 Link to comment Share on other sites More sharing options...
stephanyhoffelt Posted September 17, 2007 Author Share Posted September 17, 2007 I am still having this problem this morning as well. This is the error message I get when I try to create a folder. 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 Link to comment Share on other sites More sharing options...
joshroot Posted September 17, 2007 Share Posted September 17, 2007 How frustrating. Grrr... Link to comment Share on other sites More sharing options...
stephanyhoffelt Posted September 18, 2007 Author Share Posted September 18, 2007 Thanks for getting this working! 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