Database error

[se_p800]

My website www.customizepsp.co.uk seems to have an unknown database error. Usually when U get a database error it tells me the location of the problem but it isnt this time. Please could someone take a look and post any suggestions? Thanks

[rgMM]

Your page source shows

<!--
Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT COUNT(*) AS users,MAX(userid) AS max FROM vbuser;

MySQL Error : Table './customi5_vbforum/vbuser' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, June 19th 2008 @ 02:42:16 PM
Error Date : Thursday, June 19th 2008 @ 02:42:16 PM
Script : http://www.customizepsp.co.uk/
Referrer : http://www.vbulletin.com/forum/showthread.php?t=276058
IP Address : XXX
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->

[rgMM]

Probably have to look at the table that it is referencing

'./customi5_vbforum/vbuser' is marked as crashed and should be repaired

[se_p800]

Thanks for that but I dont know if I can repair it coz I cant acces admin cp due to the error..

[rgMM]

I am not familiar with that table but in general one option is repair via phpmyadmin if you can

[se_p800]

Any chance this will get fixed by itself?

[Steve Machol]

No.

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

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

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

Also please see these instructions for other available methods to repair a database:

http://dev.mysql.com/doc/refman/5.0/en/repair.html

[se_p800]

No.

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

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

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

Also please see these instructions for other available methods to repair a database:

http://dev.mysql.com/doc/refman/5.0/en/repair.html

I use bluehost and I can go on something called phpmyadmin, please can you tell me how I would fix if from there? Thanks

EDIT: I repaired everything and it now works. Thanks guys!

[se_p800]

Please could someone tell me how this could have been caused? Someone said it might have been a hack attempt somethin to do with the SQL?

[Steve Machol]

Table corruption is due to server issues. There are many possible causes and no way to know for certain the exact cause.