Easy Populate v2.74 - Dwonload/Upload 1054 error

[deekins]

I have installed Easy Populate v2.74 and have attempted to both download a file, and upload a file, with little success.

From the easypopulate.php page, I click on
'Download Complete tab-delimited .txt file to edit'

I receive the following error message:

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_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 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]



I was able to 'Create Model/Price/Qty tab-delimited .txt file in temp dir', and upon trying to utilize said file with the 'Upload EP File' command, I receive the following error:

File uploaded.
Temporary filename: C:\PHP\uploadtemp\php9DE.tmp
User filename: EP2004Oct31-1907.txt
Size: 593
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 = 'DVD-RPMK' AND ptoc.categories_id = subc.categories_id

[TEP STOP]

Please let me know if I can provide any further information. I have searched the forums, but the 1054 error I am seeing is not related to the ones that I have seen. Thanks so much for the guidance.

[deekins]

It appears that these errors were due to the version of the files that I downloaded. Within the contributions thread it states:

"ONLY USE THIS IF YOU HAVE VENDORS_AUTO_EMAIL installed!!!
This package includes the entire easypopulate install, with docs. The modified easypopulate.php file is saved seperately."

A little lesson to myself to read every post in detail.

[jfeist]

Hi,

How did you solve the problem?

Jonas

[deekins]

jfeist, if you navigate to the easy populate contribution page at:

http://www.oscommerce.com/community/...,easy+populate

You'll see multiple "versions" that are available. My first time around, I mistakenly downloaded and installed the version entitled: "25 Oct 2004 - EasyPopulate with Vendors Auto Email support".

I did not have VENDORS_AUTO_EMAIL installed, and thus, my install and pending trial failed. I then downloaded the version entitled: "12 Aug 2004 - EP 2.74 Fixes", and this version worked for me.

Hope this helps.