Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Error Can't call method "rows" on an undefined value...

Quote Reply
Error Can't call method "rows" on an undefined value...
Hi,

Here is my mistake if I liked to provide detail pages:

Can't call method "rows" on an undefined value at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 552.

If I the Debug mode activate the following comes :




Stack Trace
======================================
Links (23063): Links::environment called at /homepages/10/d201811806/htdocs/cgi-bin/admin/Links.pm line 751 with no arguments.
Links (23063): Links::fatal called at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 552 with arguments
(Can't call method "rows" on an undefined value at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 552.
).
Links (23063): main::_build_detailed called at /homepages/10/d201811806/htdocs/cgi-bin/admin/GT/Plugins.pm line 133 with arguments
(HASH(0x840bed4)).
Links (23063): GT::Plugins::dispatch called at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 209 with arguments
(GT::Plugins=HASH(0x84177b0), create_detailed_staggered, CODE(0x83d54b4), HASH(0x840bed4)).
Links (23063): main::build_staggered called at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 55 with no arguments.
Links (23063): main::main called at /kunden/homepages/10/d201811806/htdocs/cgi-bin/admin/nph-build.cgi line 42 with no arguments.

System Information
======================================
Current user: u44839129 (1001)
Perl version: 5.8.8
Gossamer Links version: 3.2.0
GT::SQL version: 1.111
GT::Template version: 2.161
DBI.pm Version: 1.53
Running under mod_perl: No
Running under SpeedyCGI: No
@INC =
/homepages/10/d201811806/htdocs/cgi-bin/admin
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
.
GT::SQL::error = Failed to execute query: 'SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID,lsql_Category.Meta_Keywords,lsql_Category.Payment_Mode,lsql_Category.Footer,lsql_Category.Newest_Link,lsql_Category.Direct_Links,lsql_Category.Payment_Description,lsql_Category.Number_of_Links,lsql_Category.Has_Changed_Links,lsql_Category.CatRoot,lsql_Category.Full_Name,lsql_Category.Has_New_Links,lsql_Category.Name,lsql_Category.CatDepth,lsql_Category.Header,lsql_Category.Category_Template,lsql_CatLinks.CategoryID FROM lsql_CatLinks,lsql_Category,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND ((lsql_Links.isValidated = 'Yes' AND lsql_Links.ExpiryDate >= '1206533935')) GROUP BY LinkID ORDER BY LinkID LIMIT 0, 500': Got error 28 from table handler


Can you help me ???

Cheers

Hansi
Quote Reply
Re: [Hansi] Error Can't call method "rows" on an undefined value... In reply to
Hi,

Looks like your table has become a bit corrupt.

Try running these commands from Database > SQLMonitor

REPAIR TABLE lsql_Links

..and

REPAIR TABLE lsql_Category

Hope that helps.

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] Error Can't call method "rows" on an undefined value... In reply to
Hi,

Many thanks I have tried it, but it does not go yet


Hansi
Quote Reply
Re: [Hansi] Error Can't call method "rows" on an undefined value... In reply to
Hi,

Mmm. . you may need to talk to your host then, and ask them to run a "myisamchk" to repair the database.

Its probably become corrupt when MySQL was cut off part way through a large process.

Hope that helps.

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: [Hansi] Error Can't call method "rows" on an undefined value... In reply to
It's returning "error 28", which means you ran out of hard disk space. Check that your server hasn't run out of hard disk space.

Adrian
Quote Reply
Re: [brewt] Error Can't call method "rows" on an undefined value... In reply to
haha - Guess I should have checked up on what the error code meant =) (just assumed it was a corrupt DB :P)

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: [brewt] Error Can't call method "rows" on an undefined value... In reply to
Hi,

My hard disk is big enough, maybe it is the setting for MYSQL
What are the optimal settings for Mysql? My database has nearly 700000 links

Cheers

Hansi
Quote Reply
Re: [Hansi] Error Can't call method "rows" on an undefined value... In reply to
It's not MySQL. It's the OS:
Code:
$ perror 28
OS error code 28: No space left on device
If you haven't ran out of hard disk space, then you may have filled up your quota.

Adrian
Quote Reply
Re: [brewt] Error Can't call method "rows" on an undefined value... In reply to
Hi,

my Server :

Filesystem Size Used Avail Use% Mounted on
/dev/md5 2.1G 1.5G 538M 73% /
/dev/md7 243G 5.4G 238G 3% /homepages
/dev/null 259M 312k 258M 1% /tmp


???

Cheers

Hansi