1136 - Column count doesn't match value count at row 1

[Guest]

Hi all,

 

Great contrib, but i cant seem to get it work on the shop.

 

I am getting this error everytime when i press the built product button:

 

1136 - Column count doesn't match value count at row 1

insert into products_attributes values (NULL, '930', '1', '1', '0', '+')

 

No i have checked my database and see i have 9 fields in "products_attributes", but where do i have to make changes to fix above problem? Seems "Custom product builder" misses some of the fields and can't match them with my database.??

 

Anyone any ideas?

 

Thank you in advance,

With best regards,

 

Rob Veraar

[Jan Zonjee]

I am getting this error everytime when i press the built product button:

 

1136 - Column count doesn't match value count at row 1

insert into products_attributes values (NULL, '930', '1', '1', '0', '+')

 

No i have checked my database and see i have 9 fields in "products_attributes", but where do i have to make changes to fix above problem? Seems "Custom product builder" misses some of the fields and can't match them with my database.??

If there is a support thread for this contribution than this would have been the place to search for the error and if that doesn't help post this...

 

Now you have to search for the query yourself. Most likely in the page that has the "built product" button.

 

Normally the "insert into" is followed by a list of fields like in this example taken from products_attributes.php:

		  tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . (int)$value_id . "', '" . (int)$languages[$i]['id'] . "', '" . tep_db_input($value_name) . "')");

In your code that is completely missing.