HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Locked myself out

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#52957 (In Topic #11532)
Avatar

Community saint

Accidentally changed usergroup....I am no longer admin

I was playing with subscriptions and did a manual transaction…invoiced myself. I accidentally changed my primary user group when I did that and now I am no longer an admin :lol:
Please help, how do I get back in?
Back to the top
 
Posted
Rating:
#52958
Avatar

Well-settled

Run this query in phpMyAdmin:

Code

UPDATE ocp4_f_members SET m_primary_group=(SELECT id FROM ocp4_f_groups WHERE g_is_super_admin=1) WHERE m_username='admin'

It assumes 'ocp4_' was your table prefix, and your username is 'admin'.
Back to the top
 
Posted
Rating:
#52959
Avatar

Community saint

Right on, I'm back in! Thanks Chris!
Back to the top
 
Posted
Rating:
#52960
Avatar

Well-settled

David :P.
Back to the top
 
Posted
Rating:
#52961
Avatar

Community saint

Sorry David  :lol: Thanks for the help!
Back to the top
 
Posted
Rating:
#52964
Avatar

Community saint

Glad you got yourself back in as admin…. just read the subject header and thought… "What did Brian do now?" lol  :lol:

Eric DeMars . com
My electronic portfolio and personal site. Uses ocPortal!
Back to the top
 
Posted
Rating:
#52975
Avatar

Community saint

 :lol: It scared me when it first happened. I thought some one had hacked in and was messing with me. Then I sat back and really thought about it before jumping to conclusions….what have I done that could have caused this?  :lol:
Back to the top
 
Posted
Rating:
#52976
Avatar

Community saint

Don't feel bad. I used to help run a forums based site and for some odd stupid reason, I meant to ban a troll's ip address but ended up banning myself. Had to do the SQL thing too to get myself unbanned.  :lol:

Eric DeMars . com
My electronic portfolio and personal site. Uses ocPortal!
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: