• Resolved romonoutic

    (@romonoutic)


    Hi,

    Thank you for this great plugin. I’m facing an issue that I couldn’t trace back to its origin despite having full access to my server and trying everything, such as increasing values. Here’s what I have done:

    Edited the .htaccess File:

    • php_value upload_max_filesize 15000M
    • php_value post_max_size 15000M
    • php_value memory_limit 2000M
    • php_value max_execution_time 36000
    • php_value max_input_time 36000

    Edited the php.ini File:

    • upload_max_filesize = 15000M
    • post_max_size = 15000M
    • memory_limit = 2000M
    • max_execution_time = 36000
    • max_input_time = 36000

    Edited the wp-config.php File:

    • @ini_set(‘upload_max_size’, ‘15000M’);
    • @ini_set(‘post_max_size’, ‘15000M’);
    • @ini_set(‘memory_limit’, ‘2000M’);
    • @ini_set(‘max_execution_time’, ‘36000’);
    • @ini_set(‘max_input_time’, ‘36000’);

    I also switched themes, plugins, reset the WordPress installation, cleared cache, disabled scripts, and browser extensions. However, the behavior of your plugin remains unusual. I have a CSV file with 34,884 products, and my server has enough power to handle bulk uploads, but it always stops at 21,771.

    To troubleshoot, I split the CSV file into four parts. I could upload three parts, but one part remains stuck. After inspecting with my browser, I found the following error:

    “Failed to load resource: the server responded with a status of 500 (Internal Server Error)”

    Enabling debug mode in wp-config.php:

    • define(‘WP_DEBUG’, true);
    • define(‘WP_DEBUG_LOG’, true);
    • define(‘WP_DEBUG_DISPLAY’, false);

    I encountered the following information from your plugin:

    “[20-Jun-2024 13:31:31 UTC] PHP Warning: Undefined array key ‘position’ in /var/www/html/wp-content/plugins/product-import-export-for-woo/admin/modules/product/import/import.php on line 1755” “[20-Jun-2024 13:31:34 UTC] PHP Warning: Undefined array key ‘position’ in /var/www/html/wp-content/plugins/product-import-export-for-woo/admin/modules/product/import/import.php on line 1755” “[20-Jun-2024 13:32:10 UTC] PHP Warning: Undefined array key ‘position’ in /var/www/html/wp-content/plugins/product-import-export-for-woo/admin/modules/product/import/import.php on line 1755”

    Your documentation does not mention a “position” column or how to use it. I tried adding a “position” column to my CSV with a value of “0”, but the result is the same.

    The only thing that worked was reducing the batch number from 10 to 5 and even to 1, and completely removing the “images” column, which forced me to re-upload the CSV file separately for the images. Despite having a server that can handle bulk uploads, it suddenly started showing these errors.

    My question is, as I cannot request you to add a new feature that allows your plugin to automatically restart the uploading process when it stops (automatically reducing the number of batches) with every new try, would you be kind enough to share some script or code snippet that could help bypass this error and automatically restart the uploading process while automatically reducing the batch number after each stop?

    I promise to leave a 5-star review!

    Thank you very much for your help!

    Regards,

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter romonoutic

    (@romonoutic)

    Hi again.. please find below more log errors…

    [21-Jun-2024 19:19:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [21-Jun-2024 19:19:08 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [21-Jun-2024 19:19:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [21-Jun-2024 19:19:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 00:18:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 00:18:24 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 00:18:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 00:18:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 01:37:42 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 01:37:42 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 01:37:42 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 01:37:42 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 02:44:12 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 02:44:12 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 02:44:12 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 02:44:12 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 03:42:48 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 03:42:48 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 03:42:48 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 03:42:48 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 04:48:04 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "scheme" in /var/www/html/wp-includes/canonical.php on line 751
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 04:48:04 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 04:48:04 UTC] PHP Warning: Undefined array key "scheme" in /var/www/html/wp-includes/canonical.php on line 751
    [22-Jun-2024 06:12:10 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:12:10 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:12:10 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 06:12:10 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 06:12:37 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:12:37 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:12:37 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 06:12:37 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:16:24 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "scheme" in /var/www/html/wp-includes/canonical.php on line 751
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:16:24 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 06:16:24 UTC] PHP Warning: Undefined array key "scheme" in /var/www/html/wp-includes/canonical.php on line 751
    [22-Jun-2024 08:47:59 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 08:47:59 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 08:47:59 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 08:47:59 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 09:10:14 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:10:14 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:10:14 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 09:10:14 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 09:15:02 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:15:02 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:15:02 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 09:15:02 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 09:22:51 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:22:51 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:22:51 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 09:22:51 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 09:23:46 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:23:46 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 09:23:46 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 09:23:46 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 12:51:39 UTC] PHP Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-content/plugins/product-import-export-for-woo/admin/modules/product/import/import.php on line 1269
    [22-Jun-2024 12:51:39 UTC] PHP Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-content/plugins/product-import-export-for-woo/admin/modules/product/import/import.php on line 1269
    [22-Jun-2024 13:26:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 13:26:08 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 13:26:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 13:26:08 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 17:46:39 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 17:46:39 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 17:46:39 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 17:46:39 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 19:00:44 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 19:00:44 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 19:00:44 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 19:00:44 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 19:33:49 UTC] Cron reschedule event error for hook: jetpack_clean_nonces, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"hourly","args":[],"interval":3600}
    [22-Jun-2024 19:33:49 UTC] Cron reschedule event error for hook: wc_admin_unsnooze_admin_notes, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"hourly","args":[],"interval":3600}
    [22-Jun-2024 19:52:11 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 19:52:11 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 19:52:11 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 19:52:11 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730
    [22-Jun-2024 20:59:09 UTC] WordPress database error Failed to read auto-increment value from storage engine for query
    INSERT INTO wp_actionscheduler_actions (
    hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, priority, args )
    SELECT 'forminator_daily_cron', 'pending', '2024-06-23 21:59:09', '2024-06-23 21:59:09', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1719179949;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1719179949;}', 7, 10, '[]' FROM DUAL
    WHERE (
    SELECT action_id FROM wp_actionscheduler_actions
    WHERE status IN ( 'pending', 'in-progress' )
    AND hook = 'forminator_daily_cron'
    AND group_id = 7
    LIMIT 1 ) IS NULL made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Forminator_Fields->schedule_forminator_daily_cron, as_schedule_single_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store_unique_action, ActionScheduler_DBStore->save_unique_action, ActionScheduler_DBStore->save_action_to_db
    [22-Jun-2024 20:59:13 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 20:59:13 UTC] PHP Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/wp-includes/canonical.php on line 716
    [22-Jun-2024 20:59:13 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 727
    [22-Jun-2024 20:59:13 UTC] PHP Warning: Undefined array key "host" in /var/www/html/wp-includes/canonical.php on line 730

    Thank you,

    Regards

    Plugin Support WebToffee Support

    (@webtoffeesupport)

    Hi @romonoutic,

    Thank you for reaching out to us.

    To further assist you with the issue of the CSV file getting stuck during import, could you kindly share the import CSV file that encountered this problem? Please ensure to remove any sensitive information from the file before uploading it to a file sharing service. Once done, you can share the download link with us.

    If you have concerns about sharing the file publicly, you can use this link to share the file privately with us.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.