Table "searchcore" is marked as crashed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mcharley94
    Member
    • Oct 2005
    • 51
    • 3.5.x

    [Forum] Table "searchcore" is marked as crashed

    I have been rebuilding my search index over the past several days. Everything has been going well, or so it seems until today. I have near 500,000 posts on my forum and I was around 430,000 on the rebuild when it stopped. Now I and my members are receiving a database error. I get the same error when I try to continue the index rebuild as well.

    Any ideas anyone?

    __________________________________________________________________________________
    Database error in vBulletin 4.0.2:

    Invalid SQL:
    INSERT INTO searchcore (username, contenttypeid, primaryid, groupcontenttypeid, groupid, ipaddress, userid, dateline, searchgroupid)
    VALUES ( 'Mark', 1, 1, 2, 44, 417835123, 1, 1130372610, 1 )
    ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), primaryid = VALUES(primaryid), groupcontenttypeid = VALUES(groupcontenttypeid), groupid = VALUES(groupid), ipaddress = VALUES(ipaddress), userid = VALUES(userid), dateline = VALUES(dateline), searchgroupid = VALUES(searchgroupid);

    MySQL Error : Table 'searchcore' is marked as crashed and should be repaired
    Error Number : 1194
    Request Date : Thursday, March 18th 2010 @ 08:51:37 PM
    Error Date : Thursday, March 18th 2010 @ 08:51:38 PM
    Script : http://www.myforum.org/admincp/misc.php?do=doindextypes
    Referrer : http://www.myforum.org/admincp/misc.php?do=chooser
    IP Address : 00.00.00.000
    Username : Me
    Classname : vB_Database
    MySQL Version : 4.1.22-standard
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

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

    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

    • mcharley94
      Member
      • Oct 2005
      • 51
      • 3.5.x

      #3
      TY (((Lynne)))

      I then had to repair the searchcore_text as well, but it appears to be working now. TY so much. Now if I can only finish rebuilding the search index without further issue. Think I'll wait until tomorrow though.

      Regards

      Comment

      Related Topics

      Collapse

      Working...