This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JForum and the fly likes Can not change Group Permissions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Can not change Group Permissions" Watch "Can not change Group Permissions" New topic
Author

Can not change Group Permissions

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I meet 2 problems after I upgrade Jforum from 2.1.7 to 2.1.8.
Although I logined the forum as "Admin" , changed the groups' persmissions according to the relative categories and pressed "save" button to save my settings, the variations were not active at all, the groups permissions still kept the same as before.
Additonally, I could not see some categories in the "Admin Control Pannel" though they could be found in the database "jforum". All the groups were denied to access these "unseen" categories in the "Group Permission Control" ,and just as I mentioned, I could not change the permissions to see if the problem could be fixed in this way.

Does anybody have any suggestions or advice related to the problems?
Really appreciated for your feedback.

Mysql version: mysql Ver 12.22 Distrib 4.0.23, for pc-linux (i686)
Centos version: CentOS release 4.3, kernel 2.6.9-34.EL
[originally posted on jforum.net by peter818119]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Try this: delete all data from jforum_role_values and in jforum_roles keep only perm_administration, then go to the permissions page and try to save the settings for the admin group. See if it works.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:Try this: delete all data from jforum_role_values and in jforum_roles keep only perm_administration, then go to the permissions page and try to save the settings for the admin group. See if it works.

Rafael


Thanks for your kind reply.
I have removed the relevant records in table jforum_role_values and jforum_roles except perm_administration as you indicate and go back to the permissions page and try to save the settings for the admin group. It seems not work.

In the permission page, I could change my settings on some type items, such us "Administration", "Sticky or Announcement Topics", "vote", "Karma" and when I try to do some changes on other items , such us "Categories", "Forums","Anonymous Posts", "Reply Only","Read-Only Forums", the modifications fail.

BTW, in the "Admin Control Panel", item "Users", all the listed users are sorted randomly, not by the default "ascending".

Will these clues help you to figure out the problems for me?Thanks for your patience again.
[originally posted on jforum.net by peter818119]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
1) Make sure you're testing a fresh 2.1.8 install against a copy of your 2.1.7 database with the upgrade scripts executed there

2) Make sure your web-inf/config/database/generic/generic_queries.sql file is equals to https://jforum.dev.java.net/source/browse/jforum/WEB-INF/config/database/generic/generic_queries.sql?rev=1.202&view=markup


Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I also encountere this problem!!!

I changed the groups' persmissions according to the relative categories and pressed "save" button to save my settings, the variations were not active at all, the groups permissions still kept the same as before.

Please help me, really appreciated for your feedback.
Mysql version: mysql 4.0.23, on windows 2003 Server.
Tomcat version: tomcat-5.5.25.

[originally posted on jforum.net by KentRobot]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
BTW, i am testing a fresh 2.1.8 installation.
[originally posted on jforum.net by KentRobot]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I figured out how to recur that problem!!!
when the number of forums less than 10, everything is ok, but after you built the 10 forums, pressed "save" button to save permission settings, the variations were not active at all, the groups permissions still kept the same as before.
I watched the table "jforum_forums", when the field value of "forum_id" exceed the rang "0..9", like "11" or "-1" ,that the problem will occur.

Is it a bug???
[originally posted on jforum.net by KentRobot]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hei hei,I found the bug where it is.
GenericGroupSecurityDAO.java


The search sql is below(WEB-INF\config\database\generic\generic_queries.sql)



When I use this sql string to get the Roles that i found the "union" clause can not get the record that ID >= 10, and i change the sql string as follow:



It works ! The MySql version is 4.0.26 .
Can anyone explain it ???
[originally posted on jforum.net by KentRobot]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Strange, because I have a board with 13 forums, and it is working fine (even the queries you posted return the same set of results). But I'll take a closer look in your theory.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I had this same problem, and KentRobot's solution fixed it

Thanks KentRobot!
[originally posted on jforum.net by krogers]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Can not change Group Permissions