MyBB Community Forums

Hello all. Whenever I tried to log into my admin cp I get this error:

The username/email and password combination you entered is invalid.

Please enter your username/email and password to continue.

I got the error despite the fact that I used the correct username & passwd.

I did some research & found that I can reset passwd to "test" using the query:

UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt = '' WHERE uid = '1';

I ran the query but still can't login.

Mybb version: 1.8.10
Forum: http://farmersjoint.com.

Thanks in advance.

I forget exactly how it works, but I don't believe it's a straight up md5. It would probably be best to change the email address for user in the mybb_users table then do a password reset through email.

(2017-03-08, 03:04 AM)spork985 Wrote: [ -> ]I forget exactly how it works, but I don't believe it's a straight up md5. It would probably be best to change the email address for user in the mybb_users table then do a password reset through email.

I agree with Spork, go to the database and change the email of user id 1 and then do a password reset and see if it makes any changes, you should have a salt there (unless you removed it).

Thank God I solve it! How? In the database via phpMyAdmin, I went to mybb_users and I simply replaced the paswd, salt and loginkey with that from an older account and I was able to log in.

I Thank everyone for your contributions. @spork985 & Nasyr, I tried your suggestions first but I received no email. I wonder if my users will have the same problem.

I'm now back to my old problem as follows:

Quote:SQL Error: 1054 - Unknown column 'canviewdeletionnotice' in 'field list'

<- snip ->
I made the post here: https://community.mybb.com/thread-208670.html

Can anyone help with this?