Announcement

Collapse
No announcement yet.

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

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

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

    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL:
    ### COUNT THREADS ###
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost>=1058062634 AND open<>10,1,0)) AS newthread
    FROM thread AS thread

    WHERE forumid = 2
    AND sticky = 0
    AND visible = 1

    AND lastpost >= 1055480015



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

    mysql error number: 1016

    Date: Saturday 12th of July 2003 11:53:35 PM
    Script: http://theratpackers.com/forumdisplay.php?f=2
    Referer: http://theratpackers.com/index.php?
    Username: MiLynne
    IP Address: 208.60.225.101

  • #2
    Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admi...html=1&check=1
    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.) This should fix the problem.

    Comment


    • #3
      What comes in email:

      Database error in vBulletin 3.0.0 Beta 4:
      Invalid SQL:
      ### COUNT THREADS ###
      SELECT COUNT(*) AS threads,
      SUM(IF(lastpost>=1058051875 AND open<>10,1,0)) AS newthread
      FROM thread AS thread
      LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
      WHERE forumid = 4
      AND sticky = 0
      AND visible = 1
      AND lastpost >= 1055462649
      AND deletionlog.primaryid IS NULL
      mysql error: Can't open file: 'thread.MYI'. (errno: 145)
      mysql error number: 1016
      Date: Saturday 12th of July 2003 07:04:09 PM
      Script: http://www.theratpackers.com/forumdisplay.php?f=4
      Referer: http://www.theratpackers.com
      Username: Kurtis
      IP Address: 64.85.232.193

      Comment


      • #4
        Thanks..I'll try that!

        Comment


        • #5
          The thread table is locked, because it is corrupt.

          Goto phpmyadmin and check the table vb3prefix_thread and browse down. From there, in the drop down box, select optmize, let it run, and then when the page reloads, check the threads table again, and run repair this time, from the same drop down box.

          Then see if the site runs again.

          Comment


          • #6
            Or:

            Admin CP -> Import & Maintenance -> Execute SQL Query

            REPAIR TABLE thread;
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              It says:

              "You are not authorized to execute SQL queries"

              now what?

              Comment


              • #8
                Or even better,

                from the Optimze & Maint. section, click on 'repair / optimize tables'

                Comment


                • #9
                  Thanks, ya'll...all better now

                  Comment


                  • #10
                    Glad we could have helped.

                    Comment


                    • #11
                      Originally posted by MiLynne
                      It says:

                      "You are not authorized to execute SQL queries"

                      now what?
                      For the record you need to give yourself this access by editing config.php:

                      Code:
                      // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
                      // The users specified here will be allowed to run queries from the control panel.
                      // See the above entries for more information on the format.
                      // Please note that the ability to run queries is quite powerful. You may wish
                      // to remove all user IDs from this list for security reasons.
                      $canrunqueries = 'x';
                      ...with x being your userid number.
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography


                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                      Comment


                      • #12
                        Hey, all....this did it again. We know how to fix it, now, but do you know why this keeps happening??

                        Comment


                        • #13
                          Read this thread:

                          http://www.vbulletin.com/forum/showt...threadid=69803
                          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                          Change CKEditor Colors to Match Style (for 4.1.4 and above)

                          Steve Machol Photography


                          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                          Comment


                          • #14
                            hey, thanks...that answers a lot of questions!

                            Comment

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