Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate errors when importing


Recommended Posts

My Easy Populate used to work, not sure what changed. I've added a new field, but that was working as well. Well, maybe not. Only when EP imports a new product I get an error message and my database goes corrupt. When its an update it works perfectly.

 

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

 

INSERT INTO products ( products_unitms, 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 ( 'storepics/1212.jpg', '1212', '3.9', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '', '', '1', 'Per Pkg/50' '10')

 

All i notice is a little space right here "products ( products_unitms".... If you cound the columns and values, they're both equal to 12. I don't get it. I'm importing a file that has worked before so I know this is supposed to work.

Link to comment
Share on other sites

  • 2 weeks later...

Can anyone help me with loading my products?

I am getting the following error message using EP:

 

Warning: move_uploaded_file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file(): Unable to move '/tmp/phpAzqyHJ' to '/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt' in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

 

File uploaded.

Temporary filename: /tmp/phpAzqyHJ

User filename: megagoods1.txt

Size: 248372

 

Warning: file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689

Link to comment
Share on other sites

read the last few pages of the ep support thread, mainly on the document_root

 

Can anyone help me with loading my products?

I am getting the following error message using EP:

 

Warning: move_uploaded_file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

 

Warning: move_uploaded_file(): Unable to move '/tmp/phpAzqyHJ' to '/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt' in /home/allaudio/public_html/catalog/admin/easypopulate_functions.php on line 32

File uploaded.

Temporary filename: /tmp/phpAzqyHJ

User filename: megagoods1.txt

Size: 248372

 

Warning: file(/home/allaudio/public_html/catalog//catalog/temp/megagoods1.txt): failed to open stream: No such file or directory in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 666

 

Warning: Invalid argument supplied for foreach() in /home/allaudio/public_html/catalog/admin/easypopulate.php on line 689

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