HPOS (exclusive) incompatibility

  • Resolved dimitrisv

    (@dimitrisv)


    11 months, 4 weeks ago

    He are migrating to HPOS. When opting to use the HPOS option (instead of the postmeta), in the view orders page (/wp-admin/edit.php?post_type=shop_order ) we are getting a fatal error with this entry:

    [Tue May 02 09:14:46.996186 2023] [proxy_fcgi:error] [pid 28930:tid 139700723513088] [client 143.58.222.86:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught TypeError: Argument 2 passed to Automattic\\WooCommerce\\Utilities\\ArrayUtil::d…………il::deep_compute_or_compare_array_diff()\n#2 /home/xxxxx.cloudwaysapps.com/qsdtxkdjvv/public_html/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/OrdersTableDataStore.php(1268): Automatti…’, referer: https://femme-fatale.gr/wp-admin/

    Please let us know what is happening.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Igor H

    (@ihereira)

    11 months, 3 weeks ago

    Hello,

    I understand you are migrating to HPOS, and then the site is receiving the error message above.

    Can you tell me which PHP version is your site using? And what is the database version?

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. 

    That will provide us more information to check.

    Thread Starter dimitrisv

    (@dimitrisv)

    11 months, 3 weeks ago

    Yes I am. The issue is present on both php 7.4 and 8.0 (I have tested on both).

    Here is the system status report for the php 8.0 implementation. 

    WordPress Environment

WordPress address (URL): https://v3.femme-fatale.gr
    Site address (URL): https://v3.femme-fatale.gr
    WC Version: 7.6.1
    REST API Version: ✔ 7.6.1
    WC Blocks Version: ✔ 10.1.0
    Action Scheduler Version: ✔ 3.5.4
    Log Directory Writable: ✔
    WP Version: 6.2
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: el
    External object cache: ✔

Server Environment

Server Info: Apache
    PHP Version: 8.0.28
    PHP Post Max Size: 100 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 100000
    cURL Version: 7.87.0
    OpenSSL/1.1.1p

SUHOSIN Installed: –
    MySQL Version: 8.0.33
    Max Upload Size: 100 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: 7.6.1
    WC Database Prefix: wp_
    Total Database Size: 2075.06MB
    Database Data Size: 1086.76MB
    Database Index Size: 988.30MB
    wp_woocommerce_sessions: Data: 162.20MB + Index: 2.33MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 11.52MB + Index: 5.52MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 55.59MB + Index: 60.16MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_acsell_product_data: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 13.41MB + Index: 15.44MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 16.36MB + Index: 9.92MB + Engine InnoDB
    wp_admin_columns: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_aioseo_cache: Data: 4.52MB + Index: 2.81MB + Engine InnoDB
    wp_aioseo_links: Data: 22.56MB + Index: 1.98MB + Engine InnoDB
    wp_aioseo_links_suggestions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_aioseo_notifications: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wp_aioseo_posts: Data: 27.56MB + Index: 1.52MB + Engine InnoDB
    wp_aioseo_redirects: Data: 6.52MB + Index: 6.28MB + Engine InnoDB
    wp_aioseo_redirects_404: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_aioseo_redirects_404_logs: Data: 6.52MB + Index: 1.84MB + Engine InnoDB
    wp_aioseo_redirects_hits: Data: 0.47MB + Index: 0.53MB + Engine InnoDB
    wp_aioseo_redirects_logs: Data: 9.52MB + Index: 3.34MB + Engine InnoDB
    wp_aioseo_search_statistics_objects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_aioseo_terms: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
    wp_alphabank_transactions: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_automatewoo_abandoned_carts: Data: 1.52MB + Index: 0.08MB + Engine InnoDB
    wp_automatewoo_customer_meta: Data: 1.52MB + Index: 2.03MB + Engine InnoDB
    wp_automatewoo_customers: Data: 2.52MB + Index: 6.94MB + Engine InnoDB
    wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_automatewoo_guests: Data: 1.52MB + Index: 3.64MB + Engine InnoDB
    wp_automatewoo_log_meta: Data: 6.52MB + Index: 7.03MB + Engine InnoDB
    wp_automatewoo_logs: Data: 1.52MB + Index: 3.41MB + Engine InnoDB
    wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_automatewoo_referral_advocate_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_automatewoo_referral_invites: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bv_ip_store: Data: 0.39MB + Index: 0.36MB + Engine InnoDB
    wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cardlink_gateway_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_comments: Data: 18.56MB + Index: 22.61MB + Engine InnoDB
    wp_cs_proof_consent: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wp_cs_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cs_scan_cookies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cs_scan_scripts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cs_stats_consent: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_cs_unblock_ip: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_events: Data: 26.55MB + Index: 0.00MB + Engine InnoDB
    wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 0.31MB + Index: 0.06MB + Engine InnoDB
    wp_gf_entry_meta: Data: 1.52MB + Index: 2.17MB + Engine InnoDB
    wp_gf_entry_notes: Data: 0.23MB + Index: 0.06MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 1.16MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
    wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_masterslider_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_masterslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mo_openid_linked_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_certificates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_course_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_history: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_homework_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_homeworks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_solution_files: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_student_certificates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_student_courses: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_student_homeworks: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_student_lessons: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_student_modules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_visits: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
    wp_namaste_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastecon_activities: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_namastecon_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastecon_maillog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_namastecon_newsletters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_badges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_bundles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_class_managers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_classes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_coupons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_delayed_access: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_school_signups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_school_students: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_shopcarts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_namastepro_student_classes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 12.03MB + Index: 0.59MB + Engine InnoDB
    wp_pmxe_exports: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
    wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wp_pmxe_posts: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
    wp_pmxe_templates: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_hash: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_images: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_imports: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_posts: Data: 12.52MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_templates: Data: 1.45MB + Index: 0.00MB + Engine InnoDB
    wp_po_plugins: Data: 10.52MB + Index: 10.06MB + Engine InnoDB
    wp_pods_cssurvey: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_pods_cssurveypd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pods_order_products_analytics: Data: 12.52MB + Index: 3.52MB + Engine InnoDB
    wp_pods_order_stats: Data: 12.55MB + Index: 1.52MB + Engine InnoDB
    wp_pods_product_brands: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    wp_pods_product_vitals: Data: 11.52MB + Index: 0.30MB + Engine InnoDB
    wp_pods_reciprocal_product: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_podsrel: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_postmeta: Data: 279.84MB + Index: 485.95MB + Engine InnoDB
    wp_posts: Data: 72.61MB + Index: 23.11MB + Engine InnoDB
    wp_pys_stat_landing: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_order: Data: 0.33MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_product_order: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_sbi_feed_caches: Data: 0.16MB + Index: 0.02MB + Engine InnoDB
    wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_searchwp_status: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
    wp_searchwp_tokens: Data: 7.52MB + Index: 15.55MB + Engine InnoDB
    wp_sgs_log_events: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
    wp_sgs_log_visitors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_swpext_metrics_clicks: Data: 0.47MB + Index: 0.53MB + Engine InnoDB
    wp_swpext_metrics_ids: Data: 14.52MB + Index: 20.09MB + Engine InnoDB
    wp_swpext_metrics_meta: Data: 24.56MB + Index: 21.58MB + Engine InnoDB
    wp_swpext_metrics_queries: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    wp_swpext_metrics_searches: Data: 10.52MB + Index: 25.58MB + Engine InnoDB
    wp_term_relationships: Data: 5.52MB + Index: 4.52MB + Engine InnoDB
    wp_term_taxonomy: Data: 1.52MB + Index: 0.64MB + Engine InnoDB
    wp_termmeta: Data: 2.52MB + Index: 5.55MB + Engine InnoDB
    wp_terms: Data: 0.45MB + Index: 0.53MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 19.55MB + Index: 55.78MB + Engine InnoDB
    wp_users: Data: 1.52MB + Index: 1.22MB + Engine InnoDB
    wp_vivawallet_data: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 2.52MB + Index: 2.02MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_addresses: Data: 7.52MB + Index: 11.06MB + Engine InnoDB
    wp_wc_order_composite_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_operational_data: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 8.52MB + Index: 12.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_orders: Data: 7.52MB + Index: 12.61MB + Engine InnoDB
    wp_wc_orders_meta: Data: 32.56MB + Index: 72.53MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 2.52MB + Index: 3.52MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 2.52MB + Index: 4.38MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wiz_cummulative_order_stats: Data: 9.52MB + Index: 2.52MB + Engine InnoDB
    wp_wiz_order_products_entry: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    wp_wiz_order_products_exit: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    wp_wiz_order_products_freq_entry: Data: 2.52MB + Index: 0.14MB + Engine InnoDB
    wp_wiz_order_products_freq_exit: Data: 2.52MB + Index: 0.14MB + Engine InnoDB
    wp_wiz_order_products_freq_single_item_orders: Data: 1.52MB + Index: 0.08MB + Engine InnoDB
    wp_wiz_order_products_single_orders: Data: 1.52MB + Index: 0.31MB + Engine InnoDB
    wp_wiz_order_stats: Data: 13.55MB + Index: 1.52MB + Engine InnoDB
    wp_wiz_product_brands: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    wp_woobe_history: Data: 1.52MB + Index: 2.05MB + Engine InnoDB
    wp_woobe_history_bulk: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_orders: Data: 7.52MB + Index: 3.53MB + Engine InnoDB
    wp_woocommerce_pickup_locations_geodata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_recommendations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_session_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woot_tables: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_woot_tables_columns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woot_tables_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woot_vocabulary: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wpdatacharts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wpdatatables: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wpdatatables_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpdatatables_columns: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
    wp_wpdatatables_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpr_rocket_cache: Data: 2.52MB + Index: 3.58MB + Engine InnoDB
    wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB

Post Type Counts

_pods_field: 215
    _pods_group: 9
    _pods_pod: 9
    attachment: 23675
    aw_workflow: 12
    consentmagic: 3
    cookielawinfo: 6
    cpt_variation_fields: 1
    cs-template: 4
    custom_css: 3
    customize_changeset: 25
    faq: 3
    fgf_rules: 1
    filter_group: 1
    gfw_event: 2
    gfw_report: 520
    gift_card: 1
    mailpoet_page: 1
    mgmlp_media_folder: 95
    namaste_course: 17
    namaste_homework: 4
    namaste_lesson: 28
    named_filter_type: 33
    nav_menu_item: 712
    oembed_cache: 1
    page: 84
    plugin_filter: 4
    post: 78
    product: 13395
    product_variation: 3551
    revision: 8
    saved_reply: 2
    shop_coupon: 65
    shop_order: 28426
    shop_order_refund: 5
    tdb_templates: 24
    tds_locker: 1
    ticket: 17
    wc_pickup_location: 4
    wcpf_item: 8
    wcpf_project: 1
    wishlist: 4
    wp_block: 4
    wp_global_styles: 2
    wpcode: 2
    wpforms: 2
    yith_wcan_preset: 1
    yith_wcps_type: 3

Security

Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔

Active Plugins (98)

Disable Bloat for WordPress & WooCommerce: by Disable Bloat – 3.2.2
    Acsell Product Filters: by Acsell – 1.0.5
    AIOSEO - Image SEO: by All in One SEO Team – 1.1.7
    AIOSEO - IndexNow: by All in One SEO Team – 1.0.10
    AIOSEO - Local Business: by All in One SEO Team – 1.2.16
    AIOSEO - Redirects: by All in One SEO Team – 1.2.10
    All in One SEO Pro: by All in One SEO Team – 4.3.6.1
    aThemes Blocks: by aThemes – 1.0.10
    aThemes Starter Sites: by aThemes – 1.0.35
    AutoConvert Greeklish Permalinks: by Dimitris Mavroudis – 4.1.1
    AutomateWoo - Birthdays Add-on: by WooCommerce – 1.3.17
    AutomateWoo - Refer A Friend Add-on: by WooCommerce – 2.6.19
    AutomateWoo: by WooCommerce – 5.7.2
    BestPrice 360 Analytics Integration: by BestPrice – 1.1.1
    Better Search Replace Pro: by Delicious Brains – 1.4.2
    Botiga Pro: by aThemes – 1.2.2
    Change Date Language (English speakers): by Marco Foggia – 0.1.1
    CIO Custom Fields Importer: by VisualData – 1.0.3
    Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
    Free Gifts for WooCommerce: by Flintop – 9.5.0
    Gravity Forms Color Picker: by JetSloth – 1.1.41
    Site Kit by Google: by Google – 1.99.0
    Gravity Forms: by Gravity Forms – 2.7.4
    Gravity Forms Google Analytics Add-On: by Gravity Forms – 1.2
    Gravity Forms Survey Add-On: by Gravity Forms – 3.8
    Gravity Forms User Registration Add-On: by Gravity Forms – 5.1
    GTmetrix for WordPress: by GTmetrix – 0.4.6
    WooCommerce Custom Fields for Variations by Iconic: by Iconic – 1.4.0
    Index WP MySQL For Speed: by Oliver Jones
    Rick James – 1.4.12

Instagram Feed Pro Developer: by Smash Balloon – 6.2.2
    Loco Translate: by Tim Whitlock – 2.6.4
    Max Mega Menu: by megamenu.com – 3.2.2
    Members: by MemberPress – 3.2.5
    Namaste! Connect: by Kiboko Labs – 1.0.7
    Namaste! LMS: by Kiboko Labs – 2.6
    Namaste! PRO: by Kiboko Labs – 1.5.6
    Object Cache Pro: by Rhubarb Group – 1.18.0
    PDF Bridge: by Kiboko Labs – 1.9
    PixelYourSite PRO: by PixelYourSite – 9.5.5
    PixelYourSite Super Pack: by PixelYourSite – 3.2.0
    Plugin Organizer: by Jeff Sterup – 10.1.9
    Pods Gravity Forms Add-On: by Pods Framework Team – 1.4.5
    Pods - Custom Content Types and Fields: by Pods Framework Team – 2.9.13
    Preserve Page and Taxonomy Hierarchy on Edit Menus Screen: by Sergey Biryukov – 0.1
    Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.3.1
    ReOrder Posts within Categories: by Aurorata V. – 2.14.1
    Repeat Order for Woocommerce: by polyres – 1.2.0
    SearchWP Custom Results Order: by SearchWP – 1.3.6
    SearchWP Customizations: by – 1.0.2
    SearchWP Metrics: by SearchWP – 1.4.3
    SearchWP Related: by SearchWP – 1.4.8
    SearchWP WooCommerce Integration: by SearchWP – 1.3.11
    SearchWP: by SearchWP – 4.3.1
    SiteGround Security: by SiteGround – 1.4.3
    Skroutz Analytics for WooCommerce: by Skroutz – 1.7.1
    Category Order and Taxonomy Terms Order: by Nsp-Code – 1.7.5
    TC Custom JavaScript: by Tiny Code – 1.2.3
    Temporary Login Without Password: by StoreApps – 1.8.1.1
    Timologia for WooCommerce: by John Athanasiou – 5.0
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.23.3.26

User Role Editor: by Vladimir Garagulya – 4.63.3
    Variable Font Sizes for Mobile: by Dimitris Vayenas - Oxford Metadata – 1.1.0
    Visual Term Description Editor: by Shea Bunge – 1.8.1
    Viva Wallet Smart Checkout: by Viva Wallet – 3.6.8
    Phone Orders and Payments: by 99w – 1.3.0
    Master-Detail Tables for wpDataTables: by TMS-Plugins – 1.3.5
    Powerful Filters for wpDataTables: by TMS-Plugins – 1.4.2
    weLaunch Framework: by weLaunch.io – 1.0.14
    WooCommerce UPC, EAN, and ISBN: by Scott Bolinger – 0.5.1
    WooCommerce Blocks: by Automattic – 10.1.0
    WooCommerce XML feed for Skroutz & Bestprice: by Papaki – 1.6.9.1
    WooCommerce Payment Gateway Based Fees: by InoPlugs – 3.2.3
    Woocommerce Advanced Categories: by weLaunch – 1.2.20
    BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 2.1.2
    WooCommerce Composite Products: by WooCommerce – 8.7.4
    Gift Wrapper Plus: by Sagehen Studio – 5.2.11
    WooCommerce Packing Slips: by weLaunch – 1.2.10
    WooCommerce PayPal Payments: by WooCommerce – 2.0.4
    WooCommerce Product Manual Sorting Performance Improvement: by Hayden Whiteman –
    WooCommerce Shipping & Tax: by WooCommerce – 2.2.4
    WooCommerce Shipment Tracking: by WooCommerce – 2.0.0
    WooCommerce Local Pickup Plus: by SkyVerge – 2.9.10
    WooCommerce Shop the Look: by weLaunch – 1.0.8
    WooCommerce Social Login: by SkyVerge – 2.12.0
    WooCommerce Table Rate Shipping: by WooCommerce – 3.1.0
    WooCommerce Ultimate Pricing: by weLaunch – 1.1.4
    WooCommerce: by Automattic – 7.6.1
    WOOT - WooCommerce Active Products Tables: by realmag777 – 2.0.5
    WP All Export Pro: by Soflyy – 1.8.3
    WP All Import Pro: by Soflyy – 4.7.8
    BOX NOW Delivery: by BOX NOW – 1.5
    WP Mail SMTP: by WP Mail SMTP – 3.8.0
    WP Rocket | Remove HTML Expires from .htaccess rules: by WP Rocket Support Team –
    WP Rocket: by WP Media – 3.13.1
    WP All Export - User Export Add-On Pro: by Soflyy – 1.0.7
    WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.6
    WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 3.3.4
    wpDataTables: by TMS-Plugins – 5.5

Inactive Plugins (12)

Akismet Anti-Spam: by Automattic – 5.1
    ConsentMagic Pro: by ConsentMagic – 2.0.1
    CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.9
    Envato Market: by Envato – 2.0.8
    Gravity Forms Polls Add-On: by Gravity Forms – 4.0
    Hello Dolly: by Matt Mullenweg – 1.7.2
    Mouseflow for WordPress: by Mouseflow – 5.1.2
    Post Types Order: by Nsp Code – 2.0.5
    SearchWP Redirects: by SearchWP – 1.4.2
    WP All Import - User Import Add-On Pro: by Soflyy – 1.1.7
    WP Rocket - D-bugger: by WP Rocket Support Team – 1.2.1
    WP Snow - Best Snow Effect Plugin: by Ironikus – 1.0.2

Dropin Plugins (2)

advanced-cache.php: advanced-cache.php
    object-cache.php: Object Cache Pro (Drop-in)

Must Use Plugins (2)

CDN Cache Plugin: by – 1.1.3
    Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.12

Settings

API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: simple (simple)
    grouped (grouped)
    variable (variable)
    external (external)
    composite (composite)

Taxonomies: Product Visibility: exclude-from-search (exclude-from-search)
    exclude-from-catalog (exclude-from-catalog)
    featured (featured)
    outofstock (outofstock)
    rated-5 (rated-5)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)

Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: –
    Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
    HPOS data sync enabled: ✔

WC Pages

Shop base: #29019 - /shop/
    Cart: #29049 - /cart/
    Checkout: #29050 - /checkout/
    My account: #29051 - /my-account/
    Terms and conditions: #29755 - /terms/

Theme

Name: FemmeFatale
    Version: 11.4
    Author URL: https://about.gr
    Child Theme: ✔
    Parent Theme Name: Botiga
    Parent Theme Version: 2.0.8
    Parent Theme Author URL: https://athemes.com
    WooCommerce Support: ✔

Templates

Overrides: femmefatale/woocommerce/checkout/thankyou.php
    /home/ty5pbva/public_html/wp-content/plugins/woocommerce/templates/content-product-cat.php
    femmefatale/woocommerce/content-product.php

Composite Products

Database Version: 8.7.4
    Loopback Test: ✔
    Template Overrides: –

WooCommerce PayPal Payments

Onboarded: ✔
    Shop country code: GR
    WooCommerce currency supported: ✔
    Advanced Card Processing available in country: –
    Pay Later messaging available in country: –
    Webhook status: ✔
    Vault enabled: ✔
    Logging enabled: ✔
    Reference Transactions: –
    Used PayPal Checkout plugin: –
    Tracking enabled: ✔

Admin

Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page

Disabled Features: block-editor-feature-enabled
    minified-js
    new-product-management-experience
    product-variation-management
    settings

Daily Cron: ✔ Next scheduled: 2023-05-04 09:05:25 +02:00
    Options: ✔
    Notes: 109
    Onboarding: completed

Local Pickup Plus

Status: ✔ Enabled
    Geocoding: –
    Pickup Locations: 4
    Pickup Appointments: –
    Pickup Location Tax: ✔
    Checkout Display: Pickup selection mode: per orderCart item handling mode: automatic groupingDefault cart item handling: pickup items

Social Login

Facebook: ✔ Available
    Twitter: Disabled
    Google: ✔ Available
    Amazon: Disabled
    Linkedin: Disabled
    Paypal: Disabled
    Disqus: Disabled
    Vkontakte: Disabled

Action Scheduler

Complete: 46,561
    Oldest: 2023-04-29 14:02:01 +0000
    Newest: 2023-05-03 12:44:56 +0000

Failed: 449
    Oldest: 2023-03-04 08:00:04 +0000
    Newest: 2023-05-02 14:02:27 +0000

Pending: 10
    Oldest: 2023-05-03 12:56:27 +0000
    Newest: 2023-05-10 12:41:27 +0000

Status report information

Generated at: 2023-05-03 14:44:59 +02:00
    `

    Just to add that in the php 7.4 installation the core system info is as follows:

    erver Info: Apache/2.4.54 (Debian)
    PHP Version: 7.4.27
    PHP Post Max Size: 512 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 20000
    cURL Version: 7.64.0
    OpenSSL/1.1.1d

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.6.3-MariaDB-1:10.6.3+maria~buster-log
    Max Upload Size: 500 MB

    If you like I can provide you with credentials to check it out (please provide details on how to share these privately).

    • This reply was modified 11 months, 3 weeks ago by dimitrisv.
    Igor H

    (@ihereira)

    11 months, 3 weeks ago

    Hello,

    Thank you for sending the system report.

    Can you try the following to see if that makes a difference? Switch the site theme to Storefront temporarily, and then disable all plugins except WooCommerce.

    At this point, check again to see if the issue persists, if not, it means a conflict was affecting the site, and you can then switch back your theme to the original one, and start reactivating the rest of the plugins (checking one by one, after each plugin reactivation), until you find the cause of the issue.

    More info: https://woocommerce.com/document/how-to-test-for-conflicts/

    I understand doing this is not always an easy task, you can configure a staging site to run the test, we recommend WP Staging for this purpose.

    Let us know if there are any questions.

    Thread Starter dimitrisv

    (@dimitrisv)

    11 months, 3 weeks ago

    The culprit is this plugin:

    Local Pickup Plus – WooCommerce

    It is not HPOS compatible yet and it is the one causing the issue.

    We are migrating from this to the default Local Pickup options offered by Woocommerce.

    It will be great if the Woocommmerce team can add a “details” section for each location, so that the users can receive the exact address of the location they selected.

    xue28 (woo-hc)

    (@xue28)

    11 months, 3 weeks ago

    Hi @dimitrisv

    Thanks for trying @ihereira suggestion above and I’m glad you were able to find the culprit of the issue here which is the premium plugin Local Pickup Plus.

    Since you are using the premium plugin Local Pickup Plus and you have a valid license with us, can you please open a support request for us to investigate further about your issue?

    Thanks!

    Thread Starter dimitrisv

    (@dimitrisv)

    11 months, 3 weeks ago

    Yes, I will do. For the time being though I disabled your plugin and moved to the out of the box local pickup functionality… and when you are ready I will re-activate it!

    xue28 (woo-hc)

    (@xue28)

    11 months, 2 weeks ago

    Hi @dimitrisv

    I’m glad you were able to find a workaround to your issue here.

    I will be marking this thread as resolved. Should you have further inquiries, kindly create a new topic here.

    Please do not forget to raise a support request so that our developers are aware of your issue.

    Thanks!

    Thread Starter dimitrisv

    (@dimitrisv)

    11 months, 2 weeks ago

    I did open the topic there.

    Please note however that this behaviour is only observed when the HPOS is enabled and active but the replication to post meta feature is enabled.

    If replication is disabled this error is not a destructive one; the page renders “ok”.

    xue28 (woo-hc)

    (@xue28)

    11 months, 1 week ago

    Hi @dimitrisv

    This is well noted.

    Since you’ve already raised a bug report about this issue, our developers will be able to assist you from there.

    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘HPOS (exclusive) incompatibility’ is closed to new replies.