No announcement yet.

userfield.MYD MySQL Error

  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:

  • Steve Machol
    started a topic userfield.MYD MySQL Error

    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;
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.