Unhandled exception

  • Resolved meereck

    (@meereck)


    1 year, 1 month ago

    Hello,

    suddenly, my Woocommerce Administration does not work. Perhaps, it is related to Woocommerce update which I did yesterday.

    An error of type E_ERROR was caused in line 126 of the file /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Error saving action: Unknown column ‘priority’ in ‘field list’ in /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:126 Stack trace: #0 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(69): ActionScheduler_DBStore->save_action_to_db(Object(ActionScheduler_Action), NULL, false) #1 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #2 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(175): ActionScheduler_ActionFactory->create(Array) #4 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(65): as_schedule_recurring_action(false, 86400, ‘woocommerce_cle…’) #5 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Domain/Services/DraftOrders.php(57): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->maybe_create_cronjobs() #6 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-includes/class-wp-hook.php(308): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->install(”) #7 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array) #8 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #9 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-admin/admin.php(175): do_action(‘admin_init’) #10 /data/web/virtuals/292658/virtual/www/subdom/shop/wp-admin/index.php(10): require_once(‘/data/web/virtu…’) #11 {main} thrown

    I have tried to disable all plugins, switch to StoreFront template, clear ActionScheduler tables but nothing helped.

    Should be noted the exception occurs in Admin, not on the front-end. Front-end still seems to work ok.

    Thanks for any hint.

    Meereck

    • This topic was modified 1 year, 1 month ago by meereck.
    • This topic was modified 1 year, 1 month ago by meereck.
    • This topic was modified 1 year, 1 month ago by meereck.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter meereck

    (@meereck)

    1 year, 1 month ago

    Temporarily sorted out by manually downgrading WooCommerce from 7.9.0 to 7.8.2

    Plugin Support Shameem (woo-hc)

    (@shameemreza)

    1 year, 1 month ago

    Hi @meereck

    From the error message you provided, the issue appears to be related to the ActionScheduler_DBStore.php file. Specifically, the error message indicates that there’s an issue with an ‘Unknown column ‘priority’ in ‘field list’.

    Typically, such an error might occur if there’s a discrepancy between the database structure expected by the updated version of WooCommerce and the actual structure of your database.

    You’ve already taken some great troubleshooting steps by disabling all plugins, switching to the StoreFront template, and clearing ActionScheduler tables. However, since these steps did not resolve the issue, it might be worthwhile to try a few other troubleshooting steps:

    1. Check Database Structure: Ensure that your database structure matches the one expected by the WooCommerce version you’re using. You can do this by comparing your database structure with the WooCommerce Database Description.
    2. Update Database: If there are discrepancies, updating your database might resolve the issue. You can do this by navigating to WooCommerce > Status > Tools > Database update.
    3. Reinstall WooCommerce: If the issue persists, you might want to try reinstalling WooCommerce. Please ensure that you back up your website before doing this to prevent any loss of data.

    In the meantime, if you’ve found a temporary solution by downgrading WooCommerce from 7.9.0 to 7.8.2 and everything is working as expected, you might want to stick with this version until you can find a permanent solution.

    Rest assured, we couldn’t reproduce the error using the latest version. It seems like there could be an issue with your setup. I’d also suggest running a conflict test. You can find a more detailed explanation of conducting a conflict test here.

    Please let us know how these steps work out for you or if you have any other questions or concerns. Thanks!

    Thread Starter meereck

    (@meereck)

    1 year, 1 month ago

    Hi @shameemreza,

    Woocommerce database update did not help.

    Any idea where the column “‘priority’ in ‘field list.” might come from?

    Roxy

    (@beautyofcode)

    1 year, 1 month ago

    Hi Meerek,

    Just to clarify, are you unable to access any part of your sites dashboard when WooCommerce is updated to its latest version, or only specific areas of the dashboard?

    Are you able to navigate to WooCommerce → Status in order to share your sites System Status Report with us here?

    It will be great if you could share more details about the problem you’re facing so that we can have a better understanding of what you are experiencing.

    Please include screenshots in your response showing what and where exactly you’re seeing that we can better understand the issue. You can use a free tool like Snipboard.io to create screenshots and send us image links.

    Cheers!

    Roxy

    (@beautyofcode)

    1 year, 1 month ago

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

    Thread Starter meereck

    (@meereck)

    10 months, 1 week ago

    I can confirm the solution from

    https://wordpress.org/support/topic/fatal-error-missing-column-priority/

    sorted this problem.

    Tamrat A. (woo-hc)

    (@bisratlearn)

    10 months, 1 week ago

    Hi @meereck,

    I can confirm the solution from: https://wordpress.org/support/topic/fatal-error-missing-column-priority/ sorted this problem.

    Thank you for getting back to us and sharing the solution that worked for you. I’m glad to hear that the issue has been resolved.

    I’ll go ahead and mark this thread as resolved. However, if you ever have more questions or issues in the future, don’t hesitate to kick off a new topic.

    Hope you have a fantastic day!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Unhandled exception’ is closed to new replies.