Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729.

Quote Reply
Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729.
Hi,

after installing the German Version I get this error message. I have tried also

ALTER TABLE gforum_Post ADD INDEX p_rfl (post_root_id, forum_id_fk, post_latest_reply)

as suggested in annother posting, but thern I get the error

Query Error: Failed to execute query: 'ALTER TABLE gforum_Post ADD INDEX p_rfl (post_root_id, forum_id_fk, post_latest_reply)' Reason: Duplicate key name 'p_rfl'

Please help.

Cheers,

Wolfgang
Quote Reply
Re: [netzindex] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Can you enable debugging, and look for the "$GT::SQL::error = " line? It will have more details as to the specific problem.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Jagerman,

thanks for your reply. This is the complete error message:

Stack Trace
======================================
GForum (24496): GT::SQL::Tree::parents called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Category.pm line 143 with arguments
(GT::SQL::Tree=HASH(0x830fb9c), id, 1, cols, ARRAY(0x830d22c)).
GForum (24496): GForum::Category::_full_name_cache called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Category.pm line 96 with arguments
(1).
GForum (24496): GForum::Category::full_name called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Forum.pm line 820 with arguments
(1, : ).
GForum (24496): GForum::Forum::_plg_normalize called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Forum.pm line 805 with arguments
(HASH(0x84ccb9c)).
GForum (24496): GForum::Forum::__ANON__ called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x84ccb9c)).
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Forum.pm line 805 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, forum_normalize, CODE(0x845615c), HASH(0x84ccb9c)).
GForum (24496): GForum::Forum::normalize called at /home/clubtest/www/cgi-bin/gf/admin/GForum/Forum.pm line 43 with arguments
(HASH(0x84ccb9c)).
GForum (24496): GForum::Forum::view_collapsed called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 275 with arguments
(GForum::Forum, forum_view_collapsed, HASH(0x8371640)).
GForum (24496): GForum::_plg_do_func_2 called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 239 with arguments
(forum_view_collapsed).
GForum (24496): GForum::__ANON__ called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with arguments
(forum_view_collapsed).
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 239 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, do_forum_view_collapsed, CODE(0x82926f0), forum_view_collapsed).
GForum (24496): GForum::_plg_do_func called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 230 with arguments
(forum_view_collapsed).
GForum (24496): GForum::__ANON__ called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with arguments
(forum_view_collapsed).
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 230 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, do_func, CODE(0x828f7e0), forum_view_collapsed).
GForum (24496): GForum::do_func called at GForum::Forum::view line 27 with arguments
(forum_view_collapsed).
GForum (24496): GForum::Forum::view called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 275 with arguments
(GForum::Forum, forum_view, HASH(0x8371544)).
GForum (24496): GForum::_plg_do_func_2 called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 239 with arguments
(forum_view).
GForum (24496): GForum::__ANON__ called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with arguments
(forum_view).
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 239 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, do_forum_view, CODE(0x82926f0), forum_view).
GForum (24496): GForum::_plg_do_func called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 230 with arguments
(forum_view).
GForum (24496): GForum::__ANON__ called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with arguments
(forum_view).
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/admin/GForum.pm line 230 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, do_func, CODE(0x828f7e0), forum_view).
GForum (24496): GForum::do_func called at /home/clubtest/www/cgi-bin/gf/gforum.cgi line 106 with arguments
(forum_view).
GForum (24496): main::main called at /home/clubtest/www/cgi-bin/gf/admin/GT/Plugins.pm line 108 with no arguments.
GForum (24496): GT::Plugins::dispatch called at /home/clubtest/www/cgi-bin/gf/gforum.cgi line 22 with arguments
(GT::Plugins, /home/clubtest/www/cgi-bin/gf/admin/Plugins/GForum, main, CODE(0x821d12c)).


System Information
======================================
Perl Version: v5.6.1
Gossamer Forum Version: 1.1.8
GForum.pm version: 1.118
GT::SQL Version: 1.099
GT::Template Version: 2.084
DBI.pm Version: 1.19
@INC =
/home/clubtest/www/cgi-bin/gf/admin
/usr/lib/perl5/5.6.1/i586-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i586-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl
.
GT::SQL::error = Failed to execute query: '
SELECT Category.cat_id, Category.cat_name, Category_tree.tree_id_fk, Category.cat_depth
FROM Category, Category_tree
WHERE Category_tree.tree_anc_id_fk = Category.cat_id AND (Category_tree.tree_id_fk = '1')

' Reason: Unknown column 'Category.cat_depth' in 'field list'

Thanks for your help in advance.

Cheers,

Wolfgang
Quote Reply
Re: [netzindex] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Wolfgang,

Did you install this copy over top of another, older GForum database? 'cat_depth' has been a column since 1.1.0.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Jason,

Thanks for your reply.

I made a complete new installation, using also a new folder in the cgi-bin. But of course I am using the old MYSQL database.

Cheers,

Wolfgang
Quote Reply
Re: [netzindex] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Wolfgang,

You'll need to run the upgrade code from whatever version you were running before, or else start out with a new database. Running the upgrade code is fairly easy - if you modify the admin/GForum/Config/Data.pm file, and change the value next to 'version' back to whatever version you were previously using, then "upgrade" your existing installation, all the database upgrades will be performed and GForum should function properly.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Jason,

I have tried to upgrade from version 1.0.0 and get the following error:

GT::SQL (3609): File '/home/clubtest/www/cgi-bin/gf/admin/defs/Ancestor.def' does not exist or the permissions are set incorrectly at /home/clubtest/www/cgi-bin/gf/admin/GT/SQL/Base.pm line 62.


Please help

Cheers

Wolfgang
Quote Reply
Re: [netzindex] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Jason,

I have also tried

# $ret = $db->editor('Ancestor')->drop_table;

but then I get this message:

Can't call method "fetchrow_hashref" on an undefined value at /home/clubtest/www/cgi-bin/gf/admin/GT/SQL/Tree/Rebuild.pm line 89.


Cheers,

Wolfgang
Quote Reply
Re: [netzindex] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Do you still have the old GForum installation around?

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [Jagerman] Can't call method "fetchrow_hashref" on an undefined value at GT::SQL::Tree::parents line 729. In reply to
Hi Jason,

I have just enabled debug and added some missing fields (cat_depth, forum_move_pointer and forum_new_timeout) in the database manually and now the problem is solved.

Thanks for your help

Cheers

Wolfgang