[Solved]I'm the administrator who deleted my login information

[DAN_B]

 Yes, I'm the administrator who deleted my own login information.
I'm the domain owner. I can get into the files and data base within the domain, however I would be lost in there. I installed it with the C-Panel softopuos, I can see all info, but no edit administration option. Any suggestions?

[Joker™]

http://wiki.simplemachines.org/smf/Administration_-_I_accidentally_lost_my_admin_account!_What_can_I_do

[DAN_B]

OK THanks, I'll check it out

[Colin]

Welcome to SMF.

In the future please do take the few minutes to scan the wiki or forums, here, to see if an answer has been publicized. You would be surprised how much the Doc Team has written up .

[DAN_B]

http://wiki.simplemachines.org/smf/Administration_-_I_accidentally_lost_my_admin_account!_What_can_I_do

OK I have the query window up, ready to submit, does this look right?



UPDATE *****28_smf1_members SET ID_GROUP = '1' WHERE memberName = 'adminsusername'

[Joker™]

Just make sure that the username you have created is placed in the query in place of 'adminsusername'.

Except that just make a backup of database and forum.

[DAN_B]

Just make sure that the username you have created is placed in the query in place of 'adminsusername'.

Except that just make a backup of database and forum.

Ok, I did not do that, I do not have this worked out yet.
I have the smf phpadm > member data open; I see all the various columns IS the members SET ID_GROUP = '1' the identifier for member to be the Administrator?

entering the 1 line of script; that gives a new adm. username entry;  I will next:  go to smf login, enter new username, click forgot password, so to get the reset password page?

[Colin]

If the query isn't working then just right click on your user and edit. Change the column ID_GROUP to 1 and it will do the same thing. It should not create a new user.

[DAN_B]

I managed to just add a new row[database] with just very little info, the '1' identifier is what let me get back in, then reset password. Big lesson learned, the original administrator has been reduced to a guest and has been fired. Did a lot of clean up.
I think, I wasn't using the query feature correct; for me not being able to use it as a way to reestablish the administration login needed.
Even though I went about in a 2+2=5 kind of way, I am grateful for the help, smf is a good program.
Thanks