Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: RL Joneson on April 01, 2008, 07:14:36 PM

Title: LOGIN ERROR!
Post by: RL Joneson on April 01, 2008, 07:14:36 PM
I only have the admin member on my forum. no other members yet. I went to change the username and password on the admin. I was sent an email with a different password to use. I now try logging in using both the one i was sent and the one I created and neither work. All i get its:

Sorry, you are out of login chances. Please come back and try again later.

Ive waited over a few hours and it still says this. Is there a way to get into my forum to  reset the admin user and pass, and straighten all of this out??
Title: Re: LOGIN ERROR!
Post by: RL Joneson on April 02, 2008, 03:15:21 PM
Again. I only have one member. It's an admin. And i can't log into it. Also, when it asks for the user name or email to resend the password, it doesn't work. So basically i have no way to log into the admin of the forum. What do i do? Anything besides reinstalling??
Title: Re: LOGIN ERROR!
Post by: jossanaijr on April 02, 2008, 03:47:44 PM
Are you sure you had entered the right username and password?  Had you tried again?

I know you can create a new member and after change it to admin using phpAdmin but someone can give you a better advice. (http://www.simplemachines.org/community/index.php?topic=227698.msg1462441#msg1462441)
Title: Re: LOGIN ERROR!
Post by: RL Joneson on April 02, 2008, 06:45:50 PM
Thanks Josanna but it's runs an error on phpadmin. I think im on the right track, but the forum this code was snipped from is for SMF 1.0. I need it for 2.0. there must be a change in this script..
UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'yourusername';

Here's the error it spit out.

Error

SQL query:

UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'RLJoneson'

MySQL said: Documentation
#1054 - Unknown column 'memberName' in 'where clause'


Title: Re: LOGIN ERROR!
Post by: Bulakbol on April 02, 2008, 10:39:38 PM
There's no more uppercase and camel-back fields. They are all now in lowercase and using underscore character. Try id_group and member_name.
Title: Re: LOGIN ERROR!
Post by: RL Joneson on April 03, 2008, 04:58:07 PM
Perfect! Case closed!