Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Repair Table Error

Quote Reply
Repair Table Error
Hello, I am getting some strange errors on my site. When I click the link to repair tables I get a series of errors for each category. An example of which would be this:

Category should have 154 links, but is set to 3, repairing ... 154 ok!

However, if I click "repair tables" again right after that it says:

Category should have 154 links, but is set to 7, repairing ... 154 ok!

and then it just switches back and forth between 3 and 7. However, if I use the java browse tool it will say the category name and in parentheses beside it...it will say (3) or (7), but in the right hand frame it will show all 154 sites.

Finally, I can't build the directory as I get this error:

Building Category pages ...

Building category ...
Links: 18


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 (20280): Links::environment called at /home/linkme/cgi-bin/admin/Links.pm line 431 with no arguments.Links (20280): 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 (20280): Links::Build::build_category called at /home/linkme/cgi-bin/admin/GT/Plugins.pm line 108 with arguments (HASH(0x8588298)).Links (20280): GT::Plugins::dispatch called at /home/linkme/cgi-bin/admin/Links/Build.pm line 30 with arguments (GT::Plugins, /home/linkme/cgi-bin/admin/Plugins, build_category, *Links::Build::build_category, HASH(0x8588298)).Links (20280): Links::Build::build called at /home/linkme/cgi-bin/admin/nph-build.cgi line 587 with arguments (category, HASH(0x8588298)).Links (20280): main::_build_category called at /home/linkme/cgi-bin/admin/GT/Plugins.pm line 108 with arguments (HASH(0x82d0f7c)).Links (20280): GT::Plugins::dispatch called at /home/linkme/cgi-bin/admin/nph-build.cgi line 91 with arguments (GT::Plugins, /home/linkme/cgi-bin/admin/Plugins, create_category, CODE(0x82b0128), HASH(0x82d0f7c)).Links (20280): main::build_all called at /home/linkme/cgi-bin/admin/nph-build.cgi line 43 with no arguments.Links (20280): main::main called at /home/linkme/cgi-bin/admin/nph-build.cgi line 30 with no arguments.System Information======================================Perl Version: 5.008Links SQL Version: 2.1.2DBI.pm Version: 1.30Persistant Env: mod_perl (0) SpeedyCGI (0)GT::SQL::error = Failed to execute query: ' SELECT lmao_Links.* FROM lmao_CatLinks, lmao_Links WHERE lmao_CatLinks.LinkID = lmao_Links.ID AND (lmao_Links.isValidated = 'Yes' AND lmao_CatLinks.CategoryID = '1') ORDER BY isNew DESC,isPopular DESC,Title LIMIT 0, 25 ' Reason: Got error 28 from table handler@INC = /home/linkme/cgi-bin/admin /usr/local/lib/perl5/5.8.0/i686-linux /usr/local/lib/perl5/5.8.0 /usr/local/lib/perl5/site_perl/5.8.0/i686-linux /usr/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl .CGI INPUT======================================do => allI would appreciate any assistance!
Quote Reply
Re: [Demolitioncrew] Repair Table Error In reply to
[admin@cypress admin]$ perror 28
Error code 28: No space left on device
[admin@cypress admin]$

Last edited by:

Paul: Mar 10, 2003, 2:49 AM
Quote Reply
Re: [Paul] Repair Table Error In reply to
Thanks Paul, That did help me with the build error. I'm still getting the strange error though with my categories not being able to figure out the correct number of links.

When I click repair table...i'm still getting this:
Checking category stats ...
Category should have 18 links, but is set to 0, repairing ... 18 ok!
Category should have 9 links, but is set to 0, repairing ... 9 ok!
etc. etc. etc.

and the java browse function still shows either a (0) or a (3) next to the category names. If this helps, it is also strange when I build the directory. It shows something like this:

Building category ...
Links: 154
Building subpage: 2
Building subpage: 3
Building subpage: 4
Building subpage: 5
Building subpage: 6
Building subpage: 7

Notice how the category name is completly missing? Usually it says something like Building category xyz ... etc.

I'm stumped.
Quote Reply
Re: [Demolitioncrew] Repair Table Error In reply to
Hi,

Did you do a full mysql repair after running out of disk space? Strange things can happen if your mysql tables get corrupted.

Cheers,

Alex
--
Gossamer Threads Inc.