spencefhs

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.

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.

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.

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.

I was able to resolve the first problem (as noted above).

The issue with the 500 internal server error still occurs.

Any help would be appreciated.

After going back ot Yahoo small business 4 times with them telling me that their servers were “within performance parameters”, they finally made some changes that substantially improved performance.

While not instant, it is now significantly faster.
On the first day after the change, my daily visits increase from 1,500 (down from 2,000 due to performance problems), to 4,500 a day. It is obvious that the performance problems were keeping many people away from the site.