Announcement

Collapse
No announcement yet.

database error

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

  • database error

    This is one of many errors i get. =(
    It have been working fine since i installed vb3 beta 5. But today these errors yust came running in =)
    I can acces the forum ok. its question about enter subforums that is the problem ?

    Database error in vBulletin 3.0.0 Beta 5:

    Invalid SQL:
    SELECT thread.title, thread.threadid, thread.forumid, thread.postuserid, thread.visible,
    NOT ISNULL(deletionlog.primaryid) AS isdeleted
    ,post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
    WHERE thread.threadid IN (0,5647)

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

    mysql error number: 1016
    Pimp Daddy Croft Magazine

  • #2
    getting this when going in to phpmyadmin.


    SQL-query :

    SHOW KEYS FROM `thread`

    MySQL said:


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


    "edit" I tryed running this
    REPAIR TABLE user;
    With no luck. Is there anything ellse i can do ? "edit"
    Last edited by croft; Sun 24 Aug '03, 11:47am.
    Pimp Daddy Croft Magazine

    Comment


    • #3
      That is the correct way to repair this table. Sometimes you need to run the repair query more than once so try again.
      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


      • #4
        I have run that thing about 10 times now and nothing.
        How is the thread table supposed to look like ?
        Qause when i push the thread table to browse it it comes up with this.


        SQL-query :

        SHOW KEYS FROM `thread`

        MySQL said:


        Can't open file: 'thread.MYI'. (errno: 145)
        Is the problem in the thread table or what ?
        Pimp Daddy Croft Magazine

        Comment


        • #5
          Your thread table is crashed and needs to be repaired:

          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


          • #6
            That fixed the problem =)
            A question tho.
            i se that there is a repair.php file in the admincp folder.
            can i run that when this happens again ?
            Pimp Daddy Croft Magazine

            Comment


            • #7
              Yep.
              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

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