Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Can't call method "fetchall_hashref"

Quote Reply
Can't call method "fetchall_hashref"
    Hi, I'm recieveing the following error in Glinks 3.0.4. This happens when I click on a Category while running in Dynamic mode. Everything else seems fine. I tried repairing the tables but the error persists. Any ideas?

A fatal error has occured:
Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 691.
Please enable debugging in setup for more details.

Stack Trace
======================================
Links (21007): Links::environment called at /home/mysite/public_html/cgi-bin/admin/Links.pm line 704 with no arguments.
Links (21007): Links::fatal called at Links::Build::build_category line 691 with arguments
(Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 691.
).
Links (21007): Links::Build::build_category called at /home/mysite/public_html/cgi-bin/admin/GT/Plugins.pm line 133 with arguments
(HASH(0x82de318)).
Links (21007): GT::Plugins::dispatch called at /home/mysite/public_html/cgi-bin/admin/Links/Build.pm line 30 with arguments
(GT::Plugins=HASH(0x82fe308), build_category, CODE(0x8643938), HASH(0x82de318)).
Links (21007): Links::Build::build called at /home/mysite/public_html/cgi-bin/admin/Links/User/Page.pm line 127 with arguments
(category, HASH(0x82de318)).
Links (21007): Links::User::Page::generate_category_page called at /home/mysite/public_html/cgi-bin/admin/GT/Plugins.pm line 133 with arguments
(HASH(0x832e064)).
Links (21007): GT::Plugins::dispatch called at /home/mysite/public_html/cgi-bin/admin/Links/User/Page.pm line 58 with arguments
(GT::Plugins=HASH(0x82fe308), generate_category, CODE(0x82dcaf0), HASH(0x832e064)).
Links (21007): Links::User::Page::handle called at /home/mysite/public_html/cgi-bin/admin/GT/Plugins.pm line 127 with no arguments.
Links (21007): GT::Plugins::dispatch called at page.cgi line 26 with arguments
(GT::Plugins=HASH(0x82fe308), handle_page, CODE(0x812fe38)).
System Information

======================================
Current user: mysite (32025)
Perl version: 5.8.4
Gossamer Links version: 3.0.4
GT::SQL version: 1.111
GT::Template version: 2.142
DBI.pm Version: 1.48
Running under mod_perl: No
Running under SpeedyCGI: No
@INC =
/home/mysite/public_html/cgi-bin/admin
/usr/lib/perl5/5.8.4/i686-linux
/usr/lib/perl5/5.8.4
/usr/lib/perl5/site_perl/5.8.4/i686-linux
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
.
GT::SQL::error = Failed to execute query: 'SELECT lsql_Links.* FROM lsql_CatLinks,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND (lsql_CatLinks.CategoryID = '7' AND lsql_Links.isValidated = 'Yes') ORDER BY isNew DESC,Title LIMIT 0, 20': Can't create/write to file '/tmp/#sql_7dec_0.MYD' (Errcode: 17)
CGI Input

======================================
d => 1
g => Airports/index.html
t => luna
CGI Cookies

======================================
MySQLMan_host => localhost
MySQLMan_password => xxxxxxxx
MySQLMan_username => xxxxxx
cprelogin => no
editor_cols => 75
editor_rows => 15
h2 => o
he => llo
Environment

======================================
DOCUMENT_ROOT => /home/mysite/public_html
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/mysite/public_html/cgi-bin/admin/tmp
HTTP_ACCEPT => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET => ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING => gzip,deflate
HTTP_ACCEPT_LANGUAGE => en-us,en;q=0.5
HTTP_CONNECTION => keep-alive
HTTP_COOKIE => editor_rows=15; editor_cols=75; h2=o; he=llo; cprelogin=no; MySQLMan_host=localhost; MySQLMan_username=xxxxx; MySQLMan_password=xxxxxxxx
HTTP_HOST => www.mysite.com
HTTP_KEEP_ALIVE => 300
HTTP_REFERER => http://www.mysite.com/cgi-bin/page.cgi?g=;t=luna;d=1
HTTP_USER_AGENT => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING => g=Airports%2Findex.html;t=luna;d=1
REDIRECT_QUERY_STRING => g=Airports%2Findex.html;t=luna;d=1
REDIRECT_STATUS => 200
REDIRECT_URL => /cgi-bin/page.cgi
REMOTE_ADDR => 68.73.91.138
REMOTE_PORT => 4358
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/page.cgi?g=Airports%2Findex.html;t=luna;d=1
SCRIPT_FILENAME => /home/mysite/public_html/cgi-bin/page.cgi
SCRIPT_NAME => /cgi-bin/page.cgi
SERVER_ADDR => 205.234.140.87
SERVER_ADMIN => webmaster@mysite.com
SERVER_NAME => www.mysite.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.34 (Unix) mod_jk/1.2.5 mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.0 FrontPage/5.0.2.2634a mod_ssl/2.8.25 OpenSSL/0.9.7
Jack R.
http://www.aeroseek.com/
Subject Author Views Date
Thread Can't call method "fetchall_hashref" aeroseek 3912 Oct 27, 2005, 6:49 AM
Thread Re: [aeroseek] Can't call method "fetchall_hashref"
Andy 3741 Oct 27, 2005, 7:17 AM
Thread Re: [Andy] Can't call method "fetchall_hashref"
aeroseek 3729 Oct 27, 2005, 7:53 AM
Thread Re: [aeroseek] Can't call method "fetchall_hashref"
Andy 3714 Oct 27, 2005, 7:58 AM
Thread Re: [Andy] Can't call method "fetchall_hashref"
aeroseek 3752 Oct 27, 2005, 9:13 AM
Post Re: [aeroseek] Can't call method "fetchall_hashref"
Andy 3771 Oct 27, 2005, 9:43 AM