Setup.php not sets up tables but fails to enter default data?

I have a setup file that sets up tables, but when I use the code below to try to enter the default data, I get an error:

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

- - - - - - - - - - - - - - -
mysql_query("INSERT INTO themes (
title,
layout,
m_color_show,
m_color,
m_img,
s_color_show,
s_color,
s_img,
s_img_repeat,
p_color_show,
p_color,
p_img,
p_img_repeat,
f_color_show,
f_color,
f_fontcolor,
f_img,
h_color,
h_face,
h_size,
b_color,
b_face,
b_size,
l_color_show,
l_off,
l_over,
l_bg_off,
l_bg_over,
l_bg_option,
l_bg_img,
)
VALUES (
'ZenBinder Default',
'1',
'no',
'#000000',
'mast_lwc_digitalmedia.gif',
'yes',
'#ECECEC',
'hacker_bg_page.jpg',
'repeat-x',
'no',
'#ECECEC',
'hacker_bg_page_50.png',
'repeat-y',
'no',
'#855B25',
'#000000',
'hacker_bg_footer_50.png',
'#2F2A30',
'Helvetica, Arial, sans-serif',
'18pt',
'#782F14',
'Tahoma, serifSansSerifMonospace',
'10pt',
'yes',
'#000000',
'#FFFFFF',
'#D9D9D9',
'#57534F',
'no',
'none'
)");
- - - - - - - - - - - - - - -
msvartsAsked:
Who is Participating?
 
sshah254Connect With a Mentor Commented:
l_bg_img,

Try after removing the ",".

SS
0
 
msvartsAuthor Commented:
Guru? You are a genius!
0
All Courses

From novice to tech pro — start learning today.