Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate - Column count doesn't match value count at row 1


bmw000

Recommended Posts

I am getting this error message when trying to import a file with easy populate.

 

I seached the forum and found this same error message, but the fix didn't seem to work for me. Probably because it was for another contribution.

 

Any ideas?

 

Easy Populate 2.76d-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: /tmp/phpJd2MX3

User filename: qryJEWELRY01.txt

Size: 101607

| 416769 | 29-173-548 | SL2020 Con | Controls 1 | 38.75 | 1.00 | 1 | Famous Tra | Jewelry | Watches | Famous Tra | --none-- | Active !New Product!

1136 - Column count doesn't match value count at row 1

 

INSERT INTO products ( products_ship_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '29-173-548-416769.jpg', '416769', '38.75', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '--none--', '1.00', '1', '' '10')

 

[TEP STOP]

Link to comment
Share on other sites

I found out what was causing this error. It seems I was using and old version of the instructions for adding a new field to easy populate. I got that error fixed, but now I get a new error.

 

Easy Populate 2.76d-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: /tmp/phppyWATW

User filename: qryJEWELRY01.txt

Size: 102804

| 416769a | 29-173-548 | SL2020 Con | Controls 1 | 38.75 | 1.00 | 2007-04-22 | 1 | Famous Tra | Jewelry | Watches | Famous Tra | --none-- | Active | 0 !New Product!

1048 - Column 'products_date_added' cannot be null

 

INSERT INTO products ( products_ship_price, products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '29-173-548-416769.jpg', '416769a', '38.75', '1', CURRENT_TIMESTAMP, "2007-04-22", NULL, '', '1.00', '1', '0', '10')

 

[TEP STOP]

 

Anyone have any ideas?

Edited by bmw000
Link to comment
Share on other sites

  • 4 years later...

In my programming I have to remove the quotes surrounding CURRENT_TIMESTAMP to get things to work properly. Maybe you need to do the reverse. It's a SQL version issue I think.

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.

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...