Data Base

[build]

Hi Eric

I have just found this problem.

1) made back up of data base.

2) two days later FORGOT my ADMIN passord

3) No problem I thought I will just look at the back up of the data base and just insert the sql file part for admin.

4) Hmmmm no data base field for ADMIN

5) The admin is in the "class_users"

6) So I thought ok I will do a
REPLACE INTO `class_users` VALUES xxxxxxxx
All went in ok

7) BUT this did not work

I would have thought that the admin would have been in a field on its own

So now How do I fined out

1) what my user name and passowrd was for ADMIN.
2) How do I get it put back into the data base.

[calaf6]

Until one of the others gets on, if its the user password you can use the forgotten password link, otherwise I would set up another user and go into the database and change it to admin status, so you have a spare.

[build]

Originally Posted by calaf6

Until one of the others gets on, if its the user password you can use the forgotten password link, otherwise I would set up another user and go into the database and change it to admin status, so you have a spare.

Hi

No it is not a user account , as I say it is my ADMIN account.

Yes I did make another user and opened up the data base and changed the
firstname and lastname to admin.
BUT that made no differnce, still came back to the page where you put in the user name and password.

I would have thought that if I replaced the sql statment it should have worked.

[Bucketman]

I had the same thing happen a couple of months ago, where the admin account got locked out for some reason. What I did was register a new user, taking note of the password. Then go into your database admin (phpMyAdmin) and copy the password from the new user to the admin account. Just cut and paste the hashes (#####) - it does work. Now you can log in with the admin account using the same password as your new user.

Hope this helps... Good luck ....

[juven14]

Register yourself as a new user, and change only the level to 1 (level is the only difference between a user and an admin) in the class_users table.

Also if you are trying to change your password in the database you must select the function for that field as password to encrypt the password.

Edit ~ Larry puts it much better, no need to mess around in the database.

[Lhotch]

Originally Posted by build

Hi

No it is not a user account , as I say it is my ADMIN account.

Yes I did make another user and opened up the data base and changed the
firstname and lastname to admin.
BUT that made no differnce, still came back to the page where you put in the user name and password.

I would have thought that if I replaced the sql statment it should have worked.

Your ADMIN account is a user account. Its the first (ie #1 user account) and you can log into the site front end with the admin login details. You should also be able to use use the front ends forgotten password link to get the admin password.