Can not change Group Permissions

[Migrated From Jforum.net]

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]

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]

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]

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]

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]

BTW, i am testing a fresh 2.1.8 installation.
[originally posted on jforum.net by KentRobot]

[Migrated From Jforum.net]

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]

Hei hei,I found the bug where it is.
GenericGroupSecurityDAO.java

	protected RoleCollection loadRoles(int[] groupIds)
	{
		String sql = SystemGlobals.getSql("PermissionControl.loadGroupRoles");
		String groupIdAsString = SecurityCommon.groupIdAsString(groupIds);
		
		if ("".equals(groupIdAsString)) {
			// We suppose there is no "negative" group ids
			sql = sql.replaceAll("#IN#", "-1");
		}
		else {
			sql = sql.replaceAll("#IN#", groupIdAsString);
		}
		RoleCollection roles = new RoleCollection();
		
		PreparedStatement p = null;
		ResultSet rs = null;
		
		try {
			p = JForumExecutionContext.getConnection().prepareStatement(sql);
			rs = p.executeQuery();
			
			roles = SecurityCommon.loadRoles(rs);
		}
		catch (Exception e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(rs, p);
		}
		
		return roles;
	}

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

PermissionControl.loadGroupRoles = SELECT r.name, '0' AS role_value FROM jforum_roles r WHERE r.group_id IN (#IN#) \
	UNION \
	SELECT r.name, rv.role_value \
	FROM jforum_roles r, jforum_role_values rv \
	WHERE r.role_id = rv.role_id  \
	AND r.group_id IN (#IN#) \
	ORDER BY name

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:

PermissionControl.loadGroupRoles = SELECT r.name, rv.role_value \
	FROM jforum_roles r, jforum_role_values rv \
	WHERE r.role_id = rv.role_id  \
	AND r.group_id IN (#IN#) \
	UNION \
       SELECT r.name, '0' AS role_value FROM jforum_roles r WHERE r.group_id IN (#IN#) \
	ORDER BY name

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

[Migrated From Jforum.net]

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]

I had this same problem, and KentRobot's solution fixed it

Thanks KentRobot!
[originally posted on jforum.net by krogers]