Skip to content

I18N: Store an empty WPLANG option to avoid a query on every page load - #15212

Open
JDeepD wants to merge 1 commit into
WordPress:trunkfrom
JDeepD:fix/50980-wplang
Open

JDeepD wants to merge 1 commit into
WordPress:trunkfrom
JDeepD:fix/50980-wplang

Conversation

@JDeepD

@JDeepD JDeepD commented Oct 30, 2026

Copy link
Copy Markdown

Sites that never changed their language have no WPLANG row, so get_option( 'WPLANG' ) in get_locale() misses alloptions and queries the database on every request without a persistent object cache.

This refreshes #476 against current trunk:

  • populate_options() adds an autoloaded empty WPLANG on single sites. Because upgrade_all() calls populate_options(), existing sites get it on the next database upgrade. The $wp_db_version bump is left for commit.
  • Multisite is skipped, so subsites keep falling back to the network language.
  • A WPLANG constant set to a locale is respected (no row is added), since the option would otherwise override it.
  • populate_network() removes an empty WPLANG from the main site when converting a single site to a network. Without this, the main site ignored the network language.

Trac ticket: https://core.trac.wordpress.org/ticket/50980

Use of AI Tools

AI assistance: Yes
Tool(s): Claude Code
Model(s): Claude Opus 5.5
Used for: Reproducing the issue, investigating the previous PR's test failure, and drafting the code and tests. I directed the approach and reviewed the final changes.


This Pull Request is for code review only. Please keep all other discussion in the Trac ticket. Do not merge this Pull Request. See GitHub Pull Requests for Code Review in the Core Handbook for more details.

Sites that never changed their language have no `WPLANG` row,
so `get_locale()` ran an options query on every request without
a persistent object cache.

`populate_options()` now adds an autoloaded empty `WPLANG` on single sites.
This covers new installs and, through `upgrade_all()`, existing sites on the
next database upgrade. A `WPLANG` constant set to a locale keeps taking precedence.

When a single site is converted to a network, an empty `WPLANG` is removed from
the main site so that it keeps falling back to the network language.
@github-actions

Copy link
Copy Markdown

The following accounts have interacted with this PR and/or linked issues. I will continue to update these lists as activity occurs.

Core Committers: Use this line as a base for the props when committing in SVN:

Props jdeep.

To understand the WordPress project's expectations around crediting contributors, please review the Contributor Attribution page in the Core Handbook.


Props Bot commands

You can trigger Props Bot actions by commenting on this PR:

  • @propsbot add <username> to give props to a GitHub user. Requires write access.
  • @propsbot remove <username> to leave a user out of the props. Requires write access.
  • @propsbot refresh to refresh this list. Adding the props-bot label works too.

@github-actions

Copy link
Copy Markdown

Test using WordPress Playground

The changes in this pull request can previewed and tested using a WordPress Playground instance.

WordPress Playground is an experimental project that creates a full WordPress instance entirely within the browser.

Some things to be aware of

  • All changes will be lost when closing a tab with a Playground instance.
  • All changes will be lost when refreshing the page.
  • A fresh instance is created each time the link below is clicked.
  • Every time this pull request is updated, a new ZIP file containing all changes is created. If changes are not reflected in the Playground instance,
    it's possible that the most recent build failed, or has not completed. Check the list of workflow runs to be sure.

For more details about these limitations and more, check out the Limitations page in the WordPress Playground documentation.

Test this pull request with WordPress Playground.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant