Announcement

Announcement Module
Collapse
No announcement yet.

WOT THE HECK? its working fine, then one day...

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • WOT THE HECK? its working fine, then one day...

    Database error in vBulletin 3.0.0 Beta 5:

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

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

    AND lastpost >= 1058260489



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

    mysql error number: 1016

    Date: Thursday 14th of August 2003 10:14:50 AM
    Script: http://www.indeathwefall.co.uk/forum...isplay.php?f=8
    Referer: http://www.indeathwefall.co.uk/forums/index.php?
    Username: Magik
    IP Address: *******************



    i get this! wots going on?

  • #2
    In PhpMyAdmin run this following query:

    Code:
    REPAIR TABLE thread

    Comment


    • #3
      also upgrade to MySQL 4.0.14 asap its a known bug with 4.0.12 and 4.0.13
      Scott MacVicar

      My Blog | Twitter

      Comment


      • #4
        Scott, does 4.0.14 definitely fix this? If so, we should update 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


        • #5
          reading http://bugs.mysql.com/bug.php?id=563 makes it appear that its been fixed.
          Scott MacVicar

          My Blog | Twitter

          Comment


          • #6
            no i just read it and ppl are saying its happening on 4.0.14

            it seamed to work for some ppl and not for others

            Comment

            Working...
            X