Easy Populate 2.90 error

[cerebro]

I installed easy populate 2.90 today and am pretty sure i followed the directions exactly and when i try to use the following commands i get an error

 

Download .txt file with TAB delimited to edit ( Complete )

Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

Creation file .txt file with TAB delimited ( Complete )

Creation file .txt file with TAB delimited ( Model / Price / Quantity )

 

the error is:

 

1054 - Unknown column 'p.products_price1_qty' 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_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, 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, 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 have searched the forums and haven't found anything to help...there are alot of posts and i went through most of them that had any relevence to the subject. Thank you for your time and consideration.

[josscool]

Did all the steps exactly as described in readme1st.txt. Checked twice to make sure everything was followed correctly.

 

Got the same problem with 'products_price1_qty'.

 

Help would be much appreciated!

[josscool]

I looked around and found this solution. It says the problem is because of a step missed. But, the readme1st is not talking about the sql update. Anyway, I think you need to run the update.sql that comes with it. I looked at the file and it looks like it's deletion some stuff from Configuration table and then reinserting new stuff. One guy was also reporting that this broke his store (couldn't click on products). Make sure you backup the Configuration table before running the code.

 

For reference, here is the threat I found: http://www.oscommerce.com/forums/index.php?showtopic=84137 :unsure:

[josscool]

Ok. One last post.

It looks like update.sql deletes only records that are EasyPopulate-related. Basically instead of doing an UPDATE they're doing a DELETE/INSERT combo.

 

It looks safe to run it on your db. In the worst case, if you see the store acting up, just re-run the top portion of the file (delete statements) and you should be fine.

 

I ran the code and it looks like it of

 

1. Download .txt file with TAB delimited to edit ( Complete )

2. Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

3. Download .txt file with TAB delimited to edit ( Model / Category )

4. Download .txt file with TAB delimited to edit ( Model / Attributes )

5. Download .txt file with TAB delimited to edit ( Products extra fields )

6. Download .txt file with TAB delimited to edit ( Froogle )

 

3, 4, and 6 started working, but the rest are still having issues.

 

Will keep you posted as I find out more.

[willows]

Whats the last good version of this.

getting the same errors and more it is not uploading when you do get it sorted.

 

cheers

sean

 

 

Ok. One last post.

It looks like update.sql deletes only records that are EasyPopulate-related. Basically instead of doing an UPDATE they're doing a DELETE/INSERT combo.

 

It looks safe to run it on your db. In the worst case, if you see the store acting up, just re-run the top portion of the file (delete statements) and you should be fine.

 

I ran the code and it looks like it of

 

1. Download .txt file with TAB delimited to edit ( Complete )

2. Download .txt file with TAB delimited to edit ( Model / Price / Quantity )

3. Download .txt file with TAB delimited to edit ( Model / Category )

4. Download .txt file with TAB delimited to edit ( Model / Attributes )

5. Download .txt file with TAB delimited to edit ( Products extra fields )

6. Download .txt file with TAB delimited to edit ( Froogle )

 

3, 4, and 6 started working, but the rest are still having issues.

 

Will keep you posted as I find out more.

[josscool]

It sounds like 2.9 is the last stable version, but it's not working for me. I'm going to try other versions.

[choosealogin]

It sounds like 2.9 is set up with the "separate price per customer" contribution fields in it.

 

If you don't use that contribution (sppc), then youu need to comment out or delete the references to the sppc contribution, in the easypopulate.php file.

 

Alternatively, you could download EP 2.74 (Mibble's version), which worked perfectly for me from the first try. Use the one dated 26 july 05.

[josscool]

I'm running MS2.2 and it says that the version 2.74 is for MS1... I'll try anyway (I'm pretty much desperate at the moment and would try whatever may possibly work).