• paulharrisjr

    (@paulharrisjr)


    I have tried to go forward with the upload and have received this error message. Any help?

    MySQL said:

    #1016 – Can’t open file: ‘wp_options.MYI’ (errno: 144)

Viewing 9 replies - 1 through 9 (of 9 total)
  • whooami

    (@whooami)

    check to see if your options table needs to be repaired.

    use phpmyadmin,

    Check:

    1. Login to phpMyAdmin.
    2. Select the database and click on ‘Structure’ tab.
    3. Right under the list of table there is a “Check All” link. Click on it to select all tables.
    4. From a “With selected:” drop-down menu right next to it, choose “Check table”.

    Repair:

    1. Login to phpMyAdmin
    2. Choose the affected database. If you only have one database, it should choose it by default so you don’t need to do anything.
    3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
    4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”

    paulharrisjr

    (@paulharrisjr)

    This is the response I got once I followed your steps:

    blog.wp_options repair info Found block with too small length at 479752; Skipp…
    blog.wp_options repair error Not enough memory for blob at 488380 (need 1775790…
    blog.wp_options repair info Found block with too small length at 479752; Skipp…
    blog.wp_options repair error Not enough memory for blob at 488380 (need 1775790…
    blog.wp_options repair status Operation failed
    ——————————-

    QUESTION:
    What prompted the intall of 2.7.1? Could it have been the error with the wp_options table, as opposed to Word Press?

    whooami

    (@whooami)

    What prompted the intall of 2.7.1? Could it have been the error with the wp_options table, as opposed to Word Press?

    huh?

    the error you are seeing is a result of corrupt table, just like I said.

    is this a brand new install, or an upgrade?

    IF its a brand new install, delete all wordpress tables that have been created.

    Read the following closely:

    If you have not changed the table prefix inside your wp-config.php, those tables I just mentioned will be named

    wp_options
    wp_users
    wp_terms
    so on and so on..

    point is, they will all start with wp_ …

    Once you delete those tables, try the install again.

    If this is NOT a brand new install, you will want to contact your host.

    If any of this is confusing, ask before you act. deleting your database tables WILL completely remove any content from your blog, so tread lightly and speak up, if this is NOT a brand new install you are doing.

    paulharrisjr

    (@paulharrisjr)

    This is an upgrade. But I wasn’t sure if all word press users were prompted last night to upgrade or there was an error somewhere on my local server where I had to do it. This upgrade was random, it just appeared and I had no option to disable plugins or anything else.

    Anyhoo, yeah this is not a brand new install. I do have a complete backup of all my wordpress files on my hard drive, in case something goes wrong.

    What steps should I take to fix this wp-options?

    I also contacted my host (yahoo small business) and they really didn’t have any answers.

    whooami

    (@whooami)

    ok, well, here’s the kicker, and what might be a deal breaker.. do you have a mysql backup? not a file backup — a database backup?

    the options table is arguably the simplest of the tables to ‘recreate’, but still a pain, non the less.

    the “upgrade your wordpress nag” is something everyone gets, btw.

    edit: oh wait .. are you talking about the page that you see, that looks to you like a new install? is that what is new to you???

    that is a direct result of your table crashing.

    paulharrisjr

    (@paulharrisjr)

    Frankly, I didn’t know what mysql was until the upgrade prompt, as this has never been a problem until the last 12 hours.

    I dont have a mysql or database backup. What does this mean? What kind of work will I have to put in to get this to work?

    I really need to get my site up and running by 9am if not sooner.

    paulharrisjr

    (@paulharrisjr)

    Ok, so then what I can do is, fix the table crash, and then reupload my wordpress back up that was saved last night, as if nothing happened. NO?

    whooami

    (@whooami)

    PS: yahoo small business is useless. If I had a host that couldnt decipher the simplest of mysql errors, and at the very least tell my customers what the problem was (even IF i couldnt fix it), I would promptly find a new host.

    its becoming more and more commonplace for hosts to shirk all those things that actually are part of being a host.. Its “fine” that they may not want to support wordpress, but ffs.. they really ought to be able to say “your table is crashed, if you cant repair it, we can try”

    and yes, they can try. they just dont want to.

    whooami

    (@whooami)

    I got 6:33 am here .. if youre in CST, you wont be up by 9am unless that table is repaired.

    Im on my way home, sorry. I’ll check in when I get home, and try to help some more.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Error’ is closed to new replies.