Database Query::offset() and limit() vulnerable to SQL injection in cakephp
cakephp
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| cakephp/cakephp Packagist |
|
|
| cakephp/database Packagist |
cakephp
| Product | Affected | Fixed in |
|---|---|---|
| cakephp/cakephp Packagist |
|
|
| cakephp/database Packagist |
≥ 4.2.0 · < 4.2.12≥ 4.3.0 · < 4.3.11≥ 4.4.0 · < 4.4.10
|
CakePHP is a development framework for PHP web apps. In affected versions the `Cake\Database\Query::limit()` and `Cake\Database\Query::offset()` methods are vulnerable to SQL injection if passed un-sanitized user request data. This issue has been fixed in 4.2.12, 4.3.11, 4.4.10. Users are advised to upgrade. Users unable to upgrade may mitigate this issue by using CakePHP's Pagination library. Manually validating or casting parameters to these methods will also mitigate the issue.
From the CVE record · GitHub_M
CakePHP’s `Cake\Database\Query::limit()` and `offset()` methods are vulnerable to SQL injection when passed unsanitized user request data. An attacker who can supply that data through a request may inject SQL; the input does not specify authentication or additional user-interaction requirements.
Check applications using Packagist `cakephp/cakephp` or `cakephp/database` versions >=4.2.0 <4.2.12, >=4.3.0 <4.3.11, or >=4.4.0 <4.4.10.