MyBB Community Forums
was having login issues so - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: was having login issues so (/thread-224959.html)



was having login issues so - dan dundee - 2019-10-12

i reinstalled mybb using softalious figured that would eliminate my user error on all that now I get this after importing my db please give me a step by step what to do if you know how to fix it and thanks


MyBB has experienced an internal SQL error and cannot continue.

SQL Error: 1054 - Unknown column 'loginlockoutexpiry' in 'field list' Query: SELECT loginattempts, loginlockoutexpiry FROM users WHERE uid='3'


RE: was having login issues so - Michael2014 - 2019-11-18

"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;"

Solved by Wires https://community.mybb.com/thread-219005-post-1310476.html#pid1310476