Column count doesn't match value count at row 1

Client Joined: Dec 04, 2004 Posts: 757

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

Posted: Wed Feb 13, 2008 7:53 am

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?

Posted: Wed Feb 13, 2008 11:25 am

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.

cheers
mrix

Posted: Wed Feb 13, 2008 12:55 pm

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.

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

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.

Posted: Wed Feb 13, 2008 8:22 pm

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.