Tales from the Techside

This morning I upgraded my blogging platform from Wordpress 2.0.1 to the latest version. I am not usually a proponent of using the latest release but in this case there were some great benefits for me as writer and site manager and for you the reader.

My webhosting platform is yahoo! and before you say well there is problem believe me I know however I have had my site for so long and have many dependancies that need access to specific modules yahoo! provides that moving is simply not an option at this time.  

Back to the topic after upgrading I got the following error when I would try to add categories, links and a number of other things.

WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name ASC

Took a while to figure issue out but apparantly yahoo! in its infinite wisdom decided to give the wordpress database account a restricted permission level so it could not make some critical changes to the database during the upgrade. So after some creative problem solving I resolved the issue. 

What I have done below is post my work around in case anyone runs into the same issues or is having problems with their wordpress blog after upgrading and are hosted by yahoo.

1. Log into your Yahoo webhosting account
2. I would reccoomend backing up your blog database you can do this easily using the backup tool in the management console. If you are unsure how to do it leave a comment or drop me an email and I will help you out.
3. Make sure you have phpMyAdmin installed if you are not sure Click here.
4. After you are sure it is installed, go to address it is installed to and log in if you are not sure what it is leave a comment or contact me and I will help you out.
5. Select your blog database from the list on the left.
6. After the page refreshes find the table named wp_categories, click on it.
7. In the center of the page scroll down until you see Add new field : At End of Table button selected, type 3 in the blank and click ‘Go‘.
8. You will now add three new fields first is link_count, for type select BIGINT, the length to 20, and the default value to 0.
9. Second is posts_private, for type select TINYINT, the length to 1, and the default value to 0.
10. Lastly is links_private, for type select TINYINT, the length to 1, and the default value to 0.
11. Click ‘save‘ and your done get out of the phpMyAdmin tool and check out your site.

-Mark Flavin

No comments yet.

Comments RSS TrackBack Identifier URI