Easy Populate 1.2.5.4 support

[etchedmemories]

Hello,
I installed the plugin to my site and also added the SQL to it as well after i installed i get this

Strange but there is no default language to work... That may not happen, just in case...v_products_model,v_products_image,v_specials_price,v_specials_last_modifi ed,v_specials_expires_date,v_products_price,v_products_weight,v_last_modified,v_ date_added,v_pro

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 the latest and current sql server everything is working properly on my server side but apparently there is a flaw in the SQL coding or it is not compatible with the latest zencart version. i really would like this on my site due to it will save me time and effort uploading products to website.

Thanks
Jim

[adb34]

Sorry this is a bit of a war & peace post. Zencart v1.5.4 & template carlisle fresh

I am having problems with loading the sql file I get the error 'WARNING: An Error occurred, please refresh the page and try again.' The log files are;

[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): No such file or directory in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): A link to the server could not be established in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/easypopulate.php on line 389
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): No such file or directory in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): A link to the server could not be established in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/easypopulate.php on line 398
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): No such file or directory in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_query(): A link to the server could not be established in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/includes/functions/extra_functions/easypopulate_functions.php on line 230
[19-Mar-2015 15:37:29 UTC] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/easypopulate.php on line 411
[19-Mar-2015 15:37:29 UTC] PHP Warning: include(/homepages/20/d503465712/htdocs/shops/mainshop/EASYPOPULATE_CONFIG_TEMP_DIR/fileList.php): failed to open stream: No such file or directory in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/easypopulate.php on line 2438
[19-Mar-2015 15:37:29 UTC] PHP Warning: include(): Failed opening '/homepages/20/d503465712/htdocs/shops/mainshop/EASYPOPULATE_CONFIG_TEMP_DIR/fileList.php' for inclusion (include_path='.:/usr/lib/php5.5') in /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/easypopulate.php on line 2438

and

[19-Mar-2015 15:38:45 UTC] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO jmi_configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'tempEP/', 'Name of directory for your uploads (default: tempEP/).', @configuration_group_id, '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', @configuration_group_id, '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', @configuration_group_id, '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', @configuration_group_id, '3', NULL, now(), NULL, NULL), ('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', @configuration_group_id, '4', NULL, now(), NULL, NULL), ('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', @configuration_group_id, '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', @configuration_group_id, '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', @configuration_group_id, '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', @configuration_group_id, '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', @configuration_group_id, '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'); ==> (as called by) /homepages/20/d503465712/htdocs/shops/mainshop/backoffice/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/mainshop/includes/classes/db/mysql/query_factory.php on line 155

I have installed this in to the same template on the same zencart version to another site with no problems.

[mc12345678]

Differences in php version between the two sites? mysql_ queries are no longer supported in PHP5.4+.

[adb34]

Differences in php version between the two sites? mysql_ queries are no longer supported in PHP5.4+.

I do not understand, I have just checked & my PHP is set at v5.5. Would be an idea for me to upgrade to v5.6 then back down?

[lat9]

The issue is that the install.sql is using "blind inserts" (i.e. not supplying the field names along with the values). adb34 has apparently installed one of the numinix plugins on the site that's not working (which adds a field to the configuration table, making the count mismatch).

[adb34]

The issue is that the install.sql is using "blind inserts" (i.e. not supplying the field names along with the values). adb34 has apparently installed one of the numinix plugins on the site that's not working (which adds a field to the configuration table, making the count mismatch).

I see what you are saying. How can I find which numinix plugin is causing this problem?

[mc12345678]

Differences in php version between the two sites? mysql_ queries are no longer supported in PHP5.4+.

I do not understand, I have just checked & my PHP is set at v5.5. Would be an idea for me to upgrade to v5.6 then back down?

Intent of the question was to identify what the difference in php versions was between one site and the other assuming that both sites were not hosted under the same host as neither condition was specifically identified. (both sites hosted in the same space or different spaces though specifically doesn't matter which configuration as php version depending on host setup could be different for each site)

[mc12345678]

I see what you are saying. How can I find which numinix plugin is causing this problem?

It's not necessarily that numinix software is causing the problem. It's that the sql is incorrectly formatted for any condition other than a brand new installation of ZC without modifications to the tables that are made by numinix software...

The sql needs to be in the format:

insert into DB_PREFIXtablename (field1, field2, ...) VALUES ('value1', 'value2', ...);

If the sql is in someway in the code... The portion: SB_PREFIXtablenmae ought to already be properly formatted, it is the remaining portion that does the blind insert described by lat9.

[lat9]

I see what you are saying. How can I find which numinix plugin is causing this problem?

It's not the numinix plugin that is causing the problem, it's the improperly coded install.sql file. See http://www.zen-cart.com/showthread.p...tall-sql-files for more information.

[adb34]

If the sql is in someway in the code... The portion: SB_PREFIXtablenmae ought to already be properly formatted, it is the remaining portion that does the blind insert described by lat9.

# Install Easy Populate Configuration for zen cart v1.5
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) 
FROM configuration_group 
WHERE configuration_group_title = 'Easy Populate' 
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration VALUES
('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'tempEP/', 'Name of directory for your uploads (default: tempEP/).', @configuration_group_id, '0', NULL, now(), NULL, NULL),
('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', @configuration_group_id, '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'),
('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', @configuration_group_id, '2', NULL, now(), NULL, NULL),
('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', @configuration_group_id, '3', NULL, now(), NULL, NULL),
('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', @configuration_group_id, '4', NULL, now(), NULL, NULL),
('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', @configuration_group_id, '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', @configuration_group_id, '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', @configuration_group_id, '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', @configuration_group_id, '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', @configuration_group_id, '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');

INSERT INTO admin_pages VALUES ('easyPopulate', 'BOX_TOOLS_EASY_POPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', @configuration_group_id);
INSERT INTO admin_pages_to_profiles VALUES ('1', 'easyPopulate');
INSERT INTO admin_pages VALUES ('easyPopulateConfig', 'BOX_CONFIGURATION_EASY_POPULATE', 'FILENAME_CONFIGURATION', CONCAT('gID=',@configuration_group_id), 'configuration', 'Y', @configuration_group_id);

If I have read it right, line 10 is what you are talking about?

line 10 is

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');