weird module behavior

Savent · Regular Joined: Jun 30, 2003 Posts: 81

Hey Raven

i currently upgraded my nuke 6.5 to secruity pack 4, it went great no errors or problems, but...aint there always a but lol some of my modules are deactivated by themselves, there all working fine, but i check my site a few hours later and there not activate....so every few hours i have to go back and reactivate them again? any ideas or should i upgrade to nuke 6.9 or 7.0 and the problems will go away?

Raven · Posted: Fri Oct 03, 2003 10:07 pm

More and more people are experiencing this. Just for curiosity, check around line 46 in admin/modules/module.php. Does it look like this?

Code:

sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);

or is it different?

Savent · Regular Joined: Jun 30, 2003 Posts: 81

This is my line 46:

sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);

It looks the same to me

Raven · Posted: Sat Oct 04, 2003 5:31 am

Now look at your nuke_modules table. Are there 6 columns in it?

Savent · Regular Joined: Jun 30, 2003 Posts: 81

Yes 6 columns: mid,title,custom_title,active,view and inmenu

Raven · Posted: Sat Oct 04, 2003 9:17 pm

I know this will probably seem futile, but it's worth a try. Rebuild your modules table from scratch, like this.

Backup the modules table, of course!
Drop the table entirely.
Using phpMyAdmin, run this code in the SQL window

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',
inmenu tinyint(1) NOT NULL default '1',
PRIMARY KEY (mid),
KEY mid (mid),
KEY title (title),
KEY custom_title (custom_title)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_modules`
#

INSERT INTO nuke_modules VALUES (1, 'AvantGo', 'AvantGo', 1, 0, 1);
INSERT INTO nuke_modules VALUES (2, 'Downloads', 'Downloads', 1, 0, 1);
INSERT INTO nuke_modules VALUES (3, 'Feedback', 'Feedback', 1, 0, 1);
INSERT INTO nuke_modules VALUES (4, 'Journal', 'Journal', 1, 0, 1);
INSERT INTO nuke_modules VALUES (5, 'News', 'News', 1, 0, 1);
INSERT INTO nuke_modules VALUES (6, 'Private_Messages', 'Private Messages', 1, 0, 1);
INSERT INTO nuke_modules VALUES (7, 'Recommend_Us', 'Recommend Us', 1, 0, 1);
INSERT INTO nuke_modules VALUES (8, 'Search', 'Search', 1, 0, 1);
INSERT INTO nuke_modules VALUES (9, 'Statistics', 'Statistics', 1, 0, 1);
INSERT INTO nuke_modules VALUES (10, 'Stories_Archive', 'Stories Archive', 1, 0, 1);
INSERT INTO nuke_modules VALUES (11, 'Submit_News', 'Submit News', 1, 0, 1);
INSERT INTO nuke_modules VALUES (12, 'Surveys', 'Surveys', 1, 0, 1);
INSERT INTO nuke_modules VALUES (13, 'Top', 'Top 10', 1, 0, 1);
INSERT INTO nuke_modules VALUES (14, 'Topics', 'Topics', 1, 0, 1);
INSERT INTO nuke_modules VALUES (15, 'Web_Links', 'Web Links', 1, 0, 1);
INSERT INTO nuke_modules VALUES (16, 'WebMail', 'WebMail', 1, 1, 1);
INSERT INTO nuke_modules VALUES (17, 'Your_Account', 'Your Account', 1, 0, 1);
INSERT INTO nuke_modules VALUES (18, 'Addon_Sample', 'Addon Sample', 0, 2, 1);
INSERT INTO nuke_modules VALUES (19, 'Content', 'Content', 0, 0, 1);
INSERT INTO nuke_modules VALUES (20, 'Encyclopedia', 'Encyclopedia', 0, 0, 1);
INSERT INTO nuke_modules VALUES (21, 'FAQ', 'FAQ', 0, 0, 1);
INSERT INTO nuke_modules VALUES (22, 'Forums', 'Forums', 0, 0, 1);
INSERT INTO nuke_modules VALUES (23, 'Members_List', 'Members List', 0, 1, 1);
INSERT INTO nuke_modules VALUES (24, 'Reviews', 'Reviews', 0, 0, 1);
INSERT INTO nuke_modules VALUES (25, 'Sections', 'Sections', 0, 0, 1);

You will, of course, need to customize your admin/modules, but I'd try this before doing an upgrade. I started having a problem after I upgraded to fp4 also and when I went to 6.9 it went away, but I also changed servers at the same time so I'm not sure where any, if any, correlation exists!