How To Fix Database error in vBulletin 4.2.0 for new thread or new nreply ?
 

How i can fix this Database error it came up when we submit a new thread or new reply i disable plugin and try and still have this error please help me to fix this thanks

:mad::

Invalid SQL:
INSERT INTO vb_searchcore_text (searchcoreid, title, keywordtext)
VALUES ( 51, 'Admin اِیڈمن', '' )
ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

MySQL Error : Table './mast***_so**/vb_searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, July 12th 2012 @ 06:11:11 PM
Error Date : Thursday, July 12th 2012 @ 06:11:11 PM
Script : http://www.mastdunya.com/newreply.ph...streply&t=2880
Referrer : http://www.mastdunya.com/newreply.ph...streply&t=2880
IP Address : **.**.**.**
Username : admin
Classname : vB_Database
MySQL Version : 5.1.63-cll

You need to repair the table in question.

Go to phpmyadmin
Select the table vb_searchcore_text
Select repair table from the menu at the bottom

Thanks for reply i check in myphp and i saw this code in it
SHOW FULL FIELDS FROM `vb_searchcore_text`;

but i dont know how to repair it i can see any option there for repair so can you please let me know how i can fix this.

Use an application like phpMyAdmin to repair it.

Or see this thread - 3 ways to repair a database

Thanks for helping me out i got it fixed
AdminCP > Import & Maintenence > Repair and Optimize Tables

YEah that'll do it :) Glad you got yourself sorted