No edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
If | If you accidentally delete your Administrator account, you will need to register again and run the appropriate query for your SMF version. | ||
The below queries will add | If you loses your Administrator membergroup and privileges due to a mistake or conversion, you will need to run the appropriate query for your SMF version, but you do NOT have to re-register. | ||
The below queries will add you back as an Administrator on an SMF forum. ''' Don't forget to replace smf_ with your database prefix!''' | |||
===SMF 1.1=== | ===SMF 1.1=== | ||
| Line 12: | Line 13: | ||
UPDATE smf_members SET id_group = '1' WHERE member_name = 'adminsusername' | UPDATE smf_members SET id_group = '1' WHERE member_name = 'adminsusername' | ||
Alternatively, SMF 2.0 allows | Alternatively, SMF 2.0 allows you to re-attribute posts through the ''Forum Maintenance'' section of your [[Administration Center]] (Administration Center > [[Forum Maintenance]] > ''Reattribute User Posts''). You just need to fill in the form using the e-mail address or username of the old user account, and the username for the user who is to have those posts. This only works for guest posts (remaining posts from deleted members are considered guest posts). | ||
[[Category:FAQ]] | [[Category:FAQ]] | ||
Revision as of 18:25, 29 January 2011
If you accidentally delete your Administrator account, you will need to register again and run the appropriate query for your SMF version.
If you loses your Administrator membergroup and privileges due to a mistake or conversion, you will need to run the appropriate query for your SMF version, but you do NOT have to re-register.
The below queries will add you back as an Administrator on an SMF forum. Don't forget to replace smf_ with your database prefix!
SMF 1.1
Run this query in phpMyAdmin:
UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'adminsusername'
SMF 2.0
Run this query in phpMyAdmin:
UPDATE smf_members SET id_group = '1' WHERE member_name = 'adminsusername'
Alternatively, SMF 2.0 allows you to re-attribute posts through the Forum Maintenance section of your Administration Center (Administration Center > Forum Maintenance > Reattribute User Posts). You just need to fill in the form using the e-mail address or username of the old user account, and the username for the user who is to have those posts. This only works for guest posts (remaining posts from deleted members are considered guest posts).
