No announcement yet.

Error when deleting and banning a spam bot account

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Error when deleting and banning a spam bot account

    Hello board.

    I just need some help to clear out this error message I've got from my board today :

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    DELETE searchcore, searchcore_text
    FROM searchcore
    LEFT JOIN searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
    searchcore.contenttypeid = 1 AND
    searchcore.primaryid = 1788;

    MySQL Error : Incorrect key file for table './carflashbase/searchcore_text.MYI'; try to repair it
    Error Number : 126
    Request Date : Tuesday, July 24th 2012 @ 04:28:00 PM
    Error Date : Tuesday, July 24th 2012 @ 04:28:02 PM
    Script :
    Referrer :
    IP Address :
    Username : admin
    Classname : vB_Database
    MySQL Version : 5.1.49-3-log

    This was displayed three times when I was trying to delete spam posts and ban the spammer. I had to go through the admin panel to ban the bot account.


  • #2
    Try repairing the searchcore_text table by going to the adminCP > Repair/Optimize Tables, check the box next to "searchcore_text" and click Continue (at the bottom).


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