Fatal error after woocommerce 4.0 update

Same problem

Hey there!

The error is due to the id number for a scheduled action. Here’s the steps we use to resolve this. Work your way down the list only if the steps don’t fix it, so only go to #2 if #1 doesn’t fix it, etc.

1. Try to run the WooCommerce Database update again. That is found in the WooCommerce menu, under “Status” and then the “Tools” tab. There’s a button there to run it again.

2. Install the standalone Action Scheduler plugin here: https://github.com/woocommerce/action-scheduler/ (the green button there to download, and then install manually on your site as plugin).

3. Manually change the id for the scheduled action in your WordPress database to something significantly larger. That’s found in the actionscheduler_actions table in your database, and in your case the ids are 1 and 18. Change those to a larger one and it should be good to go.

Hopefully that helps! Have a great one!

Hello,
Thank you for your help.
I tried option n.1, but nothing changed. Error is still there.
Then, I installed Action Scheduler ,but I think something is not ok.
It says:
“Action Scheduler migration in progress. The list of scheduled actions may be incomplete.
A new queue has begun processing. View actions in-progress”
If I click in view actions in-progress, this message changes to “The next queue will begin processing in approximately 57 seconds”, but the rest is the same, and after coutdown message changes to the original one, and so on.
19 Hooks founded, 17 compelted and 2 pending.

Did I do something wrong? something that I missed?

Thanks again and regards
Pablo

Hi, i had the same problem and after downloading and installing this version it was back up running. Version 4.0.1. from Peter Fabian:
https://github.com/woocommerce/woocommerce/releases

I hope it helps you to, cheers Dennis

Hi there @vialactea,

We haven’t heard back from you in a while, so I’m going to mark this thread as resolved. Hopefully the update to version 4.0.1 helped, as recommended by @ned13! If you have any further questions, please start a new thread.

Have a wonderful day!

Hello,
No, unfurtanetly issue is not solved.

I came back to a previous back up with Woocommerce 3.x because I needed to upload products to my ecommerce.
Today, I launched again Woocommerce 4.01 update (together with WordPress update) and issue is again here.

It is related to the database update. The process of updating my database starts but it doesn’t finish. If I click to “View progress” it takes me to the Scheduled Actions section and shows an empty list of (5) Pending actions for the update.
There is a message that says “next queue will start in aprox 15 secs” and nothing happens. There is also a message that says “Migration of scheduled actions is ongoing. List of scheduled actions could be incomplete.”

Find here a screen shot:
https://www.via-lactea.es/wp-content/uploads/2020/04/Scheduled-actions.png

Thanks for your support.

Regards
Pablo

@vialactea

Did you resolve this? I am having the exact same issue.

Hello,
No, unfortunately I did not, and I have no idea how to solve it… Theme and hosting IT support say is Woocommerce plugin related and they cannot help me.

@kellymetal, @ned13 do you have an idea what to we could try to fix the issue?
The problem is somehow related to the action scheduler.

Regards
Pablo

@vialactea after much Googling I came across this post: https://github.com/woocommerce/woocommerce/issues/25987#issuecomment-605388627

I deleted/dropped those tables from my database, made WooCommerce regenerate them and the issue was instantly fixed.

The tables are:

wp_actionscheduler_actions
wp_actionscheduler_claims
wp_actionscheduler_groups
wp_actionscheduler_logs

I suggest you take a backup of your database and do the same.

The other consequence I noticed from this bug is that it was causing extremely high CPU usage on my VPS for this WordPress instance, the second I dropped the tables it was fixed.

@bluebirdwebdev, thank you for the info.
I really appreciate it.

Could you tell me how to delete these tables?

Regards
Pablo

@vialactea

If you’re not comfortable editing your database, it may be worth either getting your website host or a developer to do so, as deleting the wrong thing or accidentally making wrong changes to your database can cause significant issues. Take a backup before you do anything too, so you can restore things if necessary.

To delete those tables, navigate to your database using PHPMyAdmin

Look for the tables that will likely have a prefix XXX_ prior to their name:

wp_actionscheduler_actions
wp_actionscheduler_claims
wp_actionscheduler_groups
wp_actionscheduler_logs

View post on imgur.com

Click on the “Drop” button to delete the databases.

Log in to your WordPress site and visit
WooCommerce > Status > Tools > Update Database

It will say something about required tables are missing, click here to generate. Do that, then run your WooCommerce database update and it should be fixed.

Hello @bluebirdwebdev ,
Thank you for your help, I am reading about how to use PHPMyAdmin before make any change.
I think I will try soon.
Do I have to delete these tables before o after Woocommerce update?

Regards
Pablo

Hi,
Finally I did it but something was wrong and there was a fatal error. I restored a backup.
Process was like that:
1- I launched Woocommerce update from 3.9.1 to 4.0.1 version. Result ok.
2- Woocommerce data base update started automatically. Result no ok, 11 pending actions in queue and no end.
3- Cache deleted and WordPress closed.
4- The 4 tables indicated deleted from PHPMyAdmin.
5- Try to log in to my WordPress site but not possible. Message says Fatal error.

Should I delete those tables before Woocommerce update?

Regards and thanks again for your support.

@bluebirdwebdev,
Do I have to delete these tables before o after Woocommerce update?

Hello,
I have finally updated Woocommerce to 4.0.1 version including data base update.
In this time, I deleted these tables before plugin update. Once plugin update was ok data base update started and there was an error. After that I forced Woocommerce data base update manually again and it seems it worked.
Now I can see these tables generated again in PHPMyAdmin and only some unfinished jobs under WooCommerce > Status > Scheduled Actions tab from Facebook plugin.

Thanks @bluebirdwebdev for your help.

Regards
Pablo