How to recover admin?

[Elmacik]

yes you didnt read wrong. i deleted all admin accounts to manage them from the beginning.
(because the "change screen name" changes only the seen name and DOES NOT change the account name, shouldnt it?)

all the admin accounts are gone.
what should i do now?
i dont want to unistall and install back

[Oldiesmann]

In phpMyAdmin:

Code Select Expand

UPDATE smf_members SET ID_GROUP='1' WHERE userName='yourusername';

That will give you admin status again. From there, you can go in to the user's profile, click on "Account Options", and add them to the Admin group from there. In the future, to change a user's "account name" as you call it, go into their profile and click on "Change username".

[Elmacik]

Error

SQL-query:

UPDATE smf_members SET ID_GROUP = '1' WHERE userName = 'admin'

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









when i try the sql query you gave, this erros comes up.
i use the smf 1.1.0 beta 3

[[Unknown]]

It's memberName.

-[Unknown]

[Elmacik]

i just found from the rows.
but you are still so fast
thanks