Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
mrix
Client


Joined: Dec 04, 2004
Posts: 757

PostPosted: Wed Feb 13, 2008 7:07 am Reply with quote

Hello all, I have a custom main menu block and with the upgrade at the top of this block I get this error repeated 4 times..

Column count doesn't match value count at row 1

any idea`s where to start looking
I only see this error when logged in as admin, which is not too bad but its nice getting everythign just right etc Very Happy

thanks for any help
mrix
 
View user's profile Send private message Visit poster's website
montego
Site Admin


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

PostPosted: Wed Feb 13, 2008 7:53 am Reply with quote

What did you upgrade FROM? Maybe post the code from that custom block or provide us a text link so that we can see it?

_________________
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
mrix
PostPosted: Wed Feb 13, 2008 11:25 am Reply with quote

Hello I always keep my ravennuke completely up to date and updated from the last version Wink
this is the block code here Only registered users can see links on this board! Get registered or login!

and this is my error thats i made into an image.

Image


cheers
mrix
 
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Wed Feb 13, 2008 12:55 pm Reply with quote

This program seems to be accessing a table called "main". I am not aware of any such table in Ravennuke. Is it possible that this table got wiped out during your upgrade?

The program is also not using the standard methods of accessing mysql thru mysql.php in the /db directory. That's not fatal and still should work since mainfile.php sets $dbi using sql_connect but you might want to put some echoes in. I'd be particularly suspicious of the statement:

Code:
$result = sql_query("select main_module from ".$prefix."_main", $dbi);


until you can confirm that it's returning something. You might try something like:

if (!result) {
echo 'read of main table failed <br>';
}

just to see what's going on.

We do database logging in 2.20 but it's in mysql.php and you aren't using that in this case.
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Wed Feb 13, 2008 12:56 pm Reply with quote

You will need to compare the table schema's between what you presently have in your table and what the RN upgrade script sql code is expecting.
 
View user's profile Send private message
montego
PostPosted: Wed Feb 13, 2008 8:22 pm Reply with quote

Here is the odd thing, we have not made any changes to nuke_main ever. I don't think that is it. You are definitely going to have to narrow down as to which section of code it is. You may need to put in some additional echo statements to find that out.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All 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 ©