Column count doesn't match...

JackJack

I've searched for an answer and still haven't solved the problem.

I have a part of my database I'm trying to upload. But I get this message.

Column count doesn't match value count at row 1

I highly doubt I can post the actual query I'm putting in because it's extremely long. How do I fix this?

devinemke

your RDBMS is telling you that your query syntax does not match your data structure. you are specicify either to many or too few columns. however if you refuse to post the query it is obviously impossible to spot the exact error.

JackJack

I can't post it, so I'll host the file on my site and you can follow this link to it:

www.ageoftheadepts.com/data_1a.sql

JackJack

Anyone? Please?

Kudose

1: Double check that table "ats_etc" has 4 columns.

2: Double check that your inserts match the column type.

3: Change your query to reflect the column names as well as the values inserted into them.

4: Change your query to an UPDATE instead of REPLACE INTO

5: Restructure your table to match the inserts exactly.

6: Come back to this thread if those steps don't fix your problem.

JackJack

I did #'s 1 and 4, still no use. What do you mean by 2, 3, and 5?

Kudose

2: Make sure that your column types (INT, VARCHAR, etc...) match what your trying to insert.

3: Change REPLACE INTO table VALUES ('$stuff');

-TO-

REPLACE INTO table (stuff) VALUES ('$stuff');

5: Change REPLACE INTO to UPDATE.

i.e.

UPDATE table SET value='$value';

-instead of-

REPLACE INTO table VALUES ('$stuff');

JackJack

is there any way to do those without it taking forever? As you can see, the query is really long...

Kudose

It depends.

There are two really fast ways of doing it.

If you have a nix computer or shell access to a nix computer, then you can use vi to edit the lines in less than 30 seconds.

If you dont, you can write a script to do it all for you in a few minutes with a few [man]str_replace[/man]'s.