MultiSite Fatal Error – FRESH INSTALL

  • Resolved Ty

    (@tyranthacker)


    3 years, 4 months ago

    Hey there!

    Running the latest MultiSite and WooCommerce.

    I received a fatal error on a live website, and found that it was only being caused with WooCommerce was active.

    I tested it on a FRESH sandbox and found yet another fatal error with ONLY WooCommerce installed on a fresh Multisite install.

    I tested on both sites installing ActionScheduler plugin. Still Errors.

    ERROR ON LIVE SITE:
    There has been a critical error on this website. Please check your site admin email inbox for instructions.

    Debug.log Message on Live Site:
    [16-Jul-2021 00:50:50 UTC] WordPress database error Table 'REDACTEDXXXXXXINFO_13_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM REDACTEDXXXXXXINFO_13_actionscheduler_actions a WHERE 1=1 AND a.status='pending' AND a.scheduled_date_gmt <= '2021-07-16 00:50:50' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions

    ERROR ON TEST SITE:

    Fatal error: Uncaught RuntimeException: Error saving action: Table 'dben4q0vkrxqlq.oaz_2_actionscheduler_actions' doesn't exist in

REDACTED INFO/public_html/test/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:85 Stack trace: #0

REDACTED INFO/public_html/test/wp-content/plugins/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #1

REDACTED INFO/public_html/test/wp-content/plugins/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #2

REDACTED INFO/public_html/test/wp-content/plugins/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single('wc-admin_delete...', Array, 1626397823, 'wc-admin-data') #3

REDACTED INFO/public_html/test/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php(44): as_sch in

REDACTED INFO/public_html/test/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 85
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    Based on the error messages, it looks like the database tables used by WooCommerce (and the actionscheduler component thereof) didn’t create the necessary tables.

    Just to verify:

    • Does the database user account allow for database tables to be created?
    • Is WooCommerce network activated or are you activating it on a per-subsite basis?
    • Are you seeing any notifications when running the “Verify base database tables” as found under **WooCommerce > Status > Tools**

    Thanks!

    Thread Starter Ty

    (@tyranthacker)

    Yeah the database user account does.
    Iv tested it on a sandbox, and installing the action scheduler plugin first seems to avoid this error. It was probably from another plugin creating an outdated auto scheduler, seems to be what RankMath said was an issue before.

    So I’m just going to do a fresh install, seems to of worked.

    Thread Starter Ty

    (@tyranthacker)

    Woocommerce was not network activated, I’ll run the tools like you suggested just to understand the issue more.

    Thread Starter Ty

    (@tyranthacker)

    The database tables were verified successfully.

    Plugin Support lionel.a11n

    (@lioneldaniel)

    Hi @tyranthacker,

    Thanks for letting us know that a fresh install worked, even though that doesn’t totally clear up how those tables didn’t get added/why those errors came up.

    We haven’t heard more from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘MultiSite Fatal Error – FRESH INSTALL’ is closed to new replies.