Announcement

Collapse
No announcement yet.

error =/

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

  • error =/

    Database error in vBulletin 3.0.0 Release Candidate 3:

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

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





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

    mysql error number: 1016

    Date: Friday 06th of February 2004 11:49:32 AM
    Script: http://squirrelspit.com/user/forumdisplay.php?f=6
    Referer: http://squirrelspit.com/user/board.php
    Username: Nebby
    IP Address: ***********

  • #2
    nevermind, i repaired the tables and all is well.

    Comment


    • #3
      Tip:

      Each time you see file.MYI in your error emails, run optimize and repair.
      Contact your hosting provider to upgrade to 4.0.17 to avoid bugs that could help cause corruption of tables.

      The MYI file unaccessability means the file/table is locked due to corruption.

      Comment


      • #4
        The bug is fixed in MySQL 4.0.16 and above though
        Scott MacVicar

        My Blog | Twitter

        Comment

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