There has been a critical error on your website

I’m getting this too ??

• This reply was modified 4 years, 7 months ago by bellotaweb.

I don’t know if this was related,
I was getting a lot of password recovery attempts also.

Hi @sounds, @bellotaweb

Thanks for reaching out. When you get a chance, could you please setup error logs and share the log with us? This is likely due to the error because your site was unable to create database tables for Action Scheduler which we introduced since 2.1.1. If you’re getting errors related to Action Scheduler, please follow our article to fix this.

I hope this helps!

Hi,

I was wondering about that actually,
Because wordfence listed some tables that weren’t in use by any plugins,
And I removed some, maybe that’s the cause.

I tried to install that action scheduler too, got same error message.

Hello Sanjeev,

I receive the critical error as well. The wordpress alert email displayed the following details regarding the error:

Error details
===========================================
Type E_ERROR was detected on line 44 of file /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php.

Error code: Uncaught RuntimeException: Error saving action: Error saving action: Table 'xxx.xxx_actionscheduler_actions' doesn't exist in /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action()
#1 /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action()
#2 /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store()
#3 /var/www/vhosts/domain.com/domain.com/wp-content/plugins/wp-mail-smtp/

I followed the fix you mentioned here and receved the same critical error for Action Scheduler plugin..

Regards!

• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.

Hi @pickme,

Thanks for the error details! If you’re still getting the error after installing the Action Scheduler plugin, there’s probably some misconfiguration that your site is not able to create the required database tables.

You might need to contact your hosting provider to create the required database tables. Alternatively, you can follow these steps:

1. Install & Activate plugin WP-DBManager
2. Go to menu Database -> Empty/Drop tables.
3. Check like drop the tables contains the next words: actionscheduler_actions, actionscheduler_claims, actionscheduler_groups, actionscheduler_logs https://a.supportally.com/6FqwVZ and click to button Empty/Drop at the bottom.
4. Go to page https://yoursite.com/wp-admin/options.php
5. Clean the options: action_scheduler_hybrid_store_demarkation, schema-ActionScheduler_StoreSchema, schema-ActionScheduler_LoggerSchema, action_scheduler_lock_async-request-runner and save changes.
6. Activate WP Mail SMTP plugin.
7. Delete WP-DBMigration plugin.

I hope this helps!

Hi @sanzeeb3!

Thank you very much for the super analytical support reply.

I cloned the staging site that fortunately had these 4 action scheduler tables, to its live version and the issue was resolved in that manner. I am now installing plugin action-scheduler-3.1.6 to another site on which the 4 tables are missing and are imported successfully.

If I encounter a problem with action-scheduler-3.1.6 I will follow your steps.

Question: It is a good practice to install those 4 tables via plugin action-scheduler-3.1.6 to any website I maintain in order to solve this problem before it arise, or an SQL database is fine without these tables, since there is no notice of a problem?

Thank you

• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.

Hi @pickme,

You do not need to separately install the Action Scheduler plugin under normal conditions. Action Scheduler is built into WP Mail SMTP. If you face such errors again due to some misconfiguration, you can follow those steps without manually installing an action scheduler plugin.

I hope this helps!

Hello @sanzeeb3,

The 4 Action Scheduler tables are created by Woocommerce and used by WP Mail SMTP?

If these tables are deleted or they are not present because Woocommerce is not installed, then WP mail SMTP cannot be installed?

Could you please clarify this?

On another website I think I had deleted them via WP optimize plugin. After, I installed WP Mail SMTP plugin and it was not able to create the aformentioned 4 tables. Problems where noticed to many plugins, not only WP mail SMTP.

Thank you.

• This reply was modified 4 years, 7 months ago by pickme.
• This reply was modified 4 years, 7 months ago by pickme.

That was my mistake also I think.
Used WP Optimize and deleted those tables.
It indicated they were not being used by any plugin.

Hi @pickme, @sounds,

The Action Scheduler library is created by WooCommerce, and the plugins such as WooCommerce, WP Mail SMTP etc. use this library which means these 4 Action Scheduler tables can be created by either plugin. You’ll not need WooCommerce to create these tables or have WP Mail SMTP installed.

When you manually deleted the tables via WP-Optimize plugin, there might be some residues leftover and WP Mail SMTP could not create those tables. In such cases, the steps I’ve stated earlier should fix the issue.

Basically, you’ll not need to install WooCommerce or Action Scheduler plugin manually. WP Mail SMTP installs the required tables for Action Scheduler if those are not already created.

I hope this helps!

Hi Sanjeev Aryal,

If it’s a Multisite and if WP Mail SMTP doesn’t give this error in the main site but in another site; would you still recommend following above 7 steps?

Thanks,

Hi @mrinasz,

Yes, if you have WP Mail SMTP installed separately on subsites and there could be some database configuration in your multisite creating the issue.

For multisite if you’d like to use the same SMTP settings across subsites, we recommend activating WP Mail SMTP network-wide and using SMTP constants so that all of your subsites use the same SMTP settings.

I hope this helps!

Hi Sanjeev,

I followed your instructions but while I was in the process of doing step 5 I got a critical error and now can’t even access the site, it is completely down at the moment.

I tried deleting the plug in (along with another one that I suspect was in conflict called “Check-Email”) through SSH as well as FTP but even though permissions are set properly (I checked 755 for folders and 644 for files) it wont let me and will say permission denied.

Do you have any suggestions on how to solve this?

Thanks in advance

I am thinking that I would need to recover those deleted files as that may not have been the problem in the first place and are now creating a bigger one. Could someone kindly provide me with those files mentioned by Sanjeev and their paths so that I can reupload them through FTP?

Many thanks in advance.