Cannot add groups - 'There are no new groups in database'

New Member Joined: Apr 17, 2006 Posts: 20

Hello,
I'm pretty new to all this. I've got my PHPNuke site up and running, but am having trouble adding new groups in the groups module.
I'm using the most recent version of RavenNuke 76. I understand it comes with NSN groups built in, correct? Is that module automatically active?

When I go to create a new group from the main admin, it appears to let me. On the reload of the groups page, there are no groups listed.
It states:
'There are no groups in the database.'
The groups I create do show up in the forum administration page.
As well, when I try to add a group from the forum administration page, the fields are unnamed, so I can't tell what field does what.

I have tried to reinstall (ftp'd nsngroups again) but still have the same problem. Any ideas? Anything I need to change in phpMyAdmin?

PLEASE HELP!!!!!!!!!

mopho

Site Admin Joined: Jun 04, 2004 Posts: 6432

Are the groups public or private? If they're all private, nothing will show on the groups page.

Posted: Mon Apr 17, 2006 3:57 pm

I tried to add a public group. Still not showing up.
mopho

Posted: Mon Apr 17, 2006 3:59 pm

There are 2 groups functions - standard Nuke groups and NSN Groups. Are you sure the groups function you're using is the correct one (i.e. NSN Groups)? If so, there should be a copyright there.

Posted: Mon Apr 17, 2006 4:03 pm

From the Main Admin page, I go to edit groups. Once I am there, there is no copyright info. How do I access the NSN Group module?
mopho

Posted: Mon Apr 17, 2006 4:34 pm

That might be the correct way to edit groups (the url ends with admin.php?op=NSNGroups). How are you trying to view the groups where they do not appear?

Posted: Mon Apr 17, 2006 4:41 pm

Ya, I just looked at the URL and it says NSNGroups at the end. So, I'm assuming it is using NSN Groups.
After I add a test group
group name: test group x
group mod: mopho
group decription: test group x
public: i've tried yes and no.
limit: 0

I hit 'add group'
It pulls up the group list and states 'There are no groups in the database.'

As well, if I go to 'View groups' I get the same message: There are no groups in the database.

Posted: Mon Apr 17, 2006 4:45 pm

Ahhh... Did you run the installation routine and / or verify that the table was created in your database?

Posted: Mon Apr 17, 2006 4:45 pm

How do I do that?
I'm assuming I would do that in phpMyAdmin correct?

Posted: Mon Apr 17, 2006 4:53 pm

You could, but all NSN scripts come with a web-based installation routine. Very simple. Check the readme.

Posted: Mon Apr 17, 2006 5:01 pm

Can you direct me to the specific read me you are referencing? I don't see anything in the nsngroups folder. I did find under the installation/sql rn76_nsngroups.sql

I also did a complete search in the Raven76 folder for 'readme' and could not find what you are referring to.

Thanks!
mopho

Posted: Mon Apr 17, 2006 5:50 pm

I also went to nukescripts.net to dl the nsn groups 71-78 package. It is in the form of a .tar.tar file. I had to dl two different extractors, neither worked.

Please help!
Thanks!

Posted: Mon Apr 17, 2006 6:04 pm

If you can use phpmyadmin, check the table 'nuke_blocks' and see if you have a field called 'groups' this may be the quickest way to determine if you have installed the groups tables.

Posted: Mon Apr 17, 2006 6:07 pm

I do not have a field called 'groups' in the 'nuke_blocks' table.
Now what?
Thanks!

Posted: Mon Apr 17, 2006 6:11 pm

In phpmyadmin use the SQL menu and copy/paste this into it and then run it.
This asumes your table prefix is 'nuke'.

Code:

DROP TABLE IF EXISTS `nuke_nsngr_config`;


CREATE TABLE `nuke_nsngr_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` text NOT NULL, PRIMARY KEY  (`config_name`) ) TYPE=MyISAM;





INSERT INTO `nuke_nsngr_config` VALUES ('perpage', '50');


INSERT INTO `nuke_nsngr_config` VALUES ('date_format', 'Y-m-d');


INSERT INTO `nuke_nsngr_config` VALUES ('send_notice', '1');


INSERT INTO `nuke_nsngr_config` VALUES ('version_number', '1.7.1');





DROP TABLE IF EXISTS `nuke_nsngr_groups`;


CREATE TABLE `nuke_nsngr_groups` ( `gid` int(11) NOT NULL auto_increment, `gname` varchar(32) NOT NULL default '', `gdesc` text NOT NULL, `gpublic` tinyint(1) NOT NULL default '0', `glimit` int(11) NOT NULL default '0', `phpBB` int(11) NOT NULL default '0', `muid` int(11) NOT NULL default '0', PRIMARY KEY  (`gid`) ) TYPE=MyISAM;





INSERT INTO `nuke_nsngr_groups` VALUES (1, 'Moderators', 'Moderators of this Forum', 0, 0, 3, 5);





DROP TABLE IF EXISTS `nuke_nsngr_users`;


CREATE TABLE `nuke_nsngr_users` ( `gid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', `uname` varchar(25) NOT NULL default '', `trial` tinyint(1) NOT NULL default '0', `notice` tinyint(1) NOT NULL default '0', `sdate` int(14) NOT NULL default '0', `edate` int(14) NOT NULL default '0' ) TYPE=MyISAM;





INSERT INTO `nuke_nsngr_users` VALUES (1, 5, '', 0, 0, 2005, 0);





ALTER TABLE `nuke_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;


ALTER TABLE `nuke_message` ADD `groups` TEXT NOT NULL AFTER `view`;


ALTER TABLE `nuke_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

Posted: Mon Apr 17, 2006 6:22 pm

If no one has told you before: YOU ARE A GENIUS!!!!!!!!!!!
It's working now. THANK YOU!!!

One other question:
Can you tell me how it integrates with the 7.6Nuke bb?
Thanks!
mopho

Posted: Mon Apr 17, 2006 6:27 pm

It might be called installation or something like that... The intallation php file is usually called like nsngr.php, and it's in the root directory after the [ Only registered users can see links on this board! Get registered or login! ] You must be signed on as a Nuke admin to run it. After installing, you should delete it.

Posted: Mon Apr 17, 2006 7:14 pm

Just in case - mopho, did you mean how do you use NSN Groups?
Best way to learn is to tinker Wink

Posted: Mon Apr 17, 2006 8:14 pm

Yes, tinkering is good. Actually, NSN Groups is directly integrated with phpBB groups. Just make sure you maintain the groups using NSN groups (it's much easier than using phpBB admin anyway).