Jump to content
Sign in to follow this  
stewdawg35

1054 - Unknown column 'p.products_master' in 'fiel

Recommended Posts

:blink: I uploaded a test set of data using easy populate and got this: What do I do?

 

1054 - Unknown column 'p.products_master' 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_master as v_products_master, p.products_master_status as v_products_master_status, p.products_listing_status as v_products_listing_status, 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 = 'CDG-LC001' AND ptoc.categories_id = subc.categories_id

 

Thank you so much

Share this post


Link to post
Share on other sites

That test data is for an installation running the Master Products contribution - where did you get it?

 

Matti


Matti Ressler

 

We were all once expert at...... nothing

_____

Share this post


Link to post
Share on other sites

The products I uploaded were just a sample from my entire store, I uploaded a text file to edit, saved it and edited it in excell. than I uploaded it to the database and got that response. Do I need to go into master products and make the variables the same as in my product file? If so where can I find masterproducts?

thanks for your help.

Share this post


Link to post
Share on other sites

I believe that there is a Master Products/Easypopulate contribution - if you have used this without having Master Products installed then you will have problems - search contributions.

 

Matti


Matti Ressler

 

We were all once expert at...... nothing

_____

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×