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] . "'"); | |
|