Title: Database error on Upgrade Last modified: August 18, 2016 --- # Database error on Upgrade * [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/) * I am getting a database error on my upgrade that is causing significant problems with the database. * I use Yahoo small business for my host, and they use MYSQL v.4+. * This is a significant problem. Yahoo does an automatic database backup of the MYSQL file periodically. When I checked, it indicated that it was from a few days ago. * However, when I tried to restore, the file is from 2005, and is very old. * Here is a link to my site: [http://avianflu.futurehs.com/](http://avianflu.futurehs.com/) * I get a lot of traffic (15,000 – 25,000 visitors per week). * This is important to be able to get running. * Please help if possible, or give me some new ideas to try. I have updgraded many times in the past. I went through the detailed upgrade instructions and tried to reinstall a second time, but the same error occurs. * Here is the error that is displayed in several places: * WordPress database error: [Can’t open file: ‘wp_posts.MYI’ (errno: 144)] SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’)) ORDER BY post_date DESC LIMIT 0, 10 * WordPress database error: [Can’t open file: ‘wp_posts.MYI’ (errno: 144)] SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC Viewing 14 replies - 1 through 14 (of 14 total) * [scaturan](https://wordpress.org/support/users/scaturan/) * (@scaturan) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508546) * what version of WordPress did you upgrade from and to? does Yahoo provide access to a phpMyAdmin panel or allow you to use it on your hosting account? * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508559) * That errno: 144 might mean you need to rebuild your wp_posts table. [http://www.google.com/search?q=mysql+errno%3A+144](http://www.google.com/search?q=mysql+errno%3A+144) * You might also read about Yahoo phpMyAdmin and database privilege details posted earlier: [http://wordpress.org/support/topic/101885?replies=3#post-503955](http://wordpress.org/support/topic/101885?replies=3#post-503955) * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508594) * I was on WP version 2.06 and upgraded to 2.1. * I have access to the phpmyadmin panel to make updates through Yahoo tools. * I will research the link you provided to rebuild the wp_posts table, but I do not know what needs to be changed? Is anyone available to help? * Thanks for the feedback. * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508597) * I tried the link provided for the 144 error, but the links in google are not overly helpful. It has a couple of peoples posts, and the fix suggested did not work. In addition, this was not specific to WordPress. * Given that this was previously a working database, and appears to have had an issue related to the upgrade, I would want to make sure that I am fixing it the correct way. * I have over 2,500 posts, and this is used frequently as a reference tool by lots of public health and other entities (e.g. WHO, CDC, etc.), I need to try to get the data back if at all possible. * Any help would be appreciated. * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508598) * go in with phpmyadim and repair THAT table. If youre feeling especially scared, export a backup of that table before hand. * phpmyadmin is VERY straightforward. checkmark the table. scroll down, theres a “with selected” drop down box, it will only let you do so many things. * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508604) * When I go into the phpmyadmin tool and pull up the database, that table appears to have an issue. * I can select any of the tables except 2 of them (wp_posts and wp_sem_nodes). These two tables are greyed out for all of the actions, do not show information on number of records or size, etc, and say “in use” in the collation field. * Any thoughts? * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508611) * I am making some progress, but issues still remain. * I was able to repair those two tables. The posts now shows 2806 posts, and I can browse to look at the data. * When I try to go into the WordPress administrative tool, I am not getting the database error, but none of the posts or pages show up. * If I go under manage posts, it says no posts. Same issue under pages. Categories are still in place. * However, if under manage posts, I choose browse category, each category is available, and seems to have the correct number of posts by category (number next to category name). If I choose the category, it also says no posts. * I have also tried to rerun the upgrade process again. I removed the line that stops the upgrade if the version is correct. * However, after awhile, using either internet explorer or or Firefox, it appears to timeout on the browser, and says done, but shows a blank page. * I am making progress, but seem to have my data intact, but without a converted database (assumed). * Any thoughts on other actions to try? Is there anyone with strong wordpress skills that would be willing to look at the database/upgrade from their computer to check? * Thanks for any and all help. * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508657) * If the upgrade has completed on your wp_posts table, then the `post_status` field will have “publish” and the `post_type` field will have “post” or “page” for posts and pages. * Is that what you are seeing? * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508672) * The post_status field does say publich for most posts. A few say static (these appear to be the pages, rather then the posts). * The post_type field exists, but appears to be blank. * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508673) * I also noticed that the category says 0 for all of the posts in the wp_posts table. I have over 150 categories. I would assume that this needs information as well. * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508709) * It looks like the upgrade didn’t work, at least on the wp_posts table. Might redo the upgrade.php. May have to follow Otto42’s advice here: [http://wordpress.org/support/topic/102468?replies=3#post-505485](http://wordpress.org/support/topic/102468?replies=3#post-505485) * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508737) * Ii tried to upgrade again, and even followed otto42’s method. * No change to the missing information. * Any other thoughts? * This is critical to get back up and running. * Thread Starter [spencefhs](https://wordpress.org/support/users/spencefhs/) * (@spencefhs) * [19 years, 4 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508777) * After going through several different processes to let the upgrade process run again (including setting the version to 0) and doing the upgrade process 15+ times, the upgrade finally worked. * The cause was probably the size of the database. It was taking too long to upgrade and both Internet Explorer and Firefox were both timing out during the upgrade process. * [t-steel](https://wordpress.org/support/users/t-steel/) * (@t-steel) * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508863) * Your not the only one having the time-out problem. I’m upgrading from WordPress 2.0.4 to 2.1.1 and the upgrade script just timed out. The only way I know the upgrade is working is by running “top” on my server and seeing all the MySQL processes. * The database is 65.5MB in length and contains over 10,000 posts and 30,000+ comments. If I was using a host, they would have probably kicked me out by now. Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Database error on Upgrade’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [upgrade](https://wordpress.org/support/topic-tag/upgrade/) * [yahoo](https://wordpress.org/support/topic-tag/yahoo/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 14 replies * 5 participants * Last reply from: [t-steel](https://wordpress.org/support/users/t-steel/) * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-on-upgrade/#post-508863) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics