Announcement

Collapse
No announcement yet.

Emptied word and searchindex

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

  • Emptied word and searchindex

    If I emptied word and searchindex what do I do? It gives me errors like:

    Database error in vBulletin Control Panel: Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('mad','props','on','the','new','the','new','forum')
    mysql error: Can't open file: 'word.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Tuesday 22nd of May 2001 10:40:20 PM
    Script: /admin/misc.php
    Referer: http://forums.particlesun.com/admin/misc.php?

  • #2
    Errorno 145 means the table was marked as crashed and needs to be repaired. Run isamchk or myisamchk to repair the table, or you can use admin/repair.php

    Comment


    • #3
      I ran the repair.php?html=1&check=1

      It recognised and repaired both tables, how do I know if all is well now?

      Comment


      • #4
        Originally posted by ender
        It recognised and repaired both tables, how do I know if all is well now?
        It should be... a true test would be to make a new post and see if you get any errors.

        Comment


        • #5
          Database error in vBulletin: Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1,14700,1)
          mysql error: Can't find file: 'searchindex.MYD' (errno: 2)
          mysql error number: 1017
          Date: Tuesday 22nd of May 2001 11:59:17 PM
          Script: /newthread.php
          Referer: http://forums.particlesun.com/newthr...read&forumid=3

          Comment


          • #6
            Originally posted by ender
            mysql error: Can't find file: 'searchindex.MYD' (errno: 2)
            Error code 2: No such file or directory

            It looks like your searchindex.MYD (data file) is no longer in the data directory.

            Comment


            • #7
              I think I fixed it, I reverted back to an old version of the searchindex and word. In repair it says everything is working OK.

              Comment

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