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 -> RN Themes Issues
Author Message
mrix
Client



Joined: Dec 04, 2004
Posts: 757

PostPosted: Wed Apr 04, 2007 10:46 am Reply with quote

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



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

PostPosted: Wed Apr 04, 2007 7:50 pm Reply with quote

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?

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
Gremmie
Former Moderator in Good Standing



Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Thu Apr 05, 2007 7:58 am Reply with quote

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?

_________________
GCalendar - An Event Calendar for PHP-Nuke
Member_Map - A Google Maps Nuke Module 
View user's profile Send private message
mrix







PostPosted: Fri Apr 06, 2007 1:39 am Reply with quote

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
 
gregexp
The Mouse Is Extension Of Arm



Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Fri Apr 06, 2007 11:22 am Reply with quote

Please post the table structure of nuke_modules.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
mrix







PostPosted: Fri Apr 06, 2007 11:36 am Reply with quote

Hello here it it

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- [ Only registered users can see links on this board! Get registered or login! ]
--
-- 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
 
gregexp







PostPosted: Fri Apr 06, 2007 2:41 pm Reply with quote

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.


Last edited by gregexp on Sun Apr 08, 2007 3:01 am; edited 1 time in total 
mrix







PostPosted: Fri Apr 06, 2007 3:13 pm Reply with quote

Hello I changed the code but unfortunately everything under the top google links showed a blank black page Question Crying or Very sad
thanks for trying though
mrix
 
gregexp







PostPosted: Fri Apr 06, 2007 3:38 pm Reply with quote

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







PostPosted: Fri Apr 06, 2007 4:05 pm Reply with quote

I have checked and cant see anything Crying or Very sad
Cheers
mrix
 
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661

PostPosted: Fri Apr 06, 2007 5:40 pm Reply with quote

mm,not solved yet ?
 
View user's profile Send private message
mrix







PostPosted: Fri Apr 06, 2007 5:40 pm Reply with quote

no Sad
cheers
mrix
 
hitwalker







PostPosted: Fri Apr 06, 2007 5:45 pm Reply with quote

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 ?
 
mrix







PostPosted: Fri Apr 06, 2007 5:47 pm Reply with quote

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







PostPosted: Fri Apr 06, 2007 5:49 pm Reply with quote

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







PostPosted: Fri Apr 06, 2007 5:52 pm Reply with quote

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
 
hitwalker







PostPosted: Fri Apr 06, 2007 5:54 pm Reply with quote

which menu is it ?
 
mrix







PostPosted: Fri Apr 06, 2007 5:56 pm Reply with quote

This is the info in the file

/************************************************************************/
/* DALME block-Modules */
/* =========================== */
/* */
/* Copyright (c) 2002 by Avery Hise [ 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! ] */
/* */
/* 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 [ Only registered users can see links on this board! Get registered or login! ] */
/* Updated and cleaned up 01-02-2004 Telli telli -at- Codezwiz.com */
/************************************************************************/
cheers
mrix
I am using it on my site here [ Only registered users can see links on this board! Get registered or login! ] its the main menu block
 
hitwalker







PostPosted: Fri Apr 06, 2007 6:00 pm Reply with quote

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







PostPosted: Fri Apr 06, 2007 6:54 pm Reply with quote

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
 
hitwalker







PostPosted: Fri Apr 06, 2007 6:57 pm Reply with quote

Quote:
database glitch
?
Lol...great huh these late night miracles....
 
mrix







PostPosted: Fri Apr 06, 2007 7:01 pm Reply with quote

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
 
gregexp







PostPosted: Sat Apr 07, 2007 10:10 pm Reply with quote

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







PostPosted: Sun Apr 08, 2007 2:11 am Reply with quote

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
 
gregexp







PostPosted: Sun Apr 08, 2007 3:05 am Reply with quote

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.
 
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 -> RN Themes Issues

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 ©