Announcement

Collapse
No announcement yet.

All of a sudden getting database error HELP

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

  • All of a sudden getting database error HELP

    All of a sudden tonight I started getting this error. This is the first email I got on the database errors......Then got an additional 1070+ emails over the course of a few minutes until I could get the database server shutdown. What do I do to recover from this?

    Database error in vBulletin 2.2.1:

    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='0' mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Wednesday 01st of May 2002 08:43:03 PM
    Script: http://www.xtremepccentral.com/vbfor...st&postid=3129
    Referer: http://www.xtremepccentral.com/vbfor...p?threadid=678
    Thanks so much for any insight on this....I just dont understand MySQL that much yet.
    -Mntsnow-

  • #2
    also replied to your support ticket

    you have a corrupted Table

    you need to repair it via one of the following methods
    ===================
    1. via phpmyadmin

    using query

    REPAIR TABLE user;

    2. or using mysqlcheck repair for 3.23.38 and above

    i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

    mysqlcheck -r -u mysqlusername -p databasename

    3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

    myisamchk -r -u root -p databasename

    option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
    :: 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


    • #3
      Thanks....Will try that
      -Mntsnow-

      Comment


      • #4
        Originally posted by Mntsnow
        Thanks....Will try that
        no probs... let us know how it goes
        :: 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


        • #5
          Getting closer...lol

          I can now see the forum again but I now get this error..

          Database error in vBulletin 2.2.1:

          Invalid SQL: UPDATE user SET lastvisit=lastactivity,lastactivity=1020316527,inforum='0' WHERE userid='1' mysql error: Incorrect key file for table: 'user'. Try to repair it

          mysql error number: 1034
          -Mntsnow-

          Comment


          • #6
            Originally posted by Mntsnow
            Getting closer...lol

            I can now see the forum again but I now get this error..

            Database error in vBulletin 2.2.1:

            Invalid SQL: UPDATE user SET lastvisit=lastactivity,lastactivity=1020316527,inforum='0' WHERE userid='1' mysql error: Incorrect key file for table: 'user'. Try to repair it

            mysql error number: 1034
            which method did you use above to repair in the first place ?
            :: 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


            • #7
              #2

              but Checking my logs I can see I have someone from Budapest Hungry hitting my db server pretty damn hard with requests that are errors.
              -Mntsnow-

              Comment


              • #8
                Originally posted by Mntsnow
                #2

                but Checking my logs I can see I have someone from Budapest Hungry hitting my db server pretty damn hard with requests that are errors.
                are you on mysql version 3.23.38 and above ? try runing #2 again
                :: 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


                • #9
                  Finally got it to take and I can now "browse" the user table in phpmyadmin without getting the error...


                  still got to kill that guy at
                  IP 193.224.41.14
                  NODE NAME = drama.obuda.kando.hu and from what I can see he is from Budapest Hungery
                  -Mntsnow-

                  Comment


                  • #10
                    Thanks again for your quick help!
                    -Mntsnow-

                    Comment


                    • #11
                      Originally posted by Mntsnow
                      Thanks again for your quick help!
                      no probs
                      :: 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

                      Loading...
                      Working...
                      X