Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
boylucas
New Member
New Member


Joined: Feb 04, 2006
Posts: 12

PostPosted: Mon Feb 06, 2006 2:05 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Mon Feb 06, 2006 3:54 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
boylucas
PostPosted: Mon Feb 06, 2006 4:08 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 4:12 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 4:25 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 4:46 pm Reply with quote

<Edited by me - see next post>


Last edited by Guardian2003 on Mon Feb 06, 2006 4:52 pm; edited 1 time in total 
Guardian2003
PostPosted: Mon Feb 06, 2006 4:51 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 5:23 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 5:40 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 5:54 pm Reply with quote

Thank you very much, now it is working well.
 
Guardian2003
PostPosted: Mon Feb 06, 2006 5:56 pm Reply with quote

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
PostPosted: Mon Feb 06, 2006 6:02 pm Reply with quote

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


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Mon Feb 06, 2006 9:49 pm Reply with quote

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

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
boylucas
PostPosted: Mon Feb 06, 2006 10:48 pm Reply with quote

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
PostPosted: Tue Feb 07, 2006 5:06 am Reply with quote

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
PostPosted: Wed Feb 08, 2006 7:53 am Reply with quote

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
PostPosted: Wed Feb 08, 2006 8:51 am Reply with quote

Montego, I have PM'd you.
 
montego
PostPosted: Wed Feb 08, 2006 9:00 am Reply with quote

Just responded Wink
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Wed Feb 08, 2006 11:26 am Reply with quote

Well, that's rude ROTFL - Is there a problem in the distro or not?
 
View user's profile Send private message
montego
PostPosted: Wed Feb 08, 2006 5:44 pm Reply with quote

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
PostPosted: Wed Feb 08, 2006 10:04 pm Reply with quote

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
PostPosted: Fri Feb 10, 2006 12:11 pm Reply with quote

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
PostPosted: Fri Feb 10, 2006 5:21 pm Reply with quote

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

Best regards,
montego
 
boylucas
PostPosted: Sat Feb 11, 2006 11:14 pm Reply with quote

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
PostPosted: Sun Feb 12, 2006 12:40 am Reply with quote

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).
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©