Title: SQL Syntax Error
Last modified: December 14, 2024

---

# SQL Syntax Error

 *  Resolved [Mike Meinz](https://wordpress.org/support/users/mikemeinz/)
 * (@mikemeinz)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/sql-syntax-error-24/)
 * I found these error messages in our webste’s **error_log** file. I don’t if there
   is anything I can do about them but I thought the developers might be interested
   in knowing about them.
 * [11-Dec-2024 15:23:35 UTC] WordPress database error You have an error in your
   SQL syntax; check the manual that corresponds to your MariaDB server version 
   for the right syntax to use near ‘AS ssa WHERE ssa.action_id NOT IN (SELECT asa.
   action_id FROM `wp_actionschedu...' at line 1 for query DELETE FROM`wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array('publishpressfuture_cleanup_orphan_workflow_args'),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteOrphanWorkflowArgs, PublishPress\Future\Modules\
   Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs `
   `[11-Dec-2024
   15:23:35 UTC] WordPress database error You have an error in your SQL syntax; 
   check the manual that corresponds to your MariaDB server version for the right
   syntax to use near 'AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`
   wp_actionschedu…’ at line 1 for query DELETE FROM `wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM `wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array(‘publishpressfuture_cleanup_finished_scheduled_steps’),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteExpiredScheduledSteps, PublishPress\Future\
   Modules\Workflows\Models\ScheduledActionsModel->deleteExpiredScheduledSteps, 
   PublishPress\Future\Modules\Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs[
   12-Dec-2024 15:24:27 UTC] WordPress database error You have an error in your 
   SQL syntax; check the manual that corresponds to your MariaDB server version 
   for the right syntax to use near ‘AS ssa WHERE ssa.action_id NOT IN (SELECT asa.
   action_id FROM `wp_actionschedu...' at line 1 for query DELETE FROM`wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array('publishpressfuture_cleanup_orphan_workflow_args'),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteOrphanWorkflowArgs, PublishPress\Future\Modules\
   Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs ``[12-Dec-2024
   15:24:27 UTC] WordPress database error You have an error in your SQL syntax; 
   check the manual that corresponds to your MariaDB server version for the right
   syntax to use near 'AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`
   wp_actionschedu…’ at line 1 for query DELETE FROM `wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM `wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array(‘publishpressfuture_cleanup_finished_scheduled_steps’),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteExpiredScheduledSteps, PublishPress\Future\
   Modules\Workflows\Models\ScheduledActionsModel->deleteExpiredScheduledSteps, 
   PublishPress\Future\Modules\Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs[
   13-Dec-2024 15:24:30 UTC] WordPress database error You have an error in your 
   SQL syntax; check the manual that corresponds to your MariaDB server version 
   for the right syntax to use near ‘AS ssa WHERE ssa.action_id NOT IN (SELECT asa.
   action_id FROM `wp_actionschedu...' at line 1 for query DELETE FROM`wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array('publishpressfuture_cleanup_orphan_workflow_args'),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteOrphanWorkflowArgs, PublishPress\Future\Modules\
   Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs ``[13-Dec-2024
   15:24:30 UTC] WordPress database error You have an error in your SQL syntax; 
   check the manual that corresponds to your MariaDB server version for the right
   syntax to use near 'AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`
   wp_actionschedu…’ at line 1 for query DELETE FROM `wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM `wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array(‘publishpressfuture_cleanup_finished_scheduled_steps’),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteExpiredScheduledSteps, PublishPress\Future\
   Modules\Workflows\Models\ScheduledActionsModel->deleteExpiredScheduledSteps, 
   PublishPress\Future\Modules\Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs[
   14-Dec-2024 15:24:30 UTC] WordPress database error You have an error in your 
   SQL syntax; check the manual that corresponds to your MariaDB server version 
   for the right syntax to use near ‘AS ssa WHERE ssa.action_id NOT IN (SELECT asa.
   action_id FROM `wp_actionschedu...' at line 1 for query DELETE FROM`wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array('publishpressfuture_cleanup_orphan_workflow_args'),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteOrphanWorkflowArgs, PublishPress\Future\Modules\
   Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs ``[14-Dec-2024
   15:24:30 UTC] WordPress database error You have an error in your SQL syntax; 
   check the manual that corresponds to your MariaDB server version for the right
   syntax to use near 'AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM`
   wp_actionschedu…’ at line 1 for query DELETE FROM `wp_ppfuture_workflow_scheduled_steps`
   AS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROM `wp_actionscheduler_actions`
   AS asa) made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action,
   WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner-
   >do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action-
   >execute, do_action_ref_array(‘publishpressfuture_cleanup_finished_scheduled_steps’),
   WP_Hook->do_action, WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\
   Controllers\ScheduledActions->deleteExpiredScheduledSteps, PublishPress\Future\
   Modules\Workflows\Models\ScheduledActionsModel->deleteExpiredScheduledSteps, 
   PublishPress\Future\Modules\Workflows\Models\ScheduledActionsModel->deleteOrphanWorkflowArgs

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [Riza Maulana Ardiyanto](https://wordpress.org/support/users/rizaardiyanto/)
 * (@rizaardiyanto)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/sql-syntax-error-24/#post-18204218)
 * Hi [@mikemeinz](https://wordpress.org/support/users/mikemeinz/)
 * Sorry for the inconvenience.
 * Can you please let me know what DB server you are using? Is it MySQL or Maria
   DB or else? Also what version you are using?
 * Thanks,
 *  Thread Starter [Mike Meinz](https://wordpress.org/support/users/mikemeinz/)
 * (@mikemeinz)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/sql-syntax-error-24/#post-18204239)
 * Copied from GoDaddy CPanel:
 * `MySQL Version: 10.6.20-MariaDB-cll-lve
   Architecture: x86_64Operating System:
   linux
 *  Plugin Support [Riza Maulana Ardiyanto](https://wordpress.org/support/users/rizaardiyanto/)
 * (@rizaardiyanto)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/sql-syntax-error-24/#post-18209218)
 * [@mikemeinz](https://wordpress.org/support/users/mikemeinz/) Thanks for the information.
 * This probably related to our query not being fully compatible with your DB server.
 * I’ve created a GitHub issue on this one so our developer could check it: [https://github.com/publishpress/PublishPress-Future/issues/1087](https://github.com/publishpress/PublishPress-Future/issues/1087)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL Syntax Error’ is closed to new replies.

 * ![](https://ps.w.org/post-expirator/assets/icon-256x256.png?rev=3118683)
 * [Schedule Post Changes With PublishPress Future: Unpublish, Delete, Change Status, Trash, Change Categories](https://wordpress.org/plugins/post-expirator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/post-expirator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/post-expirator/)
 * [Active Topics](https://wordpress.org/support/plugin/post-expirator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/post-expirator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/post-expirator/reviews/)

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 3 replies
 * 2 participants
 * Last reply from: [Riza Maulana Ardiyanto](https://wordpress.org/support/users/rizaardiyanto/)
 * Last activity: [1 year, 5 months ago](https://wordpress.org/support/topic/sql-syntax-error-24/#post-18209218)
 * Status: resolved