Attached files missing

[alexchairman]

under maintanence,i went for repair/optimize tables.selected all the options and did repair.

after doing this process the following error is coming in the admin pannel
Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : Table './alexforum/attachment' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Date : Saturday, November 10th 2007 @ 05:02:19 PM
Script : http://xxxxxmobiles.com/forums/admincp/index.php?do=home
Referrer : http://xxxxxmobiles.com/forums/admincp/index.php
IP Address : xxxxxxxx
Username : xxxxxx
Classname : vB_Database





and also in forum attached files are missing(not shown)

need help.plz reply

[Lynne]

Have you tried to repair/optimize just the attachment table since you got this error?

[alexchairman]

s sir i tried optimizing the attachment table.but only white screen appears for a longer time(around 30 mins)

thank u fr replying me sir

[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.

[alexchairman]

Thankyou for your reply , still my problem slove

Forums running well Thankyou.