Column count doesn't match value count at row 1

bschwarz

While running a form that previously worked fine, I recieved this error:

Why am I getting it? What could have caused this?

I checked the database, that table had an overhead of 2, 000 bytes, how does that occur? bad database structure?

I ran optimise table on it and the overhead went away.

planetsim

Okay you have more values than columns selected, maybe post some code may help y ou out but should be a simple count too see why. (A common mistake by lots)

You may want to read up from the PHPMyAdmin website about the overhead im not quite sure on what it means exactly with databases.

Sxooter

That's a query you get during an insert when then number columns named dont' match the number of columns being inserted. Like this:

insert into
table1
(col1, col2, col3)
values
('val1','val2','val3','val4');

Some databases don't handle the form:

insert into
table1
values
('val1','val2','val3','val4');

if there aren't exactly 4 columns. While the SQL spec says that ALL the columns are technically being specified when you leave out the target column list like in the above query, virtually all databases fake it and only autodefine the target list as being the first n columns where n is the number of columns you are trying to insert.

What database and version is this, and can we see the query causing the problem?

I would guess that the number of columns in the target table changed and your database is expecting an input column it isn't getting.

bschwarz

My query is:

		$query = "INSERT INTO web_user (external_mail_contact, contact_name, domain, ftp_host, username, password, name_serv, serv_name, upload_dir, start_page, cont_url, cont_user, cont_pass, mail_url, mail_serv, web_stats, Email, comments) VALUES('$_POST[external_mail_contact]', '$_POST[domain]', '$_POST[ftp_host]', '$_POST[username]', '$_POST[password]', '$name_serv', '$_POST[serv_name]', '$_POST[upload_dir]', '$_POST[start_page]', '$_POST[cont_url]', '$_POST[cont_user]', '$_POST[cont_pass]','$_POST[mail_url]', '$_POST[mail_serv]', '$_POST[web_stats]', '$Email', '$comments')";

So I missed "contact_name"
as a value!

Thanks for this, I'd never actually seen this error before!

Monday mornings are hard to get into gear, time to hit a starbucks triple shot!

edit: its a ****ing monster sorry!