Announcement

Collapse
No announcement yet.

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

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

  • MiLynne
    replied
    hey, thanks...that answers a lot of questions!

    Leave a comment:


  • Steve Machol
    replied
    Read this thread:

    http://www.vbulletin.com/forum/showt...threadid=69803

    Leave a comment:


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

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Floris
    replied
    Glad we could have helped.

    Leave a comment:


  • MiLynne
    replied
    Thanks, ya'll...all better now

    Leave a comment:


  • Floris
    replied
    Or even better,

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

    Leave a comment:


  • MiLynne
    replied
    It says:

    "You are not authorized to execute SQL queries"

    now what?

    Leave a comment:


  • Steve Machol
    replied
    Or:

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

    REPAIR TABLE thread;

    Leave a comment:


  • Floris
    replied
    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.

    Leave a comment:


  • MiLynne
    replied
    Thanks..I'll try that!

    Leave a comment:


  • MiLynne
    replied
    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

    Leave a comment:


  • Cary
    replied
    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.

    Leave a comment:


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

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X