+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: 1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators' (/thread-183158.html)
1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators' - Jayfore - 2015-10-07
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!
RE: 1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators' - Destroy666 - 2015-10-10
The column should have existed in your database, unless you/a plugin deleted it. That's the definition: https://github.com/mybb/mybb/blob/feature/install/resources/mysql_db_tables.php#L466
RE: 1.6.18 to 1.8.6 - Unknown column 'canusecustomtools' in 'mybb_moderators' - Jayfore - 2015-10-11
(2015-10-10, 09:05 PM)Destroy666 Wrote: The column should have existed in your database, unless you/a plugin deleted it. That's the definition: https://github.com/mybb/mybb/blob/feature/install/resources/mysql_db_tables.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!