Error 1016 - what is this (error paste inside). Please help!

[Scream And Fly]

Database error in vBulletin 2.3.3:

Invalid SQL: SELECT post.postid,post.userid,post.dateline,post.title,post.pagetext, post.username,post.iconid,attachment.attachmentid,attachment.filename,attachment.visible FROM post LEFT JOIN attachment ON (attachment.attachmentid=post.attachmentid) WHERE threadid=64698 ORDER BY postid LIMIT 1
mysql error: Can't open file: 'attachment.MYD'. (errno: 144)

mysql error number: 1016


This just happened to my forums today, and I get this error when I try to view a post, etc. How can I fix it? Thank you!

Greg

[Floris]

It looks like the table has crashed and is locked to avoid further corruption.

Run optimize and repair on your database tables.

[Scream And Fly]

Thank you for the response. What would cause this? My forums were running fine, then all of a sudden that happened.

[Steve Machol]

There are a number of reasons for a table crash, most having to do with either an overworked or poorly optimized server.