I have a number of usergroups and with my testing and creating and then deleting of these groups the id numbers went up to 27. Whenever I tried setting the permissions for group id #s 25, 26 & 27 they would not save. Since I had deleted some older usergroups I had a gap in id #s. Logged into phpmyadmin changed the id #s to something less than 25 and they started working again.
I came across this same problem again today. Again the problem was with the last 3 usergroup id numbers - 22, 23, & 24.
The difference this time was that the toplevel category saved the correct permissions for these 3 groups, but sub-cats would not save the permissions. This happened only with these three groups. If I changed another group's permissions it saved perfectly. Unfortunately, I've run out of smaller numbers so I couldn't do what I did the first time and re-number them.
So now I'm wondering, if I create a sub-subcat will groups 19, 20 & 21 give me this problem? Hmmm. Maybe I'll test that theory later tonight.
Ok, my theory didn't work, but I figured out that those last 3 usergroups won't save in top level or sub categories so that is definitely not the issue. And any categories that those groups had permissions to previously were ok so I did not want to change those categories. I did try giving them permission to other cats and those last 3 groups were the only ones that would not save the permission change.
I see on categories. With such an insane number of groups, you exceed mysql's limit for the size of text data fields. You have to change it to longtext to fit (phpmyadmin, categories table, permissions field). It'll still slow down your site though, and I can't imagine what the reason is for having practically a group for every member.
The reason I have created a group for every member is because I am not using WSN as a plain old links list. You've managed to make WSN so flexible and configurable we are actually using it as a place our clients can login and get information about their site and their site only, including reports, bills, etc.
Actually, this is the reason we had you create the assignment email so that when we post a report to their category/section the client will get an email letting them know that they can log into the site and get it. To do that we create a separate category and separate group for each client.
In my defense, I did ask before starting this project of any limitations to the number of usergroups that could be created. All you mentioned was the possible slowing down of the site at a certain point, but that there were no limitations. Which I guess is correct since changing the field to longtext worked. I guess my translation of "at a certain point" was at a much higher number of groups than what you meant.
That's what you get for creating such an awesome script!
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on usergroup id > 24 does not work
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I have a number of usergroups and with my testing and creating and then deleting of these groups the id numbers went up to 27. Whenever I tried setting the permissions for group id #s 25, 26 & 27 they would not save. Since I had deleted some older usergroups I had a gap in id #s. Logged into phpmyadmin changed the id #s to something less than 25 and they started working again.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I came across this same problem again today. Again the problem was with the last 3 usergroup id numbers - 22, 23, & 24.
The difference this time was that the toplevel category saved the correct permissions for these 3 groups, but sub-cats would not save the permissions. This happened only with these three groups. If I changed another group's permissions it saved perfectly. Unfortunately, I've run out of smaller numbers so I couldn't do what I did the first time and re-number them.
So now I'm wondering, if I create a sub-subcat will groups 19, 20 & 21 give me this problem? Hmmm. Maybe I'll test that theory later tonight.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Ok, my theory didn't work, but I figured out that those last 3 usergroups won't save in top level or sub categories so that is definitely not the issue. And any categories that those groups had permissions to previously were ok so I did not want to change those categories. I did try giving them permission to other cats and those last 3 groups were the only ones that would not save the permission change.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Created 28 usergroups and they all work fine for regular permissions... are you talking about category permissions?
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
are you talking about category permissions?
yes
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I see on categories. With such an insane number of groups, you exceed mysql's limit for the size of text data fields. You have to change it to longtext to fit (phpmyadmin, categories table, permissions field). It'll still slow down your site though, and I can't imagine what the reason is for having practically a group for every member.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Thank you Paul, changing to LONGTEXT worked.
The reason I have created a group for every member is because I am not using WSN as a plain old links list. You've managed to make WSN so flexible and configurable we are actually using it as a place our clients can login and get information about their site and their site only, including reports, bills, etc.
Actually, this is the reason we had you create the assignment email so that when we post a report to their category/section the client will get an email letting them know that they can log into the site and get it. To do that we create a separate category and separate group for each client.
In my defense, I did ask before starting this project of any limitations to the number of usergroups that could be created. All you mentioned was the possible slowing down of the site at a certain point, but that there were no limitations. Which I guess is correct since changing the field to longtext worked. I guess my translation of "at a certain point" was at a much higher number of groups than what you meant.
That's what you get for creating such an awesome script!