Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate 2.53 1136 - Column count error


Guest

Recommended Posts

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')

Link to comment
Share on other sites

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.

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...