webboy 0 Posted December 8, 2007 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
Nick Weisser 0 Posted December 9, 2007 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
Snoboreders 0 Posted December 9, 2007 Nick, at some point did you try installing the module that puts the attributes in order? Share this post Link to post Share on other sites
Nick Weisser 0 Posted December 9, 2007 I don't get your question? Can you please rephrase? ...or maybe you meant to ask webboy and not me. Share this post Link to post Share on other sites
Snoboreders 0 Posted December 9, 2007 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