Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Query error

Quote Reply
Query error
Greetings!

I'm getting the following error after successfully importing the entire top level Arts category of the DMOZ. I get the error upon clicking on the Arts link within the dynamically generated index page. The returned page has the below error.

I've performed the CHECK table table_name QUICK|FAST|MEDIUM etc, and it comes back as OK for both of the below mentioned tables.

I've researched past posts but all seem to point to corrupt database tables, which doesn't appear to be the problem here.

mysqld is running fine. I can connect as the Links user via mysql, and perform many different SELECT queries against the involved tables. I simply can't perform the below query.

Ideas?

System Information
======================================
Perl Version: 5.006
Links SQL Version: 2.0.4
DBI.pm Version: 1.20
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: '
SELECT mlLinks.*
FROM mlCatLinks, mlLinks
WHERE mlCatLinks.LinkID = mlLinks.ID
AND (mlLinks.isValidated = 'Yes' AND mlCatLinks.CategoryID = '1')
ORDER BY isNew DESC,isPopular DESC,Title LIMIT 0, 25
' Reason: Got error 28 from table handler
@INC =
/home/httpd/cgi-bin/meta/admin
/usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl

Subject Author Views Date
Thread Query error takacsj 2698 Nov 22, 2001, 2:26 PM
Post Re: [takacsj] Query error
Paul 2647 Nov 22, 2001, 2:36 PM
Thread Re: [takacsj] Query error
takacsj 2649 Nov 22, 2001, 4:35 PM
Post Re: [takacsj] Query error
Alex 2671 Nov 22, 2001, 4:51 PM
Thread Re: [takacsj] Query error
takacsj 2653 Nov 22, 2001, 5:03 PM
Thread Re: [takacsj] Query error
Alex 2643 Nov 22, 2001, 10:04 PM
Post Re: [Alex] Query error
takacsj 2618 Nov 24, 2001, 12:36 AM