| Author |
 Topic Search  Topic Options
|
jamesbradford 
Newbie
Joined: 27 May 2006
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Cant Recover Lost PW
Posted: 27 May 2006 at 11:06pm |
|
I am the owner of a WW Forum and I have forgotten my password, but I cant recover it! I went into HELP and its says an option to reset it can be emailed using a link at the bottom of the login page but I see no such link! I have trid to manually go to the forgotten_password.asp but it just takes me to the main page
What can I do?
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 May 2006 at 11:54pm |
|
you have to have email features enabled and a valid email address within the profile.
the other option is to edit the database replacing the password and salt fields for the user replacing with the default values found within a fresh database/ or within the SQL install script.
|
|
jamesbradford
Newbie
Joined: 27 May 2006
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2006 at 3:46am |
|
So I assume to enable email feature would require logging into the board as the owner?
How do I do the second thing you just stated? You're talking Greek to me, please explain in detail?
Thanks
J
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2006 at 11:10am |
|
If you have an valid email address and enabled the email tools then you can use the forgotten password feature when loging in.
If you don't have that what you will need to do is:-
1.Open the database
2. Open the table tblAuthor
3. Find Author_ID with the value of 1, this is your admin account
4. Copy and paste the following to the username field:-
administrator
5. Copy and paste the following to the password field:-
A85B3E67CFA695D711570FB9822C0CF82871903B
6. Copy and paste the following to the 'Salt' field:-
72964E7
Your admin username and password should now be reset to:-
user: administrator
pass: letmein
|
|
|
|
jamesbradford
Newbie
Joined: 27 May 2006
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2006 at 4:27pm |
|
Ok. So I've opened the database, and I've opened "tblAuthor"
I only see 'Author_ID' twice. The first is under COLUMNS, and the second is under INDEXES
I can't really determine if any of them have a value of 1 because I don't know what that means. But the first one has several "1's" in it's row. But I dont see any fields with username, apssword, or salt. What I see is this:
Type Length Prec. Scale Nullable Default Id. Id. Start Id. Seed
So clearly I must be doing something wrong.
J
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 May 2006 at 7:44pm |
|
You didn't mention the database version you are using, in Access you simply open the table, to view the data within the table, but in other databases you may need to run an SQL query on the table to see the data stored within the table.
Once you can view the data within the database table you can usually edit it, as per the instructions, but again it depends on the database you are using.
|
|
|
|
jamesbradford
Newbie
Joined: 27 May 2006
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 May 2006 at 2:15am |
|
Ok. We're getting somewhere ;)
So in my MYSQL functions I have something that says "Query Analyser". But then there is just a big blank box underneath that I would guess I'm supposed to type something into? And then a submit/reset set of buttons. I also have the option to "show execution plan". So what now?
Thank you for your continued help
J
|
|
jamesbradford
Newbie
Joined: 27 May 2006
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 May 2006 at 9:45pm |
|
Anyone? Please?!
|
|
