Recent Topics

Upgrading to 5.0.5 database error

Started by on Sep 14, 2013 – Contents updated: Sep 17, 2013

Sep 14, 2013 14:13    

What I did:
Running the update script and received the error below, have neither touched the database at all up to that point nor did I do anything else.

What I've tried so far:
Delete the hitlog table and backed it up again after the error wasnt fixed and got the same error below again.

Thanks for your help in advance!!!

Sep 14, 2013 17:36

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!

Sep 17, 2013 09:56

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.


Form is loading...

CCMS – This forum is powered by b2evolution CMS, a complete engine for your website.