Latest update failed

Hello @crpweb

Sorry for any inconvenience that might have been caused due to that.

It seems like new tables are not getting created in the Database or some old plugin has left an incorrect entry.

1. Please follow these steps to fix the issue:
https://rankmath.com/kb/fatal-error-after-1-0-49-update/

2. Please follow only the first 2 steps and clear your caches. The following steps mentioned in the article are for advanced users.

Here’s a video screencast:
https://i.rankmath.com/KStFug

Please clear all the cache, including the server after following the above process.

That should resolve the issue. Thank you.

After running the Repair Action Scheduler I still get the same issue unfortunately.

Hello @crpweb

Are you running a multisite?

If so, can you please confirm if you used the version built for the multisites?

If so, can you please record a video screencast showing the issue with the steps to reproduce it? You can use a tool like Loom for recording a screencast.

Looking forward to helping you. Thank you.

Hi,

I am not. This is for a single site.

I have RankMath on my other sites installed without issues, however with this one I keep having troubles.

Video:

https://we.tl/t-24tqmKwAhw

Error:

Foutdetails
===========
Een fout van het type E_ERROR werd veroorzaakt op regelnummer 44 van het bestand /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Foutmelding: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘db31579_wp322.wpmb_actionscheduler_actions’ doesn’t exist in /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce

Hello @crpweb

That’s unfortunate and sorry for the unwanted trouble.

Please take a complete backup of your website and please use phpMyAdmin to create the tables manually.

Please execute these SQL queries manually:

CREATE TABLE IF NOT EXISTS wpmb_actionscheduler_actions (
			action_id bigint(20) unsigned NOT NULL auto_increment,
			hook varchar(191) NOT NULL,
			status varchar(20) NOT NULL,
			scheduled_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
			scheduled_date_local datetime NOT NULL default '0000-00-00 00:00:00',
			args varchar(191),
			schedule longtext,
			group_id bigint(20) unsigned NOT NULL default '0',
			attempts int(11) NOT NULL default '0',
			last_attempt_gmt datetime NOT NULL default '0000-00-00 00:00:00',
			last_attempt_local datetime NOT NULL default '0000-00-00 00:00:00',
			claim_id bigint(20) unsigned NOT NULL default '0',
			extended_args varchar(8000) DEFAULT NULL,
			PRIMARY KEY  (action_id),
			KEY hook (hook(191)),
			KEY status (status),
			KEY scheduled_date_gmt (scheduled_date_gmt),
			KEY args (args(191)),
			KEY group_id (group_id),
			KEY last_attempt_gmt (last_attempt_gmt),
			KEY claim_id (claim_id)
			) utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS wpmb_actionscheduler_claims (
			claim_id bigint(20) unsigned NOT NULL auto_increment,
			date_created_gmt datetime NOT NULL default '0000-00-00 00:00:00',
			PRIMARY KEY  (claim_id),
			KEY date_created_gmt (date_created_gmt)
			) utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS wpmb_actionscheduler_groups (
			group_id bigint(20) unsigned NOT NULL auto_increment,
			slug varchar(255) NOT NULL,
			PRIMARY KEY  (group_id),
			KEY slug (slug(191))
			) utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS wpmb_actionscheduler_logs (
			log_id bigint(20) unsigned NOT NULL auto_increment,
			action_id bigint(20) unsigned NOT NULL,
			message text NOT NULL,
			log_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
			log_date_local datetime NOT NULL default '0000-00-00 00:00:00',
			PRIMARY KEY  (log_id),
			KEY action_id (action_id),
			KEY log_date_gmt (log_date_gmt)
			) utf8_unicode_ci;

Looking forward to helping you. Thank you.

Hi,

unfortunately I couldn’t get it to work. Even with creating those tables in phpMyAdmin. I have deleted the plug-in and I’m open to hearing new suggestions.

Kind regards,

CRP Webdesign

can you revert back to the older version by manually uploading it to your site?

Hello @crpweb

Are you still seeing the same error message or has anything changed in it?

Looking forward to helping you. Thank you.

Hi,

unfortuneately I keep having the some problem.

Een fout van het type E_ERROR werd veroorzaakt op regelnummer 44 van het bestand /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Foutmelding: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘db31579_wp322.wpmb_actionscheduler_actions’ doesn’t exist in /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /var/www/vhosts/159/128264/webspace/httpdocs/iphonereparatiesoest.nl/wp-content/plugins/seo-by-rank-math/vendor/woocommerce

Hello @crpweb

This is an important part of the error message:
Table 'db31579_wp322.wpmb_actionscheduler_actions' doesn't exist

This error cannot occur if you have created the table using the MySQL code provided above. Did you get any error when you ran those queries? Could you please confirm if the table wpmb_actionscheduler_actions exists in your database?

Looking forward to helping you. Thank you.

Hi Rank Math,

it’s not. Running those queries myself in PhPAdmin also doesn’t work. I will contact my hosting provider, maybe they can fix it by adding those tables manually.

Hello @crpweb

Yes, it seems like a limitation from the hosting’s end.

Please let us know if you need further assistance on this.

We are here to help. Thank you.