Easy Populate 1.2.5.4 support

[adb34]

I may have a problem with my database. I have tried to load another script for another plugin, 'editable_centerboxes' and that too this throwing up the the message 'WARNING: An Error occurred, please refresh the page and try again.'

[mc12345678]

# 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');

Yup, that line specifically. Although not aware of numinix modifying the admin_pages table, but that sql should also be revised/updated with the same consideration.

Follow the "structure" of the configuration_group insert for both cases.

[adb34]

Yup, that line specifically. Although not aware of numinix modifying the admin_pages table, but that sql should also be revised/updated with the same consideration.

Follow the "structure" of the configuration_group insert for both cases.

OK great, wading into the abyss. Never coded sql before. Let the games begin

[mc12345678]

# 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 (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 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 (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) 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 (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) 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');

OK great, wading into the abyss. Never coded sql before. Let the games begin

Didn't go and find the admin_pages_to_profiles table fields, but the bold blue added information above should at least get you through the next "step".

[delia]

Of course this doesn't run with zen cart 1.5.4 due to change from mysql to mysqli. Here's the first problem

function ep_query($query) {
    global $ep_debug_logging, $ep_debug_logging_all, $ep_stack_sql_error;
    $result = mysql_query($query);
    if (mysql_errno()) {
        $ep_stack_sql_error = true;
        if ($ep_debug_logging == true) {
            // langer - will add time & date..
            $string = "MySQL error ".mysql_errno().": ".mysql_error()."\nWhen executing:\n$query\n";
            write_debug_log($string);
        }
    } elseif ($ep_debug_logging_all == true) {
        $string = "MySQL PASSED\nWhen executing:\n$query\n";
        write_debug_log($string);
    }
    return $result;
} 

fixed by added the i in

function ep_query($query) {
    global $ep_debug_logging, $ep_debug_logging_all, $ep_stack_sql_error;
    $result = mysqli_query($query);
    if (mysqli_errno()) {
        $ep_stack_sql_error = true;
        if ($ep_debug_logging == true) {
            // langer - will add time & date..
            $string = "MySQL error ".mysqli_errno().": ".mysqli_error()."\nWhen executing:\n$query\n";
            write_debug_log($string);
        }
    } elseif ($ep_debug_logging_all == true) {
        $string = "MySQL PASSED\nWhen executing:\n$query\n";
        write_debug_log($string);
    }
    return $result;
} 

but still get the message: Strange but there is no default language to work

logs confirm that wasn't enough

[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 389
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 398
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 411
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Invalid argument supplied for foreach() in /home/domain/public_html/12wsjuY/easypopulate.php on line 448
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 852
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1200
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1201
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1207
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1209

So any php/mysqli gurus want to give me some hints? I went back a few pages here but saw no info.

[adb34]

Out of all of this what I do not understand is that; I have already put this plugin into another website and I had no problems at all. I used the same ISP, zencart version, PHP version. I have said earlier I have similar problems with other plugins and again no problems with my test site. Do I have a problem with my SQL database?

[mc12345678]

Of course this doesn't run with zen cart 1.5.4 due to change from mysql to mysqli. Here's the first problem

function ep_query($query) {
    global $ep_debug_logging, $ep_debug_logging_all, $ep_stack_sql_error;
    $result = mysql_query($query);
    if (mysql_errno()) {
        $ep_stack_sql_error = true;
        if ($ep_debug_logging == true) {
            // langer - will add time & date..
            $string = "MySQL error ".mysql_errno().": ".mysql_error()."\nWhen executing:\n$query\n";
            write_debug_log($string);
        }
    } elseif ($ep_debug_logging_all == true) {
        $string = "MySQL PASSED\nWhen executing:\n$query\n";
        write_debug_log($string);
    }
    return $result;
} 

fixed by added the i in

function ep_query($query) {
    global $ep_debug_logging, $ep_debug_logging_all, $ep_stack_sql_error;
    $result = mysqli_query($query);
    if (mysqli_errno()) {
        $ep_stack_sql_error = true;
        if ($ep_debug_logging == true) {
            // langer - will add time & date..
            $string = "MySQL error ".mysqli_errno().": ".mysqli_error()."\nWhen executing:\n$query\n";
            write_debug_log($string);
        }
    } elseif ($ep_debug_logging_all == true) {
        $string = "MySQL PASSED\nWhen executing:\n$query\n";
        write_debug_log($string);
    }
    return $result;
} 

but still get the message: Strange but there is no default language to work

logs confirm that wasn't enough

[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 389
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 398
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 411
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Invalid argument supplied for foreach() in /home/domain/public_html/12wsjuY/easypopulate.php on line 448
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_query() expects at least 2 parameters, 1 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 230
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysqli_errno() expects exactly 1 parameter, 0 given in /home/domain/public_html/12wsjuY/includes/functions/extra_functions/easypopulate_functions.php on line 231
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, null given in /home/domain/public_html/12wsjuY/easypopulate.php on line 852
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1200
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1201
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1207
[21-Mar-2015 04:29:11 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/domain/public_html/12wsjuY/easypopulate.php:404) in /home/domain/public_html/12wsjuY/easypopulate.php on line 1209

So any php/mysqli gurus want to give me some hints? I went back a few pages here but saw no info.

Yeah, sure, why not use a version of EasyPopulate that has already been written/rewritten to support ZC 1.5.3 and above? What is it about this version which hasn't been maintained that warrants it being upgraded over a version that has had continued support? (http://www.zen-cart.com/showthread.p...Support-Thread)

Or could just basically copy the code from that version and revive this one... Not sure why that would be desired...

Comes down to there is more to converting functionality from mysql_ to mysqli_ than adding a letter or even adding the remaining parameter(s). For correct usage of the applicable mysqli_ functions, may I suggest performing an internet search on any of the above functions and looking over examples provided in the results as well as looking at the documentation between php versions to see the recommended actions to take to address the changes in version?

[mc12345678]

Out of all of this what I do not understand is that; I have already put this plugin into another website and I had no problems at all. I used the same ISP, zencart version, PHP version. I have said earlier I have similar problems with other plugins and again no problems with my test site. Do I have a problem with my SQL database?

And you're 100% sure that ly have the above version of EP installed and not some other in both stores? Care to provide a screen shot of the one that is working taking out any indication of your actual admin path? Say even a section that is "unique" to this version of EP?

[delia]

I can't figure out what easy populates are what. I did the upgrade 1.5.1 to 1.5.4. I don't care which one I use - at this point I just have to get this working again.

So this is supposed to be dead and we are going forward with 4? Switching versions can cause what problems? I don't see 4 has been uploaded to the zen cart plugins yet. You still working only out of github?

[mc12345678]

I can't figure out what easy populates are what. I did the upgrade 1.5.1 to 1.5.4. I don't care which one I use - at this point I just have to get this working again.

So this is supposed to be dead and we are going forward with 4? Switching versions can cause what problems? I don't see 4 has been uploaded to the zen cart plugins yet. You still working only out of github?

In order to comply with the requirements of plugin submission, a set of instructions remains required. So, yes still working out of github as identified on the first post of the above thread, answering questions related to that version at that thread.

To my knowledge I don't know of a conflict, though if database has been upgraded, may want (if able) to uninstall the old version or at least replicate the actions.