Jump to content
Sign in to follow this  
webboy

error adding stock to products

Recommended Posts

This is the error:

 

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

 

insert into products_stock values (0,83,'1-1',5)

 

[TEP STOP]

 

Can anyone help with this?

 

Im trying to add stock to the sizes of a specific product.

Also i cant seem to delete products either...

Share this post


Link to post
Share on other sites

You seem to be using a contribution without naming it, because products_stock is not a default database table. The error message is very specific. The query tries to insert 4 values into the table, but it seems to have more than 4 fields. Try to modify your query like so:

insert into products_stock (id, field1, field2, field3) values (0,83,'1-1',5);

where id and field1, etc are just placeholders for your real table field names.

Share this post


Link to post
Share on other sites
I don't get your question? Can you please rephrase?

 

...or maybe you meant to ask webboy and not me.

 

 

Whoops, yes, I did mean to ask webboy.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×