Argghh as I suspected, just looking at the wp_posts table the data structure has changed between version. I can see the word press developers once thought that enum was a good idea. Heh, didn’t we all. Can’t fault them for changing that except it botched my upgrade.
So I reverted back to all the old files and everything is working again. Looks like I am on version 2.0.5 and was trying to upgrade to version 2.6.5 well its late and I am going to bed. Hopefully someone has insight on my problem.