Powelly Posted January 21, 2006 Posted January 21, 2006 I was deleting other members created to test things, however i've also deleted myself. I've registered again, however i'm now only a member and not an admin and therefore cant get into admin cp etc. How can i add myself back to being an admin? Quote
stevevan Posted January 21, 2006 Posted January 21, 2006 I was deleting other members created to test things, however i've also deleted myself. I've registered again, however i'm now only a member and not an admin and therefore cant get into admin cp etc. How can i add myself back to being an admin? What program are you using? CPanel? MySQL? Blog software? Quote
Powelly Posted January 21, 2006 Author Posted January 21, 2006 What program are you using? CPanel? MySQL? Blog software? Cpanel Quote
Powelly Posted January 21, 2006 Author Posted January 21, 2006 Have found mysql in cpanel, what next? Quote
Deverill Posted January 21, 2006 Posted January 21, 2006 If you deleted yourself from cPanel then a helpdesk ticket may be in order. Moving topic to CPanel and Site Maintenance forum for better visibility. Quote
TCH-Bruce Posted January 21, 2006 Posted January 21, 2006 You are probably referring to your forum software you just installed. You need to give your member id moderator or admin privledges in the admin panel of SMF under member controls. Quote
Powelly Posted January 21, 2006 Author Posted January 21, 2006 apparently i need to alter somthing in phpmyadmin, however i cant seem to find what i'm looking for. Quote
stevevan Posted January 21, 2006 Posted January 21, 2006 Well, it's a little hard to pinpoint, given the info you've provided. If you're talking about a blog or forum program, you need to check the info that Bruce provided. I would also check in MySQL (found in CPanel) to make sure that you have created the user and added the user to the database for the blog or forum program. If all else fails, simply drop a ticket to the help desk (link above) fully explaining the problem, and they'll hook you right up. Quote
Powelly Posted January 21, 2006 Author Posted January 21, 2006 Can you give me a bit more help, am in cpanel and phpmyadmin i need to add myself back as an admin, however i cant see how or where to do this, someone gave me a code listed below however i have no idea where to put this............ UPDATE smf_members SET ID_GROUP='1' WHERE userName='yourusername'; Quote
cajunman4life Posted January 21, 2006 Posted January 21, 2006 Alright, I think I've figured where you're going and where you're at. Once in phpMyAdmin, select the database in the dropdown on the left you are attempting to change. Once you've done that some tabs will load across the top of the screen. Click the tab labeled Query. In the field labeled "SQL-query on database (your DB name here)", paste the command you listed above (be sure to replace yourusername with the user name you are attempting to edit) and click the button marked "Submit Query". Let us know if this fixes you up. Quote
Powelly Posted January 21, 2006 Author Posted January 21, 2006 I believe i've done as youm said, i get to virtually the end and then when i click "ok" nothing happens. Typical. Quote
TCH-Rob Posted January 21, 2006 Posted January 21, 2006 This thread may help http://www.simplemachines.org/community/in...64494.msg445551 Quote
cajunman4life Posted January 21, 2006 Posted January 21, 2006 The thread Rob links to is exactly what you need. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.