Problems with easypopulate

[mivogt]

Hi there, I have problems using EP with my installes osComm.

If I start to import I get the following error:

 

=============================================

Easy Populate 2.62-MS2 - Default Language : English(1)

 

File uploaded.

Temporary filename: /home/www/web2/phptmp/phphxOpxd

User filename: imp-test-tab.txt

Size: 19348

1054 - Unknown column 'p.products_mediumimage' 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_mediumimage as v_products_mediumimage, p.products_largeimage as v_products_largeimage, p.products_price as v_products_price, p.products_weight as v_products_weight, 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 = '' AND ptoc.categories_id = subc.categories_id

 

[TEP STOP]

=============================================

Any hints?

 

Regards

 

Michael

[techdude]

I have gotten the same output on my setup. At first I thought it was my install. Now that I see someone else is having the problem, it makes me feel better (?!?)

:blink:

 

I reformatted the output for better readability, but it looks like the export script in the admin is missing something. I am not a big expert in PHP. Just enough to get me in trouble... :o

 

Any one have any ideas...

 

1054 - Unknown column 'p.products_mediumimage' 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_mediumimage as v_products_mediumimage,

p.products_largeimage as v_products_largeimage,

p.products_price as v_products_price,

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]

[mivogt]

I only knew a little about SQL/PHP, but I think the error is the line:

 

p.products_mediumimage as v_products_mediumimage,

 

that trys to connect to a databsefield that does not exist.

 

I do not know how to fix the problem but perhaps the EP-author does?

Is he in here?

 

OK we will see..

 

Greetings

 

Michael

[mivogt]

OK, I changed one error for another :-(

I uploaded the newer files to my Admin-Dir; now I get new errors - H-E-L-P !!!

 

After creating additional directorys (I mean /catalog/catalog/temp) it seems to work fine - I get a list of new importrt products but they do not appear in my shop.

 

What's wrong - or more precise: where can I configure EP zo use the /catalog instead of /catalog/catalog?

 

================

 

Easy Populate 2.71-MS2 - Default Language : English(1)

 

 

Warning: Unable to create '/home/www/web2/html/vogo-online/vogoshop/catalog//catalog/temp/miniimporter.csv': No such file or directory in /home/www/web2/html/vogo-online/vogoshop/catalog/admin/easypopulate_functions.php on line 32

 

Warning: Unable to move '/home/www/web2/phptmp/phpX3eiA7' to '/home/www/web2/html/vogo-online/vogoshop/catalog//catalog/temp/miniimporter.csv' in /home/www/web2/html/vogo-online/vogoshop/catalog/admin/easypopulate_functions.php on line 32

 

 

File uploaded.

Temporary filename: /home/www/web2/phptmp/phpX3eiA7

User filename: miniimporter.csv

Size: 3699

 

Warning: Unable to access /home/www/web2/html/vogo-online/vogoshop/catalog//catalog/temp/miniimporter.csv in /home/www/web2/html/vogo-online/vogoshop/catalog/admin/easypopulate.php on line 644

 

Warning: file("/home/www/web2/html/vogo-online/vogoshop/catalog//catalog/temp/miniimporter.csv") - No such file or directory in /home/www/web2/html/vogo-online/vogoshop/catalog/admin/easypopulate.php on line 644

 

Warning: Invalid argument supplied for foreach() in /home/www/web2/html/vogo-online/vogoshop/catalog/admin/easypopulate.php on line 667 :( :(

[techdude]

What's wrong - or more precise: where can I configure EP zo use the /catalog instead of /catalog/catalog?

 

Change the temp directory in the easypopulate.php file. i changed mine to /temp/ and it worked fine. Make sure you have a directory called "temp" in your catalog directory and have set priveleges to read/write. (chmod 777)

 

i also installed the new 2.71 MS2 version and I no longer get the error. Everything is good.

 

jerald bernard

[Guest]

That worked a treat! Except it is adding some of my manufactureres twice...but I think that is a file syntax problem...not an EP snaffu.

Thanks for the solution. I had thought of just configuring easypopulate.php to exclude the additional /catalog/, but I had it just as temp/, not /temp/

 

Works fine now. ;)