MyBB Community Forums

So, I tried to upgrade my forum 1.6.16 to 1.8.6 it failed, gave me some MySQL errors, code will be below, so I really need some help,

SQL Error:
1060 - Duplicate column name 'profile'
Query:
ALTER TABLE mybb_profilefields CHANGE hidden profile tinyint(1) NOT NULL default '0'

You need to contact mybb to set it up for you if your moving to their host can you please give a link to your site.

(2015-10-03, 02:07 PM)workerBee Wrote: [ -> ]You need to contact mybb to set it up for you if your moving to their host can you please give a link to your site.

We do not operate and do not have any plans to operate a hosting service. We provide the software and offer support for it, and that is all.

any solution to solve my problem ???

It's a bug: https://github.com/mybb/mybb/issues/2116 The upgrade doesn't check for a possible duplicate column. You can either delete the column in the current 1.6 database or add a field_exists() check like here: https://github.com/mybb/mybb/commit/79bc...7786642d38 for the column in the 1.8 upgrade script.