• Resolved hallerandrei

    (@hallerandrei)


    Hi,

    Product import dont work anymore. It starting, but it stops when import 5-6 products.

    I thought that it is a conflict with some plugins. I deactivate plugins, but the problem is still appearing.

    And i get an error message: “Request Timeout
    This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase ‘Connection Timeout’.” when i try to delete, or make private/hidden or to empty trash more than 5 products.

    I modified already max_input_time and max_execution_time to 60 (i dont know if is to much), but the same message appear.
    I mention that i have already over 49000 products on my page https://alwaysintrend.ro .

    Pls help.

    • This topic was modified 4 years, 5 months ago by hallerandrei.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @hallerandrei

    I recommend that you increase the amount of memory allocated to PHP on your site, as it is often what causes such issues:
    https://www.ads-software.com/support/article/editing-wp-config-php/#increasing-memory-allocated-to-php

    You can enable WordPress debugging on your site, to find out exactly what is causing the error and share the error_log.txt file in your site’s root directory with us in your response. More info on this here – https://gist.github.com/jeherve/e6acfc973c07cb500836804e1044d12a

    If that doesn’t help, please share your system report with me. You can find it by going to WooCommerce > Status > Get system report and then click Copy for support to be able to paste it in your reply.

    Thread Starter hallerandrei

    (@hallerandrei)

    Hi,

    Thx for help, but dont work. memory_limit 128M and i changed in 256M, and even in the maximum – 768M.

    I have opened in the same tim a topic in here: https://www.ads-software.com/support/topic/yoast-and-request-timeout/#post-12985462

    I dont know how to send u error_log.txt file; just copy/paste here? i put in a wetransfer link https://we.tl/t-lPQiJxxfxI

    And sistem report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://alwaysintrend.ro
    Site address (URL): https://alwaysintrend.ro
    WC Version: 4.2.0
    REST API Version: ? 1.0.8
    WC Blocks Version: ? 2.5.16
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.2.3
    Log Directory Writable: ?
    WP Version: 5.4.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ?
    WP Cron: ?
    Language: ro_RO
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.6
    PHP Post Max Size: 8 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.62.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 10.2.32-MariaDB-cll-lve
    Max Upload Size: 8 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 4.2.0
    WC Database Prefix: wp0l_
    Total Database Size: 797.71MB
    Database Data Size: 646.13MB
    Database Index Size: 151.58MB
    wp0l_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_actionscheduler_actions: Data: 13.91MB + Index: 5.33MB + Engine MyISAM
    wp0l_actionscheduler_claims: Data: 0.01MB + Index: 0.05MB + Engine MyISAM
    wp0l_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_actionscheduler_logs: Data: 7.37MB + Index: 5.48MB + Engine MyISAM
    wp0l_automated_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_commentmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp0l_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_evf_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_evf_entrymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_evf_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_hustle_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_hustle_entries_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_hustle_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_hustle_modules_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp0l_hustle_tracking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_litespeed_optimizer: Data: 0.06MB + Index: 0.01MB + Engine MyISAM
    wp0l_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_mailchimp_jobs: Data: 6.02MB + Index: 0.00MB + Engine InnoDB
    wp0l_newsletter: Data: 0.30MB + Index: 0.18MB + Engine MyISAM
    wp0l_newsletter_emails: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wp0l_newsletter_sent: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
    wp0l_newsletter_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_newsletter_user_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_options: Data: 40.25MB + Index: 6.02MB + Engine MyISAM
    wp0l_postmeta: Data: 291.08MB + Index: 58.64MB + Engine MyISAM
    wp0l_posts: Data: 112.29MB + Index: 23.84MB + Engine MyISAM
    wp0l_po_plugins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_rank_math_internal_links: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp0l_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_rank_math_sc_analytics: Data: 2.35MB + Index: 1.30MB + Engine MyISAM
    wp0l_redirection_404: Data: 17.97MB + Index: 4.52MB + Engine MyISAM
    wp0l_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_redirection_items: Data: 1.39MB + Index: 0.87MB + Engine MyISAM
    wp0l_redirection_logs: Data: 0.28MB + Index: 0.07MB + Engine MyISAM
    wp0l_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_termmeta: Data: 0.07MB + Index: 0.05MB + Engine MyISAM
    wp0l_terms: Data: 0.05MB + Index: 0.11MB + Engine MyISAM
    wp0l_term_relationships: Data: 8.41MB + Index: 17.79MB + Engine MyISAM
    wp0l_term_taxonomy: Data: 0.11MB + Index: 0.05MB + Engine MyISAM
    wp0l_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_usermeta: Data: 0.36MB + Index: 0.01MB + Engine MyISAM
    wp0l_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_wc_customer_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wc_product_meta_lookup: Data: 2.71MB + Index: 4.47MB + Engine MyISAM
    wp0l_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfconfig: Data: 0.37MB + Index: 0.02MB + Engine MyISAM
    wp0l_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wffilemods: Data: 1.43MB + Index: 0.31MB + Engine MyISAM
    wp0l_wfhits: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wp0l_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp0l_wfknownfilelist: Data: 0.73MB + Index: 0.09MB + Engine MyISAM
    wp0l_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp0l_wflogins: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp0l_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0l_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0l_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_wfstatus: Data: 0.08MB + Index: 0.04MB + Engine MyISAM
    wp0l_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woof_stat_buffer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp0l_woof_stat_tmp: Data: 1.12MB + Index: 0.11MB + Engine MyISAM
    wp0l_yoast_indexable: Data: 127.69MB + Index: 18.52MB + Engine InnoDB
    wp0l_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0l_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0l_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0l_yoast_seo_links: Data: 7.68MB + Index: 1.65MB + Engine MyISAM
    wp0l_yoast_seo_meta: Data: 1.72MB + Index: 1.68MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    amp_validated_url: 1
    attachment: 76604
    custom_css: 1
    customize_changeset: 54
    elementor_library: 1
    everest_form: 1
    jetpack_migration: 2
    jp_img_sitemap: 39
    jp_img_sitemap_index: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    mc4wp-form: 1
    nav_menu_item: 82
    oembed_cache: 2
    page: 7
    popup_theme: 6
    post: 1
    product: 49150
    revision: 89688
    saswp: 2
    saswp-collections: 1
    wp_block: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (20) ###
    
    Akismet Anti-Spam: by Automattic – 4.1.6
    GDPR Cookie Consent: by WebToffee – 1.8.8
    Elementor: by Elementor.com – 2.9.12
    Jetpack by WordPress.com: by Automattic – 8.6.1
    Mailchimp for WooCommerce: by Mailchimp – 2.4.0 – Installed version not tested with active version of WooCommerce 4.2.0
    MC4WP: Mailchimp for WordPress: by ibericode – 4.7.8
    Newsletter: by Stefano Lissa & The Newsletter Team – 6.7.2
    Plugin Organizer: by Jeff Sterup – 10.1.3
    Really Simple SSL: by Rogier Lankhorst
    Mark Wolters – 3.3.3
    
    Redirection: by John Godley – 4.8
    Resize Image After Upload: by ShortPixel – 1.8.6
    Schema & Structured Data for WP & AMP: by Magazine3 – 1.9.41.1
    WebP Express: by Bj?rn Rosell – 0.17.3
    WOOF - WooCommerce Products Filter: by realmag777 – 1.2.4 – Installed version not tested with active version of WooCommerce 4.2.0
    WooCommerce: by Automattic – 4.2.0
    Yoast SEO: by Team Yoast – 14.3
    Auto Affiliate Links: by Lucian Apostol – 5.9.1.1
    WP Fastest Cache: by Emre Vona – 0.9.0.7
    WP Global Site Tag: by Digital Apps – 1.0.4
    WP Sitemap Page: by Tony Archambeau – 1.6.2
    
    ### Inactive Plugins (1) ###
    
    Rank Math SEO: by Rank Math – 1.0.44
    
    ### Must Use Plugins (1) ###
    
    Plugin Organizer MU: by Jeff Sterup – 10.1.3
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: RON (lei)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: ?
    
    ### WC Pages ###
    
    Shop base: #6 - /imbracaminte-femei/
    Cart: ? Page ID is set
    but the page does not exist
    
    Checkout: ? Page ID is set
    but the page does not exist
    
    My account: ? Page ID is set
    but the page does not exist
    
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Zakra
    Version: 1.4.4
    Author URL: https://themegrill.com
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 37,551
    Oldest: 2020-06-15 23:01:01 +0300
    Newest: 2020-06-16 21:29:06 +0300
    
    Pending: 12,137
    Oldest: 2020-06-15 23:17:12 +0300
    Newest: 2020-06-16 18:58:13 +0300
    
    Failed: 1,327
    Oldest: 2019-11-01 13:15:01 +0200
    Newest: 2020-06-16 00:09:33 +0300
    
    Canceled: 3
    Oldest: 2020-06-14 18:34:10 +0300
    Newest: 2020-06-15 23:00:47 +0300
    
    

    Thx

    • This reply was modified 4 years, 5 months ago by hallerandrei.
    Plugin Support mouli a11n

    (@mouli)

    Hi there,
    With around 50,000 products this is likely to be caused by server side resource limits so I suggest talking to your host to see if they can find the cause of the timeouts.

    In the meantime I’d also suggest that you increase:
    PHP Time Limit: 600
    PHP Max Input Vars: 10000

    You may need to talk to your host about changing those settings on your site.

    If you are on a shared hosting account it may simply be that your account does not have sufficient resources to manage that number of products.

    You host will able to advise.

    I hope that helps you to figure it out.
    Feel free to get back to us if you have further questions.

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import dont work’ is closed to new replies.