Gossamer Forum
Home : Products : Gossamer Links : Discussions :

fetchrow_hashref

Quote Reply
fetchrow_hashref
A fatal error has occured:
Can't call method "fetchrow_hashref" on an undefined value at (eval 14) line 7.


Please enable debugging in setup for more details.

what does it mean this error?

Thanks

Antoine
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
Please enable debugging in setup for more details.

Quote Reply
Re: [Paul] fetchrow_hashref In reply to
A fatal error has occured:

Can't call method "fetchrow_hashref" on an undefined value at /home/www/mysite/cgi-bin/links2/admin/Links/Tools.pm line 451.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (8711): Links::environment called at /home/www/mysite/cgi-bin/links2/admin/Links.pm line 431 with no arguments.
Links (8711): Links::fatal called at /home/www/mysite/cgi-bin/links2/admin/Links/Tools.pm line 451 with arguments
(Can't call method "fetchrow_hashref" on an undefined value at /home/www/mysite/cgi-bin/links2/admin/Links/Tools.pm line 451.
).
Links (8711): Links::Tools::validate_links called at GT::Template::_call_func line 764 with no arguments.
Links (8711): GT::Template::_call_func called at /home/www/mysite/cgi-bin/links2/admin/templates/admin/compiled/tools_validate.html.compiled line 23 with arguments
(GT::Template=HASH(0x824c420), Links::Tools::validate_links).
Links (8711): GT::Template::parsed_template called at /home/www/mysite/cgi-bin/links2/admin/GT/Template.pm line 600 with arguments
(GT::Template=HASH(0x824c420)).
Links (8711): GT::Template::_parse called at /home/www/mysite/cgi-bin/links2/admin/GT/Template.pm line 97 with arguments
(GT::Template=HASH(0x824c420), tools_validate.html, HASH(0x824c4b0)).
Links (8711): GT::Template::parse called at /home/www/mysite/cgi-bin/links2/admin/Links.pm line 251 with arguments
(GT::Template, tools_validate.html, ARRAY(0x824c510), HASH(0x824c4b0)).
Links (8711): Links::admin_page called at admin.cgi line 50 with no arguments.
Links (8711): main::main called at admin.cgi line 24 with no arguments.


System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.2
DBI.pm Version: 1.20
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT COUNT(*) FROM lsql_Links WHERE ( ( isValidated = ? ) ) ' Reason: Can't open file: 'lsql_Links.MYD'. (errno: 145)
@INC =
/home/www/mysite/cgi-bin/links2/admin
/usr/lib/perl5/5.6.1/i386-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
.

CGI INPUT
======================================
do => page
page => tools_validate.html


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /www/mysite
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/www/mysite/cgi-bin/links2/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => it
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => site.com
HTTP_REFERER => http://site.com/...?page=home_left.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
PATH => /usr/local/bin:/usr/bin:/bin:/www/cgi-bin
QUERY_STRING => do=page&page=tools_validate.html
REMOTE_ADDR => 62.98.2.209
REMOTE_PORT => 3608
REMOTE_USER => mysite
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/links2/admin/admin.cgi?do=page&page=tools_validate.html
SCRIPT_FILENAME => /www/mysite/cgi-bin/links2/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/links2/admin/admin.cgi
SERVER_ADDR => 66.221.153.231
SERVER_ADMIN => webmaster@site.com
SERVER_NAME => www.site.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.27 (Unix) PHP/4.3.0 FrontPage/5.0.2.2510

Any hint please?

Thanks

Antoine
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
Looks like your database may be corrupt Unsure

Quote:
GT::SQL::error = Failed to execute query: 'SELECT COUNT(*) FROM lsql_Links WHERE ( ( isValidated = ? ) ) ' Reason: Can't open file: 'lsql_Links.MYD'. (errno: 145)

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] fetchrow_hashref In reply to
The main problem is here I think: Updating Cool Flags ...
I lost all links!!! so?

Is a way to save it?

Thanks

A
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
What sort of access do you have to your database?

Try MySQLMan from the Admin. If you can see records in the Links table, you can export and save them. If MySQLMan can't read the file, then you'll need root access to the database area to see what's up.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
From the SQL monitor enter:

REPAIR TABLE lsql_Links

Last edited by:

Paul: Jun 10, 2003, 8:35 AM
Quote Reply
Re: [Paul] fetchrow_hashref In reply to
1 row(s) affected ... and the error still:

A fatal error has occured:

Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.


but now the Resync Database is working Links: Table EditorThe .def file has been re-synced


what to do?

Thanks again
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
What does 'debug' show now?

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: [pugdog] fetchrow_hashref In reply to
The first and second table of MySQLMan are MySQLMan: ERROR

The third and the last one is ok, so I exported lsql_CatRelations & lsql_Users ... in the same way do I have to import them after a new set up of Links sql 2.1.2 ??

Let me know

Thanks
A

Quote Reply
Re: [Andy] fetchrow_hashref In reply to
this:

A fatal error has occured:

Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (30956): Links::environment called at /home/www/mysite/cgi-bin/mysitelinks/admin/Links.pm line 431 with no arguments.
Links (30956): Links::fatal called at Links::Build::build_category line 87 with arguments
(Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.
).
Links (30956): Links::Build::build_category called at /home/www/mysite/cgi-bin/mysitelinks/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x8251c3c)).
Links (30956): GT::Plugins::dispatch called at /home/www/mysite/cgi-bin/mysitelinks/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, /home/www/mysite/cgi-bin/mysitelinks/admin/Plugins, build_category, *Links::Build::build_category, HASH(0x8251c3c)).
Links (30956): Links::Build::build called at /home/www/mysite/cgi-bin/mysitelinks/admin/Links/User/Page.pm line 143 with arguments
(category, HASH(0x8251c3c)).
Links (30956): Links::User::Page::generate_category_page called at /home/www/mysite/cgi-bin/mysitelinks/admin/Links/User/Page.pm line 59 with no arguments.
Links (30956): Links::User::Page::handle called at /home/www/mysite/cgi-bin/mysitelinks/admin/GT/Plugins.pm line 108 with no arguments.
Links (30956): GT::Plugins::dispatch called at page.cgi line 25 with arguments
(GT::Plugins, /home/www/mysite/cgi-bin/mysitelinks/admin/Plugins, handle_page, CODE(0x8235854)).


System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.2
DBI.pm Version: 1.20
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: '
SELECT COUNT(*)
FROM lsql_CatLinks, lsql_Links
WHERE lsql_CatLinks.LinkID = lsql_Links.ID

' Reason: Can't open file: 'lsql_CatLinks.MYD'. (errno: 145)
@INC =
/home/www/mysite/cgi-bin/mysitelinks/admin
/usr/lib/perl5/5.6.1/i386-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
.

CGI INPUT
======================================
d => 1
g => Media/index.html


CGI Cookies
======================================
MySQLMan_host => localhost
MySQLMan_password => drop7in
MySQLMan_url => mysql.cgi?data_source=DBI:mysql:mysitelinks
MySQLMan_username => mysite


ENVIRONMENT
======================================
DOCUMENT_ROOT => /www/mysite
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/www/mysite/cgi-bin/mysitelinks/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => it
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => MySQLMan_host=localhost; MySQLMan_username=mysite; MySQLMan_password=drop7in; MySQLMan_url=mysql.cgi%3Fdata_source%3DDBI%3Amysql%3Amysitelinks%26do%3Dtop_level_op%26action%3Dsql_monitor%26table%3D
HTTP_HOST => site.com
HTTP_REFERER => http://site.com/...telinks/page.cgi?d=1
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
PATH => /usr/local/bin:/usr/bin:/bin:/www/cgi-bin
QUERY_STRING => g=Media%2Findex.html&d=1
REMOTE_ADDR => 62.98.5.169
REMOTE_PORT => 4142
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/mysitelinks/page.cgi?g=Media%2Findex.html&d=1
SCRIPT_FILENAME => /www/mysite/cgi-bin/mysitelinks/page.cgi
SCRIPT_NAME => /cgi-bin/mysitelinks/page.cgi
SERVER_ADDR => 66.221.153.231
SERVER_ADMIN => webmaster@site.com
SERVER_NAME => www.site.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.27 (Unix) PHP/4.3.0 FrontPage/5.0.2.2510
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
Looks like you need to do it with all the fields in your MySQL database :(

Something like;

REPAIR TABLE lsql_CatLinks
REPAIR TABLE lsql_Category
REPAIR TABLE lsql_Reviews
REPAIR TABLE lsql_Sessions

... etc

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] fetchrow_hashref In reply to
All REPAIR TABLE are with one row affected : but now is totaly working!!!!

the last thing:

Which one is for Cool, REPAIR TABLE lsql_Cool ???

THANK YOUUUUUUUUUUUUUU A LOT ANDY :)

Antoine
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
Thank Paul...he's the one who gave the command to use Smile

The cool/pop links are in lsql_Links too. isPop and isNew gets assigned via a yes/no option (decided mainly by the script though).

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] fetchrow_hashref In reply to
I still have two errors:

- From the admin pannel I can not delete undesired links.... no error shows here

- From the admin pannel or when a user try to modify a link, we have the same error of above.

Help!!!

Thanks Andy

Thanks Paul



Antoine
Quote Reply
Re: [antoined] fetchrow_hashref In reply to
Done Laugh

From the SQL monitor enter:

REPAIR TABLE lsql_Changes and it was repaired.

Thank you the same

Antoine