Guest Posted April 16, 2003 Share Posted April 16, 2003 I've installed EasyPopulate 2.53 and downloaded from the "Download Complete tab-delimited .txt file to edit" link. When I tried to re-insert the same file with EasyPopulate, I received the following error. I added a field, products_op_id, into the Products table and I believe changed EZP's files correctly. Does anyone have any ideas? 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_image, #products_mimage, #products_bimage, #products_subimage1, #products_bsubimage1, #products_subimage2, #products_bsubimage2, #products_subimage3, #products_bsubimage3, products_model, products_op_id, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '', 'aaaaaaaa', '999', '1', CURRENT_TIMESTAMP, "2003-04-12 18:14:31", CURRENT_TIMESTAMP, '', '0.00', '0', '10') Quote Link to comment Share on other sites More sharing options...
loxly Posted April 16, 2003 Share Posted April 16, 2003 The column you added doesn't appear in your list from the error, so you might ned to check on how you added it to EP and make sure you put it in the correct places. I believe there are 3 places you need to insert the new field. Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
Guest Posted April 16, 2003 Share Posted April 16, 2003 Thanks, I think I put it in 4 places. I double check. 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.
Note: Your post will require moderator approval before it will be visible.