Announcement

Collapse
No announcement yet.

Please Help Me "" searchcore_text"" Table problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Click image for larger version

Name:	1.GIF
Views:	1
Size:	12.3 KB
ID:	3717744

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

    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

    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.

  • #2
    Take a look at this thread and try these different methods of repairing the table - 3 ways to repair a database

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      I think i need to have full access on my server to do that , i only can do the first one , kindly i have shared hosting from host gator. i will try !

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X