I am upgrading from 3.3.3 to 4.1.4
The upgrade seems to go as it should, but when the update is complete this happens:
"An unexpected error has occurred!
If this error persists, please report it to the administrator.
Go back to home page
Additional information about this error:
MySQL error!
Unknown column 'hit_agent_type' in 'field list'(Errno=1054)
Your query: Record the hit
INSERT INTO evo_hitlog(
hit_sess_ID, hit_datetime, hit_uri, hit_referer_type,
hit_referer, hit_referer_dom_ID, hit_keyphrase_keyp_ID, hit_serprank, hit_blog_ID, hit_remote_addr, hit_agent_type )
VALUES( '604040', FROM_UNIXTIME(1405564915), '/blog/', 'direct', '', NULL, NULL, NULL, 1, '173.227.74.5', 'browser'
)"
I reverted to a back-up, but apparently it is not modifying the database properly.
How do I proceed? - FYI I am not savvy with html or php hence... Fantastico.
General Support
b2evolution CMS Support Forums
@joeljordan
Have you asked your hosting provider for help? The thing is that something is not going well with the database upgrade performed by Fantastico and they need to know it and fix it. It is skipping one (or several) step/s and the field that is supposed to be created is not.
If they give you no positive answer (they should do it), you may add the field "by hand", but there are two cons about it: 1) You need access to the database and some knowledge, 2) maybe this is not the only missing field and you will end hacking the database which is a totally discouraged error prone process.
Regarding the version, 4.1.4 was released almost two years and half ago, so maybe you should consider upgrade to a more recent version. It is a pretty straighforward process. Maybe this manual section could help you: http://b2evolution.net/man/upgrading/
Regards!