Various Fatal Error Messages on trying to bulk change products

  • Resolved sukeybooth

    (@sukeybooth)


    2 years, 9 months ago

    I’m trying to bulk delete products from my catalogue (via category/other filters) and I’m failing each time getting a variety of different “Fatal Error Messages”

    I was previously getting memory exceeded type errors (consistently), so have now increased the WP memory to 512M, but I am now getting a different Fatal Error message on each attempt, for example:

    Fatal error: Maximum execution time of 30 seconds exceeded in?/homepages/12/d747982170/htdocs/clickandbuilds/ConclaveBrighton/wp-includes/class-wp-object-cache.php?on line?351 

Fatal error: Maximum execution time of 30 seconds exceeded in?/homepages/12/d747982170/htdocs/clickandbuilds/ConclaveBrighton/wp-includes/meta.php?on line?652 

Fatal error: Maximum execution time of 30 seconds exceeded in?/homepages/12/d747982170/htdocs/clickandbuilds/ConclaveBrighton/wp-includes/post-formats.php?on line?261 

Fatal error: Maximum execution time of 30 seconds exceeded in?/homepages/12/d747982170/htdocs/clickandbuilds/ConclaveBrighton/wp-includes/option.php?on line?190 

Fatal error: Maximum execution time of 30 seconds exceeded in?/homepages/12/d747982170/htdocs/clickandbuilds/ConclaveBrighton/wp-includes/formatting.php?on line?1164

    —
    Any ideas?

    My Woocommerce status report is as follows:

    
### WordPress Environment ###

WordPress address (URL): https://conclave-brighton.co.uk
Site address (URL): https://conclave-brighton.co.uk
WC Version: 6.5.1
REST API Version: ? 6.5.1
WC Blocks Version: ? 7.4.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.19
PHP Post Max Size: 6 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.64.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: ? 5.5.60-0+deb7u1-log - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: ClhmG
Total Database Size: 339.52MB
Database Data Size: 283.57MB
Database Index Size: 55.95MB
ClhmGwoocommerce_sessions: Data: 97.14MB + Index: 5.35MB + Engine MyISAM
ClhmGwoocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_order_items: Data: 0.06MB + Index: 0.03MB + Engine MyISAM
ClhmGwoocommerce_order_itemmeta: Data: 0.42MB + Index: 0.31MB + Engine MyISAM
ClhmGwoocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwoocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGactionscheduler_actions: Data: 6.18MB + Index: 2.33MB + Engine MyISAM
ClhmGactionscheduler_claims: Data: 0.13MB + Index: 0.42MB + Engine MyISAM
ClhmGactionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
ClhmGactionscheduler_logs: Data: 3.74MB + Index: 2.76MB + Engine MyISAM
ClhmGaws_cache: Data: 3.66MB + Index: 0.00MB + Engine MyISAM
ClhmGaws_index: Data: 18.85MB + Index: 10.44MB + Engine MyISAM
ClhmGblc_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGblc_instances: Data: 2.16MB + Index: 0.26MB + Engine MyISAM
ClhmGblc_links: Data: 4.23MB + Index: 0.64MB + Engine MyISAM
ClhmGblc_synch: Data: 0.04MB + Index: 0.03MB + Engine MyISAM
ClhmGcommentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
ClhmGcomments: Data: 0.47MB + Index: 0.18MB + Engine MyISAM
ClhmGe_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGgla_budget_recommendations: Data: 0.11MB + Index: 0.12MB + Engine MyISAM
ClhmGgla_merchant_issues: Data: 14.32MB + Index: 0.78MB + Engine MyISAM
ClhmGgla_shipping_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGgla_shipping_times: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGlinks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGmailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
ClhmGmailchimp_jobs: Data: 0.25MB + Index: 0.01MB + Engine MyISAM
ClhmGmgmlp_folders: Data: 0.16MB + Index: 0.15MB + Engine MyISAM
ClhmGnf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_action_meta: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
ClhmGnf3_chunks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_field_meta: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
ClhmGnf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_objects: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
ClhmGnf3_object_meta: Data: 2.20MB + Index: 0.02MB + Engine MyISAM
ClhmGnf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGnf3_upgrades: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
ClhmGngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGngg_pictures: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
ClhmGoptions: Data: 7.74MB + Index: 1.98MB + Engine MyISAM
ClhmGpostmeta: Data: 50.61MB + Index: 18.13MB + Engine MyISAM
ClhmGposts: Data: 53.52MB + Index: 2.75MB + Engine MyISAM
ClhmGredirection_404: Data: 0.50MB + Index: 0.09MB + Engine MyISAM
ClhmGredirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGredirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
ClhmGredirection_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGstatify: Data: 0.31MB + Index: 0.32MB + Engine MyISAM
ClhmGtermmeta: Data: 1.22MB + Index: 0.59MB + Engine MyISAM
ClhmGterms: Data: 0.05MB + Index: 0.10MB + Engine MyISAM
ClhmGterm_relationships: Data: 0.85MB + Index: 1.88MB + Engine MyISAM
ClhmGterm_taxonomy: Data: 0.22MB + Index: 0.07MB + Engine MyISAM
ClhmGtinvwl_analytics: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
ClhmGtinvwl_items: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
ClhmGtinvwl_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGusermeta: Data: 0.44MB + Index: 0.26MB + Engine MyISAM
ClhmGusers: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
ClhmGwc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
ClhmGwc_category_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
ClhmGwc_customer_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
ClhmGwc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_order_product_lookup: Data: 0.06MB + Index: 0.06MB + Engine MyISAM
ClhmGwc_order_stats: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
ClhmGwc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
ClhmGwc_product_meta_lookup: Data: 0.83MB + Index: 1.21MB + Engine MyISAM
ClhmGwc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGwc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
ClhmGwc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ClhmGyoast_indexable: Data: 11.23MB + Index: 2.77MB + Engine MyISAM
ClhmGyoast_indexable_hierarchy: Data: 0.34MB + Index: 1.14MB + Engine MyISAM
ClhmGyoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
ClhmGyoast_primary_term: Data: 0.11MB + Index: 0.13MB + Engine MyISAM
ClhmGyoast_seo_links: Data: 0.93MB + Index: 0.32MB + Engine MyISAM
ClhmGyoast_seo_meta: Data: 0.06MB + Index: 0.06MB + Engine MyISAM

### Post Type Counts ###

attachment: 10198
custom_css: 1
elementor_library: 1
jetpack_migration: 2
mc4wp-form: 1
mgmlp_media_folder: 86
nav_menu_item: 20
nf_sub: 604
ngg_album: 3
ngg_gallery: 3
ngg_pictures: 58
oembed_cache: 6
page: 186
post: 1
product: 1947
product_variation: 11039
revision: 2236
shop_order: 427
shop_order_refund: 14
tribe_events: 27
tribe_organizer: 13
tribe_venue: 3
wp_block: 2
wp_global_styles: 1
wpforms: 1

### Security ###

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

### Active Plugins (38) ###

404page - your smart custom 404 error page: by Peter Raschendorfer – 11.3.1
a3 Lazy Load: by a3rev Software – 2.5.0
Advanced Woo Search: by ILLID – 2.55
Antispam Bee: by pluginkollektiv – 2.11.0
Broken Link Checker: by WPMU DEV – 1.11.16
CoBlocks: by GoDaddy – 2.24.0
GDPR Cookie Consent: by WebToffee – 2.1.2
Elementor: by Elementor.com – 3.6.5
Essential Addons for Elementor: by WPDeveloper – 5.1.4
Facebook for WooCommerce: by Facebook – 2.6.15
Gallery Custom Links: by Jordy Meow – 2.1.0
Getwid: by MotoPress – 1.8.1
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 7.5.3
Google Listings and Ads: by WooCommerce – 1.13.3
Insert Headers and Footers: by WPBeginner – 1.6.2
Jetpack: by Automattic – 10.9.1
Mailchimp for WooCommerce: by Mailchimp – 2.6.2
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
Media Library Folders for WordPress: by Max Foundry – 7.1.0
Media Library Folders Reset: by Max Foundry – 7.1.0
Meow Gallery: by Jordy Meow
Thomas Kim – 4.2.5

Ninja Forms: by Saturday Drive – 3.6.9
Post Duplicator: by Metaphor Creations – 2.28
Really Simple SSL: by Really Simple Plugins – 5.3.2
Redirection: by John Godley – 5.2.3
Regenerate Thumbnails Advanced: by ShortPixel – 2.4.0
Statify: by pluginkollektiv – 1.8.3
The Events Calendar: by The Events Calendar – 5.16.0
TI WooCommerce Wishlist: by TemplateInvaders – 1.45.0
Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
Social Media and Share Icons (Ultimate Social Media): by UltimatelySocial – 2.7.5
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.12

Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.1
WooCommerce Stripe Gateway: by WooCommerce – 6.4.0
WooCommerce Shipping & Tax: by WooCommerce – 1.26.0
WooCommerce: by Automattic – 6.5.1
Yoast SEO: by Team Yoast – 19.0
Related Products for WooCommerce: by WebToffee – 1.4.3

### Inactive Plugins (3) ###

1&1 WP Assistant: by 1&1 – 5.1.0
Google XML Sitemaps: by Arne Brachhold – 4.1.3
WP Super Cache: by Automattic – 1.7.7

### Must Use Plugins (1) ###

1&1 Product Subdomain: by 1&1 – 1.1.0

### 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)
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: –

### WC Pages ###

Shop base: #273 - /shop
Basket: #274 - /basket
Checkout: #275 - /checkout
My account: #276 - /my-account
Terms and conditions: #2325 - /shop/terms-and-conditions

### Theme ###

Name: Storefront
Version: 4.1.0
Author URL: https://woocommerce.com/
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: –

### TI WooCommerce Wishlist Templates ###

Overrides: –

### Action Scheduler ###

Complete: 4,701
Oldest: 2022-05-01 15:22:29 +0000
Newest: 2022-06-01 15:16:25 +0000

Failed: 10,774
Oldest: 2020-11-18 12:51:07 +0000
Newest: 2022-06-01 14:48:12 +0000

Pending: 2
Oldest: 2022-06-02 03:00:00 +0000
Newest: 2022-06-02 15:16:25 +0000

### Status report information ###

Generated at: 2022-06-01 15:18:05 +00:00

    The page I need help with: [log in to see the link]

Viewing 2 replies - 16 through 17 (of 17 total)
  • Thread Starter sukeybooth

    (@sukeybooth)

    My host won’t increase the “PHP Max Input Vars” so I’m a bit stuck.

    Hi @sukeybooth

    I am sorry to hear, it looks like the only option left would be to delete the products one by one.

    A workaround would be to update your catalog using a CSV file with a plugin that provides an option to delete the already existing products. Here: export all products that should not be deleted and re-importing them while deleting existing products.

    If it is something you would consider, I would suggest the Product CSV Import Suite extension or any other plugins.

    Hope this helps!

    Hope this helps

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘Various Fatal Error Messages on trying to bulk change products’ is closed to new replies.