Announcement

Collapse
No announcement yet.

Database Error

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

  • Database Error

    hi,

    i get the following error when i try to access the board (even the control panel). can someone elaborate on it? thank you.

    Database error in vBulletin Control Panel: Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
    mysql error: Can't open file: 'userfield.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Tuesday 26th of March 2002 02:35:35 PM
    Script: /vbulletin/admin/
    Referer:

  • #2
    See Ed Sullivan's first post in this thread:

    http://www.vbulletin.com/forum/showt...=userfield.myd
    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


    • #3
      ahh...ok. i just did a "myisamchk" on all my .MYI files and fixed them. for a second, i could get into the board but now i get the following:

      Database error in vBulletin: Invalid SQL: SELECT template FROM template WHERE title='options'
      mysql error: Got error 127 from table handler
      mysql error number: 1030
      Date: Tuesday 26th of March 2002 03:08:02 PM
      Script: /vbulletin/
      Referer: http://www.wickedland.com/

      hints?

      ps
      i tried to search for "error 127" on this board but unfortunately 127 is only 3 letters..
      Last edited by propheci; Tue 26 Mar '02, 12:14pm.

      Comment


      • #4
        nm...it's all gone after a reboot.

        Comment


        • #5
          For future reference:

          Error code 127: Unknown error 127
          127 = Record-file is crashed
          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
            Originally posted by propheci
            ahh...ok. i just did a "myisamchk" on all my .MYI files and fixed them. for a second, i could get into the board but now i get the following:

            Database error in vBulletin: Invalid SQL: SELECT template FROM template WHERE title='options'
            mysql error: Got error 127 from table handler
            mysql error number: 1030
            Date: Tuesday 26th of March 2002 03:08:02 PM
            Script: /vbulletin/
            Referer: http://www.wickedland.com/

            hints?

            ps
            i tried to search for "error 127" on this board but unfortunately 127 is only 3 letters..
            you have a corrupted template table, did you shut down mysql before myisamchk ?
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment

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