Easy Populate with Group Price on ZC 1.3.9h Not Working

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:

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

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:
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

at the bottom:
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

and in the log:
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=''

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

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

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: https://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?

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