[Forum] User database error

[sdfontanini]

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT userid, username, posts
FROM user
ORDER BY posts DESC;

MySQL Error : Table 'user' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Monday, February 6th 2012 @ 08:04:22 PM
Error Date : Monday, February 6th 2012 @ 08:04:22 PM
Script : http://www.coloradoevo.com/cmps_index.php
Referrer : http://www.vbadvanced.com/forum/showthread.php?p=220950
IP Address : 174.51.92.115
Username : Gumba
Classname : vB_Database
MySQL Version : 5.1.56

[Wayne Luke]

Table is marked as crashed and should be repaired.

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showt...threadid=44909

You may have to ask your host to try and repair this for you.