MySQL Error on Mailscanner load

[Martin.Hepworth]

Jason

Have a look in the mysql error log, should have some clues..

--
Martin Hepworth
Snr Systems Administrator
Solid State Logic
Tel: +44 (0)1865 842300
> -----Original Message-----
> From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-
> bounces at lists.mailscanner.info] On Behalf Of Jason Gottschalk
> Sent: 11 October 2007 18:05
> To: mailscanner at lists.mailscanner.info
> Subject: MySQL Error on Mailscanner load
>
> 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
>
>
>
> --
>
> Best regards,
>
>  Jason Gottschalk                         mailto:Jason at SYO.Com
>  SYO Computer Engineering Services, Inc.
>  SYO - Servicing Your Organization
>  586-286-2557
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!




**********************************************************************
Confidentiality : This e-mail and any attachments are intended for the 
addressee only and may be confidential. If they come to you in error 
you must take no action based on them, nor must you copy or show them 
to anyone. Please advise the sender by replying to this e-mail 
immediately and then delete the original from your computer.
Opinion : Any opinions expressed in this e-mail are entirely those of 
the author and unless specifically stated to the contrary, are not 
necessarily those of the author's employer.
Security Warning : Internet e-mail is not necessarily a secure 
communications medium and can be subject to data corruption. We advise 
that you consider this fact when e-mailing us. 
Viruses : We have taken steps to ensure that this e-mail and any 
attachments are free from known viruses but in keeping with good 
computing practice, you should ensure that they are virus free.

Red Lion 49 Ltd T/A Solid State Logic
Registered as a limited company in England and Wales 
(Company No:5362730)
Registered Office: 25 Spring Hill Road, Begbroke, Oxford OX5 1RU, 
United Kingdom
**********************************************************************