Woocommerce error deleting sub-sites

  • Resolved marvc

    (@marvc)


    3 years, 10 months ago

    Have a few sites, most of which are WordPress multisites, hosted on WPMUDEV and notice that after confirming to delete a sub-site with Woocommerce activated the following error appears:

    There has been a critical error on this website. Please check your site admin email inbox for instructions.

    Learn more about troubleshooting WordPress.

    I don’t receive an email but I go get the following error in the PHP Error Log:

    [12-May-2021 17:46:49 UTC] WordPress database error Table 'trotcn.wp_u0_4_actionscheduler_actions' doesn't exist for query SHOW FULL COLUMNS FROMwp_u0_4_actionscheduler_actionsmade by wpmu_delete_blog, wp_delete_site, do_action('wp_uninitialize_site'), WP_Hook->do_action, WP_Hook->apply_filters, wp_uninitialize_site, remove_user_from_blog, do_action('remove_user_from_blog'), WP_Hook->do_action, WP_Hook->apply_filters, AutomatticWooCommerceAdminSchedulersCustomersScheduler::schedule_user_delete, AutomatticWooCommerceAdminSchedulersImportScheduler::schedule_action, WC_Action_Queue->schedule_single, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_DBStore->save_action

    Another Error:

    [12-May-2021 17:46:49 UTC] WordPress database error Table 'trotcn.wp_u0_4_actionscheduler_groups' doesn't exist for query SHOW FULL COLUMNS FROMwp_u0_4_actionscheduler_groupsmade by wpmu_delete_blog, wp_delete_site, do_action('wp_uninitialize_site'), WP_Hook->do_action, WP_Hook->apply_filters, wp_uninitialize_site, remove_user_from_blog, do_action('remove_user_from_blog'), WP_Hook->do_action, WP_Hook->apply_filters, AutomatticWooCommerceAdminSchedulersCustomersScheduler::schedule_user_delete, AutomatticWooCommerceAdminSchedulersImportScheduler::schedule_action, WC_Action_Queue->schedule_single, as_schedule_single_action, ActionScheduler_ActionFactory->single, ActionScheduler_ActionFactory->store, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->get_group_id, ActionScheduler_DBStore->create_group

    There are additional errors. The only way to address this issue is to deactivate Woocommerce. Once deactivated I’m able to delete the sub-site.

    This happens on an older site and a new site I’m in the process of building. I don’t have the Woocommerce Admin plugin installed on either site.

    Nothing more to add. Let me know if further info is needed from me.

    Any responses appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter marvc

    (@marvc)

    Oops!
    WordPress ver5.7.1
    Woocommerce: 5.3.0

    It sounds like some of the Action Scheduler tables weren’t created on these sub-sites. The routine trying to delete the sites is getting stuck trying to remove something that doesn’t exist.

    If any Action Scheduler tables are missing, you should be able to generate them by going to WooCommerce > Status > Scheduled Actions. That should trigger the action to create any missing tables. If that doesn’t work, disabling and re-enabling WooCommerce should also generate missing tables.

    I hope that points you in the right direction.

    Hi @marvc,

    Since we haven’t heard from you in a while, we’re hoping that means you were able to get this resolved. I’m going to close this thread out now.

    If you’re still having trouble, please open up a new topic and we’ll be happy to help out.

    Stay safe!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Woocommerce error deleting sub-sites’ is closed to new replies.