Not Solved SQL Error: 1054 - Unknown column 'loginlockoutexpiry'
#1
Not Solved
Hi, I'm new to MyBB. I got this error on attempting to log in via Tapatalk, I can log in on my browser though.

"SQL Error: 1054 - Unknown column 'loginlockoutexpiry' in 'field list' Query: SELECT loginattempts, loginlockoutexpiry FROM mybblq_users Where uid='1'" is what I'm getting when I attempt to log in with Tapatalk. Can anyone help with this?

Also when logging in with the wrong password I get this "SQL Error:1054 - Unknown column 'loginlockoutexpiry' in 'field list'Query:SELECT loginattempts, loginlockoutexpiry FROM mybblq_users WHERE uid='2'"  Neither of these problems are resolved by disabling plugins.

Haven't switched over to the new forum yet but will soon. It is located here: https://sonichq.net/sonicblast/index.php

Also I just discovered that I cannot logout. Not right away anyway. I click log out and it takes me to the page that says you have been logged out but still shows me as logged in even after clearing my cache but after refreshing a little while later it shows me logged out. I'm guessing this has something to do with the messy update. I went to this topic (https://community.mybb.com/thread-218436.html) and fixed the problem I had before but now I'm left with this. Any help?
Reply
#2
Not Solved
You're missing a column which means somewhere down the line you've incorrectly upgraded. You may see a few more of these errors. Running the following query should resolve the issue:

ALTER TABLE mybblq_users ADD loginlockoutexpiry int unsigned NOT NULL default 0;
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)