1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators'

[Jayfore]

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!

[Destroy666]

The column should have existed in your database, unless you/a plugin deleted it. That's the definition: https://github.com/mybb/mybb/blob/featur...s.php#L466

[Jayfore]

The column should have existed in your database, unless you/a plugin deleted it. That's the definition: https://github.com/mybb/mybb/blob/featur...s.php#L466

Whoah -- that was super helpful, and it will be a good reference for the future!  I ended up needing to refer to this for at least 6 more missing columns.  I ran the queries to add them and was able to proceed thru the upgrade.

Thank you!