Guest Posted December 8, 2007 Share 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... Quote Link to comment Share on other sites More sharing options...
Nick Weisser Posted December 9, 2007 Share 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. Quote Link to comment Share on other sites More sharing options...
Snoboreders Posted December 9, 2007 Share Posted December 9, 2007 Nick, at some point did you try installing the module that puts the attributes in order? Quote Link to comment Share on other sites More sharing options...
Nick Weisser Posted December 9, 2007 Share Posted December 9, 2007 I don't get your question? Can you please rephrase? ...or maybe you meant to ask webboy and not me. Quote Link to comment Share on other sites More sharing options...
Snoboreders Posted December 9, 2007 Share 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.