so noone has solved this error yet?

as from the error: Unknown column 'hit_keyphrase_keyp_ID' in 'where clause'(Errno=1054)
the column is just missing, so should I create it and if so with what attributes is the question mainly ?

btw it's not just me having this problem, googled the error and found some other blogs with the exact same issue i.e. here:
http://beggi.com/blog/install/index.php?locale=en-SG&confirmed=0&installer_version=10&create_sample_contents=1&action=evoupgrade

Thanks for your help!

@hcn please carefully read this page I just wrote for situations like yours: http://b2evolution.net/man/installation-upgrade/faq-install-upgrade/unexpected-error-during-upgrade

Thank you very much fplangue, will try it out over over the next day!

NO OFFENSE really, but wondering a bit about the tone of all of this on a personal note though, especially about those points:

2) this kind of error does NOT happen randomly (unless your server is faulty, which is extremely rare). It happens generally because you did some bad things to your database. For example: you stopped one upgrade in the middle of its process and then tried to start it again. You can’t do that. You need to treat your database upgrades with more respect.

3)...Yes I wrote that in big fat caps, because people who have this error are generally people who didn’t follow the proper instructions in the past and that’s what lead them to a corrupt database.

When having posted here I wasnt aware about just one person being able to reply to all questions, thought it's more a community thing. Being a developer myself, just not Databses or webstuff but wouldnt consider myself the most stupid person in this field. As you're the developer of most of this it seems quite logical to me that you want pass errors on to the users, regardless what they tell you. Obviously you have been answering tons of posts like this and keep wondering what about comes next, but take it easy I recommend.