[Forum] "Repar" Problem with phpMyAdmin?

[AAR]

Hey all,

I've been having a strange issue with my forum wherein a post will cause the site to say "Database error." Posts still go through, but not in anything near the manner in which they should. vBulletin Support was very helpful, and told me that there is an issue in the searchcore_text database file, which has crashed. They told me to log on to phpMyAdmin, find the file, and click a drop-down menu saying "Repair" it, which should work.

I've logged on and found the file, but the drop down "Repair" menu is nowhere to be found. Can anyone provide any tips on how to repair it? A screenshot is attached.

Thanks!

[Andy]

Don't select the table on the left. Select the database (on the left but above the tables). Then select structure and the table and the dropdown on the bottom to repair.

[borbole]

Or alternatively you can run this query at the SQL box. it does the same.

REPAIR  TABLE 'table_name';

Ans replace table_name with the actual table name that is reported as crashed and needs repairing.

[AAR]

Thanks for the help, Andy and borbole. All is working now.

[borbole]

Glad to hear that AAR