Can't edit the modules custom name and others..

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Hy Raven!

First, I want thank you because I had installed your RavenNuke76 v2.02.00 after your tips.

But I don't know why I can't edit my modules in the admin menu, I can active or inactive them, but I can change its views, custom name, etc. some ideas about it?

Thanks from Mexico
Roberto

Guardian2003 · Posted: Mon Feb 06, 2006 3:54 pm

You you are going to the nuke admin, selecting Modules and then in the list of modules diaplyed you are using the 'Edit' function?
I cannot duplicate this problem, make sure all your files ftp'd correctly.

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Yes, the Edit function, that opens, but when I clic "save changes" them weren't there. I sure of that, a had ftp'd twice or more times.

Guardian2003 · Posted: Mon Feb 06, 2006 4:12 pm

Can you paste the database shcema for you nuke_modules table please.
I have installed this on a number of sites now and I am unable to reproduce this problem on any of them.

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Code:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 06-02-2006 a las 15:24:57
-- Versión del servidor: 4.1.14
-- Versión de PHP: 4.3.11
--
-- Base de datos: `medtropo_nuke`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `nuke_modules`
--

CREATE TABLE `nuke_modules` (
`mid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`custom_title` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`view` int(1) NOT NULL default '0',
`inmenu` tinyint(1) NOT NULL default '1',
`mod_group` int(10) default '0',
`admins` varchar(255) NOT NULL default '',
PRIMARY KEY (`mid`),
KEY `title` (`title`),
KEY `custom_title` (`custom_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;

--
-- Volcar la base de datos para la tabla `nuke_modules`
--

INSERT INTO `nuke_modules` VALUES (1, 'AvantGo', 'AvantGo', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (2, 'Content', 'Artículos y Trabajos', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (3, 'Downloads', 'Descargas', 1, 1, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (4, 'Encyclopedia', 'Diccionario', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (5, 'FAQ', 'FAQ', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (6, 'Feedback', 'Dudas y Sugerencias', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (7, 'Forums', 'Foros', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (8, 'Groups', 'Grupos', 1, 0, 0, 0, '');
INSERT INTO `nuke_modules` VALUES (9, 'Journal', 'Journal', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (10, 'Members_List', 'Lista de Miembros', 1, 1, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (11, 'News', 'Noticias y Editoriales', 1, 0, 0, 0, '');
INSERT INTO `nuke_modules` VALUES (12, 'NukeSentinel', 'NukeSentinel', 1, 0, 0, 0, '');
INSERT INTO `nuke_modules` VALUES (13, 'Private_Messages', 'Mensajes Privados', 1, 1, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (14, 'Recommend_Us', 'Recomiéndanos', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (15, 'Reviews', 'Revisiones', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (16, 'rwsMetAuthors', 'índice de artículos y autores', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (17, 'Search', 'Search', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (18, 'Statistics', 'Statistics', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (19, 'Stories_Archive', 'Stories Archive', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (20, 'Submit_News', 'Enviar Noticias', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (21, 'Surveys', 'Encuestas', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (22, 'Top', 'Top 10', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (23, 'Topics', 'Temas', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (24, 'Web_Links', 'Enlaces', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (25, 'Your_Account', 'Tu Cuenta', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (26, 'Buscar', 'Buscar', 1, 0, 1, 0, '0');
INSERT INTO `nuke_modules` VALUES (28, 'GoogleApiSearch', 'GoogleApiSearch', 1, 0, 0, 1, '0');
INSERT INTO `nuke_modules` VALUES (29, 'Monitor', 'Monitor', 1, 0, 0, 1, '0');
INSERT INTO `nuke_modules` VALUES (30, 'listadescargas', 'Descargas (Lista)', 1, 0, 1, 1, '0');

I think that is what you need. Thanks for your help.

Guardian2003 · Posted: Mon Feb 06, 2006 4:46 pm

Guardian2003 · Posted: Mon Feb 06, 2006 4:51 pm

Wait forget that.
This DB schema is not for the version of nuke you said you were using.
The schema you provided is not for Raven Nuke 7.6 V202 as it is missing the 'groups' field

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Is not this?

Code:

`mod_group` int(10) default '0',

Look, this is the schema that cames in the INSTALLATION file in the RavenNuke 7.6 v202

Code:

-- --------------------------------------------------------

--
-- Table structure for table `nuke_modules`
--

DROP TABLE IF EXISTS `nuke_modules`;
CREATE TABLE `nuke_modules` ( `mid` int(10) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `custom_title` varchar(255) NOT NULL default '', `active` int(1) NOT NULL default '0', `view` int(1) NOT NULL default '0', `inmenu` tinyint(1) NOT NULL default '1', `mod_group` int(10) default '0', `admins` varchar(255) NOT NULL default '', PRIMARY KEY (`mid`), KEY `title` (`title`), KEY `custom_title` (`custom_title`) ) TYPE=MyISAM;

--
-- Dumping data for table `nuke_modules`
--

INSERT INTO `nuke_modules` VALUES (NULL, 'AvantGo', 'AvantGo', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Content', 'Content', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Downloads', 'Downloads', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Encyclopedia', 'Encyclopedia', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'FAQ', 'FAQ', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Feedback', 'Feedback', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Forums', 'Forums', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Groups', 'Groups', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Journal', 'Journal', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Members_List', 'Members List', 0, 1, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'News', 'News', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'NukeSentinel', 'NukeSentinel', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Private_Messages', 'Private Messages', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Recommend_Us', 'Recommend Us', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Reviews', 'Reviews', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'rwsMetAuthors', 'Articles and Authors List', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Search', 'Search', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Statistics', 'Statistics', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Stories_Archive', 'Stories Archive', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Submit_News', 'Submit News', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Surveys', 'Surveys', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Top', 'Top 10', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Topics', 'Topics', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Web_Links', 'Web Links', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Your_Account', 'Your Account', 1, 0, 1, 0, '');

-- --------------------------------------------------------

Guardian2003 · Posted: Mon Feb 06, 2006 5:40 pm

No,the schema you posted is for Raven Nuke 1.x and also phpNuke 7.6
The correct schema which is my installation file and has been installed on a number of sites is;

Code:

CREATE TABLE `nuke_modules` (
`mid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`custom_title` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`view` int(1) NOT NULL default '0',
`groups` text NOT NULL,
`inmenu` tinyint(1) NOT NULL default '1',
`mod_group` int(10) default '0',
`admins` varchar(255) NOT NULL default '',
PRIMARY KEY (`mid`),
KEY `title` (`title`),
KEY `custom_title` (`custom_title`)
) TYPE=MyISAM;

The reason for your problem is because the number of fields in the table do not match the number of fields in the code that updated the modules list in the file
modules/modules.php

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Thank you very much, now it is working well.

Guardian2003 · Posted: Mon Feb 06, 2006 5:56 pm

I just check the distro and it appears something has changed from when I downloaded it - sorry for the confusion.
I have added this to our bug track system and corrected the files for the next release.

Make a back of your nuke_modules table then try this through phpmyadmin.

Code:

DROP TABLE IF EXISTS `nuke_modules`;
CREATE TABLE `nuke_modules` ( `mid` int(10) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `custom_title` varchar(255) NOT NULL default '', `active` int(1) NOT NULL default '0', `view` int(1) NOT NULL default '0', 'groups` text NOT NULL,`inmenu` tinyint(1) NOT NULL default '1', `mod_group` int(10) default '0', `admins` varchar(255) NOT NULL default '', PRIMARY KEY (`mid`), KEY `title` (`title`), KEY `custom_title` (`custom_title`) ) TYPE=MyISAM;

--
-- Dumping data for table `nuke_modules`
--

INSERT INTO `nuke_modules` VALUES (NULL, 'AvantGo', 'AvantGo', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Content', 'Content', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Downloads', 'Downloads', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Encyclopedia', 'Encyclopedia', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'FAQ', 'FAQ', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Feedback', 'Feedback', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Forums', 'Forums', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Groups', 'Groups', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Journal', 'Journal', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Members_List', 'Members List', 0, 1, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'News', 'News', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'NukeSentinel', 'NukeSentinel', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Private_Messages', 'Private Messages', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Recommend_Us', 'Recommend Us', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Reviews', 'Reviews', 0, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'rwsMetAuthors', 'Articles and Authors List', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Search', 'Search', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Statistics', 'Statistics', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Stories_Archive', 'Stories Archive', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Submit_News', 'Submit News', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Surveys', 'Surveys', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Top', 'Top 10', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Topics', 'Topics', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Web_Links', 'Web Links', 1, 0, 1, 0, '');
INSERT INTO `nuke_modules` VALUES (NULL, 'Your_Account', 'Your Account', 1, 0, 1, 0, '');

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

Don't worry, thanks for you help, I hope help you in the future.

montego · Posted: Mon Feb 06, 2006 9:49 pm

Guys, I believe that with 2.x, Raven implemented the installer where he broke up the core files from the non-core. With 2.x came NSN Groups and with that the installer had it as a separate button to push to install the NSN Groups tables and to alter the core nuke tables to have the groups fields....

Looks like that step was missed to install the NSN Groups tables!

By the way, the installer screen was very specific that Steps 1 - 3 had to be executed...

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

I'd executed all steps. As you say the installer only isntall the NSN Groups, teh Core are intact, and it has the schema for the RavenNuke7.6 v1.x and not for the v2.x

Guardian2003 · Posted: Tue Feb 07, 2006 5:06 am

Montego, thats an excellent observation, I had forgotten there was a seperate installer sql for groupshowever, that one seems to be missing the required ALTER TABLE for nuke_modules table.

montego · Posted: Wed Feb 08, 2006 7:53 am

Guardian2003, I have just checked my two 2.02 sites and nuke_modules correctly has included the "groups" field. I have also checked the raw sql file used to install NSN Groups and it has the appropriate ALTER statement in it.

Code:

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

Are you looking at a clean distro or an upgraded 1.05 to 2.02?

Guardian2003 · Posted: Wed Feb 08, 2006 8:51 am

Montego, I have PM'd you.

montego · Posted: Wed Feb 08, 2006 9:00 am

Just responded Wink

Raven · Posted: Wed Feb 08, 2006 11:26 am

Well, that's rude ROTFL

- Is there a problem in the distro or not?

montego · Posted: Wed Feb 08, 2006 5:44 pm

Raven, if we told you we would have to kill you! ROTFL

If we could update our bug reports you'd know the answer to that question... killing me

Just bustin' your chops.

Seriously, there is no issue with the 2.02 distro but we may need to either have Guardian's head checked or check the CVS repository to make sure 2.1 will be good too... Wink

Raven · Posted: Wed Feb 08, 2006 10:04 pm

I'll provide the gun and the amunition. The repository was a test repository and I have to reload the darn thing. But first, <yawn>, a nap ......

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

I'd seen the same problem in the 'nuke_blocks' table, the field 'groups' was missing. If that was a personal problem, take it like a experience, if is a general problem I hope help you.

montego · Posted: Fri Feb 10, 2006 5:21 pm

boylucas, based on this new "evidence", I am convinced Step 2 was skipped in your installation.

Best regards,
montego

boylucas · New Member Joined: Feb 04, 2006 Posts: 12

I'm sure that I'd done all steps, but everytime exist the posibility of a error...

What I have to do to make a solution to this problem (I'd repaired the problem with the blocks and modules tables)

Guardian2003 · Posted: Sun Feb 12, 2006 12:40 am

boylucas - If you have repaired the two tables then you are ready to go. You can easily confirm the table schema by looking at the groups sql file.
Just so I can publicly humiliate myself.....
The confusion was entirely mine. I had several copies of RN on my PC but these had been modified specifically as back-ups for productions sites I am using.
Rather than download a new, fresh copy of RN (which is what I SHOULD have done) to check your problem, I had looked at our CVS files which I should not have relied on as it is still an experimental set-up.

Please feel free to stone me, flog me, whatever but only after Raven and Montego have shot me (I have a low pain threshold).