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!
Subject Author Views Date
Thread Repair Table Error Demolitioncrew 2321 Mar 9, 2003, 11:06 PM
Thread Re: [Demolitioncrew] Repair Table Error
Paul 2249 Mar 10, 2003, 2:47 AM
Thread Re: [Paul] Repair Table Error
Demolitioncrew 2238 Mar 10, 2003, 6:19 AM
Post Re: [Demolitioncrew] Repair Table Error
Alex 2212 Mar 18, 2003, 1:38 AM