Forum DB error...

[Blairwarlock]

Server ran out of disk space again and corrupted the DB. I freed up disk space, but here's the error I get...

<!-- Database error in vBulletin 2.2.9:
Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'userfield.MYD'. (errno: 145)


I tried running the repair.php, but it just gives me a blank page. I ran phpMyAdmin and from the SQL tab, I ran "REPAIR TABLE user;". The results were db.user repair status OK.

However, the error is still there. Please advise! TIA.

[Steve Machol]

It's the userfield table that's corrupted, not user. Run this query in phpMyAdmin:

REPAIR TABLE userfield;

[Blairwarlock]

i knew that

any idea why running repair.php would generate a BLANK page?

[Steve Machol]

The only reason I can think of is that it was not uploaded in ASCII or it was just taking a very long time to process.

P.S. Repair.php will not fix the user and userfield tables.

[inetd]

Why this message in vB3 Troubleshooting forum?

[Steve Machol]

I tried to move it but there were some parse errors. This should be fixed now so I'll try it again.

[Blairwarlock]

All good now...my dumb mistake. Still looking into why repair.php is not working right...I know for a fact it's NOT in ASCII format. So maybe it is taking a long time. Anyway to verify that IS the case other than waiting?

[Steve Machol]

Originally posted by Blairwarlock
Still looking into why repair.php is not working right...I know for a fact it's NOT in ASCII format.

Is this a typo? Repair.php needs to be uploaded in ASCII.