No announcement yet.

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

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

    Unfortunately, I really do not know SQL very well at all, so I'm not sure where to start with it.

  • #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)


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


      • #4
        Thanks for the quick responses! This is where I am now, after running the 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


        • #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/ on line 507


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

            Info here:


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



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