Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

1.1.2 Error

Quote Reply
1.1.2 Error
The upgrade was working fine, then I got this (I added if ($sth) {} around the problem while statement to temporarily fix it):

Code:
A fatal error has occurred:
Can't call method "fetchrow" on an undefined value at d:/site/cgi-bin/forums/admin/GForum/Category.pm line 342.


Please enable debugging in setup for more details.Stack Trace======================================GForum (2280): GForum::Category::_calc_new called at d:/site/cgi-bin/forums/admin/GForum/Category.pm line 69 with arguments (ARRAY(0x213419c)).GForum (2280): GForum::Category::list called at d:/site/cgi-bin/forums/admin/GForum.pm line 293 with arguments (GForum::Category, cat_list, HASH(0x2257610)).GForum (2280): GForum::_plg_do_func_2 called at d:/site/cgi-bin/forums/admin/GForum.pm line 241 with arguments (cat_list).GForum (2280): GForum::__ANON__ called at d:/site/cgi-bin/forums/admin/GT/Plugins.pm line 105 with arguments (cat_list).GForum (2280): GT::Plugins::dispatch called at d:/site/cgi-bin/forums/admin/GForum.pm line 241 with arguments (GT::Plugins, d:/site/cgi-bin/forums/admin/Plugins/GForum, do_cat_list, CODE(0x236edf8), cat_list).GForum (2280): GForum::_plg_do_func called at d:/site/cgi-bin/forums/admin/GForum.pm line 232 with arguments (cat_list).GForum (2280): GForum::__ANON__ called at d:/site/cgi-bin/forums/admin/GT/Plugins.pm line 105 with arguments (cat_list).GForum (2280): GT::Plugins::dispatch called at d:/site/cgi-bin/forums/admin/GForum.pm line 232 with arguments (GT::Plugins, d:/site/cgi-bin/forums/admin/Plugins/GForum, do_func, CODE(0x23728a4), cat_list).GForum (2280): GForum::do_func called at D:\site\cgi-bin\forums\forums.cgi line 103 with arguments (cat_list).GForum (2280): main::main called at d:/site/cgi-bin/forums/admin/GT/Plugins.pm line 105 with no arguments.GForum (2280): GT::Plugins::dispatch called at D:\site\cgi-bin\forums\forums.cgi line 23 with arguments (GT::Plugins, d:/site/cgi-bin/forums/admin/Plugins/GForum, main, CODE(0x22c35e8)).System Information======================================Perl Version: v5.6.1Gossamer Forum Version: 1.1.2GForum.pm version: 1.109GT::SQL Version: 1.098GT::Template Version: 2.064DBI.pm Version: 1.201@INC = d:/site/cgi-bin/forums/admin d:/Perl/lib d:/Perl/site/lib .GT::SQL::error = Failed to execute query: 'SELECT forum_id_fk,COUNT(*) FROM forums_Post USE INDEX (p_rfmp) WHERE ( ( ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) OR ( forum_id_fk = ? AND post_time > ? ) ) AND user_id_fk = ? AND post_root_id = ? ) GROUP BY forum_id_fk' Reason: Key column 'p_rfmp' doesn't exist in table


Realiiity.com Forums

Last edited by:

ellipsiiis: Mar 20, 2002, 12:32 AM
Quote Reply
Re: [ellipsiiis] 1.1.2 Error In reply to
Hi,

Ensure that the gforums_posts table in mysql database has an index name - p_rfmp

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] 1.1.2 Error In reply to
Thanks-- that was the problem. Was that a new index and if so, shouldn't the upgrade have created it?


Realiiity.com Forums
Quote Reply
Re: [ellipsiiis] 1.1.2 Error In reply to
I've not upgraded it yet :)

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] 1.1.2 Error In reply to
Hi,

Did you get any error messges when upgrading?

Cheers,

Dat

Programming and creating plugins and templates
Blog