Database Error

[Sinko]

Hey guys, I got this error today:

Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT COUNT(*) AS count
FROM post
WHERE dateline >= 1082876400

mysql error: Can't open file: 'post.MYI'. (errno: 144)
mysql error number: 1016
Date: Sunday 25th of April 2004 01:01:18 PM
Script: http://www.maddennation.com/forums/
Referer:
Username: CraigM
IP Address: 68.204.249.154

I tried to repair it but I can't. Any suggestions? Thanks!

[Zachery]

If you can login to your adminCP.

AdminCP > Import & Maitence > Repair / Optmize Tables > Select all and hit continue, you made need to do this more than once.

If you cannot access the AdminCP from phpmyAdmin you can run this

REPAIR TABLE post;

[Sinko]

This is what I get:

post Check Warning: Table is marked as crashed and last repair failed
post Check Error: Found 126 keys of 72167

[Zachery]

Keep trying untill its repaired

[Sinko]

And if that doesn't work?

[Sinko]

And... this is the error I get when I enter the SQL you told me to enter in earlier.

Can't create new tempfile: '/var/lib/mysql/maddenna_forums/post.TMD'

[Zachery]

This is sounding like a host issue, you should try contacting your host.

[George L]

This is what I get:

post Check Warning: Table is marked as crashed and last repair failed
post Check Error: Found 126 keys of 72167

do the following in this order

1. close forum via admincp off switch
2. if you have ssh telnet access type the following

mysqlcheck -s -u mysqlusername -p vbdatabasename

this reports which mysql tables have errors (ignore any messages to do with session table)

now to repair

mysqlcheck -r -q -u mysqlusername -p vbdatabasename

reason why is vB's internal mysql repair options can no repair all mysql corruptions like mysqlcheck can

mysqlcheck is available from mysql 3.23.38 onwards