Forum .LRN Q&A: Response to problem when posting to a forum

Collapse
Posted by Raad Al-Rawi on
I'm having exactly the same problem with forum postings.
I have installed dotLRN using the latest CVS (for OpenACS + dotLRN packages, as per instructions) with AOLServer 3.3ad13 and Oracle 8.1.7 on RH Linux 7.2 (although Java & InterMedia were added to Oracle after the initial Oracle install).

I also noticed that the demo Collaboraid dotLRN site (http://dotlrn.collaboraid.net/register/guest-user-login) has a problem with posting into a forum (although I can't confirm it's the same one, as no debug info is shown). I then tried the SloanSpace dotLRN guest account, and could post a new message, but when I tried deleting it, the systen produced a Request Error (I have shown only the first 10 or so lines)

Error Message: ------------------
ora8.c:3930:ora_tcl_command: error in `OCIStmtExecute ()': ORA-02292: integrity constraint (SSV2.NOTIF_REPONSE_ID_FK) violated - child record found
ORA-06512: at "SSV2.ACS_OBJECT", line 104
ORA-06512: at "SSV2.FORUMS_MESSAGE", line 131
ORA-06512: at "SSV2.FORUMS_MESSAGE", line 166
ORA-06512: at line 3

SQL:
            declare begin
                forums_message.delete_thread(:message_id);
            end;

    while executing
"ns_ora dml nsdb0 {
End: ------------------

While I can implement the fix described by Deds, is the problem a dotLRN one, or is something else (I noticed the questions about OpenACS Oracle driver, but there has not yet been a reply)?