I was hacked!! Help please with msql issue
 

OK, I was hacked today, and now I am getting this error. It will not allow you to open any forum at all:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT announcementid,startdate,title,user.username,user. userid,user.usertitle,user.cus tomtitle
FROM announcement
LEFT JOIN user
ON user.userid=announcement.userid
WHERE startdate<=1062016292 AND enddate>=1062016292
AND (forumid='30' OR forumid='1' OR forumid='-1')
ORDER BY startdate DESC
LIMIT 1
mysql error: Can't open file: 'announcement.MYD'. (errno: 145)

mysql error number: 1016

Date: Wednesday 27th of August 2003 01:31:32 PM

I went in to PHP MyAdmin and I tried to "repair" the tables, but it just said:

Error

SQL-query :

SELECT *
FROM `announcement`
LIMIT 0, 30

MySQL said:

Can't open file: 'announcement.MYD'. (errno: 145)
Back

Even though you've tried it, run this query:

[SQL]
REPAIR TABLE announcement
[/SQL]

Or upload repair.php to your admin dir and run that.

OK, wow that did work this time. It was the way I was doing it I think. The board is back up, but in the admincp I can not click on the announcemnt buttons at all. I just get blank screens? Any ideas?

No idea, checked that announcement.php is still in the admin dir?

You haven't been hacked (I doubt). The announcement table has become corrupt, take a look at the MySQL forum over at vBulletin.com for eva2000's post on how to fix table corruption with MySQL 4.x.