I think I've been staring at this to long and need some fresh eyes.
Error: Column count doesn't match value count at row 1
SQL:
"(NULL
, Now()
, '$model'
, '$channel'
, '$presence'
, '$master'
, '$gain'
, '$bass'
, '$mid'
, '$treble'
, '$solo'
, '$output'
, '$power'
, '$rectifier'
, '$bias'
, '$ch1switch'
, '$ch23switch'
, '$reverb'
, '$trem'
, '$speakers'
, '$cab'
, '$sound'
, '$name'
, '$email'
, '$comments'
, '$soundfile_link'
, '$grailtone'
)";
And Table Create:
CREATE TABLE recto_settings (
num int(11) NOT NULL auto_increment,
Created datetime NOT NULL default '0000-00-00 00:00:00',
model text not null,
channel text,
presence text,
master text,
gain text,
bass text,
mid text,
treble text,
solo text,
output text,
power text,
rectifier text,
bias text,
ch1switch text,
ch23switch text,
reverb text,
trem text,
speakers text,
cab text,
sound text,
name text,
email text,
comments text,
soundfile_link text,
grailtone text,
PRIMARY KEY (num)
);
Here is the insert:
INSERT INTO recto_settings VALUES (NULL , Now() , 'Dual Rectifier 2 Channel Solo Head' , 'Vintage Orange' , '11 OClock' , '12 OClock' , '11 OClock' , '1 OClock' , '7 OClock' , '12 OClock' , ' ' , ' ' , 'Spongy' , 'Tube' , '6L6' , ' ' , ' ' , ' ' , ' ' , '16 ohms' , 'Mesa Rectifier 4x12' , 'Clean' , 'Factory Setting' , 'test' , 'Clean setting from Dual/Triple Rectifier 2 channel manual.' , 'test' , 'e038b3fd555edcbc7f4c2761a9c72e47' )
Thanks.
Ned
