Knowledgebase: General
Can't Add Product Attributes in CRE Loaded categories.php page After Installing QBI
Posted by Adam Liberman on 07 August 2008 01:04 AM
Problem:
The following error message appears when trying to add a Product Attribute in CRE Loaded after installing QBI:

1136 - Column count doesn't match value count at row 1
insert into products_attributes values ('', '78', '15', '77', '0', '+','1')
[TEP STOP]


Cause:
The code in CRE doesn't allow for the extra table columns added by QBI.

Solution:
In the osC file: /catalog/admin/categories.php
Line: 560 (approximate, may be different in your version)
Change:

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $products_id . "', '" . $options['products_options_id'] . "', '" . $values['products_options_values_id'] . "', '" . $_POST['price'][$rows] . "', '" . $_POST['prefix'][$rows] . "', '" . $_POST['products_options_sort_order'][$rows] . "')");

to:

tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id='" . $products_id . "', options_id='" . $options['products_options_id'] . "', options_values_id='" . $values['products_options_values_id'] . "', options_values_price='" . $_POST['price'][$rows] . "', price_prefix='" . $_POST['prefix'][$rows] . "', products_options_sort_order='" . $_POST['products_options_sort_order'][$rows] . "'");
(247 vote(s))
Helpful
Not helpful