The Joomla! Forum ™

Download

Demo


Board index » Joomla! 2.5 - Ask Support Questions Here » Administration Joomla! 2.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 9 posts ] 
  Print view Previous topic | Next topic 
Author Message
standib
 Post subject: Joomla User Group Tables
PostPosted: Fri May 04, 2012 3:16 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Oct 15, 2009 8:19 pm
Posts: 143
Not realizing what I was doing, I inadvertently deleted the user groups Manager and Administrator. When I realized my error I tried to add them through the backend group administrator. Unfortunately these groups do not work correctly in my site any more. Looking at the User group table I see three columns (Beside primary key). They are parent_id, lft, and rgt (nested left and right?). Anyway, I have compared the same table from this site and two other sites that work correctly and I see several discrepancies between my messed up site the other two sites. My question is, If I edit this table in the messed up site to match the other two sites, will this fix my user group access problem?


Last edited by humvee on Sat May 05, 2012 11:07 pm, edited 1 time in total.
Marked as resolved


Top
 Profile  
 
humvee
PostPosted: Fri May 04, 2012 10:28 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 17, 2005 10:27 pm
Posts: 14709
Location: Kent, England
How far into creating the site are you - how much content is there - or could you you reinstall without too much of a headache?

You "might" be able to find the user group table SQL data within the installation/SQL directory of a freshly unzipped Joomla Stable zip file of the same version and then copy that sql into a txt file, edit the prefix to match your own and import it -BUT I am not an SQL techhie and therefore cannot advise you on the feasibility of this.

If it were me - I would install a new joomla site on my development server (localhost), delete the same settings from that, as I have from my actual site, and use the "test" site to experiment on rather than "frack" up my live site. But I would have to look into the code to utilise to correctly achieve this (if it were mine) and therefore that is really down to you unless - you have an SQL buddy hiding in the woodwork somewhere - or one pops up on the forum!!

hth at least a little :eek:

Andy
Top
 Profile  
 
standib
PostPosted: Sat May 05, 2012 1:01 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Oct 15, 2009 8:19 pm
Posts: 143
I tried matching the settings in the user group table with a new Joomla installation. Since I already have many users registered, nothing worked right so I changed everything back. I have everything back to normal EXCEPT that when a Manager or Administrator logs into the backend there is nothing there. They have access but no ability to edit anything. I have every Global and compontent setting I can find set to Allowed for Managers but still nothing. There must be a place, either directly in a table or through the backend where I can control permissions to edit components in the backend. I just cannot find it.
I definitely need help from a master.
Top
 Profile  
 
humvee
PostPosted: Sat May 05, 2012 1:13 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 17, 2005 10:27 pm
Posts: 14709
Location: Kent, England
Check the settings for the two groups in the database and make sure the ID and all the other settings in every field match your example site (the one that is not corrupt).

Usergroups and viewlevels are the ones that you should be viewing.
Top
 Profile  
 
Webdongle
PostPosted: Sat May 05, 2012 1:30 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Sat Apr 05, 2008 9:58 pm
Posts: 23363
Location: @Webdongle
The user Group that SU is in (usually 8 ) needs to be in the 'Special' view/access level
Attachment:
Capture 237.PNG
Attachment:
Capture 238.PNG
Attachment:
Capture 239.PNG


Once you have access with SU then you can set the view/access levels for Administrator and Manager in the backend

Or you can edit the #__viewlevels table to add their user group ID's to the 'ordering rules' field of the record for Special :pop


You do not have the required permissions to view the files attached to this post.

_________________
http://weblinksonline.co.uk/joomla-faq.html
Top
 Profile  
 
standib
PostPosted: Sat May 05, 2012 4:38 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Oct 15, 2009 8:19 pm
Posts: 143
Thanks, I think all of that is alright. I'm looking at the user group table and I'm wondering about the "lft" and "rgt" columns. Do those values refer back to a user group? ie. administrator: id=7, parent_id=6(Manager?), lft=3(Author?), rgt=4(Editor?). This what my table looks like in a new installation. In my messed up install those values do not point to the same user groups (If that is indeed what they represent.)
Top
 Profile  
 
Webdongle
PostPosted: Sat May 05, 2012 8:00 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Sat Apr 05, 2008 9:58 pm
Posts: 23363
Location: @Webdongle
Not sure about the
"lft" and "rgt"
But if you can log in to /administrator with SU but see no menus ... then the SU user group is not in the access/view 'Special'

Look at the ID of the user that is SU in #__users
Match the number of the user ID in the #__user.id table with that of the number in the #__usergroup.id field of #__usergroups_map table

That number in the #__usergroup.id field of #__usergroups_map table is the number you need in the brackets of rules field of the #__viewlevels table.

_________________
http://weblinksonline.co.uk/joomla-faq.html
Top
 Profile  
 
standib
PostPosted: Sat May 05, 2012 9:24 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Oct 15, 2009 8:19 pm
Posts: 143
Thank you. The answer was right where you said it would be in the viewlevels table. In the 'Special' record, it only listed the id's for Author and Super user. Once I added the id for 'Manager', everything started to work correctly.
Thank you very much. I never would have figured that out myself.
Top
 Profile  
 
Webdongle
PostPosted: Sun May 06, 2012 1:00 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Sat Apr 05, 2008 9:58 pm
Posts: 23363
Location: @Webdongle
standib wrote:
... I never would have figured that out myself.

I only found out about the admin menus being 'Special' view/access level a few days ago myself.

Glad you got it Solved :D

_________________
http://weblinksonline.co.uk/joomla-faq.html
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 9 posts ] 


Board index » Joomla! 2.5 - Ask Support Questions Here » Administration Joomla! 2.5

Who is online

Users browsing this forum: No registered users and 13 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group