Can't add new modules

Regular Joined: May 27, 2005 Posts: 62

Hello im having a simlar problem wonder if raven or anyone can help me here iv installed a czm mod on 7.7 and I think thats what done it now every time I upload a module it wont appear unless I manually do it by my phpadmin

Heres my code if it helps

Code:

case "modules":


    global  $prefix, $db, $bgcolor2;


    $mcid = intval($mcid);


    include ("header.php");


    title(_MODULESADMIN);


    mainmenu();


    $handle=opendir('modules');


    while ($file = readdir($handle)) { if ( (!ereg("[.]",$file)) ) { $modlist .= "$file "; } }


    closedir($handle);


    $modlist = explode(" ", $modlist);


    sort($modlist);


    for ($i=0; $i < sizeof($modlist); $i++) {


        if($modlist[$i] != "") {


            $result = $db->sql_query("select mid from ".$prefix."_modules where title='$modlist[$i]'");


            list ($mid) = $db->sql_fetchrow($result);


            if ($mid == "") {


                $db->sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '".str_replace("_", " ", $modlist[$i])."', '0', '0', '1', '0', '1', '', '')");


            }


        }


    }

Sells PC To Pay For Divorce Joined: Posts: 5661

hello,

realise that your version of czm is for the 7.5.
even im lucky that mine works,i also use the czm.
whay you can do is check if the install is done properly,cause the modules table is altered when installing the czm.

And as the support site writes "This is a very common problem it has been posted on a few hundred times and the fix is available in the Forums. Basically you have too many data fields in your nuke_modules table or not enough. You have to open the admin/modules.php and find the insert into nuke_modules query and make sure the inputs match your nuke_modules table.".

Posted: Sun Aug 07, 2005 6:26 am

hmmm over my head how would I do that?

This is my nuke_modules

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 07, 2005 at 12:34 PM
-- Server version: 4.1.11
-- PHP Version: 4.3.11
--
-- Database: `deltas00_nuke1`
--

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

--
-- Table structure for table `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 '',
`wysig_status` tinyint(1) NOT NULL default '0',
`mcid` int(11) NOT NULL default '1',
`url` varchar(255) default '',
PRIMARY KEY (`mid`),
KEY `mid` (`mid`),
KEY `title` (`title`),
KEY `custom_title` (`custom_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

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

INSERT INTO `nuke_modules` VALUES (1, 'AvantGo', 'AvantGo', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (2, 'Content', 'Content', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (3, 'Downloads', 'Downloads', 1, 1, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (4, 'Encyclopedia', 'Encyclopedia', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (5, 'FAQ', 'FAQ', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (6, 'Feedback', 'Join Us', 1, 0, 1, 0, '', 0, 2, '');
INSERT INTO `nuke_modules` VALUES (7, 'Forums', 'Forums', 1, 1, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (8, 'Journal', 'Journal', 1, 0, 1, 0, '', 0, 3, '');
INSERT INTO `nuke_modules` VALUES (9, 'Members_List', 'Members List', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (10, 'News', 'News', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (11, 'Private_Messages', 'Private Messages', 1, 0, 1, 0, '', 0, 3, '');
INSERT INTO `nuke_modules` VALUES (12, 'Recommend_Us', 'Recommend Us', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (13, 'Reviews', 'Reviews', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (14, 'Search', 'Search', 1, 0, 1, 0, '', 0, 4, '');
INSERT INTO `nuke_modules` VALUES (15, 'Statistics', 'Website Statistics', 1, 0, 1, 0, '', 0, 4, '');
INSERT INTO `nuke_modules` VALUES (16, 'Stories_Archive', 'Stories Archive', 1, 0, 1, 0, '', 0, 4, '');
INSERT INTO `nuke_modules` VALUES (17, 'Submit_News', 'Submit News', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (18, 'Surveys', 'Polls', 0, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (19, 'Top', 'Top 10', 1, 0, 1, 0, '', 0, 4, '');
INSERT INTO `nuke_modules` VALUES (20, 'Topics', 'Topics', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (21, 'Web_Links', 'Web Links', 0, 0, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (22, 'Your_Account', 'Your Account', 1, 0, 1, 0, '', 0, 3, '');
INSERT INTO `nuke_modules` VALUES (23, 'Team', 'Team Results Fixtures', 1, 0, 1, 0, '', 0, 2, '');
INSERT INTO `nuke_modules` VALUES (31, 'Link_To_Us', 'Link To Us', 1, 0, 1, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (34, 'OFx_ClanList', 'Clan Roster', 1, 0, 1, 0, '', 0, 2, '');
INSERT INTO `nuke_modules` VALUES (35, 'Donate', 'Donate', 1, 0, 1, 0, '', 0, 2, '');
INSERT INTO `nuke_modules` VALUES (36, 'Resend_Email', 'Resend Email', 1, 2, 0, 0, '', 0, 1, '');
INSERT INTO `nuke_modules` VALUES (37, 'Advertising', 'Advertising', 0, 0, 1, 0, '', 0, 1, '');

Posted: Sun Aug 07, 2005 6:45 am

Well basicly whats already posted..

Code:




                $db->sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '".str_replace("_", " ", $modlist[$i])."', '0', '0', '1', '0', '1', '', '')");

And you can check if your modules table looks like this :

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',


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


  `admins` varchar(255) NOT NULL default '',


  `mcid` int(11) NOT NULL default '1',


  `url` varchar(255) default '',


  PRIMARY KEY  (`mid`),


  KEY `mid` (`mid`),


  KEY `title` (`title`),


  KEY `custom_title` (`custom_title`)


) TYPE=MyISAM AUTO_INCREMENT=113 ;

Posted: Sun Aug 07, 2005 8:02 am

well it seems as though my modules is broken I have that code already and my sql looks fine.

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',


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


  `admins` varchar(255) NOT NULL default '',


  `wysig_status` tinyint(1) NOT NULL default '0',


  `mcid` int(11) NOT NULL default '1',


  `url` varchar(255) default '',


  PRIMARY KEY  (`mid`),


  KEY `mid` (`mid`),


  KEY `title` (`title`),


  KEY `custom_title` (`custom_title`)


) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Try changing

Code:

ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

to

Code:

ENGINE=MyISAM AUTO_INCREMENT=40 ;

Posted: Sun Aug 07, 2005 8:27 am

hi raven im afraid that never worked. I exported the table then edited like the above post and dropped the current to import the edited but never made a difference.
BTW if I delete a module using ftp it will remove from it from the modules section but reupload it then it wont show I have to manually do it.

Posted: Sun Aug 07, 2005 8:41 am

Let's get back to basics. I would deinstall czm and return your site to how it was when it worked.

Posted: Sun Aug 07, 2005 8:50 am

im crawling their forums but no fix found yet allthough they say its posted a hundred times....lol
also full with un-install problems...so be aware of that also.. Sad

Posted: Sun Aug 07, 2005 8:54 am

Yeah ive put a few questions on there site about it but no replys yet. hmm shall I uninstall or just leave it to add them manually and wait for a fix. Im confused its gonna go one way or the other lol foooked or fixed. Ill leave it and see if teli gets back to me on it. good job I backed my site up.

Posted: Sun Aug 07, 2005 8:55 am

I recommend uninstalling. Have you looked at you server error log to see if it may be displaying the exact cause of your problem?

Posted: Sun Aug 07, 2005 9:03 am

I seem to have loads of these errrors

Code:

[Sun Aug  7 15:01:15 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 15:01:15 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 36


[Sun Aug  7 15:00:58 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:41:11 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:40:24 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:40:05 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:39:53 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:39:39 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:39:32 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:39:09 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:38:08 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:35:22 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 69


[Sun Aug  7 14:35:22 2005] [error] PHP Warning:  in_array(): Wrong datatype for second argument in /home/deltas00/public_html/index/includes/javascript.php on line 36

Posted: Sun Aug 07, 2005 9:07 am

well im out of time now...(having dinner)
But this particular problem in theit czm forum starts here,in the pages you can also download edited module files...
raven will assist...(i hope)
http://www.codezwiz.com/ftopic-1414-days0-orderasc-40.html

Posted: Sun Aug 07, 2005 9:13 am

Disregard those for now. Edit includes/sql_layer.php. Change

Code:

$sql_debug = 0;

to

Code:

$sql_debug = 1;

Note that this will temporarily show alot of information on your page. That's ok for now. Try to add a module so that it fails. Look for a failure error on the page. Then immediately look at the error log and see if there's an error.

Posted: Sun Aug 07, 2005 9:21 am

done that the deleted Email_list module then uploaded it but nothing still only error I got new was SQL query: select cl_adminlevel, cl_modulename from nuke_ofxclanlist_config which is a clan roster which I got on my website admin page

Posted: Sun Aug 07, 2005 9:23 am

To debug this further will require acces to your site, ftp, and MySQL. There would be a charge for that level of help. Contact me via PM if you want to go that route.