Hey @gnislew,
You’re seeing this error because the Action Scheduler tables don’t exist in your database. Action Scheduler is a framework that All in One SEO started to use in the latest version, and it’s a framework that’s used by a lot of different plugins like WooCommerce. If the tables do not exist, then AIOSEO will try to create them, but it’s obviously not working.
We’re currently investigating as to why this might be happening. You should probably temporarily rollback to the previous version (download here – https://downloads.wp.xz.cn/plugin/all-in-one-seo-pack.3.7.1.zip) until we’ve found a solution.
If you’d like to be of help (and we’d actually really appreciate it), would you mind temporarily installing WooCommerce to check if the tables then do get created? That information could help us find out whether we are doing something wrong or whether this is an environment related issue.
– Arnaud
Hi,
thanks for the fast reply. When installing WooCommerce I am running into a similiar stack trace.
Ein Fehler vom Typ E_ERROR wurde in der Zeile 44 der Datei /customers/1/e/8/blogspiele.de/httpd.www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php verursacht. Fehlermeldung: Uncaught RuntimeException: Fehler beim Speichern der Aktion: Fehler beim Speichern der Aktion: Table ‘blogspiele_de.wp_actionscheduler_actions’ doesn’t exist in /customers/1/e/8/blogspiele.de/httpd.www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /customers/1/e/8/blogspiele.de/httpd.www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /customers/1/e/8/blogspiele.de/httpd.www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /customers/1/e/8/blogspiele.de/httpd.www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /customers/
Hope this informations help to solve the issue. For the moment I will not fall back to the old version but leave the plugin disabled.
best regards
Michael
Hey Michael,
Thank you for getting back to us.
I would actually reach out to your hosting company and ask about this. This indicates you (and the other users who’ve experienced this) might be running into an environment issue, and there’s little we can do from our end to troubleshoot this at the moment.
At the very least, could you tell us who your hosting provider is? That way I can already reach out to them myself.
– Arnaud
Hey Michael,
Just to follow up: would you mind adding this code snippet to your theme’s functions.php file (you can also use the Code Snippet plugin for this if you like), then navigate to a random page, delete the code again and try activating All in One SEO?
add_action( 'init', function() {
delete_option( 'schema-ActionScheduler_StoreSchema' );
} );
It’s possible an older plugin on your website already created the Action Scheduler tables, but didn’t run any update routines for newer versions of Action Scheduler, which is why plugins that use a more recent versions crash. We’ve been investigating this issue and many other plugins that use Action Scheduler seem to have run into this issue.
The code above is supposed to delete a specific option of Action Scheduler so that its upgrade routines are triggered.
– Arnaud
@gnislew I wanted to check in and see if the code snippet that Arnaud posted above worked.
Hi,
sorry for the late reply. The code snippet didn’t work. I doubt that there is an infrastructure issue with my provider one.com, because I run two other pages on the same server as blogspiele and there the plugin is not causing problems.
Good news. I did some more digging and compared my DB structure of blogspiele with one of the sites where AIOSEO is running correctly. The action scheduler tables where not present on blogspiele, so I exported them from the other page, imported them to blogspiele, cleared them and restarted the plugin. As I previously deinstalled the plugin is there any table that schould be created by your plugin?
@gnislew All in One SEO creates these tables:
wp_aioseo_notifications
wp_aioseo_posts
It uses the actionscheduler tables which are also used by other plugins.
Strange. Those two tables were not created when installing the plugin again. Do I need to recreate them manually?
