Users not assigned to any groups

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

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.
Locked
agenda9
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Jan 14, 2006 6:12 pm

Users not assigned to any groups

Post by agenda9 » Sat Feb 09, 2013 3:26 pm

After upgrading to Joomla 2.5, one of my users could not log in. I finally figured out he was not assigned to the Registered users group. That fixed it for him. But I still have several hundred other users where the usertype is blank. Can I simply use SQL to set it to Registered or are there other tables involved?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30809
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Users not assigned to any groups

Post by Per Yngve Berg » Sat Feb 09, 2013 3:59 pm

Use the Batch Processing of users at the bottom of User Manager to set several users at once.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Sat Feb 09, 2013 4:19 pm

What version of Joomla did you upgrade from and what version did you upgrade to ? Also how did you upgrade ?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

agenda9
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Jan 14, 2006 6:12 pm

Re: Users not assigned to any groups

Post by agenda9 » Sat Feb 09, 2013 4:31 pm

I upgraded from 1.5.x to 2.5.9 using the SPUPGRADE component.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Sat Feb 09, 2013 5:34 pm

Perhaps notify them of what happened ? They may need to know if there is a bug ?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

agenda9
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Jan 14, 2006 6:12 pm

Re: Users not assigned to any groups

Post by agenda9 » Sat Feb 09, 2013 6:29 pm

Yes, I've done that. What I'm wondering is if I can simply write a SQL update statement to update the usertype field to Registered or if there is more to it than that.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Sat Feb 09, 2013 7:21 pm

agenda9 wrote:... What I'm wondering is if I can simply write a SQL update statement to update the usertype field to Registered ...
Per Yngve Berg gave you the answer to that
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

agenda9
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Jan 14, 2006 6:12 pm

Re: Users not assigned to any groups

Post by agenda9 » Sun Feb 10, 2013 12:41 am

Batch processing doesn't really do the trick. User Manager doesn't allow you to sort by User Group and the filter doesn't allow you to select users which don't belong to a group.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Sun Feb 10, 2013 1:07 am

agenda9 wrote:Batch processing doesn't really do the trick. ...
Yes it does ... you don't need soet by group or to filter. All you need to do is click to view all ... then select all and assign then to the Registered user group.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
atarr
Joomla! Intern
Joomla! Intern
Posts: 68
Joined: Thu Oct 23, 2008 6:06 pm
Location: Massachusetts, USA
Contact:

Re: Users not assigned to any groups

Post by atarr » Mon Feb 11, 2013 3:59 pm

If you have a normal setup, you should be able to successfully add the Register user group to all your users even if they already have a higher level user group assigned. It's ok for users to have more than one user group and Registered is usually the lowest level assigned so it normally will be irrelevant unless it's the only group.
Andrea Tarr
http://www.tarrconsulting.com - Tarr Consulting
http://www.twitter.com/Tarrconsulting - Follow me on Twitter @Tarrconsulting

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Mon Feb 11, 2013 5:00 pm

atarr wrote:... It's ok for users to have more than one user group ...
IMHO it is best to only have a user in one user group. Yes it is possible to have more than one user group per user .. but many site owners have problems working out the logic for viewing/access levels. And what users see on the site should be controlled by viewing/access levels first.

If site owners add users to more than one user group(before working out their logic for the viewing/access levels) in order control what users see ... then they themselves all mixed up with which user has access to what.

Users access on the site should be entirely controlled by correct use of viewing/access levels having several user groups selected in each viewing/access level. If a user is unable to see all they need from 1 user group ... then a user group should be created and selected in the relevant viewing/access levels. Instead of adding the user to multiple user groups.

Yes I know the default action for the Batch Processing of users is ' Add To Group. But it would probably be better if it was 'Set To Group' ... that way it would prevent inexperienced site owners getting in a muddle with users in multiple groups.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
atarr
Joomla! Intern
Joomla! Intern
Posts: 68
Joined: Thu Oct 23, 2008 6:06 pm
Location: Massachusetts, USA
Contact:

Re: Users not assigned to any groups

Post by atarr » Mon Feb 11, 2013 6:02 pm

If you are using Set to Group, then you don't want to use Select All without having an appropriate filter or sort, or you will mess up the users who already have an appropriate group, so the earlier poster would still need a way to change hundreds of users without doing them one by one.

I haven't had a problem with multiple user groups and use them frequently when it's appropriate. It makes role type acl much easier.
Andrea Tarr
http://www.tarrconsulting.com - Tarr Consulting
http://www.twitter.com/Tarrconsulting - Follow me on Twitter @Tarrconsulting

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Mon Feb 11, 2013 6:43 pm

atarr wrote:If you are using Set to Group, then you don't want to use Select All without having an appropriate filter or sort, or you will mess up the users who already have an appropriate group, ....
Good point ... from the OP
But I still have several hundred other users where the usertype is blank
Order by ID ascending should put SU at the top. Deselect SU and any user already assigned(but it sounds like none of the others are assigned).

atarr wrote:...
I haven't had a problem with multiple user groups and use them frequently when it's appropriate. ....
I was speaking of users assigned to more than one user groups not to having multiple user groups. But if you mean that you don't have problems assigning users to more than one group then ... that is because you are experienced with the logic of viewing/access levels. But there are many website owners that are inexperienced in such matters. They do not properly organise viewing/access levels and user groups ... then get in a mess by trying to sort it out by adding users to more groups.

You said "use them frequently when it's appropriate", my point is you are experienced enough to know when it is appropriate. And the logic of setting up viewing/access levels and user groups then assigning the user groups to viewing/access levels is probably second nature to you. However it is not second nature to many thus many website owners get the viewing/access levels and user groups mixed up.

To avoid adding users to more than one user group when it is not appropriate many website owners need to organize their viewing/access levels and user groups correctly. And a lot of problems that I have seen with ACL on this forum is people setting users to more than one user group before correctly creating viewing/access levels with user groups.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Users not assigned to any groups

Post by sovainfo » Mon Feb 11, 2013 9:31 pm

Use this SQL to assign users to 2 (registered) that have no group assinment

Code: Select all

insert into j259_user_usergroup_map  SELECT u.id, 2 FROM `j259_users` as u
left join j259_user_usergroup_map as ugm on u.id = ugm.user_id 
where ugm.user_id is null
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

agenda9
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Jan 14, 2006 6:12 pm

Re: Users not assigned to any groups

Post by agenda9 » Mon Feb 11, 2013 11:45 pm

Thanks - that;s what I was looking for.

BTW - View all wouldn't work for me -- the user list is too long and I received an error.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44018
Joined: Sat Apr 05, 2008 9:58 pm

Re: Users not assigned to any groups

Post by Webdongle » Tue Feb 12, 2013 12:26 am

agenda9 wrote:...
BTW - View all wouldn't work for me -- the user list is too long and I received an error.
Then view by 50 or 100 but you got your sql code now courtesy of solveinfo :D
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
masoesa
Joomla! Explorer
Joomla! Explorer
Posts: 300
Joined: Mon Sep 26, 2005 7:11 pm
Location: Brooklyn NY
Contact:

Re: Users not assigned to any groups

Post by masoesa » Wed Oct 16, 2013 3:51 am

sovainfo wrote:Use this SQL to assign users to 2 (registered) that have no group assinment

Code: Select all

insert into j259_user_usergroup_map  SELECT u.id, 2 FROM `j259_users` as u
left join j259_user_usergroup_map as ugm on u.id = ugm.user_id 
where ugm.user_id is null
Thanks!
http://going-natural.com
The site where Natural Beauty Shines

derekk
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Aug 03, 2007 6:30 pm

Re: Users not assigned to any groups

Post by derekk » Wed Mar 23, 2016 10:30 pm

Have the same issue with users inexplicably and no trace of how they became unassigned and are now blank. We have migrated form 1.5 to 3.4 over the years. We think the trace or common path is the user was refunded and canceled out of [spam].
1. we have no way of sorting them so we can see just the users unassigned and we have thousands of users. So the batch process wont work.
2. Were using 3.4 will the sql query still work?


Locked

Return to “Migrating and Upgrading to Joomla! 2.5”