Announcement

Collapse
No announcement yet.

Weird SQL errors

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

  • Weird SQL errors

    My host sql went wrong yesterday as it keeps saying the MAX connection message.

    Today, finally my board went back up. However when i tried to post a message, i got this error.

    Database error in vBulletin 2.2.0:

    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (3,9739,1)
    mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Thursday 22nd of November 2001 06:52:05 PM
    Script: http://www.chikopek.com/vbulletin/vb.../newthread.php
    Referer: http://www.chikopek.com/vbulletin/ne...ead&forumid=18

    Any solutions?

    Aaron

  • #2
    The database looks like it was corupted during a bad shut down, try running repair.php found in the /etxtras directory.

    If that doesn't work you'll prolly have to restore from a backup...


    But if your host will do it for you, you can see if they will run myisamchk to try to repair the bad table....
    Last edited by The Prohacker; Thu 22 Nov '01, 5:04pm.

    Comment


    • #3
      Thanks Prohacker,

      I will try to do the repair. I will update this thread after i did the repair script.

      Comment

      Loading...
      Working...
      X