Previous Thread
Next Thread
Print Thread
Hop To
#237500 06/16/2010 7:40 AM
Joined: Jan 2009
Posts: 15
S
stranger
stranger
S Offline
Joined: Jan 2009
Posts: 15
Sorry to bother you all however I am somewhat desperate and don't know what to do.

I was editing permissions in my UBB.threads 7.5.3 and have accidentally it seems locked administrators out of the control panel functions except approve posts. I thought I was editing another groups permissions and seems I was editing adminstrator group functions. I changed the '1' to '0' in the CP section of the permissions and now I no longer have permission to run my own board. No other member has permissions either.

I have a drama as I rely on the CP daily and need it back. How the hell do I get it back??

Can you help PLEASE!!??

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
SQL Query
update ubbt_CP_PERMISSIONS 
set FULL_ACCESS=1 WHERE GROUP_ID=1

from phpmyadmin or equiv

SD #237502 06/16/2010 9:49 AM
Joined: Jan 2009
Posts: 15
S
stranger
stranger
S Offline
Joined: Jan 2009
Posts: 15
Thanks so much Sirdude! You have saved my ass smile smile Thought my universe was melting down there for a moment! I owe you! smile

speedwest #237503 06/16/2010 10:29 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
no probs smile

SD #237513 06/16/2010 5:52 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Well I am glad it worked for him . But the query just changes the settings. For me I would want to know what was wrong to begin with.
Call me Mr. Anal.
Before I start doing a update query.

No offense intended Sirdude!


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Ruben #237514 06/16/2010 8:09 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
he told us what was 'wrong' in the 1st post and how it happened.

he accidentally did the opposite of what that query fixed in the CP permissions and locked himself out..

so look @ me like the triple A guy that got called to help someone who locked themself out of their own car

wink

SD #237523 06/17/2010 3:43 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
I understand. It is just I tend to agree with speedwest.
Where in the control panel you assign the main admin in Main Administrator User Id?
Usually it is defaulted to 2
So why would you be able to remove cp access to user 2.
My thinking is whatever user id is in
Main Administrator User Id?
Should never loose cp access no mater what cp panel process you use.

So if it happened to me I probably would be doing some digging to see where it allows that to happen and prevent it from happening again. Especially if you have multiple admins.

BTW, Here in Florida the company is pop-a-lock. HE HE.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 797 guests, and 200 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)