Error on multiple sites after update

Pretty much the same issue with the 6.15.0 update for us. I rolled back to 6.14.2 and all is well.

Pressable is our host, WP 6.8, PHP 8.3.

Tom

@ Plugin Devs:
There was a comment from your team asking for a test environment, that is now gone. However, if you still need a test environment we (Pressable) would be happy to provide you with one.

I can’t reach your team as we don’t have a licence. But you can live chat with us at Pressable[dot]com or email help[at]pressable[dot]come

For posterity, I wanted to note that the issue with the sites I’ve observed is that they, for some reason, are missing their {database-prefix}_actionscheduler_logs tables.

Then the StellarWP DB & Shepherd functionality included In TEC encounters a fatal because it doesn’t know how to handle that condition.

Relevant errors.

WordPress database error Table 'wp_actionscheduler_logs' doesn't exist for query SHOW FULL COLUMNS FROM wp_actionscheduler_logs /* {site-domain}.tld/wp-admin/admin-ajax.php?action=as_async_request_queue_runner&nonce=xxxxxx request_id: {request_id} */ made by require_once('wp-load.php'), require_once('/srv/htdocs/wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, TEC\Common\StellarWP\Shepherd\Regulator->schedule_cleanup_task, TEC\Common\StellarWP\Shepherd\Regulator->dispatch, TEC\Common\StellarWP\Shepherd\Regulator->dispatch_callback, TEC\Common\StellarWP\Shepherd\Action_Scheduler_Methods::schedule_single_action, as_schedule_single_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->save_action_to_db, do_action('action_scheduler_stored_action'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_Logger->log_stored_action, ActionScheduler_DBLogger->log

PHP Fatal error:  Uncaught TEC\Common\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291
Stack trace:
#0 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(114): TEC\Common\StellarWP\DB\DB::runQueryWithErrorChecking(Object(Closure))
#1 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(109): TEC\Common\StellarWP\DB\DB::__callStatic('query', Array)
#2 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(67): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::insert_many(Array)
#3 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(95): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::insert(Array)
#4 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Log.php(335): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::upsert(Array)
#5 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Loggers/ActionScheduler_DB_Logger.php(71): TEC\Common\StellarWP\Shepherd\Log->save()
#6 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Loggable.php(64): TEC\Common\StellarWP\Shepherd\Loggers\ActionScheduler_DB_Logger->log('info', 'Task 8177 creat...', Array)
#7 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Loggable.php(80): TEC\Common\StellarWP\Shepherd\Regulator->log('info', 'created', 8177, 'Task 8177 creat...', Array)
#8 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(200): TEC\Common\StellarWP\Shepherd\Regulator->log_created(8177, Array)
#9 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(145): TEC\Common\StellarWP\Shepherd\Regulator->dispatch_callback(Object(TEC\Common\StellarWP\Shepherd\Tasks\Herding), 21600)
#10 /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(395): TEC\Common\StellarWP\Shepherd\Regulator->dispatch(Object(TEC\Common\StellarWP\Shepherd\Tasks\Herding), 21600)
#11 /wordpress/core/6.8.2/wp-includes/class-wp-hook.php(322): TEC\Common\StellarWP\Shepherd\Regulator->schedule_cleanup_task()
#12 /wordpress/core/6.8.2/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array)
#13 /wordpress/core/6.8.2/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#14 /wordpress/core/6.8.2/wp-settings.php(727): do_action('init')
#15 /srv/htdocs/wp-config.php(85): require_once('/wordpress/core...')
#16 /wordpress/core/6.8.2/wp-load.php(55): require_once('/srv/htdocs/wp-...')
#17 /wordpress/core/6.8.2/wp-admin/admin-ajax.php(22): require_once('/wordpress/core...')
#18 {main}
  thrown in /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php on line 291

To resolve, you can create the actionscheduler_logs table manually or install the action-scheduler plugin and visit /wp-admin/tools.php?page=action-schedule or run wp action-scheduler fix-schema via WP-CLI.

Same thing is happening with my website. I was only able to roll back “The Events Calendar” to 6.14.2 but i am still getting error codes with my “The Events Calendar Pro” plugin. Cleared cache and did the old version and the calendar still isnt working.

I have The Events Calendar 16.15.0,1 and The Events Calendar Pro 7.7.0 installed and I am seeing the problem on my clone site created using WP Staging. So far, the real site is OK but if I install Foogallery plug-in (or Modula Gallery, or Envira Gallery, or Meow Gallery) on the clone site within a few hours the clone system crashes with the same E_ERROR caused in line 291 of the file /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php. Error message: Uncaught TEC\Common\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /srv/htdocs/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291. I opened a ticket at The Events Calendar but so far no response.

I got the same error today in the latest version of The Events Calendar (6.15.6). I found 51 corrupt lines in wp_shepherd_tec_tasks in my database. This bug doesn’t seem to be resolved, or it has made a comeback in the latest update.

An error of type E_ERROR occurred on line 291 in the following file:
/home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php.

Error message:
Uncaught TEC\Common\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query
in /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291

0 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(114): TEC\Common\StellarWP\DB\DB::runQueryWithErrorChecking() 1 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(109): TEC\Common\StellarWP\DB\DB::__callStatic() 2 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(67): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::insert_many() 3 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Traits/Custom_Table_Query_Methods.php(95): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::insert() 4 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Abstracts/Model_Abstract.php(67): TEC\Common\StellarWP\Shepherd\Abstracts\Table_Abstract::upsert() 5 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Abstracts/Task_Model_Abstract.php(243): TEC\Common\StellarWP\Shepherd\Abstracts\Model_Abstract->save() 6 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(179): TEC\Common\StellarWP\Shepherd\Abstracts\Task_Model_Abstract->save() 7 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(145): TEC\Common\StellarWP\Shepherd\Regulator->dispatch_callback() 8 /home/mysite/mysite.se/wp-content/plugins/the-events-calendar/common/vendor/vendor-prefixed/stellarwp/shepherd/src/Regulator.php(395): TEC\Common\StellarWP\Shepherd\Regulator->dispatch() 9 /home/mysite/mysite.se/wp-includes/class-wp-hook.php(322): TEC\Common\StellarWP\Shepherd\Regulator->schedule_cleanup_task() 10 /home/mysite/mysite.se/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() 11 /home/mysite/mysite.se/wp-includes/plugin.php(517): WP_Hook->do_action() 12 /home/mysite/mysite.se/wp-settings.php(727): do_action() 13 /home/mysite/mysite.se/wp-config.php(126): require_once('/home/mysite/my…') 14 /home/mysite/mysite.se/wp-load.php(50): require_once('/home/mysite/my…') 15 /home/mysite/mysite.se/wp-admin/admin-ajax.php(22): require_once('/home/mysite/my…') 16 {main}

thrown