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

mopho · 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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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.

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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?

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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!

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

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.

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

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`;

mopho · New Member Joined: Apr 17, 2006 Posts: 20

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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 to the forums!

You must be signed on as a Nuke admin to run it. After installing, you should delete it.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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).