Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding product attributes and having an error.


onedownfiveup

Recommended Posts

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

 

insert into products_attributes values (null, '102', '2', '2', '0', '+')

 

[TEP STOP]

 

No one see this error before?

 

I have already added a bunch of attributes before I was just doing some updating.

Link to comment
Share on other sites

  • 2 weeks later...
anyone?

 

I just received that error after installing the Quantity for Product Attributes Mod contribution found here: http://addons.oscommerce.com/info/3302

 

The error that you are receiving means (at least I think so..) that you are trying to insert a number of values that doesn't match the number of fields in the database table. What you want to do is look at the products_attributes table in the database and see how many fields there are are. I'm guessing that it doesn't match the number of values that you were trying to insert (the values are separated by commas in the error message).

 

My problem was that I was trying to insert 7 values into the products_attributes table, but there were only 6 fields in the table. I realized that when installing the Quantity for Product Attributes Mod contribution, I forgot to run the SQL query which adds another field to the table.

 

Hope this helps,

 

Brian

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...