CVE-2026-31825: Sylius has a DQL Injection via API Order Filters
Impact Sylius API filters ProductPriceOrderFilter and TranslationOrderNameAndLocaleFilter pass user-supplied order direction values directly to Doctrine's orderBy() without validation. An attacker can inject arbitrary DQL: Patches The issue is fixed in versions: 1.9.12, 1.10.16, 1.11.17, 1.12.23, 1.13.15, 1.14.18, 2.0.16, 2.1.12, 2.2.3 and above.
Published Mar 11, 2026
Affected packages
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- <= 1.9.11
- Fixed in
- 1.9.12
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 1.10.0, <= 1.10.15
- Fixed in
- 1.10.16
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 1.11.0, <= 1.11.16
- Fixed in
- 1.11.17
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 1.12.0, <= 1.12.22
- Fixed in
- 1.12.23
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 1.13.0, <= 1.13.14
- Fixed in
- 1.13.15
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 1.14.0, <= 1.14.17
- Fixed in
- 1.14.18
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 2.0.0, <= 2.0.15
- Fixed in
- 2.0.16
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 2.1.0, <= 2.1.11
- Fixed in
- 2.1.12
- Check
composer show sylius/sylius
sylius/sylius
- Ecosystem
- Composer (PHP)
- Affected
- >= 2.2.0, <= 2.2.2
- Fixed in
- 2.2.3
- Check
composer show sylius/sylius
Advisory details
From the GitHub Advisory Database (CC BY 4.0).
Impact
Sylius API filters ProductPriceOrderFilter and TranslationOrderNameAndLocaleFilter pass user-supplied order direction values directly to Doctrine's orderBy() without validation. An attacker can inject arbitrary DQL:
GET /api/v2/shop/products?order[price]=ASC,%20variant.code%20DESCPatches
The issue is fixed in versions: 1.9.12, 1.10.16, 1.11.17, 1.12.23, 1.13.15, 1.14.18, 2.0.16, 2.1.12, 2.2.3 and above.
Workarounds
An EventSubscriber that sanitizes order query parameters only on API routes before they reach the vulnerable filters.
The subscriber accepts an $apiRoute constructor parameter (default /api/v2) and skips non-API requests entirely — so there is zero overhead on shop/admin page requests.
This follows the same pattern used by Sylius's own KernelRequestEventSubscriber (src/Sylius/Bundle/ApiBundle/EventSubscriber/KernelRequestEventSubscriber.php), which also uses str_contains($pathInfo, $this->apiRoute) to scope logic to API routes.
---
Step 1 — Create the EventSubscriber
src/EventSubscriber/SanitizeOrderDirectionSubscriber.php:
<?php
declare(strict_types=1);
namespace App\EventSubscriber;
use Symfony\Component\EventDispatcher\EventSubscriberInterface;
use Symfony\Component\HttpKernel\Event\RequestEvent;
use Symfony\Component\HttpKernel\KernelEvents;
final class SanitizeOrderDirectionSubscriber implements EventSubscriberInterface
{
private const ALLOWED_DIRECTIONS = ['asc', 'desc'];
public function __construct(
private string $apiRoute,
) {
}
public static function getSubscribedEvents(): array
{
return [
KernelEvents::REQUEST => ['sanitizeOrderParameters', 64],
];
}
public function sanitizeOrderParameters(RequestEvent $event): void
{
if (!str_contains($event->getRequest()->getPathInfo(), $this->apiRoute)) {
return;
}
$request = $event->getRequest();
/** @var mixed $order */
$order = $request->query->all()['order'] ?? null;
if (!is_array($order)) {
return;
}
$needsSanitization = false;
$sanitized = [];
foreach ($order as $field => $direction) {
if (is_string($direction) && in_array(strtolower($direction), self::ALLOWED_DIRECTIONS, true)) {
$sanitized[$field] = $direction;
} else {
$needsSanitization = true;
}
}
if (!$needsSanitization) {
return;
}
$all = $request->query->all();
$all['order'] = $sanitized;
$request->query->replace($all);
$request->server->set('QUERY_STRING', http_build_query($all));
$request->attributes->set('_api_filters', $all);
}
}Step 2 — Register the service
Option A — If your config/services.yaml already has App\ autowiring (Symfony default):
# Nothing to do — autoconfigure picks up EventSubscriberInterface automatically.
# Optionally bind the API route prefix:
services:
App\EventSubscriber\SanitizeOrderDirectionSubscriber:
arguments:
$apiRoute: '%sylius.security.new_api_route%'Option B — If there is no App\ autowiring:
services:
App\EventSubscriber\SanitizeOrderDirectionSubscriber:
arguments:
$apiRoute: '%sylius.security.new_api_route%'
tags: ['kernel.event_subscriber']Using %sylius.security.new_api_route% ties the subscriber to the same prefix Sylius uses (/api/v2 by default). If the parameter is not available, hardcode '/api/v2' instead.
Step 3 — Clear cache
bin/console cache:clearReporters
We would like to extend our gratitude to the following individuals for their detailed reporting and responsible disclosure of this vulnerability:
- Chris Alupului (@Neosprings)
- Bartłomiej Nowiński (@bnBart)
For more information
If you have any questions or comments about this advisory:
- Open an issue in Sylius issues
- Email us at [[email protected]](mailto:[email protected])
Credited to Neosprings, bnBart.
References
How this page is made: the data panel comes from the GitHub Advisory Database, CISA’s KEV catalog, the NVD and FIRST EPSS, and updates twice a day. No analysis has been written for this entry yet. Methodology
More Composer (PHP) vulnerabilities
All Composer (PHP) entriesCVE-2026-53637
Sylius: Cart FormComponent allows modification or deletion of an already-completed order
medium6.5Jul 9, 2026CVE-2026-53638
Sylius: Channel-based payment method restriction bypass on shop account orders API endpoint
medium4.3Jul 9, 2026CVE-2026-53639
Sylius: IDOR on Shop Payment Request API endpoints
medium6.3Jul 9, 2026CVE-2026-31819
Sylius has an Open Redirect via Referer Header
medium6.9Mar 11, 2026CVE-2026-31820
Sylius affected by IDOR in Cart and Checkout LiveComponents
high7.1Mar 11, 2026CVE-2026-31821
Sylius is Missing Authorization in API v2 Add Item Endpoint
medium6.9Mar 11, 2026
