Fatal error when click on Products after the updating to 7.9.0

more information for there is another error:

WordPress database error Unknown column ‘priority’ in ‘order clause’ for query UPDATE wp_actionscheduler_actions SET claim_id=2596, last_attempt_gmt=’xxxxx’, last_attempt_local=’xxxxx’ WHERE claim_id = 0 AND scheduled_date_gmt <= ‘xxxxxx’ AND status=’pending’ ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions

I down graded back to 7.8.2 and has no issue. 7.9 definitely has some issue

Hi @travelavenger ,

Thanks for reaching out!

I understand that updating WooCommerce core to its latest version [7.9.0] results in a fatal error being displayed when clicking on products, is this correct?

Does this occur when clicking on Products on the front end of the site, or on the backend?

Please can you walk us through the steps taken that lead you to this error so that we can see if we are able to reproduce this on our end.

Additionally, please can you share the following:

• System Status Report: navigate to WooCommerce → Status. Select Get system report and then Copy for support.
• Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.

Once you have this, please share the results in your response here.

Cheers!

The problem occur when I click on the product tab at admin panel, ie to show all the products.

And the error is in the apache as shown in the previous message, sorry the company does not allow me to send out the system report, is it possible to fix from the information provided?

Thank you!

Hi @travelavenger ,

Thanks for the clarity!

The System Status Report and Fatal error logs can provide valuable insight into what may be causing the issue.

However, the error you’re encountering seems to be related to the ActionScheduler_DBStore.php file. The Action Scheduler is a library that triggers scheduled actions, and it appears there’s a database error preventing it from functioning correctly.

There could be several reasons for this error, including a conflict with a plugin or theme, or a problem with the database.

You can try the following and see if any of these suggestions resolve the issue:

1. Perform a full conflict test.
2. Make sure that the Database is set up correctly and that there are no issues with the database server.
3. Check the sites SSR and make sure that the WooCommerce core version and the WooCommerce Database version are updated, and match. A mismatch could cause errors. You can read more about this here:

• WooCommerce Database Update

Hope this helps!

Thank you for your advise, but how come I have no issue with 7.82 and version prior but only has this fatal issue with 7.9?

Thank you again!

Hi @travelavenger ,

It could possibly be due to a plugin/theme conflicting with the latest version of WooCommerce core, or a WC database mismatch, or missing/corrupt database tables.

However without more details on the sites current environment and/or fatal errors, its difficult to troubleshoot, so the previous suggestions may be a good starting point. ??

Cheers!

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!