Advisory

GHSA-r54v-qq87-px5r

Also known as: CVE-2026-32272

Summary

Craft Commerce hasVariant/hasProduct Blind SQL Injection

Details

Overview

Craft Commerce’s ProductQuery::hasVariant and VariantQuery::hasProduct properties bypass the unset() blocklist added to ElementIndexesController in GHSA-2453-mppf-46cj.

The blocklist only strips top-level Yii2 Query properties (where, orderBy, etc.), but hasVariant and hasProduct pass
through untouched. Internally, these properties call Craft::configure() on a subquery without sanitization, re-introducing SQL injection via criteria[hasVariant][where]=INJECTED_SQL.

An authenticated control panel user can perform boolean-based blind SQL injection through the patched ElementIndexesController and extract arbitrary database contents.

Impact

  • Full database read access via blind SQL injection
  • Privilege escalation via security key extraction → forged admin sessions

Prerequisites

  • Authenticated control panel user
  • Commerce plugin installed
  • Products with variants in the database

Severity

High Basis: The source's own band: HIGH

Dates

Published
2026-04-14 00:06 UTC
Modified
2026-07-08 07:27 UTC

Affected packages and fixes

craftcms/commerce

Packagist · All systems

Affected

  • introduced 5.0.0, fixed 5.6.0 (ecosystem)

Fixed versions

5.6.0

Fix

The export has no generic command for this ecosystem.

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0

Sources & licences