Problems with user groups

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

I am trying to set up various parts of my site to e visible only to certain user groups. The problem is, when I select the module, then view by groups only, then in the next box, I have a list of groups, I highlight the desired group and save. It does not save the group I have saved, it will say "none". I have tried in IE and Mozilla thinking it was a browser issue but still no go.

fkelly · Posted: Thu Oct 11, 2007 3:25 pm

I just tried the same thing on a RN 2.10 (actually a 2.20) system. Works. So my question is did you set this group up thru nsngroups? Can you go into groups administration and see the group? Does it have users in it? I'd check that out.

You also don't say what version you are running. That would help.

If this doesn't help maybe you could create a simple group with one member thru nsngroups and then try to make the module access only that. Other than that all I can think of is that you might be getting a SQL error behind the scenes. We will probably have a SQL logging facility in 2.20 in a bit if all the testing comes out positive. Not that that helps you but you might take a look at your groups tables in phpmyadmin if you are good at looking at tables and see if you see anything squirrely there. Gosh, I don't know how to spell squirrely very well.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

I am using 2.10.01. I can see the groups in the groups admin, I have added users to the groups, it is through the groups system that came with the rn 2.10.01 distribution. I have set some forum threads to be only visible by the group I am trying to make certain modules visible by and it works just fine. Just not able to make modules visible only by them.

fkelly · Posted: Thu Oct 11, 2007 7:17 pm

Quote:

have set some forum threads to be only visible by the group I am trying to make certain modules visible by and it works just fine. Just not able to make modules visible only by them.

I am not sure that I understand the problem. I believe there was a recent thread about nsngroups versus forums groups? Long and short is that I would recommend that you not mix the two. When you create a nsngroup it creates a corresponding forum group but it doesn't work in reverse. Also, when you do certain types of maintenance on groups it doesn't necessarily "take" over in the other type of group (forum or nsngroups). There are separate tables for each type and very incomplete integration.

Make sure that the group that you are trying to limit the view to was a nsngroup and not a forum group. And if that doesn't work please post back here with a little more about what you are doing. Or maybe someone else will have an idea.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

I am using it in the way you are saying. Creating a group in nsn groups and then they are created in the forums. I am not creating them in the forums seperately.

I have group1 set up in nsn groups, then I added users, this is verifiable in the admin. Then when I try to make a module visible only to group1, I am not able to do so. I edit module members list, beside "who can view this" I select "groups only", then under that I select the group that I want to be able to view this module, ie: group1. However when I hit save changes, the group I selected is not being saved.

When I go to edit modules again, the members list module shows it is active, visible to groups only, but the group section says "none". The group selection is not being added to the db it appears.

montego · Posted: Thu Oct 11, 2007 8:28 pm

Sounds like you might have migrated from a non-RavenNuke nuke site to RN at some point? There is one field called "groups" that needs to be added to nuke_modules, nuke_blocks and nuke_messages.

You could try to execute the rn_nsngroups.sql file within phpMyAdmin... but check to see if that field is on these tables.

fkelly · Posted: Fri Oct 12, 2007 7:30 am

Just to add to what M. said, the problem probably is in the /admin/modules/modules.php file and within that in the module_edit_save function. The statement that is probably blowing up on you* is:

Code:

$result = $db->sql_query('update ' . $prefix . '_modules set custom_title=\''.$custom_title.'\', view=\''.$view.'\', groups=\''.$ingroups.'\', inmenu=\''.$inmenu.'\', mod_group=\''.$mod_group.'\' where mid=\''.$mid.'\'');

This would require that your modules table have the fields: custom_title, view, groups, inmenu, mod_group. So check out that table thru PHPmyadmin and then execute the file M. pointed you to if it doesn't have all those fields.

* generating a SQL error which PHPNUKE has historically ignored.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

It was a new install of RN. The only migration i did was the data itself. The "group" field is present in all three tables as it should be.

fkelly · Posted: Fri Oct 12, 2007 9:59 am

I am very puzzled then. The only other thing I can think of, and it's a stretch, is what version of MYSQL are you running on? There have been some threads about MYSQL 5 with strict settings having problems with some of the Nuke code.

When 2.20 is available we'll have a logging feature that will be able to pin down whether there is a SQL error. But I don't think we can hand that out piecemeal, there are a number of files that need to be updated to run it. I guess that doesn't help short run but I can't think of anything else off the top.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

I am having the same issue when trying to assign block visible only by groups. I checked the db and the correct group is being entered in the group field of the table for both the module and the block but it is not being recognized for some reason.

What is weird, I can make them visible to specific groups that come in RN, IE: all visitors, admins only, registered users only, but not specific to groups that I create through nsn groups (i guess that is what comes in the RN distro)

The mysql version is 4.1.22

fkelly · Posted: Fri Oct 12, 2007 2:20 pm

The only other thing I can think of is that maybe when you installed RN some of the files didn't get FTP'd correctly or completely and so you are using old versions? Did you write over an older distribution or was this from scratch? If you check that file and function I quoted earlier do you have exactly the same code in the $result = statement?

I admit I'm grasping at straws.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

No sir, not an over write, a complete fresh install. The code you mentioned seems to be exact as well.

You guys are going to be mad at me. I think I found something that may cause it but I do not know why. I have the module cnbya 750.442 that has been fixed by fade2glory that works with captch. I have it on 2 sites, one rn2.10.00 and rn2.10.01. This function does not work on either of them. I have just tested another site without that module on it and the function works. Did not think that could have been an issue but I guess it is. Still have no idea how to correct it though.

fkelly · Posted: Fri Oct 12, 2007 5:30 pm

Not mad

That's just how it goes. Personally I wish I had more time to spend on it but I don't. You might want to look at what that module does when it is installed ... does it change any tables? The other thing you can look at is to bring up your tables in PHPmyadmin (and I know you've done some of this) and then bring up the table definitions that are in the INSTALLATION directory of RN. In the sql directory under INSTALLATION, look at the nsngroups.sql file and also at the rn_core_pl32.sql file. Compare all the tables in nsngroups.sql and compare the modules table in the core file with the definitions that show up in phpmyadmin. Any differences are what's causing the program to go bonkers. Unfortunately if you change them back to the RN standard (even assuming that's the problem, which is far from certain) then cnbya might in turn go bonkers.

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

Well, after all that, and comparing until my eyes hurt, optimizing the tables from within phpmyadmin appears to have fixed it.

Now what would I do about this message:
PRIMARY and INDEX keys should not both be set for column `fid`?

cnbya has three fields that have similar errors.

Thanks again.

Gremmie · Posted: Fri Oct 12, 2007 9:09 pm

You can ignore that error message, those are all over stock nuke. If you want, you can remove the index key if it makes you sleep better. Wink

kevinkap · Involved Joined: Apr 22, 2006 Posts: 352

Thanks!