I received a message from the hosting provider that my site will be shut down because of server overloading. When I investigated the issue I found that error which is logged in the errors log on the server:
[26-May-2021 11:20:11 UTC] WordPress database error Table ‘threec719_sim.wp_actionscheduler_logs’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_actionscheduler_logs made by do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, do_action(‘action_scheduler_execution_ignored’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_Logger->log_ignored_action, ActionScheduler_DBLogger->logThe log file grows with a megabyte of strings each second.
I disabled all other plugins and narrowed the issue to the woocommerce plugin alone, probably after an automatic update that issue occured. Tried with older versions – no luck.
2
Answers
Note: Please make a backup of the database first.
This happened when you upgrade WordPress.
I had a local version with the right tables in the database. I have copied manually the tables and the problem disappeared.
This is the SQL…hope can help you:
I had the same issue after udpating woocommerce, what i ended up doing was removing the tables in phpmyadmin:
Then creating them through SQL with the following queries:
NOTE: You will need to update the database prefix from wp_ to whatever you actually use on your site.
Hope this helps someone 🙂