Hi

I have been trying to install the tables in phpminiadmin for the nuke books module, not sure where to get an update of this mod but am using the original I think.

when I upload the sql file in the database it is coming up with this error:

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

I have taken a look at the sql tables and can not figure out which value it is that I have to change.

Please can someone who is good at sql tables and coding when they have a free few minutes to take a look.

I hope this is ok, here is a copy of the sql file. If anyone can point me in the right direction or tell me what I need to change to what I would very much appreciate it. I have tried to find the error and I cant being new to php and sql coding. I can have this up and running in no time.

Best wishes, Kated smile.gif

INSERT INTO nuke_blocks VALUES (29, '', 'Top Books', '', '', 'l', 6, 1, 0, '', '', 'block-Books-Popular.php', 0);
# --------------------------------------------------------

#
# Table structure for table `nuke_books`
#

CREATE TABLE nuke_books (
id int(11) NOT NULL auto_increment,
catid int(255) NOT NULL default '0',
name varchar(250) NOT NULL default '',
author varchar(250) NOT NULL default '',
publisher varchar(100) NOT NULL default '',
year varchar(25) NOT NULL default '',
edition varchar(25) NOT NULL default '',
isbn varchar(25) NOT NULL default '0',
url varchar(255) NOT NULL default '',
review varchar(255) NOT NULL default '',
img varchar(255) NOT NULL default '',
hits int(11) NOT NULL default '0',
bookratingsummary double(6,4) NOT NULL default '0.0000',
totalvotes int(11) NOT NULL default '0',
totalcomments int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_books`
#

INSERT INTO nuke_books VALUES (1, 1, 'Nuke-Books Rocks!', 'NyQuist', 'NyQuist@ntlworld.com', '2002', '1.2', '', 'http://people.ecsc.co.uk/~matt/', '', 'nyquist.png', 1, '10.0000', 1, 1);
# --------------------------------------------------------

#
# Table structure for table `nuke_books_categories`
#

CREATE TABLE nuke_books_categories (
cid int(11) NOT NULL auto_increment,
title varchar(50) NOT NULL default '',
cdescription text NOT NULL,
parentid int(11) NOT NULL default '0',
PRIMARY KEY (cid)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_books_categories`
#

INSERT INTO nuke_books_categories VALUES (1, 'Main Category', 'Example Main Category', 0);
INSERT INTO nuke_books_categories VALUES (2, 'Sub Category', 'Example Sub-Category', 1);
# --------------------------------------------------------

#
# Table structure for table `nuke_books_votedata`
#

CREATE TABLE nuke_books_votedata (
ratingdbid int(11) NOT NULL auto_increment,
ratingid int(11) NOT NULL default '0',
ratinguser varchar(60) NOT NULL default '',
rating int(11) NOT NULL default '0',
ratinghostname varchar(60) NOT NULL default '',
ratingcomments text NOT NULL,
ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ratingdbid)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_books_votedata`
#

INSERT INTO nuke_books_votedata VALUES (1, 1, 'nyquist', 10, 'localhost', 'Great Book Module!', '2002-05-12 19:51:28');