MyBB Community Forums

Hi

I was locked out of my admin panel some reason 2FA was not working 

I deleted AuthSecret by mistake instead of the fields  + I removed the table underneath AuthSecert  also in my phpmyadmin


the error is 

MyBB has experienced an internal SQL error and cannot continue.

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



Does anyone know how to add the 2 fields back so I can add get the admin panel loading again

I really don't want to start again I have so much content on forum

Thomas

Could you please run following SQL in phpMyAdmin and post the result back?

SHOW create table mb_adminoptions

.

(2020-05-09, 11:00 AM)noyle Wrote: [ -> ]Could you please run following SQL in phpMyAdmin and post the result back?

SHOW create table mb_adminoptions

.

Hi

I Tried that no luck 

The fields I need are  authsecret and recovery_codes   in adminoptions on forum 

I deleted them by mistake I was meant to wipe the values not the whole thing 

The reason I was editing them was I needed to clear Authsecert so I could get in to admin panel as for some reason
2FA Codes were not working on forum

Do you or anyone know how to add them back so I can fix the error 

I hope there is a solution as I don't want to have to loose all my members and posts

SQL Error:

SELECT authsecret FROM mb_adminoptions WHERE uid='1'

****
Edit :   Added   Authsecret to the  adminoptions  and solved  

Thomas