Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error when uploading EasyPopulate file


xiu

Recommended Posts

I got this when uploading EP file:

 

File uploaded. 
Temporary filename: /tmp/phpDiLcbn
User filename: EP2005Nov06-1604.txt
Size: 3394
1054 - Unknown column 'p.products_image_med' in 'field list'

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_image_med as v_products_image_med, p.products_image_lrg as v_products_image_lrg, p.products_image_sm_1 as v_products_image_sm_1, p.products_image_xl_1 as v_products_image_xl_1, p.products_image_sm_2 as v_products_image_sm_2, p.products_image_xl_2 as v_products_image_xl_2, p.products_image_sm_3 as v_products_image_sm_3, p.products_image_xl_3 as v_products_image_xl_3, p.products_image_sm_4 as v_products_image_sm_4, p.products_image_xl_4 as v_products_image_xl_4, p.products_image_sm_5 as v_products_image_sm_5, p.products_image_xl_5 as v_products_image_xl_5, p.products_image_sm_6 as v_products_image_sm_6, p.products_image_xl_6 as v_products_image_xl_6, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'ck001' AND ptoc.categories_id = subc.categories_id 

[TEP STOP]

 

Is it UltraPics additional code? I think I don't need that fields. What should I do?

Really desperate about it since I have to online my store soon.

 

Thanks in advance,

Xiu

Link to comment
Share on other sites

  • 3 months later...
I got this when uploading EP file:

 

File uploaded. 
Temporary filename: /tmp/phpDiLcbn
User filename: EP2005Nov06-1604.txt
Size: 3394
1054 - Unknown column 'p.products_image_med' in 'field list'

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_image_med as v_products_image_med, p.products_image_lrg as v_products_image_lrg, p.products_image_sm_1 as v_products_image_sm_1, p.products_image_xl_1 as v_products_image_xl_1, p.products_image_sm_2 as v_products_image_sm_2, p.products_image_xl_2 as v_products_image_xl_2, p.products_image_sm_3 as v_products_image_sm_3, p.products_image_xl_3 as v_products_image_xl_3, p.products_image_sm_4 as v_products_image_sm_4, p.products_image_xl_4 as v_products_image_xl_4, p.products_image_sm_5 as v_products_image_sm_5, p.products_image_xl_5 as v_products_image_xl_5, p.products_image_sm_6 as v_products_image_sm_6, p.products_image_xl_6 as v_products_image_xl_6, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'ck001' AND ptoc.categories_id = subc.categories_id 

[TEP STOP]

 

Is it UltraPics additional code? I think I don't need that fields. What should I do?

Really desperate about it since I have to online my store soon.

 

Thanks in advance,

Xiu

 

This is most likely being caused by something other than EP but just the same... your database table (products) is missing entry for image_med in the field list. If you have phpMyAdmin, view your products table Make sure you are in correct table by finding one of the other entries in the list that seem to be working - do you see image_med in there? If not, you will need to insert that ...best way is to check the install instructions of contribution using this (UltraPics?), and verify that you have followed any SQL query instructions for adding tables to your database. Good luck!

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