Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

db error???


innovcom

Recommended Posts

Posted

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]

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...