• Resolved jmartos

    (@jmartos)


    I have an e-commerce website where orders are randomly duplicated. I haven’t been able to diagnose it myself through order tests because it doesn’t happen to me. A customer mentioned to us that ‘the website froze and the order was repeated.’ The details of my website are:

    WordPress Environment<br><br>WordPress address (URL): https://www.disofic.es<br>Site address (URL): https://www.disofic.es<br>WC Version: 8.8.5<br>REST API Version: ? 8.8.5<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.5.5<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: es_ES<br>External object cache: – Server Environment<br><br>Server Info: Apache/2.4.52 (Ubuntu)<br>PHP Version: 7.4.33<br>PHP Post Max Size: 40 MB<br>PHP Time Limit: 30<br>PHP Max Input Vars: 1000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2<br><br>SUHOSIN Installed: –<br>MySQL Version: 5.5.5-10.6.18-MariaDB-0ubuntu0.22.04.1<br>Max Upload Size: 40 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ? Tu servidor no tiene la clase SoapClient activada - puede que algunos plugins de pasarela de pago que utilizan SOAP no funcionen como se espera.<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 8.8.5<br>WC Database Prefix: wp_<br>Tama?o total de la base de datos: 1075.73MB<br>Tama?o de los datos de la base de datos: 822.92MB<br>Tama?o del índice de la base de datos: 252.81MB<br>wp_woocommerce_sessions: Datos: 13.02MB + índice: 1.02MB + Motor InnoDB<br>wp_woocommerce_api_keys: Datos: 0.06MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_woocommerce_order_items: Datos: 1.52MB + índice: 0.16MB + Motor InnoDB<br>wp_woocommerce_order_itemmeta: Datos: 7.38MB + índice: 6.80MB + Motor InnoDB<br>wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>forma_pago_cliente: Datos: 0.11MB + índice: 0.00MB + Motor InnoDB<br>wp_actionscheduler_actions: Datos: 53.19MB + índice: 37.17MB + Motor InnoDB<br>wp_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_actionscheduler_logs: Datos: 36.16MB + índice: 21.06MB + Motor InnoDB<br>wp_admin_columns: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_berocket_termmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_cky_banners: Datos: 0.14MB + índice: 0.00MB + Motor InnoDB<br>wp_cky_cookies: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_cky_cookie_categories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_comments: Datos: 1.52MB + índice: 0.69MB + Motor InnoDB<br>wp_dgwt_wcas_index: Datos: 10.52MB + índice: 0.31MB + Motor InnoDB<br>wp_dgwt_wcas_invindex_cache: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_dgwt_wcas_invindex_doclist: Datos: 19.55MB + índice: 23.03MB + Motor InnoDB<br>wp_dgwt_wcas_invindex_wordlist: Datos: 3.52MB + índice: 4.48MB + Motor InnoDB<br>wp_dgwt_wcas_stats: Datos: 9.02MB + índice: 0.00MB + Motor InnoDB<br>wp_dgwt_wcas_tax_index: Datos: 0.19MB + índice: 0.05MB + Motor InnoDB<br>wp_dgwt_wcas_var_index: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_e_notes: Datos: 0.02MB + índice: 0.17MB + Motor InnoDB<br>wp_e_notes_users_relations: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_e_submissions: Datos: 0.02MB + índice: 0.27MB + Motor InnoDB<br>wp_e_submissions_actions_log: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB<br>wp_e_submissions_values: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_gla_attribute_mapping_rules: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_gla_budget_recommendations: Datos: 0.19MB + índice: 0.14MB + Motor InnoDB<br>wp_gla_merchant_issues: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_gla_shipping_rates: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_gla_shipping_times: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_imagify_files: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wp_imagify_folders: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_mailchimp_carts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_mailchimp_jobs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_options: Datos: 48.13MB + índice: 7.06MB + Motor InnoDB<br>wp_pmlca_links: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_files: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_hash: Datos: 6.52MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_history: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_images: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_imports: Datos: 0.14MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_posts: Datos: 6.52MB + índice: 0.00MB + Motor InnoDB<br>wp_pmxi_templates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_postmeta: Datos: 427.95MB + índice: 48.16MB + Motor InnoDB<br>wp_posts: Datos: 64.59MB + índice: 27.11MB + Motor InnoDB<br>wp_rank_math_404_logs: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_rank_math_internal_links: Datos: 0.11MB + índice: 0.05MB + Motor InnoDB<br>wp_rank_math_internal_meta: Datos: 2.52MB + índice: 0.00MB + Motor InnoDB<br>wp_rank_math_redirections: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_rank_math_redirections_cache: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_rcp_customers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_rcp_discounts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_rcp_logs: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_rcp_membershipmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_rcp_memberships: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_rcp_membership_counts: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_rcp_payments: Datos: 0.02MB + índice: 0.13MB + Motor InnoDB<br>wp_rcp_payment_meta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_rcp_queue: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_rcp_subscription_level_meta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_redsys_order: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_restrict_content_pro: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_slim_events: Datos: 3.52MB + índice: 1.92MB + Motor InnoDB<br>wp_slim_events_archive: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_slim_stats: Datos: 16.55MB + índice: 9.58MB + Motor InnoDB<br>wp_slim_stats_archive: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wp_statistics_events: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_statistics_exclusions: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_statistics_historical: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_statistics_pages: Datos: 1.52MB + índice: 4.84MB + Motor InnoDB<br>wp_statistics_search: Datos: 0.14MB + índice: 0.25MB + Motor InnoDB<br>wp_statistics_useronline: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_statistics_visit: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_statistics_visitor: Datos: 1.52MB + índice: 1.16MB + Motor InnoDB<br>wp_statistics_visitor_relationships: Datos: 1.52MB + índice: 3.03MB + Motor InnoDB<br>wp_termmeta: Datos: 0.22MB + índice: 0.31MB + Motor InnoDB<br>wp_terms: Datos: 0.09MB + índice: 0.09MB + Motor InnoDB<br>wp_term_relationships: Datos: 8.45MB + índice: 2.48MB + Motor InnoDB<br>wp_term_taxonomy: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB<br>wp_usermeta: Datos: 8.52MB + índice: 9.02MB + Motor InnoDB<br>wp_users: Datos: 1.52MB + índice: 0.63MB + Motor InnoDB<br>wp_wcpdf_invoice_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_admin_notes: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_admin_note_actions: Datos: 0.06MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_category_lookup: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_customer_lookup: Datos: 1.52MB + índice: 1.89MB + Motor InnoDB<br>wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_wc_orders: Datos: 1.52MB + índice: 0.53MB + Motor InnoDB<br>wp_wc_orders_meta: Datos: 1.48MB + índice: 2.83MB + Motor InnoDB<br>wp_wc_order_addresses: Datos: 0.30MB + índice: 0.25MB + Motor InnoDB<br>wp_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_wc_order_operational_data: Datos: 0.27MB + índice: 0.14MB + Motor InnoDB<br>wp_wc_order_product_lookup: Datos: 1.52MB + índice: 0.55MB + Motor InnoDB<br>wp_wc_order_stats: Datos: 0.13MB + índice: 0.08MB + Motor InnoDB<br>wp_wc_order_tax_lookup: Datos: 0.08MB + índice: 0.03MB + Motor InnoDB<br>wp_wc_product_attributes_lookup: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_product_meta_lookup: Datos: 2.50MB + índice: 4.89MB + Motor InnoDB<br>wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_reserved_stock: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wdr_order_discounts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wdr_order_item_discounts: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_wdr_rules: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpda_app_apps: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515103732: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104006: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104007: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104021: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104202: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104205: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104423: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104513: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_apps_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515103732: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104006: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104007: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104021: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104202: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104205: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104423: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104513: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515103732: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104006: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104007: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104021: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104202: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104205: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104423: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104513: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_app_container_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_csv_uploads: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_csv_uploads_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_csv_uploads_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_csv_uploads_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_logging: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_logging_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_logging_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_logging_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_media: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_media_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_media_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_media_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_menus: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_menus_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_menus_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_menus_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpda_project_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_page: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpda_project_page_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_page_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_page_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_table: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_table_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_table_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_project_table_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_publisher: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpda_publisher_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_publisher_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_publisher_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_design: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_design_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_design_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_design_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_settings: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_settings_BACKUP_20240515104624: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_settings_BACKUP_20240515104747: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpda_table_settings_BACKUP_20240515105149: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpforms_logs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpforms_payments: Datos: 0.02MB + índice: 0.14MB + Motor InnoDB<br>wp_wpforms_payment_meta: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_wpforms_tasks_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpf_filters: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpf_meta_data: Datos: 5.13MB + índice: 11.50MB + Motor InnoDB<br>wp_wpf_meta_keys: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_meta_values: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_wpf_meta_values_bk: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_modules: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_modules_type: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpf_statistics: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_statistics_det: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_statistics_sum: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_statistics_val: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpf_usage_stat: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wpmailsmtp_debug_events: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB<br>wp_wpmailsmtp_emails_log: Datos: 3.52MB + índice: 0.41MB + Motor InnoDB<br>wp_wpmailsmtp_email_tracking_events: Datos: 0.19MB + índice: 0.22MB + Motor InnoDB<br>wp_wpmailsmtp_email_tracking_links: Datos: 0.48MB + índice: 0.08MB + Motor InnoDB<br>wp_wpmailsmtp_tasks_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wpr_rocket_cache: Datos: 2.47MB + índice: 3.69MB + Motor InnoDB<br>wp_wpr_rucss_used_css: Datos: 37.06MB + índice: 10.13MB + Motor InnoDB<br>wp_yith_wapo_addons: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_yith_wapo_blocks: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_yith_wapo_blocks_assoc: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_yith_wcan_filter_sessions: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_yith_wcwl: Datos: 3.52MB + índice: 1.52MB + Motor InnoDB<br>wp_yith_wcwl_lists: Datos: 1.27MB + índice: 0.47MB + Motor InnoDB Post Type Counts<br><br>attachment: 153665<br>br_labels: 9<br>custom_css: 2<br>customize_changeset: 4<br>elementor_library: 9<br>envato_tk_import: 3<br>nav_menu_item: 242<br>oembed_cache: 1<br>page: 56<br>popup: 4<br>popup_theme: 8<br>post: 8<br>product: 14847<br>revision: 1869<br>rm_content_editor: 1<br>shop_coupon: 4<br>shop_order_placehold: 1401<br>wp_global_styles: 1<br>wp_navigation: 1<br>wp_template: 2<br>wpcf7_contact_form: 2<br>wpforms: 1<br>yith_wcan_preset: 3 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (42)<br><br>Query Monitor: por John Blackbourn – 3.16.2<br>WooCommerce Advanced Product Labels: por BeRocket – 1.2.5.3<br>FiboSearch - AJAX Search for WooCommerce (Pro): por Equipo de FiboSearch – 1.28.1<br>Better Search Replace: por WP Engine – 1.4.7<br>Code Profiler: por Jerome Bruandet ~ NinTechNet Ltd. – 1.6.8<br>Contact Form 7: por Takayuki Miyoshi – 5.9.5<br>GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: por Thomas Geiger – 1.20.2<br>Elementor Pro: por Elementor.com – 3.20.0<br>Elementor: por Elementor.com – 3.21.4<br>ElementsKit Lite: por Wpmet – 3.1.3<br>Envato Elements: por Envato – 2.0.13<br>Font Awesome: por Font Awesome – 4.5.0<br>Google Listings and Ads: por WooCommerce – 2.7.6<br>Hide admin menu: por Bhavin Thummar & Maulik Patel (BM Studio) – 1.1.1<br>Hide Page And Post Title: por Arjun Thakur – 1.5.7<br>Mailrelay: por Mailrelay – 2.1.3<br>MainWP Child: por MainWP – 5.0.1.1<br>Popup Maker: por Popup Maker – 1.19.0<br>Payment Plugins para PayPal WooCommerce: por Payment Plugins<br>[email protected] – 1.0.48<br><br>Role Based Pricing for WooCommerce: por Addify – 2.1.1<br>Rank Math SEO with AI Best SEO Tools: por Rank Math – 1.0.218<br>Importar kit de plantillas: por Envato – 1.0.15<br>WooCommerce Address Book: por CrossPeak – 2.6.3<br>Checkout Field Editor for WooCommerce: por ThemeHigh – 2.0.2<br>Discount Rules Core: por Flycart – 2.6.4<br>Min Max Quantity & Step Control for WooCommerce: por CodeAstrology Team – 6.2<br>Product Filter by WBW: por WBW – 2.5.9 (la actualización a la versión 2.6.5 está disponible)<br>Payment Plugins para Stripe WooCommerce: por Payment Plugins<br>[email protected] – 3.3.73<br><br>WooPayments: por Automattic – 7.5.3 (la actualización a la versión 7.9.1 está disponible)<br>PDF Invoices & Packing Slips for WooCommerce: por WP Overnight – 3.8.2<br>WooCommerce: por Automattic – 8.8.5 (la actualización a la versión 9.1.1 está disponible)<br>WP Data Access: por Passionate Programmers B.V. – 5.5.1<br>WP Mail SMTP Pro: por WP Mail SMTP – 4.0.2<br>WP-PageNavi: por Lester 'GaMerZ' Chan – 2.94.1<br>WP Rocket: por WP Media – 3.15.9<br>SlimStat Analytics Pro: por VeronaLabs – 1.1.2<br>SlimStat Analytics: por Jason Crouse<br>VeronaLabs – 5.2.1<br><br>WP Statistics: por VeronaLabs – 14.8<br>WPForms Lite: por WPForms – 1.8.8.3<br>WPS Hide Login: por WPServeur<br>NicolasKulka<br>wpformation – 1.9.15.2<br><br>YITH Infinite Scrolling: por YITH – 1.24.0<br>YITH WooCommerce Wishlist: por YITH – 3.35.0 Inactive Plugins (19)<br><br>CookieYes | GDPR Cookie Consent: por CookieYes – 3.2.2<br>Custom Order Status Manager for WooCommerce: por Bright Plugins – 1.1.3.2<br>Image Optimizer by Elementor – Compress, Resize and Optimize Images: por Elementor.com – 1.3.0<br>Restrict Content: por StellarWP – 3.2.10<br>Seraphinite Accelerator (Extended, limited): por Seraphinite Solutions – 2.21.10<br>Ultimate Post Kit: por BdThemes – 3.11.6<br>UpdraftPlus - Backup/Restore: por UpdraftPlus.Com<br>DavidAnderson – 2.24.3.26<br><br>Variation Swatches for WooCommerce: por Emran Ahmed – 2.0.31<br>WBW Product Filter PRO: por WBW – 2.5.4<br>WooCommerce Order Approval: por Lagudi Domenico – 8.6<br>WP All Import - ACF Add-On: por Soflyy – 3.3.8<br>WP All Import - Link Cloaking Add-on: por Soflyy – 1.1.5<br>WP All Import - User Import Add-On Pro: por Soflyy – 1.1.8<br>WP All Import - WooCommerce Import Add-On Pro: por Soflyy – 4.0.0<br>WP All Import Pro: por Soflyy – 4.8.6<br>WP Mail SMTP: por WP Mail SMTP – 4.0.1<br>YITH WooCommerce Ajax Product Filter: por YITH – 5.0.1<br>YITH WooCommerce Ajax Product Filter Premium: por YITH – 4.31.0<br>Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.5 Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php<br>db.php: Query Monitor Database Class (Drop-in) Must Use Plugins (2)<br><br>Code Profiler (mu-plugin): por Jerome Bruandet – 1.0<br>Elementor Safe Mode: por Elementor.com – 1.0.0 Settings<br><br>API Enabled: –<br>Force SSL: –<br>Currency: EUR (€)<br>Currency Position: right_space<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 días<br>Level threshold: –<br>Log directory size: 2 MB WC Pages<br><br>Base de la tienda: #7 - /tienda/<br>Carrito: ? La página no contiene el shortcode [woocommerce_cart] o el bloque woocommerce/cart.<br>Finalizar compra: ? La página no contiene el shortcode [woocommerce_checkout] o el bloque woocommerce/checkout.<br>Mi cuenta: #10 - /mi-cuenta/<br>Términos y condiciones: ? Página sin definir Theme<br><br>Name: Hello Elementor<br>Version: 3.1.0<br>Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash<br>Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente<br>te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo<br><br>WooCommerce Support: ? Templates<br><br>Overrides: – WooPayments<br><br>Version: 7.5.3<br>Connected to WPCOM: ? No<br>Logging: Desactivado Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>product-linked<br>product-pre-publish-modal<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>product-custom-fields<br>settings<br>async-product-editor-category-field<br>launch-your-store<br><br>Daily Cron: ? Next scheduled: 2024-07-12 12:19:15 +02:00<br>Options: ?<br>Notes: 70<br>Onboarding: completed Action Scheduler<br><br>Canceled: 6<br>Oldest: 2024-07-12 08:32:43 +0200<br>Newest: 2024-07-12 09:03:09 +0200<br><br>Complete: 112.677<br>Oldest: 2024-06-11 09:04:05 +0200<br>Newest: 2024-07-12 09:03:27 +0200<br><br>Failed: 316<br>Oldest: 2023-11-24 12:59:27 +0100<br>Newest: 2024-07-05 08:23:14 +0200<br><br>In-progress: 1<br>Oldest: –<br>Newest: –<br><br>Pending: 80<br>Oldest: 2024-07-12 09:03:03 +0200<br>Newest: 2024-07-16 13:18:43 +0200 Status report information<br><br>Generated at: 2024-07-12 09:04:04 +02:00<br>

    I have fatal errors but doesn’t seem to be related:


    2024-07-12T04:02:44+00:00Crítico Uncaught RuntimeException: Unable to claim actions. Database error: Deadlock found when trying to get lock; try restarting transaction. in /var/www/html/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:942 Contexto adicional{ “error”: { “type”: 1, “file”: “\/var\/www\/html\/wp-content\/plugins\/seo-by-rank-math\/vendor\/woocommerce\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php”, “line”: 942 }, “backtrace”: [ “”, “#0 \/var\/www\/html\/wp-content\/plugins\/seo-by-rank-math\/vendor\/woocommerce\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions()”, “#1 \/var\/www\/html\/wp-content\/plugins\/seo-by-rank-math\/vendor\/woocommerce\/action-scheduler\/classes\/ActionScheduler_QueueRunner.php(160): ActionScheduler_DBStore->stake_claim()”, “#2 \/var\/www\/html\/wp-content\/plugins\/seo-by-rank-math\/vendor\/woocommerce\/action-scheduler\/classes\/ActionScheduler_QueueRunner.php(139): ActionScheduler_QueueRunner->do_batch()”, “#3 \/var\/www\/html\/wp-includes\/class-wp-hook.php(324): ActionScheduler_QueueRunner->run()”, “#4 \/var\/www\/html\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()”, “#5 \/var\/www\/html\/wp-includes\/plugin” ] }

    2024-07-12T05:54:20+00:00Crítico Maximum execution time of 30 seconds exceeded Contexto adicional{ “error”: { “type”: 1, “file”: “\/var\/www\/html\/wp-content\/plugins\/wp-rocket\/inc\/functions\/posts.php”, “line”: 200 }, “backtrace”: [ { “file”: “\/var\/www\/html\/wp-content\/plugins\/woocommerce\/includes\/class-woocommerce.php”, “line”: 380, “function”: “critical”, “class”: “WC_Logger”, “type”: “->” }, { “function”: “log_errors”, “class”: “WooCommerce”, “type”: “->” } ]

    • This topic was modified 4 months, 1 week ago by jmartos.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello jmartos

    Thank you for contactin Woo support.

    Could you edit the duplicate orders and share screenshots with me?
    I want to check the order data and see what happened.

    How many times has this issue been reported?
    Is it reported by multiple different customers?

    Looking forward to your response. ??

    Best regards.

    Thread Starter jmartos

    (@jmartos)

    Of course. It has happened several times, and to different customers. Which part of the order data do you want to see exactly?

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello jmartos

    Thank you for your reply.

    I understand that this issue has happened multiple times and with different cusomers.

    I would like the review the following order data:
    1- Order Notes (May need a separate screenshot)
    2- Order Details
    3- Products in cart

    You may hide the sensitive customer information.

    Here is an example:

    Looking forward to your response. ??

    Best regards.

    Thread Starter jmartos

    (@jmartos)

    Want one example or more? I’ll give one now. (Forma de pago del cliente is just payment by COD with another name) The order is cancelled by myself. It also happens with direct bank transfer

    https://i.imgur.com/su8yR8V.png

    • This reply was modified 4 months, 1 week ago by jmartos.
    • This reply was modified 4 months, 1 week ago by jmartos.
    • This reply was modified 4 months, 1 week ago by jmartos.

    Hi there @jmartos, thank you for reaching back, with further details on this.

    I have an e-commerce website where orders are randomly duplicated.

    While investigating the site’s System Status Report (SSR), an unusual amount of shop_order_placehold appears, it appears.

    Until what point in time were orders coming through without issues?

    I haven’t been able to diagnose it myself through order tests because it doesn’t happen to me. A customer mentioned to us that ‘the website froze and the order was repeated.

    For duplicate orders to exist, there must be two different order # created at the same (or similar) time.

    How many of those instances do you have in the last, say, 3 months? There need to follow a study of their similarities, for collecting clues as to what the culprit might be.

    Forma de pago del cliente is just payment by COD with another name) The order is cancelled by myself. It also happens with direct bank transfer

    It appears customizations to the core payment methods are in place. From the order’s notes, it appears the order was cancelled, then the inventory was reduced, before its status appeared as Pending Payment to Processing (translated from Spanish).

    We look forward to your response. In the meantime, please let us know if you have any further questions or concerns.

    Thread Starter jmartos

    (@jmartos)

    Yes, I cancelled myself. A different # is created after 3 minutes approximately. In the last 3 months, it happened like in 40+ orders. It’s been happening for a few months now. What causes the shop_order_placehold?

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @jmartos

    The issue you’re experiencing with order duplication can be caused by a variety of factors.

    From the error logs you’ve shared, it looks like, there might be a deadlock issue with your database. This could potentially be the root cause of your problem as it can lead to unexpected behavior such as order duplication.

    The deadlock error is usually caused when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a database, a deadlock is not a bug, but rather a fact of life that can occur when multiple users are accessing the database in a write-heavy environment.

    To resolve this, you might want to consider optimizing your database or increasing the limit of your MySQL innodb_lock_wait_timeout value. This can be done in your MySQL configuration file (my.cnf or my.ini depending on your setup).

    What causes the shop_order_placehold?

    It is created when a customer reaches the checkout page. It is used to reserve stock for unpaid orders. If it’s unusually high, it could be due to a high number of customers reaching the checkout page but not completing their order.

    Please try these suggestions and let us know if the issue persists. We’re here to help.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @jmartos

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

    If you have further questions, please feel free to open a new topic.

    Thanks!

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