MySQL Error on Mailscanner load

[Scott Silva]

on 10/11/2007 10:04 AM Jason Gottschalk spake the following:
> Hello mailscanner,
> 
>   So last night I get a call from my ISP saying my server is not
>   responding. I was snoozing so they waited the 20 minutes I require
>   then they rebooted it for me. It came back up and everything seems
>   just ducky....
> 
>   Then I go to have a peak at MailScanner a bit ago, and SHEBANG! I
>   have a problem, that most likely caused my server lockup during the
>   night.
> 
>   Here is my error when I try to load MailScanner:  Any ideas? My
>   fellow Gurus...
> 
> Warning: mysql_query() [function.mysql-query]: Unable to save result
> set in
> /usr/local/cpanel/whostmgr/docroot/3rdparty/mailwatch/functions.php on
> line 530
> Error executing query: 
> 
> Got error 127 from table handler
> 
> SQL:
> 
> SELECT
>  id AS id2,
>  LEFT(hostname,INSTR(hostname,'.')-1) AS host,
>  DATE_FORMAT(timestamp, '%d/%m/%y%H:%i:%s') AS datetime,
>  from_address,
>  to_address,
>  subject,
>  size as size,
>  isspam,
>  ishighspam,
>  spamwhitelisted,
>  spamblacklisted,
>  virusinfected,
>  nameinfected,
>  otherinfected,
>  sascore,
>  report,
>  ismcp,
>  issamcp,
>  ishighmcp,
>  mcpsascore,
>  '' AS status
> FROM
>  maillog
> WHERE
>  1
> ORDER BY
>  date DESC,
>  time DESC
> LIMIT 50
>   
>   
> 
Mysql table corruption?


-- 
MailScanner is like deodorant...
You hope everybody uses it, and
you notice quickly if they don't!!!!