My first database error, and I need help with it!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kelesis
    New Member
    • Apr 2001
    • 9
    • 3.6.x

    My first database error, and I need help with it!

    Here's the error:

    Database error in vBulletin: 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: Thursday 31st of May 2001 07:05:51 PM
    Script: /forums/index.php
    Referer: http://www.irondragonclan.com/

    Unfortunately, I really do not know SQL very well at all, so I'm not sure where to start with it.
  • Mike Sullivan
    Former vBulletin Developer
    • Apr 2000
    • 13327
    • 3.6.x

    #2
    MySQL marked the userfield table as crashed, so you need to repair it.

    You can run this query via phpMyAdmin or telnet:

    REPAIR TABLE userfield;

    (info on phpMyAdmin can be found in tubedogg's sig)

    Comment

    • tubedogg
      Senior Member
      • Feb 2001
      • 13602

      #3
      Did I hear my name? You can also find that thread at the top of this forum (it's called How To Run a Query in phpMyAdmin).

      Comment

      • Kelesis
        New Member
        • Apr 2001
        • 9
        • 3.6.x

        #4
        Thanks for the quick responses! This is where I am now, after running the query:


        SQL-query:
        REPAIR TABLE userfield; LIMIT 0, 30

        rows starting from

        Table Op Msg_type Msg_text
        userfield repair error 28 when fixing table
        vbdforum.userfield repair status Operation failed

        Comment

        • Kelesis
          New Member
          • Apr 2001
          • 9
          • 3.6.x

          #5
          I get the above result when trying to repair the userfield, and I also get this in the list of tables as a result for userfield:

          Warning: Supplied argument is not a valid MySQL result resource in /home3/irondrag/public_html/sqlstuff/lib.inc.php on line 507

          Comment

          • Mike Sullivan
            Former vBulletin Developer
            • Apr 2000
            • 13327
            • 3.6.x

            #6
            You will have to login to telnet and fix it through myisamchk.

            Info here: http://i4net.tv/marticle/get.php?act...le&articleid=4

            Comment

            • Byron
              Senior Member
              • Nov 2000
              • 525
              • 3.0.0 Beta 6

              #7
              I just encountered the 1016 error too on one of my vbs.

              Ed's post at the top solved the error.

              REPAIR TABLE userfield;

              Lesson. Always search vbulletin forums for the MySQL error code.

              Thanks.
              .

              Comment

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