Empty Bin with deleted orders while HPOS enabled
-
Hello,
I have just enabled HPOS for my store and everything works OK. The only problem I faced is when I try to empty the bin of past/test orders, I get a critical error. If I try to bulk delete I get a critical error and when I revisit the page, only one of the orders I selected in bulk was deleted.
Is there any known issue about this? Can you please have a look?
Kind regards,
Barnabas
-
Hey @barnabas1 ,
Thanks for reaching out!
It looks like enabling HPOS has resulted in a critical error when emptying the
Trash
for binned orders, correct?This is not something I am able to reproduce on my test site, as emptying the
Trash
for binned orders works as expected (I trashed 8 for the test):Does this perhaps occur with a specific amount of trashed orders? I used 8 for testing purposes, so just want to make sure that this isn’t reproducible with a specific number of binned orders.
Also, can you please share the exact error you are seeing when performing this action? Do you receive an email with the error details? If so, can you please share the content of the email with us here so that we can take a closer look?
Additionally, can you please share the following:
- System Status Report: navigate to WooCommerce → Status. Select
Get system report
and thenDownload for Support
. This will download a TXT file that has the contents of the SSR which you can then share with us here. - Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.
Cheers!
Hello Roxy,
Here is a video showing what happens when I try to delete orders.
This is the System Report:
WordPress Environment WordPress address (URL): https://... Site address (URL): https://... WC Version: 8.2.2 REST API Version: ? 8.2.2 WC Blocks Version: ? 11.1.3 Action Scheduler Version: ? 3.6.3 Log Directory Writable: ? WP Version: 6.4.1 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: – Language: en_GB External object cache: ? Server Environment Server Info: Apache PHP Version: 7.4.15 PHP Post Max Size: 256 MB PHP Time Limit: 900 PHP Max Input Vars: 3000 cURL Version: 7.75.0 OpenSSL/1.1.1i SUHOSIN Installed: – MySQL Version: 8.0.23 Max Upload Size: 256 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.2.2 WC Database Prefix: wp_ Total Database Size: 1065.75MB Database Data Size: 916.76MB Database Index Size: 148.99MB wp_woocommerce_sessions: Data: 5.02MB + Index: 1.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 1.52MB + Index: 0.25MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 7.52MB + Index: 7.97MB + 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.02MB + Index: 0.03MB + 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.09MB + Index: 0.09MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 4.02MB + Index: 3.69MB + 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: 3.02MB + Index: 2.03MB + Engine InnoDB wp_commentmeta: Data: 0.08MB + Index: 0.06MB + Engine MyISAM wp_comments: Data: 4.01MB + Index: 1.64MB + Engine MyISAM wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB wp_e_notes_users_relations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_fb3d_pages: Data: 0.11MB + Index: 0.05MB + Engine InnoDB wp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_campaign_emails: Data: 336.56MB + Index: 20.80MB + Engine InnoDB wp_fc_campaign_url_metrics: Data: 4.50MB + Index: 7.47MB + Engine InnoDB wp_fc_campaigns: Data: 3.50MB + Index: 0.05MB + Engine InnoDB wp_fc_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_fc_contact_relation_items: Data: 1.52MB + Index: 0.97MB + Engine InnoDB wp_fc_contact_relations: Data: 0.09MB + Index: 0.11MB + Engine InnoDB wp_fc_funnel_metrics: Data: 3.52MB + Index: 5.94MB + Engine InnoDB wp_fc_funnel_sequences: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_fc_funnel_subscribers: Data: 1.45MB + Index: 1.06MB + Engine InnoDB wp_fc_funnels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_fc_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_meta: Data: 1.36MB + Index: 0.05MB + Engine InnoDB wp_fc_sequence_tracker: Data: 0.31MB + Index: 0.58MB + Engine InnoDB wp_fc_smart_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_subscriber_meta: Data: 1.52MB + Index: 0.34MB + Engine InnoDB wp_fc_subscriber_notes: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_fc_subscriber_pivot: Data: 2.52MB + Index: 4.50MB + Engine InnoDB wp_fc_subscribers: Data: 1.42MB + Index: 0.50MB + Engine InnoDB wp_fc_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_url_stores: Data: 2.52MB + Index: 0.14MB + Engine InnoDB wp_ff_scheduled_actions: Data: 0.16MB + Index: 0.00MB + Engine InnoDB wp_fls_auth_logs: Data: 2.52MB + Index: 1.08MB + Engine InnoDB wp_fls_login_hashes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_entry_details: Data: 1.09MB + Index: 0.00MB + Engine InnoDB wp_fluentform_form_analytics: Data: 9.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_form_meta: Data: 1.20MB + Index: 0.00MB + Engine InnoDB wp_fluentform_forms: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_fluentform_logs: Data: 2.27MB + Index: 0.00MB + Engine InnoDB wp_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_submission_meta: Data: 1.42MB + Index: 0.00MB + Engine InnoDB wp_fluentform_submissions: Data: 2.11MB + Index: 0.00MB + Engine InnoDB wp_fluentform_subscriptions: Data: 0.03MB + Index: 0.00MB + Engine InnoDB wp_fluentform_transactions: Data: 1.08MB + Index: 0.00MB + Engine InnoDB wp_fm_file_action_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fsmpt_email_logs: Data: 272.02MB + Index: 0.00MB + Engine InnoDB wp_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + 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_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_dashboard_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_dashboard_lockouts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_firewall_rules: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_itsec_logs: Data: 1.02MB + Index: 0.11MB + Engine InnoDB wp_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_itsec_vulnerabilities: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_ninja_table_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 31.15MB + Index: 4.09MB + Engine MyISAM wp_postmeta: Data: 28.39MB + Index: 10.49MB + Engine MyISAM wp_posts: Data: 7.51MB + Index: 0.54MB + Engine MyISAM wp_presto_player_audio_presets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_presto_player_email_collection: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_presto_player_presets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_presto_player_videos: Data: 0.05MB + Index: 0.06MB + Engine InnoDB wp_presto_player_visits: Data: 1.44MB + Index: 3.92MB + Engine InnoDB wp_presto_player_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_rcb_asset_seo_redirect: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_blocker_thumbnails: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_rcb_consent: Data: 38.55MB + Index: 14.64MB + Engine InnoDB wp_rcb_revision: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wp_rcb_revision_independent: Data: 5.52MB + Index: 0.02MB + Engine InnoDB wp_rcb_scan: Data: 49.08MB + Index: 19.23MB + Engine InnoDB wp_rcb_scan_markup: Data: 9.52MB + Index: 1.52MB + Engine InnoDB wp_rcb_stats: Data: 0.30MB + Index: 0.17MB + Engine InnoDB wp_rcb_stats_buttons_clicked: Data: 0.11MB + Index: 0.09MB + Engine InnoDB wp_rcb_stats_custom_bypass: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_rcb_tcf_features: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_tcf_purposes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_tcf_special_features: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_tcf_special_purposes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_tcf_stacks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_tcf_vendors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcb_template: Data: 14.17MB + Index: 0.08MB + Engine InnoDB wp_rcb_template_translation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_real_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_realmedialibrary: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_realmedialibrary_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_realmedialibrary_posts: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_realmedialibrary_resetnames: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_realmedialibrary_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_responsive_menu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rsssl_csp_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_snippets: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_surecart_integrations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_term_relationships: Data: 0.06MB + Index: 0.14MB + Engine MyISAM wp_term_taxonomy: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wp_termmeta: Data: 0.07MB + Index: 0.04MB + Engine MyISAM wp_terms: Data: 0.03MB + Index: 0.05MB + Engine MyISAM wp_umbrella_backup: Data: 7.47MB + Index: 0.00MB + Engine InnoDB wp_umbrella_log: Data: 2.02MB + Index: 1.02MB + Engine InnoDB wp_umbrella_task_backup: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_usermeta: Data: 6.06MB + Index: 3.72MB + Engine MyISAM wp_users: Data: 0.41MB + Index: 0.29MB + Engine MyISAM wp_vi_wbe_history: Data: 0.47MB + Index: 0.00MB + Engine InnoDB wp_vi_wcuf_order_info: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_vi_woo_orders_tracking_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_vi_wpbulky_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_viredis_product_pricing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_viwcr_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_viwec_clicked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_w3tc_cdn_pathmap: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_w3tc_cdn_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wacv_abandoned_cart_record: Data: 2.02MB + Index: 0.00MB + Engine InnoDB wp_wacv_cart_log: Data: 7.52MB + Index: 0.00MB + Engine InnoDB wp_wacv_email_history: Data: 0.16MB + Index: 0.00MB + Engine InnoDB wp_wacv_guest_info_record: Data: 0.23MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.20MB + Index: 0.17MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_addresses: Data: 1.52MB + Index: 0.94MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: Data: 1.52MB + Index: 0.23MB + Engine InnoDB wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.63MB + Engine InnoDB wp_wc_order_stats: Data: 0.25MB + Index: 0.23MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.14MB + Index: 0.14MB + Engine InnoDB wp_wc_orders: Data: 1.52MB + Index: 1.13MB + Engine InnoDB wp_wc_orders_meta: Data: 11.52MB + Index: 22.14MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.20MB + Index: 0.11MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + 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_wf301_linkhero: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpcb_folders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpcb_snippets: Data: 1.36MB + Index: 0.00MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfm_shortcodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfnl_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfnl_analytics_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wpsr_caches: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_wpsr_optimize_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpsr_reviews: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts 3d-flip-book: 38 acf-field: 14 acf-field-group: 3 aiosrs-schema: 2 astra-advanced-hook: 2 attachment: 1019 br_filters_group: 1 br_product_filter: 2 bsf-sidebar: 1 custom_css: 1 custom-css-js: 1 customize_changeset: 48 elementor_library: 40 fc_template: 18 gtw_custom_fields: 3 itsec-dash-card: 20 itsec-dashboard: 3 language_switcher: 6 nav_menu_item: 6 ninja-table: 3 oembed_cache: 2 option-tree: 1 page: 26 post: 59 pp_email_submission: 5 pp_video_block: 46 product: 201 product_variation: 36 r3d: 100 rank_math_schema: 3 rcb-banner-link: 2 rcb-blocker: 8 rcb-cookie: 14 revision: 542 rvp: 60 sc_cart: 1 sc_form: 1 shop_coupon: 1 shop_order: 3139 shop_order_placehold: 10 shop_order_refund: 65 slick_slider: 1 um_directory: 1 um_form: 3 viwcpf_filter_block: 5 viwcpf_filter_menu: 1 viwcr_email_template: 2 viwec_template: 18 wacv_email_template: 3 wc_order_email: 1 wc_order_status: 8 wcpf_item: 2 wcpf_project: 1 wcps: 1 wcps_layout: 1 wishlist: 1 wp_global_styles: 1 wp_navigation: 1 wp_social_reviews: 7 wpforms: 1 wpfunnel_steps: 4 wpfunnels: 2 wpsr_social_chats: 1 wsm_access_group: 2 ywrac_cart: 4 ywrac_email: 2 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (56) WP Umbrella: by WP Umbrella - Backup & Manage WordPress – 2.11.6 WPCodeBox 2: by WPCodeBox – 1.0.3 FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.6 Advanced Custom Fields: by WP Engine – 6.2.2 FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.26.1 Astra Pro: by Brainstorm Force – 4.4.0 The SEO Framework: by The SEO Framework Team – 4.2.8 Solid Security Basic: by SolidWP – 9.0.3 Book shelf: by creativeinteractivemedia – 1.0.9 Bulky - Bulk Edit Products for WooCommerce Premium: by VillaTheme – 1.2.6 Dynamic Visibility for Elementor: by Dynamic.ooo – 5.0.10 Elementor Pro: by Elementor.com – 3.17.1 Elementor: by Elementor.com – 3.17.3 FluentCRM - Marketing Automation For WordPress: by WP Email Newsletter Team - FluentCRM – 2.8.34 FluentCRM Pro: by Fluent CRM – 2.8.33 Fluent Forms: by Contact Form - WPManageNinja LLC – 5.1.2 Fluent Forms Pro Add On Pack: by Fluent Forms – 5.1.1 Lightbox for Gallery & Image Block: by Johannes Kinast – 1.13 Imagify: by Imagify – Optimize Images & Convert WebP – 2.1.2 Longer Permalinks: by Giannis Economou – 1.29 Metorik Helper: by Metorik – 1.7.1 Modern Footnotes: by Prism Tech Studios – 1.4.17 Pinterest for WooCommerce: by WooCommerce – 1.3.14 Pofily - WooCommerce Product Filters Premium: by VillaTheme – 1.2.1 Presto Player Pro: by Presto Player – 2.0.1 Presto Player: by Presto Made Inc – 2.0.11 Payment Plugins for PayPal WooCommerce: by Payment Plugins [email protected] – 1.0.39 Real Cookie Banner: by devowl.io – 4.0.0 Real Media Library: by devowl.io – 4.21.16 Real3D Flipbook: by creativeinteractivemedia – 3.38 Sequential Order Numbers for WooCommerce: by BeRocket – 3.5.7.8 SureMembers: by SureCart – 1.9.2 Temporary Login Without Password: by StoreApps – 1.8.2 Transglobal Shipping: by Transglobal Express – 0.0.6 Ultimate Addons for Elementor: by Brainstorm Force – 1.36.25 W3 Total Cache: by BoldGrid – 2.6.0 Challan Pro: by WebAppick – 4.3.4 CTX Feed Pro: by WebAppick Author – 7.2.1 WooCommerce Locations Pack: by dangoodman – 1.9.3 Payment Plugins for Stripe WooCommerce: by Payment Plugins [email protected] – 3.3.51 WooCommerce Abandoned Cart Recovery Premium: by VillaTheme – 1.1.1 WooCommerce Cart All in One Premium: by VillaTheme – 1.1.1 WooCommerce Checkout Upsell Funnel Premium: by VillaTheme – 1.0.9 DHL Express Commerce: by DHL Express – 3.0.0 WooCommerce Email Template Customizer Premium: by VillaTheme – 1.2.2 CURCY - WooCommerce Multi Currency Premium: by VillaTheme – 2.3.1 WooCommerce Orders Tracking Premium: by VillaTheme – 1.1.9 WooCommerce Product Variations Swatches Premium: by VillaTheme – 1.1.1 WooCommerce Table Rate Shipping: by Bolder Elements – 4.3.9 WooCommerce Thank You Page Customizer Premium: by VillaTheme – 1.2.2 WooCommerce: by Automattic – 8.2.2 WP-PageNavi: by Lester 'GaMerZ' Chan – 2.94.1 WP Rocket | WooCommerce Recently Viewed Products Widget Integration: by WP Rocket Support Team – WP Social Ninja Pro: by WPManageNinja LLC – 3.11.0 WP Social Ninja: by WPManageNinja LLC – 3.11.0 WPBulky - WordPress Bulk Edit Post Types Premium: by VillaTheme – 1.0.7 Inactive Plugins (0) Dropin Plugins (3) advanced-cache.php: advanced-cache.php db.php: db.php object-cache.php: object-cache.php Must Use Plugins (2) WP Umbrella: by WP Umbrella – 1.0.0 _WPHealthHandlerMU.php: by – Settings API Enabled: ? Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) pw gift card (pw-gift-card) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – HPOS feature screen enabled: ? HPOS feature enabled: ? Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: – WC Pages Shop base: #11 - /bookshop/ Basket: #1147 - /basket/ Checkout: #1148 - /checkout/ My account: #1149 - /my-account/ Terms and conditions: ? Page not set Theme Name: Astra Version: 4.4.1 Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ? Templates Overrides: – Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management 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: customize-store minified-js new-product-management-experience settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-11-15 14:40:44 +00:00 Options: ? Notes: 28 Onboarding: completed Action Scheduler Complete: 2,662 Oldest: 2023-11-08 09:19:03 +0000 Newest: 2023-11-15 08:42:53 +0000 Failed: 351 Oldest: 2022-10-07 05:45:03 +0100 Newest: 2023-11-13 19:07:02 +0000 Pending: 6 Oldest: 2023-11-15 08:58:04 +0000 Newest: 2023-11-16 01:12:04 +0000 Status report information Generated at: 2023-11-15 08:48:08 +00:00
And this is the Fatal log:
2023-10-17T18:12:18+00:00 CRITICAL Uncaught Error: Call to a member function get_order_number() on bool in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/wpcodebox2/src/Runner/QueryRunner.php(126) : eval()'d code:19 Stack trace: #0 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(310): woo_invoice_file_name_callback() #1 /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php(205): WP_Hook->apply_filters() #2 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/webappick-pdf-invoice-for-woocommerce-pro/includes/class-woo-invoice-pro-pdf.php(241): apply_filters() #3 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/webappick-pdf-invoice-for-woocommerce-pro/includes/class-woo-invoice-pro-engine.php(144): Woo_Invoice_Pro_PDF->generatePDF() #4 /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/webappick-pdf-invoice-for-woocommerce-pro/woo-invoice-pro.php(1001): Woo_Invoice_Pro_Engine->generatePackingSlip() #5 /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php(310): woo_invoice_pro_generate_packing_sli in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/wpcodebox2/src/Runner/QueryRunner.php(126) : eval()'d code on line 19
It might be a plugin conflict with my woocommerce invoicing plugin? Or with a custom snippet that I have?
Thank you for your time on this. Looking forward to your reply.
Hey @barnabas1 ,
Thanks for sharing a recording of the issue, this is very helpful!
It looks like there may be some plugin or custom code altering the appearance (and perhaps functionality) of the
Orders
page and/or folders, as your sitesOrder
page looks somewhat different from what I am seeing on my vanilla WooCommerce test site.Given your list of plugins, none seem to be explicitly related to modifying the
Orders
page interface from what I can see.Name: Astra Version: 4.4.1 WooCommerce Support: ? Templates Overrides: – Admin
I do however see that the Astra theme is overriding the Admin. It’s possible that this may be conflicting with HPOS or bulk deletion, resulting in a critical error.
It might be a plugin conflict with my woocommerce invoicing plugin? Or with a custom snippet that I have?
This is very possible since the error logs are pointing to errors with these plugins.
As a first step, can you try temporarily deactivating those 2 plugins and see if this resolves the issue? If not, can you try switching your theme to Storefront with all plugins deactivated except for WooCommerce and see if this does the trick?
If the issue persists, I’d suggest a full conflict test at this point so that we can see if any theme/plugin conflict is causing the critical error to trigger when performing the bulk delete action.
You can read our comprehensive guide on how to perform a conflict test below:
We recommend performing a conflict test by using the free Health Check plugin since this allows you to deactivate all plugins, and change the theme while still logged in, without affecting normal visitors to your site.
If you do make any changes or perform updates on your live site, we always recommend ensuring that you have a good?backup?of your?full site and database?before doing this, so that, should something go wrong, you are able to easily restore your site to a functioning state.
Let us know how this goes!
Thank you @roxy. Your explanation is very clear. I appreciate this. I’ll continue the testing on my side to find the root of this conflict.
Kind regards,
Barnabas
Hi @barnabas1,
Your explanation is very clear. I appreciate this. I’ll continue the testing on my side to find the root of this conflict.
You’re very welcome! I’m glad to hear that the information provided was helpful.
Take your time with the testing and please don’t hesitate to reach out if you have any further questions or need additional assistance. Remember, it’s always a good idea to backup your site before making any changes or updates.
Once you’ve completed the testing, please let us know your findings. If the problem persists, we’re here to help you troubleshoot further. We’re committed to helping you resolve this issue so you can get back to managing your WooCommerce store without any hiccups.
Looking forward to hearing from you soon.
Howdy Barnabas,
We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.
Cheers!
- System Status Report: navigate to WooCommerce → Status. Select
- The topic ‘Empty Bin with deleted orders while HPOS enabled’ is closed to new replies.