MyBB Community Forums

Hello i need help for fix this
i try to install My Awards and wen i click for active it said this

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1060 - Duplicate column name 'awards'
Query:
ALTER TABLE mybb_users ADD awards int(10) NOT NULL DEFAULT '0' AFTER postnum
Please contact the MyBB Group for support.



how do i fix this?

login to your cpanel
go into phpmyadmin find the duplicated 'awards' column and delete it.

I suggest you contact the plugin author for assistance, it seems you had it installed at some other point and failed to uninstall it when you got rid of it. Additionally is it possible another plugin uses a column of that name? I'm not aware of any but it is possible.

What Dark Byte suggested should work but be careful as you could use valuable data and definitely backup your database before trying.