Easy Populate with Group Price on ZC 1.3.9h Not Working

[rocksolidhq]

Hey All,

i've been fighting with this one all day and can't get it sorted out. i thought it was my import file but have now pretty much determined that this is not the case. i've installed a fresh new copy of Zencart 1.3.9h and only added the "Easy Populate with Group Price Per Item" version 1.3.9.gp.meta.e.

When i go to the Easy Populate page the first time i get the following message:

[FONT="Fixedsys"]Installation Successfull! A full download of your store has been done and is available in your uploads (tempEP) directory. You can use this as your 1st template for uploading/updating products.
File Full-EP2011Jan23-0808.csv successfully exported! The file is ready for download in your /tempEP/ directory.
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer[/FONT]

No file is created though and clicking the "Download Complete .csv file to edit" link produces a file with nothing but the header row despite the fact that i installed the demo products with Zencart.

i have a file that works fine with Zencart 1.3.8a and the Easy Populate with Group Price per Item (not sure which version) and it works like a charm. Attempts to use this same file in my vanilla install generates the following messages:

at the top:
[FONT="Fixedsys"]An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer[/FONT]

at the bottom:
[FONT="Fixedsys"]File uploaded.
Temporary filename: /tmp/php27jCxD
User filename: showers-clean.csv
Size: 795

ADD NEW PRODUCT FAILED! - Model: 05A1000 - SQL error. Check Easy Populate error log in uploads directory
Upload Complete[/FONT]

and in the log:
[FONT="Fixedsys"]MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET
products_model = '05A1000' ,
products_price = '' ,
products_group_a_price = '' ,
products_group_b_price = '' ,
products_group_c_price = '' ,
products_group_d_price = '' ,
products_image = 'showers/05A1000.jpg' ,
products_weight = '' ,
products_sort_order = '' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '0' ,
master_categories_id = '65' ,
manufacturers_id = '10',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '' , EASYPOPULATE_CONFIG_CUSTOM_FIELDS=''[/FONT]

i've attached the import file and the log.

does anyone have an idea of what might be causing this?

it's running on Debian Lenny.

thanks,
dean

[rocksolidhq]

As an update, i've commented out the following lines from easypopulate.php and the problems with exports and imports have been resolved.

~line 138-142
$custom_fields == FALSE;
if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
{
$custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
}

i'm planning on using custom fields though so i still need to get this resolved.

thanks,
dean

[ABC2011]

hello, I also have a problem by using
Easy Populate with Group Price Per Item
Version: 1.3.9.gp.meta.f
Last Updated: Feb 02 2011
Author: DeanB
I dont know how to post a new thread, so I post it here,hope to get some support.

here some details about my website envirement:
Server OS: Linux 3.0.9-nx Database: MySQL 5.0.91-log
Server Date: 01/09/2012 20:53:48 Database Date: 01/09/2012 20:53:48
Server Up Time: Unsupported HTTP Server: Apache/2
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 18M PHP Safe Mode: Off
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h

I could not get the images show up on my website after I uploading the products with easy populate.
for I put the images in the images folders in zencart, but after upload, the images path does not point to that directory, for example, the actual path is: www.domainname.com/images/subfolder/image1.jpg, but the images could not show up, when I click the image URL, it said Directory has no index file.
but all the images I upload manually are working.. dont know why? any one have the same issue?

[rocksolidhq]

Hey ABC2011,

Yeah, you probably should start a new thread but i'll try to help.

When you say that "the actual path is: www.domainname.com/images/subfolder/image1.jpg" is this actual URL or is this what you are including in your csv? The v_product_image column should be formatted as such:
subfolder/image.jpg
where 'subfolder' is a directory in /path/to/store/images/

Does that help? If not:

Please provide your site URL and a product that is not working.
Please, either attach a sample csv or include it as text in a message.

dean