Gossamer Forum: Products: Gossamer Links: Discussions: Can't call method "fetchall

Oct 27, 2005, 6:49 AM

aeroseek

Novice (39 posts)

Oct 27, 2005, 6:49 AM

Post #1 of 6

Shortcut

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/

Oct 27, 2005, 7:17 AM

Andy

Veteran / Moderator (17366 posts)

Oct 27, 2005, 7:17 AM

Post #2 of 6

Shortcut

Re: [aeroseek] Can't call method "fetchall_hashref" In reply to

Hi,

This looks like your problem;

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)

Might need to run a REPAIR TABLE's command, via SQL Monitor, or MySQLMan;

REPAIR TABLE lsql_Links;

Otherwise, you probably need to get in contact with your host, and ask them to run a myisamchk on it.

hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Oct 27, 2005, 7:53 AM

aeroseek

Novice (39 posts)

Oct 27, 2005, 7:53 AM

Post #3 of 6

Shortcut

Re: [Andy] Can't call method "fetchall_hashref" In reply to

Thanks Andy. I have tried repairing the tables already but to no avail. I have contacted my host per your suggestion. Would a backup and then a restore potentially solve this problem?
Jack R.
http://www.aeroseek.com/

Oct 27, 2005, 7:58 AM

Andy

Veteran / Moderator (17366 posts)

Oct 27, 2005, 7:58 AM

Post #4 of 6

Shortcut

Re: [aeroseek] Can't call method "fetchall_hashref" In reply to

Hi,

No problem.

> Would a backup and then a restore potentially solve this problem?

I guess it depends whats wrong in the first place. Personally, I prefer to use one of the 2 backups (just because thee backup restore function in LSQL/GLinks doesn't seem to accomidate for additional fields, so you end up having to manually adding those additional fields);

1) Using a physical backup of the MYD and MYI files (our servers with Gossamer do this automatically, which is a lot off our mind :))
2) Using my Auto_Backup plugin, which does quite a bit more (database, def files, plugins, template, admin folder, etc).

Hopefully yours will be a simple find-and-replace fix, but its not always as easy as that Unsure