Support » Plugin: WooCommerce » Can’t delete WooCommerce 6.9.4
Can’t delete WooCommerce 6.9.4
-
Installed the WooCommerce plugin a year ago and used it temporarily. Something in it is corrupt (problems started after a prompt to update tables like here). When I activate it, I get a critical error on my site. Deleting and reinstalling it thru the plugins page does not change this.
I’m willing to delete all WC content, and start over completely from scratch, so I’ve added the line: define( ‘WC_REMOVE_ALL_DATA’, true ); to my wp-config file (as recommended by WC) and tried deleting the plugin and all associated files–but I get an error, saying it cannot delete.
Since WooCommerce content is not just stored in the Plugins folder, I’m not sure how else to go about starting fresh. I esp want to scrub my tables of any content, since that might be the culprit. Any advice would be helpful.
The page I need help with: [log in to see the link]
-
Hi @rachelpilv
Thanks for reaching out!
I understand that you cannot delete the WooCommerce plugin on your site and receive an error that it cannot be deleted.
Can you please share the following below?
– screenshot of the error message on your end
If you don’t already have a screenshot service installed, you can try https://snipboard.io or http://skitch.com/. You can share the direct link to the image as a response to this topic.
– System Status Report under
WooCommerce > Status
. SelectGet system report
and thenCopy for support
. Once you’ve done that, you can paste it into your reply here.
– Fatal Error Logs (if any) underWooCommerce > Status > Logs
Sorry for the delay–here you go.
PLUGIN MESSAGE:
https://snipboard.io/YeOpEx.jpgERROR LOGS:
These Database Update and Action Scheduler alerts have been there for days.
https://snipboard.io/CraHkp.jpg
There are more error logs, these are just the 2 most recent:
2022-10-10T14:14:15+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/customer/www/trellishta.org/public_html/wp-content/plugins in /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
_________
2022-10-07T11:30:57+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/customer/www/trellishta.org/public_html/wp-content/plugins in /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
__________SYSTEM STATUS REPORT:
### WordPress Environment ###WordPress address (URL): https://trellishta.org
Site address (URL): https://trellishta.org
WC Version: 6.9.4
REST API Version: ✔ 6.9.4
WC Blocks Version: ✔ 8.3.3
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: 6.0.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –### Server Environment ###
Server Info: Apache
PHP Version: 7.4.32
PHP Post Max Size: 256 MB
PHP Time Limit: 300
PHP Max Input Vars: 4000
cURL Version: 7.66.0
OpenSSL/1.1.1q-fipsSUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔### Database ###
WC Database Version: 5.9.0
WC Database Prefix: wp_
Total Database Size: 167.26MB
Database Data Size: 164.20MB
Database Index Size: 3.06MB
wp_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 2.90MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_feed: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_entry: Data: 0.33MB + Index: 0.00MB + Engine InnoDB
wp_gf_entry_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_view: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_give_commentmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_give_comments: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
wp_give_donationmeta: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_give_donormeta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_give_donors: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_give_formmeta: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_give_log: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_give_migrations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_give_revenue: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_give_sequential_ordering: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_give_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_give_subscriptionmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_give_subscriptions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.34MB + Index: 0.00MB + Engine MyISAM
wp_gla_merchant_issues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gla_shipping_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gla_shipping_times: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_layerslider: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_templates: Data: 1.28MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_scheduled_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_bounces: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_user_agents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 6.52MB + Index: 1.52MB + Engine InnoDB
wp_postmeta: Data: 59.52MB + Index: 0.34MB + Engine InnoDB
wp_posts: Data: 89.52MB + Index: 0.33MB + Engine InnoDB
wp_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rg_form_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_rg_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rg_lead: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_rg_lead_detail: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_vxg_ccontact: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vxg_ccontact_accounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vxg_ccontact_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB### Post Type Counts ###
attachment: 132
custom_css: 1
event_listing: 1
fl-builder-template: 5
fl-theme-layout: 2
fusion_element: 18
fusion_form: 12
fusion_tb_section: 1
fusion_template: 1
give_forms: 4
give_payment: 73
mailpoet_page: 1
nav_menu_item: 29
page: 23
post: 9
product: 4
product_variation: 8
revision: 1313
shop_order: 11
shop_order_refund: 3
slide: 9
tribe_events: 2
tribe_organizer: 2
tribe_rsvp_tickets: 1
tribe_venue: 2
wp_global_styles: 1### Security ###
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔### Active Plugins (7) ###
Duplicate Page: by mndpsingh287 – 4.4.9
Avada Builder: by ThemeFusion – 3.8.2
Avada Core: by ThemeFusion – 5.8.2
Give – Stripe Gateway: by GiveWP – 2.5.0
Give – Donation Plugin: by GiveWP – 2.22.2
WooCommerce: by Automattic – 6.9.4
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.6### Inactive Plugins (0) ###
### Dropin Plugins (1) ###
maintenance.php: maintenance.php
### Settings ###
API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)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: ❌ Page visibility should be public
Cart: ❌ Page visibility should be public
Checkout: ❌ Page visibility should be public
My account: ❌ Page visibility should be public
Terms and conditions: ❌ Page not set### Theme ###
Name: Avada
Version: 7.8.2
Author URL: https://themeforest.net/user/ThemeFusion
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: Avada/woocommerce/cart/cart.php
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/checkout/thankyou.php
Avada/woocommerce/loop/loop-start.php
Avada/woocommerce/single-product/add-to-cart/variable.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php### Admin ###
Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-pageDisabled Features: minified-js
new-product-management-experience
settingsDaily Cron: ✔ Next scheduled: 2022-10-10 21:07:20 -04:00
Options: ✔
Notes: 74
Onboarding: completed### Action Scheduler ###
Complete: 10
Oldest: 2022-10-01 21:00:05 -0400
Newest: 2022-10-01 21:00:05 -0400Pending: 6
Oldest: 2022-10-01 21:00:05 -0400
Newest: 2022-10-01 21:00:05 -0400### Status report information ###
Generated at: 2022-10-10 10:15:06 -04:00`
Hi @rachelpilv
Thanks for sharing the information above.
These Database Update and Action Scheduler alerts have been there for days.
https://snipboard.io/CraHkp.jpgThis issue is documented on the Action Scheduler GitHub page and related to an internal database migration and missing tables.
https://github.com/woocommerce/action-scheduler/issues/631
Since you’ve mentioned above that you’ve tried to remove all data, this may have caused the issue here.
Can you please try the provided solutions on the Github thread above and see if this works? Then, please try to deactivate and delete the WooCommerce plugin again.
Let us know how it goes!
Thank you, I added the above code to the theme’s functions.php file. I was then able to delete the plugin–at first it gave an error, but the next day it was gone from the Plugins page. I did a fresh install of WooCommerce and was working through the Setup Wizard when I received another fatal error email:
Error Details ============= An error of type E_ERROR was caused in line 44 of the file /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/customer/www/trellishta.org/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/customer/www/trellishta.org/public_html/wp-content/plugins
I’ve installed the Query Monitor plugin and here’s what it’s showing:
https://snipboard.io/shxkwm.jpgAny further advice would be helpful.
- You must be logged in to reply to this topic.