Can’t update woocommerce database

  • Resolved ohnsu

    (@ohnsu)


    4 years, 3 months ago

    Hi everyone,

    How are you today? I hope someone can please help me out. I try to update woocommerce database for my website: http://www.ohnsuhaus.com, but I run into the following message when I do:

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

    Learn more about troubleshooting WordPress.”

    When I check my inbox for the error report, I’m receiving the following:

    “`When seeking help with this issue, you may be asked for some of the following information:
    WordPress version 5.8.3
    Current theme: Hello Elementor (version 2.4.1)
    Current plugin: WooCommerce (version 6.2.0)
    PHP version 7.4.27

    Error Details
    =============
    An error of type E_ERROR was caused in line 86 of the file /home/deb105580/domains/ohnsuhaus.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Error saving action: Table ‘deb105580_wp7.wp_actionscheduler_actions’ doesn’t exist in /home/deb105580/domains/ohnsuhaus.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:86
    Stack trace:
    #0 /home/deb105580/domains/ohnsuhaus.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
    #1 /home/deb105580/domains/ohnsuhaus.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #2 /home/deb105580/domains/ohnsuhaus.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single(‘wc-admin_delete…’, Array, 1645092276, ‘wc-admin-data’)
    #3 /home/deb105580/domains/ohnsuhaus.com/public_html/wp-conte`”

    I don’t understand what this report means but at first I thought it had to do with “action scheduler” not working properly. I googled online how to fix it but nothing helped.

    I tried the following already:

    1. log in at PHPMYADMIN to find the action scheduler line to reset it, action scheduler is missing in PHPMYADMIN
    2. Installed plugin Action Scheduler by automattic, didn’t help
    3. Copied and pasted a code I found on Github about action scheduler (I think it was a repair code, at that point I didn’t know I was missing action scheduler yet), didn’t work
    4. Googled how to install action scheduler but couldn’t find it except for the tip to install the plugin
    5. Tried to delete woocommerce completely (to reinstall it) with this line: (‘WC_REMOVE_ALL_DATA’, true), didn’t work + I tried to delete woocommerce in PHPADMIN and in my backend, didn’t work

    I’m at loss what will actually solve this problem. Is there anyone who knows the answer?

    I’m looking forward to read from you.

    Kind regards,

    Cammy

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mirko P.

    (@rainfallnixfig)

    4 years, 3 months ago

    Hi @ohnsu,

    This issue is documented on the Action Scheduler GitHub repository and it’s related to a missing database table.

    Can you check if the solution provided here works for you?

    https://github.com/woocommerce/action-scheduler/issues/587#issuecomment-658168773

    Cheers.

    Thread Starter ohnsu

    (@ohnsu)

    4 years, 3 months ago

    Hi Mirko,

    Thank you so much for getting back to me so fast. It took me a while to understand what’s being said at the page your link referred me to. Unfortunately I’m not tech savy and I didn’t manage to get it fixed.

    I copied the codes and pasted it into phpmyadmin but I received an error.

    I copied this:

    CREATE TABLEwp_actionscheduler_actions` (
    action_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    hook varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    status varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    scheduled_date_gmt datetime DEFAULT NULL,
    scheduled_date_local datetime DEFAULT NULL,
    args varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    schedule longtext COLLATE utf8mb4_unicode_520_ci,
    group_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
    attempts int(11) NOT NULL DEFAULT ‘0’,
    last_attempt_gmt datetime DEFAULT NULL,
    last_attempt_local datetime DEFAULT NULL,
    claim_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
    extended_args varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    PRIMARY KEY (action_id),
    KEY hook (hook),
    KEY status (status),
    KEY scheduled_date_gmt (scheduled_date_gmt),
    KEY args (args),
    KEY group_id (group_id),
    KEY last_attempt_gmt (last_attempt_gmt),
    KEY claim_id (claim_id)
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;`

    into SQL

    and received this message:

    MySQL said: Documentation

    #1046 – No database selected

    I tried to look for the database in the code hoping I could refer it to the database that my site is on (not sure if I’m thinking the right thing here), but I couldn’t find any. :’)

    Do you perhaps know how I can fix this?

    Mai

    Thread Starter ohnsu

    (@ohnsu)

    4 years, 3 months ago

    Hi Mirko,

    I don’t know what I did but I was able to solve the problem! I really don’t remember what I did.

    Thank you again for providing guidance earlier.

    Wishing you a great day.

    Mai

    aetta

    (@chiape)

    4 years, 3 months ago

    Hey @ohnsu!

    I am happy to hear that! Let us know if you have other questions by creating a new topic!

    My very best,

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Can’t update woocommerce database’ is closed to new replies.