No announcement yet.

userfield.MYD MySQL Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • userfield.MYD MySQL Error

    If you get an error like this:

    mysql error: Can't open file: 'userfield.MYD'. (errno: 145)
    Be aware that repair.php does not work on the user or userfiled tables. Instead, run this query to fix the table (courtesy of Ed Sullivan):

    From this thread:

    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;
    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.

  • #2
    yup there are actually 3 ways to do this:

    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. 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 [ blog summary ]


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