celiae Posted July 16, 2009 Share Posted July 16, 2009 I had an issue that produced the following: 1136 - Column count doesn't match value count at row 1 insert into products_stock values (0,107,'1-2,2-19',5) Note, my configuration had QTPro and Easy Populate for QTPro. The solution I found was in this forum: http://www.oscommerce.com/forums/lofiversion/i...31484-1700.html I modified the SQL database with the following: DROP TABLE IF EXISTS products_stock; CREATE TABLE products_stock ( products_stock_id int(11) not null auto_increment, products_id int(11) default '0' not null , products_stock_attributes varchar(255) not null, products_stock_quantity int(11) default '0' not null , PRIMARY KEY (products_stock_id), UNIQUE idx_products_stock_attributes (products_id,products_stock_attributes) ); ------------------ My original table had fields for weight, st_item_code, and st_item_number that were not recreated after running the above which solve the issue. Good luck all! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.