Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2011-09-08
2
182 Views
Last Modified: 2012-05-12
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'
)");
- - - - - - - - - - - - - - -
0
Comment
Question by:msvarts
2 Comments
 
LVL 9

Accepted Solution

by:
sshah254 earned 500 total points
ID: 36508138
l_bg_img,

Try after removing the ",".

SS
0
 

Author Comment

by:msvarts
ID: 36508235
Guru? You are a genius!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Email called spam 5 36
How does PHP Storm display on Linux high resolution laptops? 1 36
PHP Mail error 3 26
JQuery Search Filter 2 29
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question