Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 50 guests, and 280 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Outdoorking
Outdoorking
Sydney, Australia
Posts: 320
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 18
Gizmo 13
Ruben 10
Morgan 6
BB 2
Abbott 2
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
Locked out of CP after Moving Members Groups 7.6.1 #260826
01/09/18 11:06 AM
01/09/18 11:06 AM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
Today I was in process of moving members from one group to another so I can delete the groups we are no longer using. When page refreshed, it said I don’t have permissions. I still show as ADMN but lost access to all but one control panel function. See attached image to what I am limited to:

Attached Files A2477DFE-8A29-41C3-BB86-DDFF3A5AC1ED.png
Last edited by Geoff; 01/09/18 11:54 AM. Reason: Changed Subject to include Locked out of CP
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260827
01/09/18 11:17 AM
01/09/18 11:17 AM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
USER_MEMBERSHIP_LEVEL still shows Administrator

Should I delete the record for me found in:
ubbt_CACHED_PERMISSIONS
with CACHED_TIMESTAMP 15515511393

CP_PERMISSIONS are
a:1:{s:13:”APPROVE_POSTS”;i:1;}

Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260832
01/09/18 04:07 PM
01/09/18 04:07 PM
Joined: Dec 2003
Posts: 5,898
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,898
Lutz,FL
That is a odd wacked out time.
Unix time says it is
08/31/2461 @ 4:16pm
I would use the clear cache in the cp first and see if it rebuilds everything..

Last edited by Ruben; 01/09/18 04:13 PM.

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260833
01/09/18 04:19 PM
01/09/18 04:19 PM
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
You're going to need to restore from backups if you hosed your permissions, as this is a permission matrix required for forum functionality.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260834
01/09/18 04:23 PM
01/09/18 04:23 PM
Joined: Apr 2004
Posts: 1,172
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,172
California
The default groups which should never be deleted (i dont think its even possible to delete them) are the first 5. Which are titled as follows:
Group 1 - Administrators
Group 2 - GlobalModerators
Group 3 - Moderators
Group 4 - Users
Group 5 - Guests

--

You could try the following route, but without knowing which main account groups you've changed / deleted, all I can offer is a guess in to where to begin troubleshooting. Especially since you haven't mentioned about having a backup to compare with.

Assuming that your account number is "2", and your table prefix begins with "ubbt_", manually or from with your phpMyAdmin, update your account USER_MEMBERSHIP_LEVEL to "Administrator"

UPDATE ubb_forum.ubbt_USERS
SET USER_MEMBERSHIP_LEVEL = "Administrator"
WHERE USER_ID = "2"


isaac @ id242.com // forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Changelog
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260835
01/09/18 04:30 PM
01/09/18 04:30 PM
Joined: Dec 2003
Posts: 5,898
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,898
Lutz,FL
Never thought about anyone attempting to delete the primary default groups.
I don't know how you would do that without database diving.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260836
01/09/18 04:45 PM
01/09/18 04:45 PM
Joined: Dec 2003
Posts: 5,898
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,898
Lutz,FL
Makes me leery when I hear
Originally Posted by Geoff
USER_MEMBERSHIP_LEVEL still shows Administrator

Should I delete the record for me found in:
ubbt_CACHED_PERMISSIONS
with CACHED_TIMESTAMP 15515511393

CP_PERMISSIONS are
a:1:{s:13:”APPROVE_POSTS”;i:1;}


You should never edit the database unless you know exactly what you are doing.
And then do it with caution.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260838
01/09/18 05:20 PM
01/09/18 05:20 PM
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
Editing the database at all is not recommended or supported; the only tools that are supported are those which exist in the control panel.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260844
01/09/18 09:49 PM
01/09/18 09:49 PM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
It was a group I added that I used the Group CP tool to move users from that group to default USER group and nothing that was original to UBB. I have not deleted the group I created. It was being used as the default group for new registrations and I wanted to stop using it and thought I had to move them out before I deleted the group I created in the CP.

I only hosed my user id access to the cp for some reason. I have not heard anything about other users. I still have access as a user with the one CP access seen in picture. I have not manually adjusted any db data as of yet besides changing issac to Administrator in ubbt_USER so he could poke around as I don’t have access theough the CP.

At this point I don’t think it has affected anyone but me. I will look for the db back up and attempt to replace db with it. Will be a first for me.

Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260845
01/09/18 09:56 PM
01/09/18 09:56 PM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
I really do not think I hosed the permissions for the board as I did not do anything to the DB itself. It happened right after using the CP as I described above. Only my Id and suspect the cached permissions as it is one of only couple in that table. Again, I have not made changes directly to the board besides changing Issac to Administrator in the ubbt_USER table.

Re: Moving Members in Groups Issue 7.6.1 [Re: isaac] #260846
01/09/18 10:01 PM
01/09/18 10:01 PM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
Originally Posted by isaac

Assuming that your account number is "2", and your table prefix begins with "ubbt_", manually or from with your phpMyAdmin, update your account USER_MEMBERSHIP_LEVEL to "Administrator"

UPDATE ubb_forum.ubbt_USERS
SET USER_MEMBERSHIP_LEVEL = "Administrator"
WHERE USER_ID = "2"


Sorry. Misspelled your name in posts above. Can you see if you have admn access in our CP before I restore db from a backup.

I looked at the USER_MEMBERSHIP_LEVEL directly using phpMyAdmin and it says Administrator already.

Last edited by Geoff; 01/09/18 10:05 PM. Reason: Note to Isaac to check admn access to out board
Re: Moving Members in Groups Issue 7.6.1 [Re: Geoff] #260859
01/10/18 10:15 AM
01/10/18 10:15 AM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
I have also preformed the same procedure several times in the UBB CP moving a group of people from one group to another without issue in past. It is like it over wrote a record for my permissions somewhere else besides the USER table. What other table record would have priority?

Re: Locked out of CP after Moving Members Groups 7.6.1 [Re: Geoff] #260860
01/10/18 11:55 AM
01/10/18 11:55 AM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
I still suspect the ubbt_CACHED_PERMISSIONAS. Attached are print outs from the tables from 1/8 (pre issue) and 1/10. I am dragging my feet on restoring from the 1/8 back up as I am worried when I perform this action again in the control panel, I will have the same issue and want to help here before it happens again.

The other two with "APPROVE__POSTS" are my two GlobalModerators. As you see, these also changed after I performed the Group move in UBB CP.

Attached Files
ubbt_CAHCED_PERMISSIONS-2018-01-08.pdf (11 downloads)
Pre Issue
ubbt_CACHED_PERMISSIONS-2018-01-10.pdf (11 downloads)
Post Issue
Last edited by Geoff; 01/10/18 12:02 PM. Reason: Added info about user 41 and 1774
Re: Locked out of CP after Moving Members Groups 7.6.1 [Re: Geoff] #260862
01/10/18 05:15 PM
01/10/18 05:15 PM
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,931
Portland, OR; USA
The user groups table is ubbt_USER_GROUPS.

If you've somehow managed to remove your entry from the groups table, below should re-insert you as an administrator:
Code
INSERT INTO ubb_forum.ubbt_USER_GROUPS (USER_ID, GROUP_ID) VALUES ('2', '1');


ubb_forum would be your db, ubbt_ would be your table prefix, and '2' would be your user id.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Locked out of CP after Moving Members Groups 7.6.1 [Re: Geoff] #260874
01/11/18 03:19 PM
01/11/18 03:19 PM
Joined: Aug 2006
Posts: 89
Florida
G
Geoff Offline OP
journeyman
Geoff  Offline OP
journeyman
G
Joined: Aug 2006
Posts: 89
Florida
I was user 2 and had administration assigned to me.

I restored from backup today. I am going to set up a test site to replicate issue to share as should be measure in place to prevent what I did moving people from one user group to another. I ended up being in the group along with our other moderators and all of us were impacted and lost moderator and above functions.

If I can replicate in test site, I will have a before and after db for you to compare and video capture of steps.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
random 500 server errors on post
by Bad Frog. 05/31/18 09:34 AM
Forum Statistics
Forums36
Topics35,122
Posts191,329
Members12,085
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)