Forum Please Help Me "" searchcore_text"" Table problem
 

Dear team ,
I am currently facing a problem with my vBulletin DB , i had tried to repair and optimize my tables and after finishing that i got the following error.

Attachment 45106

also my members getting the following error whenever they try to post new thread.

Quote:
Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO searchcore_text (searchcoreid, title, keywordtext)
VALUES ( 144, 'منتدي التجارب', '' )
ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

MySQL Error : Table './almassra_2m4ah/searchcore_text' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Wednesday, May 12th 2010 @ 04:54:04 AM
Error Date : Wednesday, May 12th 2010 @ 04:54:05 AM
Script : http://www.almassrawy.com/vbtest/for...stthread&f=119
Referrer : http://www.almassrawy.com/vbtest/for...ewthread&f=119
IP Address : 62.140.64.24
Username : islamabdelrazik
Classname : vB_Database
MySQL Version : 5.1.30


Also whenever i try to copy my database to another one through phpMyadmin i got the following error:

"Server mysql shutdown" or something like this when it try to copy table " searchcore_text "


I had seen this post for Mr Lynne


some one is facing similar problem like mine and the solution was

Quote:
maintenance > repair/optimize tables > select the searchcore_text table > click Continue. You may have to do this a couple of times until it says OK.

Note : searchcore_text table size is 409 MB

But i had tried this hundred of times but it's aim to nothing as the problem still exists and not solved up till.

You may check this here : http://www.almassrawy.com/vbtest/forum/


Thanks In Advance.
Attached Images

• http://vb.ma7room.com/gif.gif 1.GIF‎ (12.3 KB)