MyBB Community Forums

Hello everyone. I tried upgrading my forum farmersjoint.com from 1.8.10 - 1.8.11. During the installation stage I got to the point below:


MyBB Installation Wizard

Upgrade Process

Settings Synchronization

The board settings have been synchronized with the latest in MyBB.

2 new settings inserted along with 0 new setting groups.

To finalize the upgrade, please click next below to continue.

I clicked Next and got:


Data Cache Building
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'enabled' in 'where clause'
Query:
SELECT * FROM mybb_attachtypes WHERE enabled=1

Please contact the MyBB Group for technical support.

I followed the instructions in the documentation, except that I uploaded the files in the upload folder using file manager instead of Filezilla. Please help.

---

I ran this query to create the column: ALTER TABLE mybb_attachtypes ADD COLUMN enabled tinyint(1) NOT NULL default '1' ; I got this error:

Data Cache Building
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'farmersjoint_biz.mybb_reportreasons' doesn't exist
Query:
SELECT * FROM mybb_reportreasons ORDER BY disporder

---

Then i fix it with this

CREATE TABLE mybb_reportreasons (
rid int unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
appliesto varchar(250) NOT NULL default '',
extra tinyint(1) NOT NULL default '0',
disporder smallint unsigned NOT NULL default '0',
PRIMARY KEY (rid)
) ENGINE=MyISAM;

---

Thanks to https://community.mybb.com/thread-209843.html