Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

easypopulate upload problem


simon_cargolines

Recommended Posts

I get the following error message

 

File uploaded.

Temporary filename: /tmp/phpOsp0VS

User filename: Ashworth datebase input.txt

Size: 5726

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 = 'AW01' AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

 

When I try to upload using easypopulate?

Can anybody help?

Link to comment
Share on other sites

All your tables and fields have to match exactly. Apparently that is not the case here.

 

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

 

This field seems to be the problem (so far) now you need to make sure it is either in both your upload file and your existing database or in neither

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

if you are going to use easypopulate AND want to get/put the field outside the ones programmed with easypopulate, then you need to add them.

there is a contribution for adding fields to easypopulate.

there is also a support thread for easypopulate, which has your question answered.

search the thread for your answer or go add the field via the add new fields to easypopulate.

http://www.oscommerce.com/forums/index.php?showtopic=64945

 

i know for sure the answer is in there. all it takes is a bit of your time.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...