ERROR Message displayed while in admin

Client Joined: Dec 04, 2004 Posts: 757

Hello all, I upgraded my site from the latest 7.6 version and everything went fairly well apart from when I sign into admin panel in phpnuke I get some errors appear in the top left block like this

Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1
Column count doesn't match value count at row 1

This is what it repeats over and over in the side panel?
any idea`s where I would start to fix it ?
my m8 had just done the same thing with his site and he got the same thing happen so I am hoping that some others have had the same thing and know the fix etc?????

thanks for any help all
mrix

registered · Posted: Wed Apr 04, 2007 7:50 pm

Couple of questions:

1) What is the block that is showing this issue?

2) Are you seeing issues with the rest of your site, or is it just this one block?

3) Do you have Apache/PHP errors turned on and something other than E_ALL^E_NOTICE within rnconfig.php?

registered · Posted: Thu Apr 05, 2007 7:58 am

Try to isolate which block is causing that error by turning blocks on and off and then once we identify the culprit we can help you decide what needs to be fixed.

It may also be theme related somehow. Do you and your m8 use the same theme?

Posted: Fri Apr 06, 2007 1:39 am

Hello all, the errors I have found seem to be coming from my custom main menu and the offending code seems to in this somewhere?

if (is_admin($admin)) {
$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 = sql_query("select mid from ".$prefix."_modules where title='$modlist[$i]'", $dbi);
list ($mid) = sql_fetch_row($result, $dbi);
if ($mid == "") {
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '0')", $dbi);
}
}
}
//$content .= "<OPTION VALUE=\"\">"._FORADMINTESTS."\n";
$content .= "<OPTION VALUE=\"\">---------------\n";
$result = sql_query("select title, custom_title from ".$prefix."_modules where active='0' ORDER BY title ASC", $dbi);
while(list($mn_title, $custom_title) = sql_fetch_row($result, $dbi)) {
$mn_title2 = ereg_replace("_", " ", $mn_title);
if ($custom_title != "") {
$mn_title2 = $custom_title;
}
if ($mn_title2 != "") {
$content .= "<OPTION VALUE=\"modules.php?name=$mn_title\">$mn_title2\n";
$dummy = 1;
} else {
$a = 1;
}
}
if ($a = 1 AND $dummy != 1) {
$content .= "<OPTION VALUE=\"\">"._NONE."\n";
}
}

I would have liked to post all the block code but the raven site classes me as a hacker so this is all I could post.

thanks for your help
mrix

Posted: Fri Apr 06, 2007 11:22 am

Please post the table structure of nuke_modules.

Posted: Fri Apr 06, 2007 11:36 am

Hello here it it

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 06, 2007 at 01:30 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `mrix_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 '',
`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=119 ;

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

INSERT INTO `nuke_modules` VALUES (2, 'Content', 'Content', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (7, 'Forums', 'Sea Fishing Forums', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (8, 'Journal', 'Journal', 1, 2, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (9, 'Members_List', 'Members List', 1, 1, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (11, 'Private_Messages', 'Private Messages', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (12, 'Recommend_Us', 'Recommend Us', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (13, 'Reviews', 'Tackle Reviews', 1, 1, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (14, 'Search', 'Search', 0, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (17, 'Submit_News', 'Submit News', 1, 1, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (18, 'Surveys', 'Surveys', 0, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (20, 'Topics', 'Topics', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (21, 'Web_Links', 'Web Partners', 1, 0, 0, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (22, 'Your_Account', 'Your_Account', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (23, 'Fish_Pictures', 'Sea Fish Pictures', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (24, 'Fishing-uni-knot', 'Uni knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (25, 'Fishing_Knots', 'Sea Fishing Knots', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (26, 'Sea_Baits', 'Sea Fishing Baits', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (28, 'fishing-albright-knot', 'albright Knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (29, 'fishing-blood-knot', 'Blood Knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (31, 'fishing-centauri-knot', 'Centauri knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (33, 'fishing-droploop-knot', 'Droploop knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (34, 'fishing-grinner-knot', 'Grinner knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (36, 'fishing-palomar-knot', 'Palomar knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (39, 'fishing-tackle-manufacturers', 'Manufacturers', 1, 0, 1, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (40, 'fishing-thumb-knot', 'Thumb Knot', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (41, 'fishing-tides-uk', 'UK Tides', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (42, 'fishing-webrings-webring', 'Fishing Webrings', 1, 0, 1, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (43, 'nfsa-size-limits', 'NFSA Size Limits', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (44, 'rigs1', 'rigs1', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (45, 'rigs2', 'rigs2', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (46, 'rigs3', 'rigs3', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (47, 'sea-bass', 'Bass', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (48, 'sea-blackbream', 'Black Bream', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (49, 'sea-dab', 'Dab', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (50, 'sea-dogfish', 'Dogfish', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (51, 'sea-fishing-books', 'Sea Fishing Books', 1, 0, 1, 0, '', 3, '');
INSERT INTO `nuke_modules` VALUES (52, 'sea-fishing-videos', 'Sea Fishing Videos', 1, 0, 1, 0, '', 3, '');
INSERT INTO `nuke_modules` VALUES (53, 'sea-flounder', 'Flounder', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (54, 'sea-garfish', 'Garfish', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (55, 'sea-gurnard', 'Gurnard', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (56, 'sea-mackerel', 'Mackerel', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (57, 'sea-plaice', 'Plaice', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (58, 'sea-pollack', 'Pollack', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (59, 'sea-pout', 'Pout', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (60, 'sea-rockling', 'Rockling', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (61, 'sea-scad', 'Scad', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (62, 'sea-smoothhound', 'Smoothhound', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (63, 'sea-sole', 'Sole', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (64, 'sea-whiting', 'Whiting', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (65, 'weather-uk', 'UK Weather', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (68, 'sea-fishing-reels', 'Sea Fishing Reels', 1, 0, 1, 0, '', 3, '');
INSERT INTO `nuke_modules` VALUES (70, 'Blocked_IPs', 'Blocked IPs', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (71, 'Blocked_Ranges', 'Blocked Ranges', 1, 2, 0, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (79, 'Banner_Links', 'UK Banner Links', 1, 0, 1, 0, '1', 4, '');
INSERT INTO `nuke_modules` VALUES (81, 'UserInfoAddons', 'UserInfoAddons', 0, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (82, 'fishing-Half-knot2', 'Half Blood knot2', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (83, 'fishing-blood-night', 'Blood Night Knot', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (84, 'fishing-half-blood', 'Half Blood Knot', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (85, 'fishing-plastic-leader', 'Plastic Leader Knot', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (86, 'fishing-spider-knot', 'Spider Knot', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (87, 'fishing-swivel-knot', 'Swivel Knot', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (92, 'FAQ', 'FAQ', 0, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (93, 'Feedback', 'Feedback', 0, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (94, 'PHP-Nuke_Tools', 'PHP-Nuke Tools', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (95, 'Statistics', 'Statistics', 0, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (98, 'sea-fishing-rods', 'sea-fishing-rods', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (99, 'sea-combos', 'sea-combos', 1, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (101, 'rigs-traces', 'rigs-traces', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (105, 'Email_List', 'Email_List', 1, 2, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (109, 'Flash_Games', 'Flash Games', 0, 1, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (108, 'world-fishing-banner-links', 'Reciprocal Links', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (110, 'MyHeadlines', 'MyHeadlines', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (111, 'mod_topsite', 'mod_topsite', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (10, 'News', 'News', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (1, 'AvantGo', 'AvantGo', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (112, 'sea-fishing-lines', 'Sea Fishing Lines', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (113, 'fishing-floatation-suits', 'Floatation suits', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (115, 'MS_Analysis', 'MS_Analysis', 1, 0, 0, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (116, 'Donate', 'Donate', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (117, 'Meta', 'Meta Tags', 1, 2, 1, 0, '1', 1, '');
INSERT INTO `nuke_modules` VALUES (118, 'gallery', 'gallery', 0, 0, 1, 0, '', 1, '');

thanks for your time
mrix

Posted: Fri Apr 06, 2007 2:41 pm

Do This:

Find:

if ($mid == "") {
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '0')", $dbi);
}

***********************

Replace with:

if ($mid == "") {
sql_query("INSERT INTO ".$prefix."_modules VALUES (NULL, '$modlist[$i]', '$mod_uname', '0', '0', '', '1', '0')");
}

That should make your error disapear.

**edited for a code mishap that makes no sense, sql_query should be $db->sql_query but because I dont know all the info on this site, Ill go with what appears to be working in other sections of the code.

Posted: Fri Apr 06, 2007 3:13 pm

Hello I changed the code but unfortunately everything under the top google links showed a blank black page Question

thanks for trying though
mrix

Posted: Fri Apr 06, 2007 3:38 pm

that shouldnt happen at all. I'm farely certain this should resolve your issue, but when you save a php file, you must make sure there are no white spaces after the ?> or before the <?php

This is very important, but I seriously believe I've given you the right fix.

Posted: Fri Apr 06, 2007 4:05 pm

I have checked and cant see anything Crying or Very sad

Cheers
mrix

Sells PC To Pay For Divorce Joined: Posts: 5661

mm,not solved yet ?

Posted: Fri Apr 06, 2007 5:40 pm

no

cheers
mrix

Posted: Fri Apr 06, 2007 5:45 pm

question....you said...

Quote:

I upgraded my site from the latest 7.6 version

what you mean by ...latest 7.6 ?
a non ravennuke ? to ravennuke ?

Posted: Fri Apr 06, 2007 5:47 pm

Yes it was the very latest patch 7.6 non raven nuke which was then upgraded to the latest ravennuke
cheers
mrix

Posted: Fri Apr 06, 2007 5:49 pm

lemme guess....
your friend uses the same custom block ?

Posted: Fri Apr 06, 2007 5:52 pm

Yep you guessed it Embarassed

the thing is I have used it on my site for 5 years with a fair few versions of pnpnuke and its worked fine ..... it also looks good in my theme and it would be a shame to have to get shot of it etc. mind you I am only getting this error while in admin so maybe I can live with it
cheers
mrix

Posted: Fri Apr 06, 2007 5:54 pm

which menu is it ?

Posted: Fri Apr 06, 2007 5:56 pm

This is the info in the file

/************************************************************************/
/* DALME block-Modules */
/* =========================== */
/* */
/* Copyright (c) 2002 by Avery Hise avery@dalme.com */
/* http://www.dalme.com */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/* */
/* DALME block-Modules v1.6a provided by http://www.dalme.com */
/* Updated and cleaned up 01-02-2004 Telli telli -at- Codezwiz.com */
/************************************************************************/
cheers
mrix
I am using it on my site here www.sea-fishing.org its the main menu block

Posted: Fri Apr 06, 2007 6:00 pm

well you could drop me a login to have a look.
but like you said...its in admin only...so it doesnt bother you that much..
however....its possible that some parts of the block dont work anymore...
what you could do is try a few functions.
if it comes with adding a link ,or editing whatever......try that.
see if that still works.

Posted: Fri Apr 06, 2007 6:54 pm

My m8 decided to do a fresh install and his menu like mine works now I guest it must be a database glitch somewhere?
Cheers
mrix

Posted: Fri Apr 06, 2007 6:57 pm

Quote:

database glitch

?
Lol...great huh these late night miracles....

Posted: Fri Apr 06, 2007 7:01 pm

I am going to live with my error though as I dont want to go through what I have to get this far Embarassed

cheers
mrix

Posted: Sat Apr 07, 2007 10:10 pm

sorry, I have been setting up a few servers in the last few days.

mrix, If you can zip the block file to me, as is, and Ill test it on a local server and then I'll correct the problem and send it back to you.

Thanks, and this is only if hitwalker cant resolve the issue.

Posted: Sun Apr 08, 2007 2:11 am

Hello many thanks for the offer but somehow I have fixed it Very Happy

more by accident I think Laughing

I cant really explain how but it was appearing because of some kind of module conflict I noticed that a fair few of my modules were not in the database modules part so I deleted them of my server and the error went Question

I replaced them and the error doesnt show anymore it was something like that anyway I was messing around a fair bit trying this and that I cant fully remember Embarassed

thanks anyway
mrix

Posted: Sun Apr 08, 2007 3:05 am

ahh that explains it, btw, the problem with my edit, I corrected it, it may have been what was causing the error, but other then that, the block will insert a module if its not listed. My error was how the sql_query was handled, my apologies, but none the less, I really dont think this is the last time you will see that error.