GHSA-6g8q-qfpv-57wpCriticalCVSS 9.8

CakePHP Database\\Query::offset() and limit() methods are vulnerable to SQL injection

Published
January 20, 2023
Last Modified
January 25, 2023

🔗 CVE IDs covered (1)

CVE-2023-22727 →

📋 Description

Impact

The Cake\Database\Query::limit() and Cake\Database\Query::offset() methods are vulnerable to SQL injection if passed un-sanitized user request data.

Patches

This issue has been fixed in 4.2.12, 4.3.11, 4.4.10

Workarounds

Using CakePHP's Pagination library will mitigate this issue, as will validating or casting parameters to these methods.

References

https://bakery.cakephp.org/2023/01/06/cakephp_4211_4311_4410_released.html

🎯 Affected products6

  • composer/cakephp/cakephp:>= 4.2.0, < 4.2.12
  • composer/cakephp/cakephp:>= 4.3.0, < 4.3.11
  • composer/cakephp/cakephp:>= 4.4.0, < 4.4.10
  • composer/cakephp/database:>= 4.2.0, < 4.2.12
  • composer/cakephp/database:>= 4.3.0, < 4.3.11
  • composer/cakephp/database:>= 4.4.0, < 4.4.10

🔗 References (5)