Just a quick note that I run into this issue today while testing one Studio site. ``` [17-Apr-2026 11:50:05 UTC] WordPress database error

MySQL query:

DELETE FROM wp_actionscheduler_actions WHERE hook = 'wp_mail_smtp_queue_process' AND status = 'complete' LIMIT 10

Queries made or created this session were:

Executing: BEGIN IMMEDIATE | (no parameters)
Executing: DELETE FROM `wp_actionscheduler_actions` WHERE `hook` = 'wp_mail_smtp_queue_process' AND `status` = 'complete' LIMIT 10 | (no parameters)
Executing: ROLLBACK | (no parameters)

SQLSTATE[HY000]: General error: 1 near "LIMIT": syntax error

Backtrace:

#0 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/database/sqlite/class-wp-pdo-mysql-on-sqlite.php(921): WP_PDO_MySQL_On_SQLite->new_driver_exception('SQLSTATE[HY000]...', 'HY000', Object(PDOException))
#1 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/database/sqlite/class-wp-sqlite-driver.php(160): WP_PDO_MySQL_On_SQLite->query('DELETE FROM wp_...', 5)
#2 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(543): WP_SQLite_Driver->query('DELETE FROM wp_...')
#3 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(455): WP_SQLite_DB->_do_query('DELETE FROM wp_...')
#4 /wordpress/wp-content/plugins/wp-mail-smtp/src/Tasks/Task.php(389): WP_SQLite_DB->query('DELETE FROM wp_...')
#5 /wordpress/wp-content/plugins/wp-mail-smtp/src/Tasks/Queue/ProcessQueueTask.php(82): WPMailSMTP\Tasks\Task->remove_completed(10)
#6 /wordpress/wp-includes/class-wp-hook.php(341): WPMailSMTP\Tasks\Queue\ProcessQueueTask->cleanup('')
#7 /wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#8 /wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#9 /wordpress/wp-content/plugins/post-expirator/lib/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(163): do_action('action_schedule...')
#10 /wordpress/wp-includes/class-wp-hook.php(341): ActionScheduler_QueueRunner->run('Async Request')
#11 /wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#12 /wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#13 /wordpress/wp-content/plugins/post-expirator/lib/vendor/woocommerce/action-scheduler/classes/ActionScheduler_AsyncRequest_QueueRunner.php(48): do_action('action_schedule...', 'Async Request')
#14 /wordpress/wp-content/plugins/post-expirator/lib/vendor/woocommerce/action-scheduler/lib/WP_Async_Request.php(174): ActionScheduler_AsyncRequest_QueueRunner->handle()
#15 /wordpress/wp-includes/class-wp-hook.php(341): WP_Async_Request->maybe_handle('')
#16 /wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#17 /wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#18 /wordpress/wp-admin/admin-ajax.php(192): do_action('wp_ajax_as_asyn...')
#19 {main}

for query DELETE FROM wp_actionscheduler_actions WHERE hook = 'wp_mail_smtp_queue_process' AND status = 'complete' LIMIT 10 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, do_action('action_scheduler_after_process_queue'), WP_Hook->do_action, WP_Hook->apply_filters, WPMailSMTP\Tasks\Queue\ProcessQueueTask->cleanup, WPMailSMTP\Tasks\Task->remove_completed, WP_SQLite_DB->query, WP_SQLite_DB->print_error ```

Support DELETE with LIMIT and ORDER BY #100

Description

Metadata

Metadata

Assignees

Labels

Type

Fields

Projects

Milestone

Relationships

Development

Issue actions

Support `DELETE` with `LIMIT` and `ORDER BY` #100