admincp Database error in vBulletin 3.7.3

[mannaraja]

admincp Database error sir

Sir Help Me

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Table './mannaraja2/attachment' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Monday, September 8th 2008 @ 06:34:47 AM
Error Date : Monday, September 8th 2008 @ 06:34:48 AM
Script : http://muthumobiles.org/forums/admincp/index.php?do=home
Referrer : http://muthumobiles.org/forums/admincp/index.php
IP Address : 122.145.173.79
Username : MannaRaja
Classname : vB_Database
MySQL Version : 5.0.51a

[Dismounted]

In phpMyAdmin (or something similar), browse to the "attachment" table, and click on "Repair".

[Opserty]

You need to do what the error says, repair the table.

If you still have access to the AdminCP then: AdminCP > Maintence > Repair/Optimize Tables

[Dismounted]

Looks like he was trying to get into the Admin CP, so I doubt he can repair from there. :o

[Opserty]

do=home indicates it was just the AdminCP homepage script, so the navigation should still show up. :p (I hope :D)

[mannaraja]

You need to do what the error says, repair the table.

If you still have access to the AdminCP then: AdminCP > Maintence > Repair/Optimize Tables

i have do it but still same error

[Dismounted]

Did it report any errors when repairing them?

[Marco van Herwaarden]

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 can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

[mannaraja]

ok all Friend's Thnx ........:up: