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.

[Opserty]

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

[mannaraja]

Originally Posted by 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

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: