Gossamer Forum
Home : Products : Gossamer Links : Discussions :

new install data base error

Quote Reply
new install data base error
Crazy hi I just had a data based installed (full dmoz)........... 1st I was getting 503 time outs and finally now I get a fatal error message

cant call method "fetchall_hashref" on an undifined value at Linls::Build::build.cgi

I'm a new user with limited programming EXP.

Best regards, and happy holidays

Mike
Quote Reply
Re: [redball1] new install data base error In reply to
If you go into Setup > Misc, and set 'debug' to 2, what does the error message say then?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] new install data base error In reply to
Crazy well , first it spit out a fetchall error . then I reset defaults and debug to 2

it works now ....However it takes about 30 Pirate secs to query and generate page ....and it has this attached and written into the html

1: UPDATE lsql_SearchLog SET HitCount = 12 , Results = 29631 WHERE Term = 'games'
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 538 with arguments
(GT::SQL::Table=HASH(0x85a3104), UPDATE lsql_SearchLog SET HitCount = ? , Results = ? WHERE Term = ?, ARRAY(0x8334da8)).
GT::SQL::Table::update called at GT::SQL::Table::modify line 444 with arguments
(GT::SQL::Table=HASH(0x85a3104), HASH(0x86502d0), HASH(0x865042c)).
GT::SQL::Table::modify called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins/SearchLogger.pm line 111 with arguments
(GT::SQL::Table=HASH(0x85a3104), HASH(0x86503cc)).
Plugins::SearchLogger::log_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 118 with arguments
(HASH(0x85bdc6c)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
2: SELECT HitCount,Term,Results FROM lsql_SearchLog WHERE Term = 'games'
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(GT::SQL::Table=HASH(0x85a3104), SELECT HitCount,Term,Results FROM lsql_SearchLog WHERE Term = ? , ARRAY(0x865018c)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 1937 with arguments
(GT::SQL::Table=HASH(0x85a3104), ARRAY(0x832de98), HASH(0x865042c)).
GT::SQL::Table::_check_update called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 501 with arguments
(GT::SQL::Table=HASH(0x85a3104), HASH(0x86502d0), HASH(0x865042c)).
GT::SQL::Table::update called at GT::SQL::Table::modify line 444 with arguments
(GT::SQL::Table=HASH(0x85a3104), HASH(0x86502d0), HASH(0x865042c)).
GT::SQL::Table::modify called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins/SearchLogger.pm line 111 with arguments
(GT::SQL::Table=HASH(0x85a3104), HASH(0x86503cc)).
Plugins::SearchLogger::log_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 118 with arguments
(HASH(0x85bdc6c)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
3: SELECT * FROM lsql_SearchLog WHERE ( Term = 'games' )
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(GT::SQL::Table=HASH(0x85a3104), SELECT * FROM lsql_SearchLog WHERE ( Term = ? ) , ARRAY(0x8585f80)).
GT::SQL::Table::select called at GT::SQL::Table::get line 923 with arguments
(GT::SQL::Table=HASH(0x85a3104), GT::SQL::Condition=HASH(0x813a1a4), ARRAY(0x8650144)).
GT::SQL::Table::get called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins/SearchLogger.pm line 105 with arguments
(GT::SQL::Table=HASH(0x85a3104), games).
Plugins::SearchLogger::log_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 118 with arguments
(HASH(0x85bdc6c)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
4: SELECT lsql_CatLinks.LinkID, lsql_Category.Full_Name FROM lsql_CatLinks, lsql_Category WHERE lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.LinkID IN (1301,15807,53136,53313,70207,70522,87238,88869,88870,88889,88908,88922,89066,89069,89137,89161,89279,89281,89285,89291,89335,89356,89489,89495,89512))
GT::SQL::Relation::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 152 with arguments
(GT::SQL::Relation=HASH(0x85f4af4), LinkID, Full_Name, HASH(0x85cb98c)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
5: SELECT * FROM lsql_Reviews WHERE Review_Validated = 'Yes' AND ( Review_LinkID IN (1301,15807,53136,53313,70207,70522,87238,88869,88870,88889,88908,88922,89066,89069,89137,89161,89279,89281,89285,89291,89335,89356,89489,89495,89512) )
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(GT::SQL::Table=HASH(0x85bda74), SELECT * FROM lsql_Reviews WHERE Review_Validated = ? AND ( Review_LinkID IN (1301,15807,53136,53313,70207,70522,87238,88869,88870,88889,88908,88922,89066,89069,89137,89161,89279,89281,89285,89291,89335,89356,89489,89495,89512) ) , ARRAY(0x85a45bc)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/Link.pm line 377 with arguments
(GT::SQL::Table=HASH(0x85bda74), HASH(0x85b8d60), GT::SQL::Condition=HASH(0x85aa950)).
Links::Link::add_reviews called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 148 with arguments
(Links::Link=HASH(0x81f62e0), ARRAY(0x834150c)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
6: SELECT COUNT(*) FROM lsql_Links WHERE ( ( ( ( Description LIKE '%games%' OR Title LIKE '%games%' OR URL LIKE '%games%' ) ) ) AND ( isValidated = 'Yes' ) )
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Link=HASH(0x81f62e0), SELECT COUNT(*) FROM lsql_Links WHERE ( ( ( ( Description LIKE ? OR Title LIKE ? OR URL LIKE ? ) ) ) AND ( isValidated = ? ) ) , ARRAY(0x85a3074)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Base.pm line 273 with arguments
(Links::Link=HASH(0x81f62e0), GT::SQL::Condition=HASH(0x85a2630), ARRAY(0x85a3038)).
GT::SQL::Base::count called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Search/NONINDEXED/Search.pm line 173 with arguments
(Links::Link=HASH(0x81f62e0), GT::SQL::Condition=HASH(0x85a2630)).
GT::SQL::Search::NONINDEXED::Search::query called at GT::SQL::Base::build_query_cond line 430 with arguments
(GT::SQL::Search::NONINDEXED::Search=HASH(0x8432194)).
GT::SQL::Base::build_query_cond called at GT::SQL::Table::_query line 775 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x842f694), HASH(0x81f6a78)).
GT::SQL::Table::_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/Link.pm line 40 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
Links::Link::_query called at GT::SQL::Table::query_sth line 754 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
GT::SQL::Table::query_sth called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 123 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
7: SELECT * FROM lsql_Links WHERE ( ( ( ( Description LIKE '%games%' OR Title LIKE '%games%' OR URL LIKE '%games%' ) ) ) AND ( isValidated = 'Yes' ) ) LIMIT 0, 25
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Link=HASH(0x81f62e0), SELECT * FROM lsql_Links WHERE ( ( ( ( Description LIKE ? OR Title LIKE ? OR URL LIKE ? ) ) ) AND ( isValidated = ? ) ) LIMIT 0, 25, ARRAY(0x8583b30)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Search/NONINDEXED/Search.pm line 169 with arguments
(Links::Link=HASH(0x81f62e0), GT::SQL::Condition=HASH(0x85a2630)).
GT::SQL::Search::NONINDEXED::Search::query called at GT::SQL::Base::build_query_cond line 430 with arguments
(GT::SQL::Search::NONINDEXED::Search=HASH(0x8432194)).
GT::SQL::Base::build_query_cond called at GT::SQL::Table::_query line 775 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x842f694), HASH(0x81f6a78)).
GT::SQL::Table::_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/Link.pm line 40 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
Links::Link::_query called at GT::SQL::Table::query_sth line 754 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
GT::SQL::Table::query_sth called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 123 with arguments
(Links::Link=HASH(0x81f62e0), HASH(0x83e4140)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
8: SELECT COUNT(*) FROM lsql_Category WHERE ( ( ( Description LIKE '%games%' OR Name LIKE '%games%' ) ) )
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x83f9f00), SELECT COUNT(*) FROM lsql_Category WHERE ( ( ( Description LIKE ? OR Name LIKE ? ) ) ) , ARRAY(0x8583800)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Base.pm line 273 with arguments
(Links::Category=HASH(0x83f9f00), GT::SQL::Condition=HASH(0x8580b9c), ARRAY(0x85955c0)).
GT::SQL::Base::count called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Search/NONINDEXED/Search.pm line 173 with arguments
(Links::Category=HASH(0x83f9f00), GT::SQL::Condition=HASH(0x8580b9c)).
GT::SQL::Search::NONINDEXED::Search::query called at GT::SQL::Base::build_query_cond line 430 with arguments
(GT::SQL::Search::NONINDEXED::Search=HASH(0x82c2d30)).
GT::SQL::Base::build_query_cond called at GT::SQL::Table::_query line 775 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x8429af0), HASH(0x83fb7f8)).
GT::SQL::Table::_query called at GT::SQL::Table::query_sth line 754 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x83e4140)).
GT::SQL::Table::query_sth called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 116 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x83e4140)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).
9: SELECT * FROM lsql_Category WHERE ( ( ( Description LIKE '%games%' OR Name LIKE '%games%' ) ) ) LIMIT 0, 25
GT::SQL::Table::do_query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x83f9f00), SELECT * FROM lsql_Category WHERE ( ( ( Description LIKE ? OR Name LIKE ? ) ) ) LIMIT 0, 25, ARRAY(0x82c13dc)).
GT::SQL::Table::select called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/SQL/Search/NONINDEXED/Search.pm line 169 with arguments
(Links::Category=HASH(0x83f9f00), GT::SQL::Condition=HASH(0x8580b9c)).
GT::SQL::Search::NONINDEXED::Search::query called at GT::SQL::Base::build_query_cond line 430 with arguments
(GT::SQL::Search::NONINDEXED::Search=HASH(0x82c2d30)).
GT::SQL::Base::build_query_cond called at GT::SQL::Table::_query line 775 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x8429af0), HASH(0x83fb7f8)).
GT::SQL::Table::_query called at GT::SQL::Table::query_sth line 754 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x83e4140)).
GT::SQL::Table::query_sth called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 116 with arguments
(Links::Category=HASH(0x83f9f00), HASH(0x83e4140)).
Links::User::Search::query called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 103 with arguments
(HASH(0x83e3d54)).
GT::Plugins::dispatch called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 67 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, search_results, CODE(0x8255cd4), HASH(0x83e3d54)).
Links::User::Search::search called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/Links/User/Search.pm line 48 with no arguments.
Links::User::Search::handle called at /home/httpd/vhosts/interballx.com/cgi-bin/admin/GT/Plugins.pm line 108 with no arguments.
GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/interballx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x82353a0)).

Quote Reply
Re: [redball1] new install data base error In reply to
That was because 'debug' was set to '2'. I've set it to off again for you, and it seems to be ok now. I've also setup the search settings to run on INTERNAL INDEXING, as this will make the searches a *lot* faster (the reindexing will run once weekly).

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!