• Resolved barnabas1

    (@barnabas1)


    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

Viewing 6 replies - 1 through 6 (of 6 total)
  • 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!

    Thread Starter barnabas1

    (@barnabas1)

    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:

    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!

    Thread Starter barnabas1

    (@barnabas1)

    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!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Empty Bin with deleted orders while HPOS enabled’ is closed to new replies.