Empty Bin with deleted orders while HPOS enabled

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 then Download 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 sites Order 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:

• How to test for conflicts

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!