Column count doesn't match value count at row 1

[Mumex]

Hello

So I tried to download this new catalogue release and did like usual.. So I got to running SQL and I started with my furniture and it just says this:

#1136 - Column count doesn't match value count at row 1
And I dont know really what to do..
I also dont know if I have done something really stupid.. Something in the catalogue I downloaded was already in my catalogue and I just overwrited it in Filezilla, because it was the same thing.. But then I started thinking.. Does it means anything?

Thank you!

 

[Ultra]

It means that you have more or less columns than values or vice versa in the SQL.

For example:

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(757369052, '310', '757369052', 'wildwest_spittoon2', '5', '0', '0', '1');

That would work because there are 8 columns and 8 values in the SQL code.

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(757369052, '310', '757369052', 'wildwest_spittoon2', '5', '0', '0', '1', '0');

However, that won't work because there are 8 columns and 9 values.

If the amount of columns and values don't match, it won't be able to enter your SQL.