Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Trouble with trial install

Quote Reply
Trouble with trial install
We are trying to get a trial install of Forums up and running to demo to management. We plan to move a large wwwthreads boards system over to your software if we can get it working to our liking. It is mostly up and running, and we are using an Oracle 9i database.

Problem is we are getting an error every time we try to reply to a post. The error is pasted below.

According to the debug info POST_LASTEST_POSTER with a NULL value. According to the debug info this value is not coming across in the CGI input at all.

Any ideas on how to fix this other than modifying the schema to allow NULL's which I am sure would screw something else up.

We are running an Oracle 9i database

Error ---------------------------------

A fatal error has occurred:

Failed to execute query: 'INSERT INTO gforum_Post (post_last_edit_time,post_time,post_anonymous_email,post_unique_id,forum_id_fk,post_reply_notify,user_id_fk,post_depth,post_ip,post_message,post_subject,post_father_id,post_icon,post_last_edit_username,post_locked,post_root_id,post_latest_reply,post_style,post_username,post_deleted,post_keep,post_latest_poster,post_replies,post_has_attachments,post_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'0','0','','0','0',gforum_Post_seq.NEXTVAL)' Reason: ORA-01400: cannot insert NULL into ("GOSSAMER"."GFORUM_POST"."POST_LATEST_POSTER") (DBD ERROR: OCIStmtExecute) at /usr/local/apache/cgi-bin/admin/GForum/Post/Write.pm line 856.

Please enable debugging in setup for more details.

Stack Trace
======================================
GForum (16184): GForum::Post::Write::reply_post called at /usr/local/apache/cgi-bin/admin/GForum.pm line 292 with arguments
(GForum::Post::Write, post_reply_post, HASH(0x1494624)).
GForum (16184): GForum::_plg_do_func_2 called at /usr/local/apache/cgi-bin/admin/GForum.pm line 240 with arguments
(post_reply_post).
GForum (16184): GForum::__ANON__ called at /usr/local/apache/cgi-bin/admin/GT/Plugins.pm line 105 with arguments
(post_reply_post).
GForum (16184): GT::Plugins::dispatch called at /usr/local/apache/cgi-bin/admin/GForum.pm line 240 with arguments
(GT::Plugins, /usr/local/apache/cgi-bin/admin/Plugins/GForum, do_post_reply_post, CODE(0x5c05d0), post_reply_post).
GForum (16184): GForum::_plg_do_func called at /usr/local/apache/cgi-bin/admin/GForum.pm line 231 with arguments
(post_reply_post).
GForum (16184): GForum::__ANON__ called at /usr/local/apache/cgi-bin/admin/GT/Plugins.pm line 105 with arguments
(post_reply_post).
GForum (16184): GT::Plugins::dispatch called at /usr/local/apache/cgi-bin/admin/GForum.pm line 231 with arguments
(GT::Plugins, /usr/local/apache/cgi-bin/admin/Plugins/GForum, do_func, CODE(0x5bd7c8), post_reply_post).
GForum (16184): GForum::do_func called at /usr/local/apache/cgi-bin/gforum.cgi line 101 with arguments
(post_reply_post).
GForum (16184): Apache::ROOT::cgi_2dbin::gforum_2ecgi::main called at /usr/local/apache/cgi-bin/admin/GT/Plugins.pm line 105 with no arguments.
GForum (16184): GT::Plugins::dispatch called at /usr/local/apache/cgi-bin/gforum.cgi line 23 with arguments
(GT::Plugins, /usr/local/apache/cgi-bin/admin/Plugins/GForum, main, CODE(0x10e24ec)).
GForum (16184): Apache::ROOT::cgi_2dbin::gforum_2ecgi::handler called at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/Apache/Registry.pm line 143 with arguments
(Apache=SCALAR(0x1746798)).
GForum (16184): (eval) called at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/Apache/Registry.pm line 143 with arguments
(Apache=SCALAR(0x1746798)).
GForum (16184): Apache::Registry::handler called at /dev/null line 0 with arguments
(Apache=SCALAR(0x1746798)).
GForum (16184): (eval) called at /dev/null line 0 with arguments
(Apache=SCALAR(0x1746798)).


System Information
======================================
Perl Version: v5.6.1
Gossamer Forum Version: 1.1.3
GForum.pm version: 1.109
GT::SQL Version: 1.098
GT::Template Version: 2.064
DBI.pm Version: 1.21
mod_perl Version: 1.26
@INC =
/home/jagerman/projects/gforum/cgi/admin
/usr/local/apache/cgi-bin/admin
/usr/local/lib/perl5/5.6.1/sun4-solaris
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
.
/usr/local/apache/
/usr/local/apache/lib/perl
GT::SQL::error = Failed to execute query: 'INSERT INTO gforum_Post (post_last_edit_time,post_time,post_anonymous_email,post_unique_id,forum_id_fk,post_reply_notify,user_id_fk,post_depth,post_ip,post_message,post_subject,post_father_id,post_icon,post_last_edit_username,post_locked,post_root_id,post_latest_reply,post_style,post_username,post_deleted,post_keep,post_latest_poster,post_replies,post_has_attachments,post_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'0','0','','0','0',gforum_Post_seq.NEXTVAL)' Reason: ORA-01400: cannot insert NULL into ("GOSSAMER"."GFORUM_POST"."POST_LATEST_POSTER") (DBD ERROR: OCIStmtExecute)
$!: No such file or directory

CGI INPUT
======================================
basic_editor => 1
do => post_reply_post
parent_post_id => 1
post_append_signature => 1
post_attachment =>
post_icon =>
post_message => test
post_reply_notify => 1
post_style => 1
post_subject => Re: [jzahn] I'd like to test this please
temp_id => 5e1c2573e30b79d527a11d98db27d1ae


CGI Cookies
======================================
gforum_1006370746_session => f4160383693596248593cd2a1adb7a2d


ENVIRONMENT
======================================
CONTENT_LENGTH => 1304
CONTENT_TYPE => multipart/form-data; boundary=---------------------------7d2bae250336
DOCUMENT_ROOT => /usr/local/apache/htdocs
GATEWAY_INTERFACE => CGI-Perl/1.1
GT_TMPDIR => /usr/local/apache/cgi-bin/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => gforum_1006370746_session=f4160383693596248593cd2a1adb7a2d
HTTP_HOST => rumor.owo.com
HTTP_REFERER => http://rumor.owo.com/cgi-bin/gforum.cgi?do=post_reply_write;parent_post_id=1
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
MOD_PERL => mod_perl/1.26
ORACLE_HOME => /opt/oracle/product/9011
PATH => /bin:/usr/bin:/usr/local/bin:/opt/oracle/product/9011/bin:/usr/ccs/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/local/bin
PERL_SEND_HEADER => On
QUERY_STRING =>
REMOTE_ADDR => 10.30.11.17
REMOTE_PORT => 1133
REQUEST_METHOD => POST
REQUEST_URI => /cgi-bin/gforum.cgi
SCRIPT_FILENAME => /usr/local/apache/cgi-bin/gforum.cgi
SCRIPT_NAME => /cgi-bin/gforum.cgi
SERVER_ADDR => 216.141.8.27
SERVER_ADMIN => bwasher@origin.ea.com
SERVER_NAME => rumor.owo.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE => Apache/1.3.24 Server at rumor.owo.com Port 80

SERVER_SOFTWARE => Apache/1.3.24 (Unix) mod_perl/1.26
TZ => US/Central
Quote Reply
Re: [jzahn] Trouble with trial install In reply to
Hi,

We don't yet have a major customer using Gossamer Forum with Oracle, so it's not nearly as tested as I would like. Internally we do testing only with Oracle 8i, so there might be some other differences there.

Can you send an email to support-gforum@gossamer-threads.com with this information and we'll work out any issues you may have, as I'd really like to make sure it works smoothly for you.

Cheers,

Alex
--
Gossamer Threads Inc.