1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators'
I am trying to upgrade from 1.6.18 to 1.8.6 and getting this error after I select my source version and click the button to start the upgrade process.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'canusecustomtools' in 'mybb_moderators'
Query:ALTER TABLE mybb_moderators ADD canmanageannouncements tinyint(1) NOT NULL default '0' AFTER canusecustomtools
I am not great at digging into SQL and fixing issues like this but I can follow instructions. From what I can see in phpMyAdmin, there is no column "canusecustomtools" in this table. So the upgrade seems to be trying to add a column "canmanageannouncements" after "canusecustomtools" (which does not exist) -- would that be correct?
If yes, I can add the column, but where should it go (after ___________)? And are there any other special parameters that I will need to set for it?
Thank you!
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 'canusecustomtools' in 'mybb_moderators'
Query:ALTER TABLE mybb_moderators ADD canmanageannouncements tinyint(1) NOT NULL default '0' AFTER canusecustomtools
I am not great at digging into SQL and fixing issues like this but I can follow instructions. From what I can see in phpMyAdmin, there is no column "canusecustomtools" in this table. So the upgrade seems to be trying to add a column "canmanageannouncements" after "canusecustomtools" (which does not exist) -- would that be correct?
If yes, I can add the column, but where should it go (after ___________)? And are there any other special parameters that I will need to set for it?
Thank you!