-
Notifications
You must be signed in to change notification settings - Fork 54
Open
Description
I activated WooCommerce in Studio and checked the debug.log afterwards; it contained this SQLite error. The plugin works as expected.
Listing or running scheduled actions didn't create any errors later.
[03-Feb-2026 06:16:03 UTC] WordPress database error <div style="clear:both"> </div>
<div class="queries" style="clear:both;margin-bottom:2px;border:red dotted thin;">
<p>MySQL query:</p>
<p>INSERT wp_actionscheduler_logs (action_id, message, log_date_gmt, log_date_local) VALUES (10, 'action canceled', '2026-02-03 06:16:03', '2026-02-03 06:16:03')</p>
<p>Queries made or created this session were:</p>
<ol>
<li>Executing: BEGIN IMMEDIATE | (no parameters)</li>
<li>Executing: SELECT 1 FROM sqlite_temp_schema WHERE type = 'table' AND name = ? | parameters: wp_actionscheduler_logs</li>
<li>Executing:
SELECT LOWER(column_name) AS COLUMN_NAME, is_nullable, column_default, data_type, extra
FROM `_wp_sqlite_mysql_information_schema_columns`
WHERE table_schema = ?
AND table_name = ?
ORDER BY ordinal_position
| parameters: sqlite_database, wp_actionscheduler_logs</li>
<li>Executing: INSERT `wp_actionscheduler_logs` (`action_id`, `message`, `log_date_gmt`, `log_date_local`) SELECT CAST(`column1` AS INTEGER), CAST(`column2` AS TEXT), CASE
WHEN `column3` IS NULL THEN NULL
WHEN DATETIME(`column3`) > '0' THEN DATETIME(`column3`)
ELSE '0000-00-00 00:00:00'
END, CASE
WHEN `column4` IS NULL THEN NULL
WHEN DATETIME(`column4`) > '0' THEN DATETIME(`column4`)
ELSE '0000-00-00 00:00:00'
END FROM (VALUES ( 10 , 'action canceled' , '2026-02-03 06:16:03' , '2026-02-03 06:16:03' )) WHERE true | (no parameters)</li>
<li>Executing: ROLLBACK | (no parameters)</li>
</ol>
</div>
<div style="clear:both;margin-bottom:2px;border:red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">
SQLSTATE[HY000]: General error: 1 near "`wp_actionscheduler_logs`": syntax error
</div>
<p>Backtrace:</p>
<pre>#0 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/sqlite-ast/class-wp-sqlite-driver.php(832): WP_SQLite_Driver->new_driver_exception('SQLSTATE[HY000]...', 'HY000', Object(PDOException))
#1 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(537): WP_SQLite_Driver->query('INSERT wp_actio...')
#2 /wordpress/wp-content/mu-plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(449): WP_SQLite_DB->_do_query('INSERT wp_actio...')
#3 /internal/symlinks/Users/bero/Downloads/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBLogger.php(152): WP_SQLite_DB->query('INSERT wp_actio...')
#4 /wordpress/wp-includes/class-wp-hook.php(341): ActionScheduler_DBLogger->bulk_log_cancel_actions(Array)
#5 /wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#6 /wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#7 /internal/symlinks/Users/bero/Downloads/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(780): do_action('action_schedule...', Array)
#8 /internal/symlinks/Users/bero/Downloads/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(714): ActionScheduler_DBStore->bulk_cancel_actions(Array)
#9 /internal/symlinks/Users/bero/Downloads/woocommerce/packages/action-scheduler/functions.php(318): ActionScheduler_DBStore->cancel_actions_by_hook('woocommerce_cle...')
#10 /internal/symlinks/Users/bero/Downloads/woocommerce/includes/queue/class-wc-action-queue.php(113): as_unschedule_all_actions('woocommerce_cle...', Array, '')
#11 /internal/symlinks/Users/bero/Downloads/woocommerce/src/Blocks/Domain/Services/DraftOrders.php(73): WC_Action_Queue->cancel_all('woocommerce_cle...')
#12 /wordpress/wp-includes/class-wp-hook.php(341): Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->unschedule_cronjobs(false)
#13 /wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters(NULL, Array)
#14 /wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#15 /wordpress/wp-admin/includes/plugin.php(826): do_action('deactivate_wooc...', false)
#16 /wordpress/wp-admin/plugins.php(211): deactivate_plugins('woocommerce/woo...', false, false)
#17 {main}</pre>
for query INSERT wp_actionscheduler_logs (action_id, message, log_date_gmt, log_date_local) VALUES (10, 'action canceled', '2026-02-03 06:16:03', '2026-02-03 06:16:03') made by deactivate_plugins, do_action('deactivate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Domain\Services\DraftOrders->unschedule_cronjobs, WC_Action_Queue->cancel_all, as_unschedule_all_actions, ActionScheduler_DBStore->cancel_actions_by_hook, ActionScheduler_DBStore->bulk_cancel_actions, do_action('action_scheduler_bulk_cancel_actions'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_DBLogger->bulk_log_cancel_actions, WP_SQLite_DB->query, WP_SQLite_DB->print_error
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels