• Resolved Mike Meinz

    (@mikemeinz)


    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 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 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 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 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 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 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 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)
Viewing 3 replies - 1 through 3 (of 3 total)

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