Story Data Import Problem

Hangin' Around Joined: Jul 20, 2006 Posts: 41

Hi folks, having some trouble with RavenNuke76. I've corrected the structure of the 'nuke_stories' table 'cos I'd imported the old one and was unable to post new stories, but now I can't import the data that I exported from the old database. I get this error when I try:

Code:

Error


INSERT INTO `nuke_stories`


VALUES ( 3, 0, 'synaptyx', 'Docs', '2005-07-21 15:56:24', 'story_was_here', '', 0, 77, 0, 'synaptyx', '', 0, 'english', 0, 0, 0, 0, 0, '0', '' ) ;





MySQL said: Documentation


#1136 - Column count doesn't match value count at row 1

Help!?

I know nothing of MySql, I'm just playing with PHPMyAdmin. Blundering around in the dark trying to do this on my own is going to kill the database. Sad

Thanks for reading.

Sells PC To Pay For Divorce Joined: Posts: 5661

well make sure the table you wanna put it in is empty..
if no changes...the you probably have a field to many or to less..
i count 21 ,and standard nuke has 20..
so theres 1 to many....

Posted: Tue Aug 15, 2006 3:36 pm

O, I'm with you as far as the empty table, then I fall over. Very Happy

Posted: Tue Aug 15, 2006 3:37 pm

and that means ?

Posted: Tue Aug 15, 2006 3:58 pm

um, how do I make it fit?

Posted: Tue Aug 15, 2006 4:00 pm

send you a pm..

Posted: Tue Aug 15, 2006 4:02 pm

ok, thanks.

Posted: Wed Aug 16, 2006 6:25 am

Actually, I've figured it out myself. Thanks for the hint.