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
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