error adding stock to products

[Guest]

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...

[Nick Weisser]

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.

[Snoboreders]

Nick, at some point did you try installing the module that puts the attributes in order?

[Nick Weisser]

I don't get your question? Can you please rephrase?

 

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

[Snoboreders]

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.