• Resolved pablorodriguezsierra

    (@pablorodriguezsierra)


    I've taken all the steps to activate HPOS (updating all plugins so that I can do so, and sync all orders) and once activated, when attempting to place an order on the checkout page, an error message appears without processing it, no payment attempt. Then I find that the order is saved with payment pending.
    Here is the system report

     WordPress Environment
    
    WordPress address (URL): https://virtualmedicum.com<br>Site address (URL): https://virtualmedicum.com<br>WC Version: 8.5.2<br>REST API Version: ? 8.5.2<br>WC Blocks Version: ? 11.8.0-dev<br>Action Scheduler Version: ? 3.7.1<br>Log Directory Writable: ?<br>WP Version: 6.4.2<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: ?<br>WP Cron: –<br>Language: es_ES<br>External object cache: – Server Environment
    
    Server Info: Apache<br>PHP Version: 7.4.33<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 30000<br>cURL Version: 7.61.1<br>OpenSSL/1.1.1k
    
    SUHOSIN Installed: –<br>MySQL Version: 5.5.5-10.3.39-MariaDB<br>Max Upload Size: 128 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database
    
    WC Database Version: 8.5.2<br>WC Database Prefix: wpcncr_<br>Tama?o total de la base de datos: 1735.40MB<br>Tama?o de los datos de la base de datos: 1331.55MB<br>Tama?o del índice de la base de datos: 403.85MB<br>wpcncr_woocommerce_sessions: Datos: 1.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_woocommerce_order_items: Datos: 2.52MB + índice: 1.52MB + Motor InnoDB<br>wpcncr_woocommerce_order_itemmeta: Datos: 19.55MB + índice: 15.03MB + Motor InnoDB<br>wpcncr_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_woocommerce_payment_tokens: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_woocommerce_payment_tokenmeta: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB<br>wpcncr_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_autorizaciones: Datos: 2.52MB + índice: 0.03MB + Motor InnoDB<br>adm_autorizacion_familia: Datos: 0.11MB + índice: 0.03MB + Motor InnoDB<br>adm_citas: Datos: 0.06MB + índice: 0.03MB + Motor InnoDB<br>adm_cron_emails: Datos: 0.13MB + índice: 0.02MB + Motor InnoDB<br>adm_equivalencia_productos_labos: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>adm_laboratorios: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_laboratorio_familia: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_laboratorio_planes: Datos: 0.14MB + índice: 0.02MB + Motor InnoDB<br>adm_laboratorio_tiendas: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_payments: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_payments_log: Datos: 0.09MB + índice: 0.02MB + Motor InnoDB<br>adm_productos_profesionales: Datos: 0.09MB + índice: 0.02MB + Motor InnoDB<br>adm_profesionales_clinicas: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>adm_usuarios: Datos: 10.52MB + índice: 0.13MB + Motor InnoDB<br>adm_usuarios_comisiones: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>cli_clientes_ed: Datos: 3.52MB + índice: 0.00MB + Motor InnoDB<br>cli_comerciales: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>cli_consumosnutricion: Datos: 268.86MB + índice: 0.00MB + Motor InnoDB<br>cli_laboratorios: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>cli_maestro_clientes: Datos: 11.52MB + índice: 0.00MB + Motor InnoDB<br>cli_maestro_clientes_consumos: Datos: 0.25MB + índice: 0.00MB + Motor InnoDB<br>cli_productos: Datos: 0.14MB + índice: 0.02MB + Motor InnoDB<br>cli_visitadores: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>cli_zonasnombres: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>EXTRACCION_DOCTOR: Datos: 0.00MB + índice: 0.00MB + Motor<br>wpcncr_actionscheduler_actions: Datos: 271.81MB + índice: 130.41MB + Motor InnoDB<br>wpcncr_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_actionscheduler_logs: Datos: 215.75MB + índice: 79.16MB + Motor InnoDB<br>wpcncr_affiliate_wp_affiliatemeta: Datos: 0.13MB + índice: 0.13MB + Motor InnoDB<br>wpcncr_affiliate_wp_affiliates: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_campaigns: Datos: 0.00MB + índice: 0.00MB + Motor<br>wpcncr_affiliate_wp_connections: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_affiliate_wp_coupons: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_creativemeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_affiliate_wp_creatives: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_customermeta: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB<br>wpcncr_affiliate_wp_customers: Datos: 0.16MB + índice: 0.13MB + Motor InnoDB<br>wpcncr_affiliate_wp_custom_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_direct_links: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_affiliate_wp_groups: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_affiliate_wp_notifications: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_payouts: Datos: 0.11MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_affiliate_wp_referralmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_affiliate_wp_referrals: Datos: 9.52MB + índice: 0.13MB + Motor InnoDB<br>wpcncr_affiliate_wp_rest_consumers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_affiliate_wp_sales: Datos: 0.17MB + índice: 0.09MB + Motor InnoDB<br>wpcncr_affiliate_wp_visits: Datos: 22.55MB + índice: 3.52MB + Motor InnoDB<br>wpcncr_aioseo_notifications: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_aioseo_posts: Datos: 0.13MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_berocket_termmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_cartflows_ca_cart_abandonment: Datos: 2.52MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_cartflows_ca_email_history: Datos: 0.09MB + índice: 0.11MB + Motor InnoDB<br>wpcncr_cartflows_ca_email_templates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_cartflows_ca_email_templates_meta: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_cmplz_cookiebanners: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_cmplz_cookies: Datos: 0.08MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_cmplz_services: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_commentmeta: Datos: 0.19MB + índice: 0.20MB + Motor InnoDB<br>wpcncr_comments: Datos: 6.52MB + índice: 4.98MB + Motor InnoDB<br>wpcncr_cpk_wpcsv_export_queue: Datos: 0.17MB + índice: 0.06MB + Motor MyISAM<br>wpcncr_cpk_wpcsv_log: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM<br>wpcncr_dgwt_wcas_index: Datos: 1.52MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_dgwt_wcas_invindex_cache: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_dgwt_wcas_invindex_doclist: Datos: 3.52MB + índice: 4.03MB + Motor InnoDB<br>wpcncr_dgwt_wcas_invindex_wordlist: Datos: 1.52MB + índice: 0.50MB + Motor InnoDB<br>wpcncr_dgwt_wcas_stats: Datos: 0.44MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_dgwt_wcas_var_index: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_duplicator_packages: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_e_notes: Datos: 0.02MB + índice: 0.17MB + Motor InnoDB<br>wpcncr_e_notes_users_relations: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_e_submissions: Datos: 0.05MB + índice: 0.27MB + Motor InnoDB<br>wpcncr_e_submissions_actions_log: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB<br>wpcncr_e_submissions_values: Datos: 0.13MB + índice: 0.13MB + Motor InnoDB<br>wpcncr_fbv: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_fbv_attachment_folder: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_fql_logs: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_fv_enteries: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_fv_entry_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_fv_logs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_gdpr_cc_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_imagify_files: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_imagify_folders: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_ld_notifications_delayed_emails: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_category: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_form: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_lock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_master: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_prerequisite: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_question: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_statistic: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_statistic_ref: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_template: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_pro_quiz_toplist: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_learndash_user_activity: Datos: 0.14MB + índice: 0.42MB + Motor InnoDB<br>wpcncr_learndash_user_activity_meta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_mailchimp_carts: Datos: 0.14MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_mailchimp_jobs: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_ms_snippets: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_options: Datos: 43.05MB + índice: 11.19MB + Motor InnoDB<br>wpcncr_pantheon_sessions: Datos: 89.63MB + índice: 57.19MB + Motor InnoDB<br>wpcncr_pda_passwords: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_postmeta: Datos: 71.59MB + índice: 29.08MB + Motor InnoDB<br>wpcncr_posts: Datos: 24.48MB + índice: 5.84MB + Motor InnoDB<br>wpcncr_po_plugins: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_prevent_direct_access_free: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_pum_subscribers: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_pv_commission: Datos: 1.52MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_redirection_404: Datos: 2.45MB + índice: 1.72MB + Motor InnoDB<br>wpcncr_redirection_groups: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_redirection_items: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB<br>wpcncr_redirection_logs: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_smush_dir_images: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_sm_sessions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_snippets: Datos: 0.08MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_tablesome_event_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_records: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_47784: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_47931: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48556: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48705: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48706: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48727: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48742: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48773: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_48827: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_49000: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_49588: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_tablesome_table_49621: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_termmeta: Datos: 0.22MB + índice: 0.23MB + Motor InnoDB<br>wpcncr_terms: Datos: 0.14MB + índice: 0.14MB + Motor InnoDB<br>wpcncr_term_relationships: Datos: 0.48MB + índice: 0.27MB + Motor InnoDB<br>wpcncr_term_taxonomy: Datos: 0.19MB + índice: 0.16MB + Motor InnoDB<br>wpcncr_tm_taskmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_tm_tasks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_ulike: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_ulike_activities: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_ulike_comments: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_ulike_forums: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wpcncr_ulike_meta: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_usermeta: Datos: 8.52MB + índice: 6.03MB + Motor InnoDB<br>wpcncr_useronline: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_users: Datos: 0.33MB + índice: 0.23MB + Motor InnoDB<br>wpcncr_wcpdf_credit_note_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_credit_note_number_2023: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_invoice_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_invoice_number_2021: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_invoice_number_2022: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_invoice_number_2023: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_packing_slip_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcpdf_proforma_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wcs_payment_retries: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wc_admin_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wc_customer_lookup: Datos: 0.27MB + índice: 0.19MB + Motor InnoDB<br>wpcncr_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_wc_orders: Datos: 2.52MB + índice: 2.81MB + Motor InnoDB<br>wpcncr_wc_orders_meta: Datos: 19.55MB + índice: 34.22MB + Motor InnoDB<br>wpcncr_wc_order_addresses: Datos: 2.52MB + índice: 4.98MB + Motor InnoDB<br>wpcncr_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_wc_order_operational_data: Datos: 1.52MB + índice: 0.66MB + Motor InnoDB<br>wpcncr_wc_order_product_lookup: Datos: 1.52MB + índice: 0.92MB + Motor InnoDB<br>wpcncr_wc_order_stats: Datos: 1.52MB + índice: 0.38MB + Motor InnoDB<br>wpcncr_wc_order_tax_lookup: Datos: 0.27MB + índice: 0.20MB + Motor InnoDB<br>wpcncr_wc_product_attributes_lookup: Datos: 0.45MB + índice: 0.42MB + Motor InnoDB<br>wpcncr_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wc_product_meta_lookup: Datos: 0.17MB + índice: 0.41MB + Motor InnoDB<br>wpcncr_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wfblockediplog: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfblocks7: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_wfconfig: Datos: 1.34MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfcrawlers: Datos: 1.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wffilechanges: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wffilemods: Datos: 126.77MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfhits: Datos: 1.02MB + índice: 0.23MB + Motor InnoDB<br>wpcncr_wfhoover: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wfissues: Datos: 0.05MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_wfknownfilelist: Datos: 58.58MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wflivetraffichuman: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wflocs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wflogins: Datos: 0.45MB + índice: 0.16MB + Motor InnoDB<br>wpcncr_wfls_2fa_secrets: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wfls_role_counts: Datos: 0.00MB + índice: 0.00MB + Motor MEMORY<br>wpcncr_wfls_settings: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfnotifications: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfpendingissues: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_wfreversecache: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfsecurityevents: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfsnipcache: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_wfstatus: Datos: 1.02MB + índice: 0.09MB + Motor InnoDB<br>wpcncr_wftrafficrates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wfwaffailures: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_woo_shippment_provider: Datos: 0.20MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wpfm_backup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wpmailsmtp_debug_events: Datos: 2.52MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wpmailsmtp_tasks_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wpstg_queue: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wps_cleaner: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wps_cleaner_queue: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wpvivid_options: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_wt_iew_action_history: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wt_iew_cron: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wt_iew_ftp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_wt_iew_mapping_template: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_yith_vendors_commissions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_yith_vendors_commissions_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wpcncr_yith_wcan_filter_sessions: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wpcncr_yith_wcwl: Datos: 0.19MB + índice: 0.06MB + Motor InnoDB<br>wpcncr_yith_wcwl_lists: Datos: 0.08MB + índice: 0.09MB + Motor InnoDB<br>wpcncr_yoast_indexable: Datos: 2.52MB + índice: 0.94MB + Motor InnoDB<br>wpcncr_yoast_indexable_hierarchy: Datos: 0.14MB + índice: 0.22MB + Motor InnoDB<br>wpcncr_yoast_migrations: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wpcncr_yoast_primary_term: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB<br>wpcncr_yoast_seo_links: Datos: 0.52MB + índice: 0.36MB + Motor InnoDB<br>wpcncr_yoast_seo_meta: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB<br>zonasnombres_geoloc2: Datos: 0.27MB + índice: 0.00MB + Motor InnoDB Post Type Counts
    
    attachment: 3398<br>br_labels: 4<br>copy-to-clipboard: 1<br>coursenote: 15<br>custom_css: 3<br>dce_elementor_from: 2<br>dce_html_template: 3<br>doctor: 347<br>elementor_icons: 5<br>elementor_library: 213<br>elementor_snippet: 2<br>faq: 2<br>gp_elements: 1<br>hospital: 23<br>iv_coupon: 1<br>iv_payment_setting: 1<br>jp_img_sitemap: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>ld-custom-template: 10<br>mc4wp-form: 1<br>meeting: 2<br>nav_menu_item: 190<br>oembed_cache: 91<br>page: 108<br>popup: 2<br>popup_theme: 9<br>post: 68<br>post_grid: 1<br>post_grid_layout: 2<br>product: 1013<br>product_variation: 2<br>revision: 3390<br>rs_elements: 1<br>sfwd-courses: 35<br>sfwd-lessons: 114<br>sfwd-topic: 111<br>shipping_package: 13<br>shop_coupon: 425<br>shop_order: 6272<br>shop_order_refund: 74<br>shop_order_vendor: 5070<br>tablesome_cpt: 12<br>ticket: 5<br>ticket_history: 10<br>ticket_reply: 7<br>tribe_events: 1<br>tribe_organizer: 1<br>tribe_venue: 1<br>wafs: 10<br>was: 13<br>wc_membership_plan: 8<br>wc_user_membership: 4864<br>wishlist: 1<br>wll_records: 25<br>wp_template: 2<br>wpes_setting: 1<br>xlwcty_thankyou: 1<br>yith_wcan_preset: 12 Security
    
    Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (78)
    
    Copy Anything to Clipboard: por Clipboard Team – 3.5.1<br>PDF Embedder Premium: por PDF Embedder Team – 5.1.2<br>Advanced Cron Manager: por BracketSpace – 2.5.2<br>Advanced Custom Fields: por WP Engine – 6.2.5<br>WooCommerce Advanced Product Labels: por BeRocket – 1.2.5.3<br>AffiliateWP - Affiliate Area Custom Styling: por Andrew Munro<br>Sumobi – 1.0
    
    AffiliateWP - Mis Pacientes: por Sandhills Development<br>LLC – 1.4
    
    AffiliateWP: por AffiliateWP – 2.21.0<br>AffiliateWP - Affiliate Area Tabs: por AffiliateWP – 1.4.1<br>AffiliateWP - Affiliate Info: por Sandhills Development<br>LLC – 1.2
    
    AffiliateWP - Affiliate QR Codes: por Sandhills Development<br>LLC – 1.0.3
    
    AffiliateWP - Direct Link Tracking: por Sandhills Development<br>LLC – 1.1.4
    
    AffiliateWP - Order Details For Affiliates: por Sandhills Development<br>LLC – 1.3
    
    AffiliateWP - Store Credit: por Sandhills Development<br>LLC – 2.5
    
    FiboSearch - AJAX Search for WooCommerce (Pro): por Equipo de FiboSearch – 1.26.1<br>Autocomplete WooCommerce Orders: por QuadLayers – 3.2.0<br>Awesome Support: FAQ: por Awesome Support – 3.1.3<br>Awesome Support: Smart Submit: por The Awesome Support Team – 1.0.1<br>Awesome Support: por Awesome Support Team – 6.1.7<br>Checkout Field Editor and Manager for WooCommerce: por Acowebs – 2.2.18<br>Editor clásico: por Colaboradores de WordPress – 1.6.3<br>Clone Woo Orders - Free by WP Masters: por WP Masters – 1.0.3<br>Code Snippets: por Code Snippets Pro – 3.6.2<br>Complianz | GDPR/CCPA Cookie Consent: por Really Simple Plugins – 6.5.6<br>Custom Template for LearnDash: por Pratik Chaskar – 1.0.6<br>Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.5<br>Dynamic.ooo - Dynamic Content for Elementor: por Dynamic.ooo – 2.12.7<br>Elementor Pro: por Elementor.com – 3.18.3<br>Elementor: por Elementor.com – 3.18.3<br>Extensions for Elementor Form: por EduardoVillao.me – 2.0.1<br>Directorio médico de la clínica: por e-plugin – 1.2.8<br>Integration for Elementor forms - Sendinblue: por Webtica – 1.5.6<br>Kadence WooCommerce Email Designer: por Kadence WP – 1.5.12<br>LearnDash LMS - Course Grid: por LearnDash – 2.0.5<br>LearnDash LMS - Elementor: por LearnDash – 1.0.3<br>LearnDash Licensing & Management: por LearnDash – 1.2<br>Notes for LearnDash: por SnapOrbital – 1.7.4<br>LearnDash LMS - Notifications: por LearnDash – 1.5.3<br>LearnDash LMS - WooCommerce Integration: por LearnDash – 1.9.7<br>Loco Translate: por Tim Whitlock – 2.6.6<br>Nav Menu Roles + WooCommerce Memberships Bridge: por Kathy Darling – 1.0.0<br>Nav Menu Roles: por Kathy Darling – 2.1.2<br>One Click Order Re-Order: por CedCommerce – 1.1.9<br>Popup Trigger URL for Elementor Pro: por Suki WordPress Theme – 1.0.5<br>Scriptless Social Sharing: por Robin Cornett – 3.2.4<br>LearnDash LMS: por LearnDash – 4.7.0.1<br>Shortcode Elementor: por RSTheme – 1.0.3<br>Timber: por Timber Team & Contributors – 1.23.0<br>TinyPNG - JPEG, PNG & WebP image compression: por TinyPNG – 3.4.3<br>User Role Editor: por Vladimir Garagulya – 4.64.1<br>WC Hide Shipping Methods: por Rynaldo Stoltz – 1.5<br>WC Vendors Marketplace: por WC Vendors – 2.4.7.3<br>Seguimiento avanzado de envíos para WooCommerce: por zorem – 3.6.5<br>WooCommerce Cart Abandonment Recovery: por CartFlows Inc – 1.2.26<br>WooCommerce Custom Add To Cart Button: por Barn2 Plugins – 1.2.2<br>Advanced Order Export For WooCommerce: por AlgolPlus – 3.4.5<br>NextMove Lite - Thank You Page for WooCommerce: por XLPlugins – 2.17.0<br>Variation Swatches for WooCommerce: por Emran Ahmed – 2.0.30<br>WooCommerce Advanced Shipping Packages: por Jeroen Sormani – 1.1.11<br>WooCommerce Advanced Shipping: por Jeroen Sormani – 1.1.2<br>Número de impuesto de la UE de WooCommerce: por WooCommerce – 2.8.7 (la actualización a la versión 2.8.9 está disponible)<br>WooCommerce Stripe Gateway: por WooCommerce – 7.9.1<br>WooCommerce Memberships: por SkyVerge – 1.26.0<br>PDF Invoices & Packing Slips for WooCommerce: por WP Overnight – 3.7.6<br>PDF Invoices & Packing Slips for WooCommerce - Professional: por WP Overnight – 2.15.6<br>Brevo - WooCommerce Email Marketing: por Brevo – 4.0.10<br>WooCommerce Shipping & Tax: por WooCommerce – 2.4.2<br>WooCommerce: por Automattic – 8.5.2<br>Wordfence Security: por Wordfence – 7.11.1<br>WordPress Importer: por wordpressdotorg – 0.8.2<br>Yoast SEO: por Equipo Yoast – 21.9.1<br>WP Crontrol: por John Blackbourn & crontributors – 1.16.1<br>WP Force SSL: por WebFactory Ltd – 1.65<br>WP Google Search: por WebshopLogic – 1.1.0<br>WP Mail SMTP: por WP Mail SMTP – 3.11.1<br>WP-UserOnline: por Lester 'GaMerZ' Chan – 2.88.3<br>YITH WooCommerce Ajax Product Filter Premium: por YITH – 4.30.0<br>YITH WooCommerce Wishlist Premium: por YITH – 3.29.0 Inactive Plugins (40)
    
    AffiliateWP - Affiliate Product Rates: por AffiliateWP – 1.2.1<br>AffiliateWP - Groups: por Click Studio – 1.6.14<br>AffiliateWP - Multi Level Affiliates: por Click Studio – 1.9.15<br>Asset CleanUp: Page Speed Booster: por Gabe Livan – 1.3.9.3<br>Backup Migration: por Migrate – 1.4.2<br>Classic Widgets: por WordPress Contributors – 0.3<br>Combo Blocks: por PickPlugins – 2.2.70<br>Currency Switcher for WooCommerce: por WP Wham – 2.15.2<br>Disable Cart Fragments: por Optimocha – 2.3<br>Duplicator: por Duplicator – 1.5.8<br>Freesoul Deactivate Plugins: por Jose Mortellaro – 2.1.9<br>Health Check & Troubleshooting: por The www.remarpro.com community – 1.7.0<br>Import Export WordPress Users and WooCommerce Customers: por WebToffee – 2.5.1<br>IP2Location Redirection: por IP2Location – 1.29.1<br>Mailchimp for WooCommerce: por Mailchimp – 3.6<br>Maintenance: por WebFactory Ltd – 4.08<br>Menu Icons: por ThemeIsle – 0.13.8<br>Password Protect WordPress Lite: por BWPS – 1.8.9<br>PDF Embedder: por WP PDF Embedder Team – 4.6.4<br>Performance Lab: por WordPress Performance Team – 2.8.0<br>Plugin Organizer: por Jeff Sterup – 10.1.10<br>Popup Maker: por Popup Maker – 1.18.2<br>Post Type Switcher: por Triple J Software<br>Inc. – 3.2.2
    
    Prevent Direct Access: por BWPS – 2.8.5<br>Query Monitor: por John Blackbourn – 3.15.0<br>Redirection: por John Godley – 5.4.1<br>Safe SVG: por 10up – 2.2.2<br>Simple Local Avatars: por 10up – 2.7.7<br>Tablesome: por Pauple – 1.0.26<br>Tawk.to Live Chat: por Tawkto – 0.8.2<br>UpdraftPlus - Backup/Restore: por UpdraftPlus.Com<br>DavidAnderson – 1.23.16
    
    Webinar and Video Conference with Jitsi Meet Pro: por WPPOOL – 1.7.3<br>When Last Login: por Yoohoo Plugins – 1.2.2<br>WooCommerce Country Restrictions - Advanced Pro: por WP Super Admins – 1.14.1<br>WooCommerce UPC, EAN, and ISBN: por Scott Bolinger – 0.5.1<br>WP-Optimize - Clean, Compress, Cache: por David Anderson<br>Ruhani Rabin<br>Team Updraft – 3.2.22
    
    WP Plugin Manager: por HasThemes – 1.2.1<br>WPS Cleaner: por WPServeur<br>NicolasKulka<br>wpformation – 1.6.9
    
    WP STAGING WordPress Backup Plugin - Backup Duplicator & Migration: por WP-STAGING<br>WPStagingBackup – 3.3.2
    
    WPvivid Backup Plugin: por WPvivid Team – 0.9.95 Dropin Plugins (2)
    
    advanced-cache.php: advanced-cache.php<br>maintenance.php: maintenance.php Settings
    
    API Enabled: –<br>Force SSL: ?<br>Currency: EUR (€)<br>Currency Position: right<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: course (course)<br>external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)
    
    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)
    
    Connected to Woo.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: ? WC Pages
    
    Base de la tienda: #3659 - /productos-laboratorios/<br>Carrito: #1282 - /carrito/<br>Finalizar compra: #1283 - /finalizar-compra/<br>Mi cuenta: #62165 - /mi-cuenta/<br>Términos y condiciones: #420 - /terminos-de-uso/ Theme
    
    Name: GeneratePress<br>Version: 3.3.1<br>Author URL: https://tomusborne.com<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
    
    WooCommerce Support: ? Templates
    
    Overrides: – Memberships
    
    Restriction mode:: Redirect to page<br>Public content:: Doctor: 1 itemProductos: 1 itemPáginas: 1 item<br>Excluded from discounts:: –<br>Planes:: 8<br>Authorization 1 month:: Members: 0Access method: Product(s) purchaseAccess length: Specific length (1 months)<br>Full Auth UK:: Members: 3Access method: Product(s) purchaseAccess length: Unlimited<br>Autorización Suplementos:: Members: 1330Access method: Product(s) purchaseAccess length: Unlimited<br>3 meses Autorización Plena:: Members: 23Access method: Product(s) purchaseAccess length: Specific length (90 days)<br>6 meses Autorización Plena:: Members: 4Access method: Product(s) purchaseAccess length: Specific length (90 days)<br>Suscripción Básica:: Members: 1780Access method: User account registrationAccess length: Unlimited<br>Autorización Plena permanente:: Members: 1295Access method: Product(s) purchaseAccess length: Unlimited<br>Plan Afiliados:: Members: 429Access method: Product(s) purchaseAccess length: Unlimited Admin
    
    Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<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>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
    
    Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-linked<br>settings<br>async-product-editor-category-field
    
    Daily Cron: ? Next scheduled: 2024-01-27 15:50:08 +01:00<br>Options: ?<br>Notes: 24<br>Onboarding: completed Action Scheduler
    
    Completo: 1.683<br>Oldest: 2023-12-26 18:59:39 +0000<br>Newest: 2024-01-26 16:49:16 +0000
    
    Fallida: 576.626<br>Oldest: 2022-10-21 15:44:06 +0000<br>Newest: 2023-11-30 13:50:47 +0000
    
    Pendiente: 12<br>Oldest: 2024-01-26 16:57:13 +0000<br>Newest: 2024-12-31 23:00:01 +0000 Status report information
    
    Generated at: 2024-01-26 17:57:44 +01:00<br>

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

Viewing 15 replies - 16 through 30 (of 36 total)
  • Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    They remain pending

    ?? hola @pablorodriguezsierra

    Thank you for reaching back, with further details on this.

    The following:

    I find that woocommerce’s cron jobs are no execunting

    Appears to be resulting in this (orders still pending).

    To clarify, was this known before activating HPOS, or otherwise?

    Nevertheless, as the case is like this now, did you already have an opportunity to investigate the server cron issue further, or otherwise?

    Otherwise, it might be worth reverting to WordPress Cron, temporarily, and see how it goes.

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    I think they are running now, but here is what i’ve discovered:
    When I switch to hpos, there’s no link showing pending orders, so I also deactivate compatibility mode. Then I refresh and there they are, and stay there for ever. I then activate the compatibility mode back again, and orders start to sync. The number went down to 1.000.

    Refresh and no pending orders to sync, so I deactivate compatibility mode and 999 orders are pending. I then clic the sync link, refresh and orders have gone down to 996. Refresh and now 986, but further attemps to refresh show no progress at all.

    I then activate compatibility mode again, I get a 500 error, refresh again and no orders are pending. Switch off compatibility mode criticar error occurs, refresh and again, 999 orders sync pending. Hit the sync link again and back to where we started

    You might ask your self why I’m going back and forth with hpos? It’s because I have a snippet that shows order’s notes on the order’s dashboard, and that is no working now since hpos started. Here’s the code:

    // WooCommerce – Add order notes column to orders list
    // Code goes in functions.php for your child theme
    // not tested in a PHP snippet plugin

    // Add column “Order Notes” on the orders page
    add_filter( ‘manage_edit-shop_order_columns’, ‘add_order_notes_column’ );
    function add_order_notes_column( $columns ) {
    $new_columns = ( is_array( $columns ) ) ? $columns : array();
    $new_columns[‘order_notes’] = ‘Order Notes’;
    return $new_columns;
    }

    add_action( ‘admin_print_styles’, ‘add_order_notes_column_style’ );
    function add_order_notes_column_style() {
    $css = ‘.post-type-shop_order table.widefat.fixed { table-layout: auto; width: 100%; }’;
    $css .= ‘table.wp-list-table .column-order_notes { min-width: 280px; text-align: left; }’;
    $css .= ‘.column-order_notes ul { margin: 0 0 0 18px; list-style-type: disc; }’;
    $css .= ‘.order_customer_note { color: #ee0000; }’; // red
    $css .= ‘.order_private_note { color: #0000ee; }’; // blue
    wp_add_inline_style( ‘woocommerce_admin_styles’, $css );
    }

    // Add order notes to the “Order Notes” column
    add_action( ‘manage_shop_order_posts_custom_column’, ‘add_order_notes_content’ );
    function add_order_notes_content( $column ) {
    if( $column != ‘order_notes’ ) return;
    global $post, $the_order;
    if( empty( $the_order ) || $the_order->get_id() != $post->ID ) {
    $the_order = wc_get_order( $post->ID );
    }
    $args = array();
    $args[‘order_id’] = $the_order->get_id();
    $args[‘order_by’] = ‘date_created’;
    $args[‘order’] = ‘ASC’;
    $notes = wc_get_order_notes( $args );
    if( $notes ) {
    print ‘

    • ‘; } else { print ‘
    • ‘; } $date = date( ‘d/m/y H:i’, strtotime( $note->date_created ) ); print $date.’ by ‘.$note->added_by.’
      ‘.$note->content.’

    ‘;
    }
    } // end function

    What do you think is going on?

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @pablorodriguezsierra,

    When you enable HPOS, the pending orders aren’t showing up as expected. However, when you deactivate the compatibility mode, the pending orders appear but don’t sync properly. This behaviour suggests there might be a conflict between HPOS and cron functionality.

    Regarding the order notes not showing up on the dashboard, the custom snippet you’ve added may be incompatible with HPOS. The snippet might not be able to retrieve the order notes correctly due to the changes HPOS introduces.

    To troubleshoot this issue, I recommend the following steps:

    1. Check your server logs for any error messages related to WooCommerce. These logs can provide valuable insights into what might be causing the problem.
    2. Temporarily disable all other plugins except for WooCommerce to see if there’s a plugin conflict.
    3. Switch to a default WordPress theme like Storefront to rule out any theme-related issues.
    4. Disable to remove all the custom code you have added and see if the issue exists or not.

    Let us know how that goes. Looking forward to hearing from you!

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Thanks Shameen, as I’m loosing functions like order cloning plugin, the notes display, and maybe others I haven’t discovered yet, I have to rollback until things get more mature. Any options you can suggest?

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @pablorodriguezsierra,

    Rolling back to a previous version of WooCommerce could be an option, but we always recommend using the latest version.

    Another alternative could be to use a staging site to test the latest WooCommerce updates before applying them to your live site. This way, you can ensure that everything works as expected without affecting your live site.

    For the issues with the order cloning plugin and notes display, it might be worth reaching out to the plugin developers for support. They may be able to provide a solution or update to make their plugins compatible with the latest version of WooCommerce.

    Alternatively, you may consider hiring a developer to help resolve these issues. They could review your site’s configuration and custom code to identify and fix any compatibility issues.

    I hope this clarifies your concern. If you have any other questions, feel free to ask.

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Hello again, I’ve tested the platform taking out everything but woocommerce, and it’s still not working, in the sense that there are always around 1000 orders syncronizing, it goes slow, and it collapses bringing the server down several times a day.
    I’ve noticed on the server that this appearing many times collapsing the cpu:
    POST /wp-admin/admin-ajax.php HTTP/1.0

    Please give me some guidance. Cron Jobs are being trigeered by the server every 30 minutes.

    Hi there @pablorodriguezsierra,

    Cron Jobs are being trigeered by the server every 30 minutes.

    As a workaround to delete all those schedule actions in the SQL database, please try using this SQL code in phpmyadmin:

    DELETE FROM ‘wp_actionscheduler_actions’ WHERE ‘status’ = ‘complete’
    DELETE FROM ‘wp_actionscheduler_actions’ WHERE ‘status’ = ‘canceled’
    DELETE FROM ‘wp_actionscheduler_actions’ WHERE ‘status’ = ‘failed’

    Let us know how it goes.

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Hi Ckadenge, and thanks for the tip. Befor doing that, I managed to stabilize the whole thing (server was being collapsed several times recurrently). What I did was to leave HPOS active, and activate compatibility mode, as shown in the image below.
    Once I did that, orders started to sync quickly and the server didn’t overload again, so far.
    The downside is to have the compatibility active, if this slows down the order processing, does it?

    Thanks

    Hello @pablorodriguezsierra,

    It’s great to hear that you’ve managed to stabilize your server by keeping HPOS active and activating the compatibility mode.

    When you activate compatibility mode, it might not significantly slow down your order processing. This is because the mode is designed to guarantee maximum compatibility with different environments. This might need a bit more processing time. However, usually, this doesn’t impact speed, and it shouldn’t significantly affect your overall operation.

    Please monitor your site’s performance and if you notice any significant slowdown, do not hesitate to get back to us.

    Cheers!

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Well, the “stable so far” didn’t last for long, things have just gone south… The server is collapsing continuosly, since experimenting with HPOS, the bottom line is that it doesn’t really work.

    The last move, minutes ago, was to return to the wordpress tables and see if we can return to square cero again.

    We are loosing sales and reputation, not good at all. Moving those daily jobs to night time didn’t help, as once again, starting at the same time as the day before, CPU went up, apache too, and memory aswell. Many requests.

    Maybe this gives you a clue about whats going on:
    returning to wordpress tables was just saving changes and instantly taking the new configuration. But, while still keeping the compatibility mode on, I’ve returned to HPOS, and this time, for the first time, after a few seconds it took to save the configuration, no “pending orders syn” message was displayed.

    Hello @pablorodriguezsierra,

    I’m sorry to hear that the issue persists even after a temporary fix.

    Since there has been a recent update to WooCommerce, could you please try updating to the latest version and let us know if this makes any changes?

    Please be sure to back up your site before performing the update.

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Hi Ckadenge, you are looking at what good news looks like.

    Although I tried to delete all the finished, canceled or failed jobs, there were son many that the query didn’t complete. So this is what I did:
    DELETE FROM wpcncr_actionscheduler_actions WHERE status IN (‘complete’, ‘canceled’, ‘failed’);

    Hundreads of thousands or maybe some millions deleted. This was the game changer. From then on. I’ve been monitoring and cleaning since that. In a few hours, the completed jobs grow by the tens of thousands

    Woocommerce updated, cron jobs executed, and still stuck with hpos without compatibility mode

    It stays there for ever, with pending orders, even growing a bit in numbers, until I activate compatibility mode again. When I reactivate compatibility mode, it takes a while, gives back a 503, and then this

    Same thing, but eventually, this syncs orders (not doing so after updating woocommerce, so far…).

    So, can I introduce a job that does the cleaning
    DELETE FROM wpcncr_actionscheduler_actions WHERE status IN (‘complete’, ‘canceled’, ‘failed’);
    and if so, how and with what frequency would you suggest?
    And then, what should I do with the imposibility to finally take out the compatibility nmode without having these orders sync pending for ever?

    Thread Starter pablorodriguezsierra

    (@pablorodriguezsierra)

    Finally got to sync the pending orders by manually excecuting due tasks, like import orders. I’m not going to take out compatibility mode until you can tell me a way of safely doing it

    ?? hi there @pablorodriguezsierra

    Finally got to sync the pending orders by manually excecuting due tasks, like import orders.

    That’s great to hear! Thanks for letting us know.

    I’m not going to take out compatibility mode until you can tell me a way of safely doing it

    It is advisable to maintain compatibility mode for some time to ensure a seamless transition. In case of any issues, reverting to the?_posts?table can be done instantly.

    When the?High-performance order storage (recommended)?and?compatibility mode?options are both selected, WooCommerce populates the HPOS tables with data from?_posts?and?_postmeta?tables.?Learn more about synchronization between tables.

    Feel free to refer to the official documentation, linked here, for more.

    We’re happy to help, so please feel free to let us know if you have any other questions.

Viewing 15 replies - 16 through 30 (of 36 total)
  • The topic ‘hpos checkout error’ is closed to new replies.