[ php-wasm ] Follow-up on Intl

[mho22]

Intl

• [ php-wasm ] add intl extension #2187
• [ Intl ] disable Intl functions in bootWordpress by default #2247
• [ php-wasm ] Add intl dynamic extension to @php-wasm/node JSPI #2501
• [ php-wasm ] Add intl dynamic extension to @php-wasm/node ASYNCIFY #2501 #2557
• [ php-wasm ] Add intl dynamic extension to @php-wasm/web #2591
• [ php-wasm ] Remove static intl extension artifacts #2970
• [ Intl ] Implement Intl in blueprints #2979
• [ Intl ] Implement Intl in Playground CLI #3011
• [Website] Move dynamic extension files in assets/extensions directory #2984

Dynamic extension

• Transform withIntl into a more generic option : withExtensions and manage those extensions individually.
• Transform setPHPIniEntries to mention which php ini file we want to create or update
• Set MAIN_MODULE = 2
• [ Vite ] Regroup ignore-*-imports Vite plugin inside a vite-extension #2999
• [ Vite ] Regroup preserve-*-loaders-imports Vite plugin inside a vite-extension #3002

Related issues and pull requests

• [Intl] Correct intl errors during compilation and build #2613
• [Php-wasm] Add intl support #2173
• [ Intl ] An unexpected error occurred while trying to use PHP Intl Collator class #2466
• PHP intl extension #1295

[enwikuna]

Hi,

don't know if its related to this ticket but Playground stopped working on all our demo websites:

[26-Nov-2025 11:59:38 UTC] An unexpected error occurred while trying to use PHP Intl Collator class, it may be caused by an incorrect installation of PHP Intl and ICU, and could be fixed by reinstallaing PHP Intl, see more details about PHP Intl installation: https://www.php.net/manual/en/intl.installation.php. Error message: Constructor failed
[26-Nov-2025 11:59:39 UTC] WordPress database error <div style="clear:both">&nbsp;</div>
<div class="queries" style="clear:both;margin-bottom:2px;border:red dotted thin;">
<p>MySQL query:</p>
<p>SELECT wp_wc_orders.id FROM wp_wc_orders  WHERE 1=1 AND (wp_wc_orders.status IN ('wc-pending','wc-processing','wc-on-hold','wc-completed','wc-cancelled','wc-refunded','wc-failed','wc-checkout-draft')) AND (wp_wc_orders.type = 'shop_order_refund') AND (wp_wc_orders.parent_order_id = 11) GROUP BY wp_wc_orders.id ORDER BY wp_wc_orders.date_created_gmt DESC LIMIT 0, 18446744073709551615</p>
<p>Queries made or created this session were:</p>
<ol>
<li>Executing: BEGIN IMMEDIATE | (no parameters)</li>
<li>Executing: SELECT `wp_wc_orders`.`id` FROM `wp_wc_orders` WHERE 1 = 1 AND ( `wp_wc_orders`.`status` IN ( 'wc-pending' , 'wc-processing' , 'wc-on-hold' , 'wc-completed' , 'wc-cancelled' , 'wc-refunded' , 'wc-failed' , 'wc-checkout-draft' ) ) AND ( `wp_wc_orders`.`type` = 'shop_order_refund' ) AND ( `wp_wc_orders`.`parent_order_id` = 11 ) GROUP BY `wp_wc_orders`.`id` ORDER BY `wp_wc_orders`.`date_created_gmt` DESC LIMIT 0 , 18446744073709551615 | (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: 20 datatype mismatch
</div>
<p>Backtrace:</p>
<pre>#0 /internal/shared/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 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(537): WP_SQLite_Driver->query('SELECT wp_wc_or...')
#2 /internal/shared/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php(449): WP_SQLite_DB->_do_query('SELECT wp_wc_or...')
#3 /wordpress/wp-includes/class-wpdb.php(3): WP_SQLite_DB->query('SELECT wp_wc_or...')
#4 /wordpress/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/OrdersTableQuery.php(1416): wpdb->get_col('SELECT wp_wc_or...')
#5 /wordpress/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/OrdersTableQuery.php(211): Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery->run_query()
#6 /wordpress/wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/OrdersTableDataStore.php(3104): Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery->__construct(Array)
#7 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(224): Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore->query(Array)
#8 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-order-query.php(87): WC_Data_Store->__call('query', Array)
#9 /wordpress/wp-content/plugins/woocommerce/includes/wc-order-functions.php(76): WC_Order_Query->get_orders()
#10 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-order.php(2147): wc_get_orders(Array)
#11 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-order.php(2308): WC_Order->get_refunds()
#12 /wordpress/wp-content/plugins/woocommerce/templates/emails/email-order-items.php(196): WC_Order->get_qty_refunded_for_item(1)
#13 /wordpress/wp-content/plugins/woocommerce/includes/wc-core-functions.php(346): include('/wordpress/wp-c...')
#14 /wordpress/wp-content/plugins/woocommerce/includes/wc-template-functions.php(3622): wc_get_template('emails/email-or...', Array)
#15 /wordpress/wp-content/plugins/woocommerce/templates/emails/email-order-details.php(93): wc_get_email_order_items(Object(WC_Order), Array)
#16 /wordpress/wp-content/plugins/woocommerce/includes/wc-core-functions.php(346): include('/wordpress/wp-c...')
#17 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-emails.php(513): wc_get_template('emails/email-or...', Array)
#18 /wordpress/wp-includes/class-wp-hook.php(3): WC_Emails->order_details(Object(WC_Order), false, false, Object(WC_Email_Customer_Completed_Order))
#19 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters(NULL, Array)
#20 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#21 /wordpress/wp-content/plugins/woocommerce/templates/emails/customer-completed-order.php(56): do_action('woocommerce_ema...', Object(WC_Order), false, false, Object(WC_Email_Customer_Completed_Order))
#22 /wordpress/wp-content/plugins/woocommerce/includes/wc-core-functions.php(346): include('/wordpress/wp-c...')
#23 /wordpress/wp-content/plugins/woocommerce/includes/wc-core-functions.php(365): wc_get_template('emails/customer...', Array, '', '')
#24 /wordpress/wp-content/plugins/woocommerce/includes/emails/class-wc-email-customer-completed-order.php(118): wc_get_template_html('emails/customer...', Array)
#25 /wordpress/wp-content/plugins/woocommerce/includes/emails/class-wc-email.php(847): WC_Email_Customer_Completed_Order->get_content_html()
#26 /wordpress/wp-content/plugins/woocommerce/includes/emails/class-wc-email-customer-completed-order.php(74): WC_Email->get_content()
#27 /wordpress/wp-includes/class-wp-hook.php(3): WC_Email_Customer_Completed_Order->trigger(11, Object(WC_Order))
#28 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters('', Array)
#29 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#30 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-emails.php(211): do_action_ref_array('woocommerce_ord...', Array)
#31 /wordpress/wp-includes/class-wp-hook.php(3): WC_Emails::send_transactional_email(Array, Object(WC_Order), Array)
#32 /wordpress/wp-includes/class-wp-hook.php(3): WP_Hook->apply_filters(NULL, Array)
#33 /wordpress/wp-includes/plugin.php(2): WP_Hook->do_action(Array)
#34 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-order.php(448): do_action('woocommerce_ord...', 11, Object(WC_Order), Array)
#35 /wordpress/wp-content/plugins/woocommerce/includes/class-wc-order.php(274): WC_Order->status_transition()
#36 /wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version2/class-wc-rest-orders-v2-controller.php(831): WC_Order->save()
#37 /wordpress/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-crud-controller.php(205): WC_REST_Orders_V2_Controller->save_object(Object(WP_REST_Request), true)
#38 /wordpress/wp-includes/rest-api/class-wp-rest-server.php(3): WC_REST_CRUD_Controller->create_item(Object(WP_REST_Request))
#39 /wordpress/wp-includes/rest-api/class-wp-rest-server.php(3): WP_REST_Server->respond_to_request(Object(WP_REST_Request), '/wc/v2/orders', Array, NULL)
#40 /wordpress/wp-includes/rest-api.php(2): WP_REST_Server->dispatch(Object(WP_REST_Request))
#41 /wordpress/wp-content/plugins/woocommerce/includes/cli/class-wc-cli-rest-command.php(304): rest_do_request(Object(WP_REST_Request))
#42 /wordpress/wp-content/plugins/woocommerce/includes/cli/class-wc-cli-rest-command.php(130): WC_CLI_REST_Command->do_request('POST', '/wc/v2/orders', Array)
#43 [internal function]: WC_CLI_REST_Command->create_item(Array, Array)
#44 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/CommandFactory.php(100): call_user_func(Array, Array, Array)
#45 [internal function]: WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}(Array, Array)
#46 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Dispatcher/Subcommand.php(497): call_user_func(Object(Closure), Array, Array)
#47 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(470): WP_CLI\Dispatcher\Subcommand->invoke(Array, Array, Array)
#48 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(493): WP_CLI\Runner->run_command(Array, Array)
#49 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1295): WP_CLI\Runner->run_command_and_exit()
#50 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/WP_CLI/Bootstrap/LaunchRunner.php(28): WP_CLI\Runner->start()
#51 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/bootstrap.php(84): WP_CLI\Bootstrap\LaunchRunner->process(Object(WP_CLI\Bootstrap\BootstrapState))
#52 phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php(35): WP_CLI\bootstrap()
#53 phar:///tmp/wp-cli.phar/php/boot-phar.php(20): include('phar:///tmp/wp-...')
#54 /tmp/wp-cli.phar(4): include('phar:///tmp/wp-...')
#55 /wordpress/run-cli.php(22): require('/tmp/wp-cli.pha...')
#56 {main}</pre>
 for query SELECT wp_wc_orders.id FROM wp_wc_orders  WHERE 1=1 AND (wp_wc_orders.status IN ('wc-pending','wc-processing','wc-on-hold','wc-completed','wc-cancelled','wc-refunded','wc-failed','wc-checkout-draft')) AND (wp_wc_orders.type = 'shop_order_refund') AND (wp_wc_orders.parent_order_id = 11) GROUP BY wp_wc_orders.id ORDER BY wp_wc_orders.date_created_gmt DESC LIMIT 0, 18446744073709551615 made by require('/tmp/wp-cli.phar'), include('phar:///tmp/wp-cli.phar/php/boot-phar.php'), include('phar:///tmp/wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, WC_CLI_REST_Command->create_item, WC_CLI_REST_Command->do_request, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WC_REST_CRUD_Controller->create_item, WC_REST_Orders_V2_Controller->save_object, WC_Order->save, WC_Order->status_transition, do_action('woocommerce_order_status_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Emails::send_transactional_email, do_action_ref_array('woocommerce_order_status_completed_notification'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Email_Customer_Completed_Order->trigger, WC_Email->get_content, WC_Email_Customer_Completed_Order->get_content_html, wc_get_template_html, wc_get_template, include('/plugins/woocommerce/templates/emails/customer-completed-order.php'), do_action('woocommerce_email_order_details'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Emails->order_details, wc_get_template, include('/plugins/woocommerce/templates/emails/email-order-details.php'), wc_get_email_order_items, wc_get_template, include('/plugins/woocommerce/templates/emails/email-order-items.php'), WC_Order->get_qty_refunded_for_item, WC_Order->get_refunds, wc_get_orders, WC_Order_Query->get_orders, WC_Data_Store->__call, Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore->query, Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery->__construct, Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableQuery->run_query, WP_SQLite_DB->query, WP_SQLite_DB->print_error

[mho22]

Hi @enwikuna! This issue is a follow-up to track progress on the intl extension. I believe you’ve encountered the same problem I’m currently working on. I’ll let you know once it’s resolved. In the meantime, if you’re using Blueprints, there’s a related issue with a temporary workaround here: #2466.

[enwikuna]

@mho22 alright, good to hear you're on it! Good luck fixing it. We will just wait for a follow-up and hotfix. It's not that urgent but would be cool if it works again at some point.