Announcement

Collapse
No announcement yet.

Adding Smiley to post results in mysql error

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

  • Adding Smiley to post results in mysql error

    My forums were working fine and perfect. However, today I woke up to find 121 mysql error messages sent from my vBulletin.

    Code:
    Database error in vBulletin 2.2.1:
    
    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (132,46606,0)
    mysql error: Can't find file: './svencoop/searchindex.frm' (errno: 13)
    
    mysql error number: 1017
    
    Date: Monday 28th of January 2002 01:37:56 PM
    Script: http://www.svencoop.com/forums/forums/newreply.php
    Referer: http://www.svencoop.com/forums/newre...&threadid=4083

    It was working fine before! There seems to be a file "searchindex.frm" missing, but I don't have a clue what this file is. Where is it supposed to be located?

    Help? This is very confusing.

  • #2
    Crap.

    I ran repair.php, it checked the tables and when it came to searchindex it reported an error. It tried 4 times and couldn't fix the problem.

    ARGH! The forum works, it's just the searchindex table is screwed up.

    What should I do now?

    ....help

    Comment


    • #3
      little bit of help

      I doubt this is the solution (because of version number differences) but I think the file you are looking for is not a file!

      Check this thread.

      Comment


      • #4
        Thanks.

        I had to delete the searchindex table, recreate the table using the install.php searchindex mysql information, and then re-index the 30,000 posts... ugh.

        Oh well, at least the problem is fixed.

        Comment


        • #5
          solved!

          I am happy to hear you found a solution! blargh.. 30.000posts!!

          Comment

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