Moderators: Gaia.
Page: 1
| Author | Post |
|---|---|
|
#1 Sun Jan 15, 2006 7:38 pm
|
|
|
Member
Registered: Sep 2005
Posts: 5
|
Somehow I managed to delete my admin account when upgrading to latest version. A query in MySQL shows it as an empty set.
Is it possible to restore that account in MySQL or to enable a new account with admin priveleges? Please advise at your earliest convenience. Thanks! |
|
#2 Mon Jan 16, 2006 2:20 am
|
|
Moderator
 Registered: Oct 2005
Posts: 449
Location: canada
|
By empty, do you mean the admin member field is gone from the table? If so, go into PHPMyAdmin or some other MySQL management and put the field level to 3 on the user you want to be admin. ( in the usebb_members table )
_______________ |
|
#3 Mon Jan 16, 2006 2:45 am
|
|
|
Member
Registered: Sep 2005
Posts: 5
|
Thanks much! I was having an insane time trying to locate that number, all fixed up now with new admin account :^)
|
|
#4 Tue Jan 17, 2006 12:45 pm
|
|
|
Developer
Registered: Apr 2004
Posts: 2218
Location: Belgium
|
You will also have to set the id field right as it was before you deleted the account. So probably id will have to be 1.
_______________ |
Page: 1
UseBB Community is powered by UseBB 1 Forum Software
.