Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Import csv file from Temp but get 1054 - Unknown column


vincenthedan

Recommended Posts

Posted

Hi everyone,

 

Im new to osCommerce and Easy Populate, and Im stuck right now.

 

I go to Easy Populate on my admin panel, then to the "Import EP file from Temp Dir" section, then select the name of the csv file I want from the drop down menu (that file is the one I uploaded in the temp directory).

Finally I click on "insert into db". During previous trials, it was working fine and all was good. But now I get this message:

 

Filename: test.csv

1054 - Unknown column 'p.products_image_description' 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_description as v_products_image_description,p.products_subimage1 as v_products_subimage1,p.products_subimage2 as v_products_subimage2,p.products_subimage3 as v_products_subimage3,p.products_subimage4 as v_products_subimage4,p.products_subimage5 as v_products_subimage5,p.products_subimage6 as v_products_subimage6,products_image_med as v_products_image_med,products_image_lrg as v_products_image_lrg,products_image_sm_1 as v_products_image_sm_1,products_image_xl_1 as v_products_image_xl_1,products_image_sm_2 as v_products_image_sm_2,products_image_xl_2 as v_products_image_xl_2,products_image_sm_3 as v_products_image_sm_3,products_image_xl_3 as v_products_image_xl_3,products_image_sm_4 as v_products_image_sm_4,products_image_xl_4 as v_products_image_xl_4,products_image_sm_5 as v_products_image_sm_5,products_image_xl_5 as v_products_image_xl_5,products_image_sm_6 as v_products_image_sm_6,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_available as v_date_avail, p.products_date_added as v_date_added, 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, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'ARTOFCUL2' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1

[TEP STOP]

 

I've been trying different things, modifying the file and so on, but nothing is working.

Can anybody tell me what I did wrong? Let me know if you need more details to understand that issue.

 

Thanks if you can help me :-)

Posted

1054 - Unknown column 'p.products_image_description' in 'field list'

 

Is an SQL error.

 

This would tell me you don't have a products_image_description field in your database specifically the products table.

 

Did you recently add any image modification contributions?

Posted

That field is not found in the standard osC distribution. You must have added an add-on that uses it (EasyPopulate?), but failed to run the SQL command to add that field to the products table. Go back over the installation instructions with a fine-toothed comb and see what you missed.

Posted

Thanks guys,

I've reinstalled the whole thing, going very carefully thru every step, and it seems to be working now.

Again, thanks for you help!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...