HPOS (exclusive) incompatibility
-
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.
-
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.
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.1dSUHOSIN Installed: –
MySQL Version: 5.5.5-10.6.3-MariaDB-1:10.6.3+maria~buster-log
Max Upload Size: 500 MBIf 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 1 year, 6 months ago by dimitrisv.
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.
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.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!
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!
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!
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”.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!
- The topic ‘HPOS (exclusive) incompatibility’ is closed to new replies.