Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate Problem


Guest

Recommended Posts

Firstly, apologies if this has been covered but I am unable to search in the forum at the moment ???

 

I have just installed MS2 and the first contri I added was Easy Pop. When I try to Download Complete tab-delimited .txt file to edit. I receieve the error below. I'm a complete newbi at sql so please be gentle.

 

 

 

1054 - Unknown column 'p.products_caratweight' 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_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, p.products_caratweight as v_products_caratweight, p.products_gemlength as v_products_gemlength, p.products_gemwidth as v_products_gemwidth, p.products_gemheight as v_products_gemheight, p.products_dim_type as v_products_dim_type, p.products_length as v_products_length, p.products_width as v_products_width, p.products_height as v_products_height, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

Link to comment
Share on other sites

Firstly, apologies if this has been covered but I am unable to search in the forum at the moment ???

 

I have just installed MS2 and the first contri I added was Easy Pop. When I try to Download Complete tab-delimited .txt file to edit. I receieve the error below. I'm a complete newbi at sql so please be gentle.

 

 

 

1054 - Unknown column 'p.products_caratweight' 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_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, p.products_caratweight as v_products_caratweight, p.products_gemlength as v_products_gemlength, p.products_gemwidth as v_products_gemwidth, p.products_gemheight as v_products_gemheight, p.products_dim_type as v_products_dim_type, p.products_length as v_products_length, p.products_width as v_products_width, p.products_height as v_products_height, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

 

Hello.

I had the same problem. All you have to do is update easypopulate to 2.61.1-MS2 and that problem will be gone.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...