New Zenner
- Join Date:
- Jun 2010
- Posts:
- 32
- Plugin Contributions:
- 0
Error uploading file to EP 1.5
I had EP 1.5 installed and it all seem fine but when I go to upload a file after I download the .csv I file in the fields I want to populate and I leaver others empty. When I go to upload the file I get a SQL error that reads on top in yellow: An SQL error has occured. Please check your input data for tabs within fields and delete these.
Also when I go to my EP error log file I get this, which I don't understand:
MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
zen_products as p,
zen_categories as subc,
zen_products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id
What am I doing wrong ? does the SQL file have an error due to its installation or is it the .csv file that im not populating it correctly.
thanks in advance guy's.