Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Category Browser Problem

Quote Reply
Category Browser Problem
I am getting this error message with 2.01beta (haven't had been able to upgrade yet because we have to reorganize the partitions on the server to extract the data file).

The error occurs when I try to click on any folder in the category browser (with the exception of the "home" folder). This pretty much just happened "all of the sudden", it was working just fine until today. I tried restoring to an earlier version of the database, and the error message still happens. Here is the message:

Stack Trace
======================================
Links (23492): Links::environment called at Links.pm line 439.Links (23492): Links::fatal called at GT/Base.pm line 257.Links (23492): GT::Base::error_handler called at Links/Browser.pm line 1162.Links (23492): Links::Browser::_links_list_html called at Links/Browser.pm line 268.Links (23492): Links::Browser::category_click called at /home/aaasearch/public_html/kaazoocom/cgi-bin/links/admin/browser.cgi line 43.Links (23492): main::main called at /home/aaasearch/public_html/kaazoocom/cgi-bin/links/admin/browser.cgi line 23.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.0-beta1
DBI.pm Version: 1.13
GT::SQL::error = Failed to execute query: ' SELECT kzCatLinks.LinkID, kzLinks.URL, kzLinks.Title, kzLinks.Description, kzLinks.isValidated FROM kzCatLinks, kzLinks WHERE kzCatLinks.LinkID = kzLinks.ID AND kzCatLinks.CategoryID = '255' ORDER BY isValidated DESC, Title ASC LIMIT 0, 25' Reason: Got error -1 from table handler
@INC =
/usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i386-linux
/usr/lib/perl5/site_perl/5.005
.

CGI INPUT
======================================
action => category_click
category_id => 255


Anyone have any idea what is going on?

Thx



Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com
Quote Reply
Re: Category Browser Problem In reply to
Hi,

See previous post about upgrading.. As for this message:

In Reply To:
Got error -1 from table handler
This usually indicates a MySQL table is corrupt, you should run isamchk on it to fix.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Category Browser Problem In reply to
You said:

"This usually indicates a MySQL table is corrupt, you should run isamchk on it to fix."

Pardon my ignorance, but where do I find that?

Thx


Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com
Quote Reply
Re: Category Browser Problem In reply to
in the .../mysql/bin directory.

If you are on a virtual server, you'll have to ask your ISP to do it.

If not, check the docs at mysql.com first.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ


Quote Reply
Re: Category Browser Problem In reply to
Ok, I have figured out how to import the database, but now for some reason there is a problem when I try to build the HTML pages. =P I am going to start a new thread with the error message.


Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com