Announcement

Collapse
No announcement yet.

All of a sudden getting database error HELP

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    George L
    Former vBulletin Support

  • George L
    replied
    Originally posted by Mntsnow
    Thanks again for your quick help!
    no probs

    Leave a comment:


  • Mntsnow
    replied
    Thanks again for your quick help!

    Leave a comment:


  • Mntsnow
    replied
    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

    Leave a comment:

  • George L
    Former vBulletin Support

  • George L
    replied
    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

    Leave a comment:


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

    Leave a comment:

  • George L
    Former vBulletin Support

  • George L
    replied
    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 ?

    Leave a comment:


  • Mntsnow
    replied
    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

    Leave a comment:

  • George L
    Former vBulletin Support

  • George L
    replied
    Originally posted by Mntsnow
    Thanks....Will try that
    no probs... let us know how it goes

    Leave a comment:


  • Mntsnow
    replied
    Thanks....Will try that

    Leave a comment:

  • George L
    Former vBulletin Support

  • George L
    replied
    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.

    Leave a comment:


  • Mntsnow
    started a topic All of a sudden getting database error HELP

    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.
Loading...
Working...
X