No announcement yet.

search busted all of a sudden

  • Filter
  • Time
  • Show
Clear All
new posts

  • search busted all of a sudden

    Here is the error message.

    Invalid SQL:
    SELECT searchid, dateline
    FROM search AS search
    WHERE ipaddress =''
    ORDER BY dateline DESC LIMIT 1

    mysql error: Can't open file: 'search.MYI'. (errno: 145)

    mysql error number: 1016
    I am guessing that the search.MYI thing is fairly critical on this.

    Now, it was working fine for about 4-6 months, and no backend (coding) changes have been made for the past 3 months. Any ideas on what would cause this, and how to fix it... getting about 500 such error messages in my inbox per day is not very pleasant

  • #2
    Oh, and if anyone tells me to repair the table, can you please outline explicit steps, as well as the estimated time it would take on a 100,000+ post board. Danke.


    • #3
      Anything better than recreating the table, as here:


      • #4
        Admin CP, utilities (bottom of the left-side menu). It may be in the SQL Queries section, I don't recall. But it's in there somewhere. Repairing the search table should only take a few minutes. I suggest you close your board and repair all tables. Your board is small enough that you'd probably only be down about 15 minutes.