Re: aggregate functions producing bad data

[Jay]

On my server the MySQL database decided to die on me.  So I killed it and
restarted and that didn't work.  So I just rebooted the machine.  Now I'm
getting this error below.

Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)

mysql error number: 1016

Anyone know what is going on?

Thanks.