USing ZenCart 1.3.9h and ezpop 1.2.5.4 after upload categories are showing the wrong product counts. 1 category has 1 product but shows 4 as a count. Others show double the amounts actually in the store.
Printable View
USing ZenCart 1.3.9h and ezpop 1.2.5.4 after upload categories are showing the wrong product counts. 1 category has 1 product but shows 4 as a count. Others show double the amounts actually in the store.
hi all
im using zen 1.5.0 and ep 1257c , it all work fine on upload etc but the download is struggling on a full download either to pc or temp folder. if i do a model/price/quantity dload it is all ok, a complete csv dload and my screen starts ok but about 20-30 secs in my browser screen just goes white and nothing else happens. i have about 22000 items in my store, it all worked fine initially when i had a few items but now get the error, it will upload ok just not download. ive changed my timout in admin and php.ini but no joy.
any help appreciated
thanks
dessy
I am runing Zen 1.5.1 and easy populate csv for zencart 1.5.x
I am getting following error message:
MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS 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
MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS 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
MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS 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
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET
products_price = '0.0000' ,
products_image = '02.jpg' ,
products_weight = '23' ,
products_tax_class_id = '1' ,
products_date_available = '' ,
products_date_added = '2003-11-03 12:32:17' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '0' ,
master_categories_id = '4' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '', EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' WHERE ( `products_id` = '1' )
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET
products_price = '0.0000' ,
products_image = 'matrox/DSC_0514.JPG' ,
products_weight = '0' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2003-11-03 12:32:17' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '31' ,
master_categories_id = '4' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '', EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' WHERE ( `products_id` = '2' )
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET
** and it continues in the same way
I hope somebody is able to help me fix this issue.
Can anyone help with this please?
My install of Easy Populate is working fine, but is missing from the 'configuration' menu.
I downloaded what looks to be the latest version from http://www.zen-cart.com/downloads.php?do=file&id=868
I've tried to upload the SQL patch to no avail.
MySQL v5.0.9
Zen Cart v1.5.1
EP v1.2.5.7c
i am not able to do anything. when i try to upload my file i get a message that says...
an sql error has occured. PLease check your input data for tabs within the fields and delete these...
Not sure what is going wrong... Please help
I've just installed this mod,and so far I think things are looking good,but I notice a few threads here that are not replied to, and perhaps I can help out:
Hardy159 => Are you certain you clicked on the install link at the top of the page after visiting the Admin>Tools>EasyPopulate page?
double-happiness => Do you mean to say the Admin>Tools>EasyPopulate menu? It may have been in configuration in the past, but it is not there now.
drago => This sounds like a problem with the data you are trying to move, in one of your products, you use a TAB instead of spaces, which may cause problems with some data downloads/uploads. Change the product to use spaces and you should be ok. Yes, I know it may be difficult to find which product this is. :(
Ray
Quote:
Originally Posted by RayDube
Upon Further review, double-happiness, you may be looking for the EASY POPULATE 4.0 SUPPORT THREAD, found here:
http://www.zen-cart.com/showthread.p...sy+Populate+V4
Ray
Yes... You should use EP 4 if your site is based on ZC 1.5.x
This is a much-improved and advanced version, and has a number of valuable new features and functions. There is a support thread with a link to GITHUB where the latest "edition" of chad's module will be available.
hello all i need some help please
when i try and import my products via this add-on i get an error come up saying
ADD NEW PRODUCT FAILED! - Model: 633043 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: 633044 - SQL error. Check Easy Populate error log in uploads directory
when i look in the error file it says this????
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET
can anyone please tell me what im doing wrong?
at top of admin page it says
Warning 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
I have upgraded from 1.38 tot 1.51. the module is working, but I have no menu options anymore for configuring easy populate. (only in tools --> easy populate)
How can I make the menu visible again to configure the module, without re-installing or upgrading to other (newer) versions of easy populate?
Remark: The newer versions do not seem to work when I open the exported file to excel (products get mixed up)