SQL Syntax Error
-
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 FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu…’ at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu...' at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu…’ at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu...' at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu…’ at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu...' at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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 FROMwp_actionschedu…’ at line 1 for query DELETE FROMwp_ppfuture_workflow_scheduled_stepsAS ssa WHERE ssa.action_id NOT IN (SELECT asa.action_id FROMwp_actionscheduler_actionsAS 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
The topic ‘SQL Syntax Error’ is closed to new replies.