MyBB Community Forums

Hi there,
I just wanted to upgrade my forum form version 1.6.13 to the latest.
But a SQL Error occured:

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

Can't find any solution. Please help, thanks

canusecustomtools field must be present in the database. looks like it was modified!

you can run below SQL query to add the field (see SQL queries guidance if required)

ALTER TABLE `mybb_moderators` ADD `canusecustomtools` INT(1) NOT NULL DEFAULT '0';