MyBB Community Forums

Full Version: Admin Login Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
MyBB version 1.8.5
Installation via cPanel's Installatron

I am having quite a serious problem and have no idea when it started as I almost never use the admin account. If I try to login the admin account using the web, the attached screen-shot shows the error I get. The error.log in the admin section shows these entries:

SQL Error: 1054 - Unknown column '2fasecret' in 'field list'
Query: SELECT 2fasecret FROM mbb_adminoptions WHERE uid='1'

SQL Error: 1054 - Unknown column 'authsecret' in 'field list'
Query: SELECT authsecret FROM mbb_adminoptions WHERE uid='1'

SQL Error: 1054 - Unknown column 'authsecret' in 'field list'
Query: SELECT authsecret FROM mbb_adminoptions WHERE uid='2'

The rest of the board appears to be working correctly for regular logins although rather slow at times.

Any help would be appreciated.
2fasecret is not a regular column of table adminoptions. But authsecret is a regular column indeed.
Are you perhaps coming from 1.6, because authsecret was introduced in 1.8.

And are you using a plugun which could explain the column 2fasecret? And is this 1.8 compatible, I remember a 2 step authorization plugin for 1.6.

EDIT
It must have something to do with cPanel, that also adds this column I expect.
I installed MyBB on 10-23-2014 and have no idea what version I started with.
When you connect to the administration panel, one the home page, there is the current version of your mybb which is displayed.
Ok, I just read again your first post ^^"

Did you recently upgrade your forum ?
There is this thread on mybb which is related too : http://community.mybb.com/thread-167991.html
Sorry, wrong message