innovcom Posted January 2, 2005 Posted January 2, 2005 Please help!!! I'm getting this error when trying to add a product attribute value onto an existing product. I've made changes to the db. How can I resolve this? 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '65', '2', '10', '', '+') [TEP STOP]
kagg Posted January 2, 2005 Posted January 2, 2005 replace following line in admin/products_attributes.php: tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')"); with: tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix) values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "')");
Recommended Posts
Archived
This topic is now archived and is closed to further replies.