Skip to content

CVE-2023-22727 Database Query::offset() and limit() vulnerable to SQL injection in cakephp

CriticalCVSS 9.8 EPSS 0.93%
Published
Updated
Exploit status
No public exploit known
CISA SSVC
No known exploitation · automatable: yes · technical impact: total
Technology
PHPUbuntuDebian

Description

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.

Upgrade path

7 packages: 3 fixed, 4 with no fix yet.

PackageAffectedFixed inStatus
debian/cakephp(Debian 11) = 2.10.11-2.1; = 2.10.24-1; = 2.10.24-2; All versions No fix listed No fix yet
ubuntu/cakephp(Ubuntu 20.04) = 2.10.11-2; All versions No fix listed No fix yet
ubuntu/cakephp(Ubuntu 22.04) = 2.10.11-2.1; = 2.10.24-1; All versions No fix listed No fix yet
ubuntu/cakephp(Ubuntu Pro 16.04) = 2.7.2-1; = 2.8.0-1; = 2.8.0-1ubuntu0.1~esm1; All versions No fix listed No fix yet
cakephp/cakephp = >= 4.2.0, < 4.2.12; = >= 4.3.0, < 4.3.11; = >= 4.4.0, < 4.4.10; >= 4.2.0, < 4.2.12 +2 more 4.2.12, 4.3.11, 4.4.10 Fixed
cakephp/cakephp(Packagist) = 4.2.0; = 4.2.1; = 4.2.2; = 4.2.3 +32 more 4.2.12, 4.3.11, 4.4.10 Fixed
cakephp/database(Packagist) = 4.2.0; = 4.2.1; = 4.2.2; = 4.2.3 +32 more 4.2.12, 4.3.11, 4.4.10 Fixed

Affected products

ProductAffected versionsFixed in
cakephp/cakephp(Packagist) >= 4.2.0, < 4.2.12 4.2.12
cakephp/cakephp(Packagist) = 4.2.0 No fix listed
cakephp/cakephp(Packagist) = 4.2.1 No fix listed
cakephp/cakephp(Packagist) = 4.2.10 No fix listed
cakephp/cakephp(Packagist) = 4.2.11 No fix listed
cakephp/cakephp(Packagist) = 4.2.2 No fix listed
cakephp/cakephp(Packagist) = 4.2.3 No fix listed
cakephp/cakephp(Packagist) = 4.2.4 No fix listed
cakephp/cakephp(Packagist) = 4.2.5 No fix listed
cakephp/cakephp(Packagist) = 4.2.6 No fix listed
cakephp/cakephp(Packagist) = 4.2.7 No fix listed
cakephp/cakephp(Packagist) = 4.2.8 No fix listed
cakephp/cakephp(Packagist) = 4.2.9 No fix listed
cakephp/cakephp(Packagist) >= 4.3.0, < 4.3.11 4.3.11
cakephp/cakephp(Packagist) = 4.3.0 No fix listed
cakephp/cakephp(Packagist) = 4.3.1 No fix listed
cakephp/cakephp(Packagist) = 4.3.10 No fix listed
cakephp/cakephp(Packagist) = 4.3.2 No fix listed
cakephp/cakephp(Packagist) = 4.3.3 No fix listed
cakephp/cakephp(Packagist) = 4.3.4 No fix listed
cakephp/cakephp(Packagist) = 4.3.5 No fix listed
cakephp/cakephp(Packagist) = 4.3.6 No fix listed
cakephp/cakephp(Packagist) = 4.3.7 No fix listed
cakephp/cakephp(Packagist) = 4.3.8 No fix listed
cakephp/cakephp(Packagist) = 4.3.9 No fix listed
Show 66 more
ProductAffected versionsFixed in
cakephp/cakephp(Packagist) >= 4.4.0, < 4.4.10 4.4.10
cakephp/cakephp(Packagist) = 4.4.0 No fix listed
cakephp/cakephp(Packagist) = 4.4.1 No fix listed
cakephp/cakephp(Packagist) = 4.4.2 No fix listed
cakephp/cakephp(Packagist) = 4.4.3 No fix listed
cakephp/cakephp(Packagist) = 4.4.4 No fix listed
cakephp/cakephp(Packagist) = 4.4.5 No fix listed
cakephp/cakephp(Packagist) = 4.4.6 No fix listed
cakephp/cakephp(Packagist) = 4.4.7 No fix listed
cakephp/cakephp(Packagist) = 4.4.8 No fix listed
cakephp/cakephp(Packagist) = 4.4.9 No fix listed
cakephp/database(Packagist) >= 4.2.0, < 4.2.12 4.2.12
cakephp/database(Packagist) = 4.2.0 No fix listed
cakephp/database(Packagist) = 4.2.1 No fix listed
cakephp/database(Packagist) = 4.2.10 No fix listed
cakephp/database(Packagist) = 4.2.11 No fix listed
cakephp/database(Packagist) = 4.2.2 No fix listed
cakephp/database(Packagist) = 4.2.3 No fix listed
cakephp/database(Packagist) = 4.2.4 No fix listed
cakephp/database(Packagist) = 4.2.5 No fix listed
cakephp/database(Packagist) = 4.2.6 No fix listed
cakephp/database(Packagist) = 4.2.7 No fix listed
cakephp/database(Packagist) = 4.2.8 No fix listed
cakephp/database(Packagist) = 4.2.9 No fix listed
cakephp/database(Packagist) >= 4.3.0, < 4.3.11 4.3.11
cakephp/database(Packagist) = 4.3.0 No fix listed
cakephp/database(Packagist) = 4.3.1 No fix listed
cakephp/database(Packagist) = 4.3.10 No fix listed
cakephp/database(Packagist) = 4.3.2 No fix listed
cakephp/database(Packagist) = 4.3.3 No fix listed
cakephp/database(Packagist) = 4.3.4 No fix listed
cakephp/database(Packagist) = 4.3.5 No fix listed
cakephp/database(Packagist) = 4.3.6 No fix listed
cakephp/database(Packagist) = 4.3.7 No fix listed
cakephp/database(Packagist) = 4.3.8 No fix listed
cakephp/database(Packagist) = 4.3.9 No fix listed
cakephp/database(Packagist) >= 4.4.0, < 4.4.10 4.4.10
cakephp/database(Packagist) = 4.4.0 No fix listed
cakephp/database(Packagist) = 4.4.1 No fix listed
cakephp/database(Packagist) = 4.4.2 No fix listed
cakephp/database(Packagist) = 4.4.3 No fix listed
cakephp/database(Packagist) = 4.4.4 No fix listed
cakephp/database(Packagist) = 4.4.5 No fix listed
cakephp/database(Packagist) = 4.4.6 No fix listed
cakephp/database(Packagist) = 4.4.7 No fix listed
cakephp/database(Packagist) = 4.4.8 No fix listed
cakephp/database(Packagist) = 4.4.9 No fix listed
debian/cakephp(Debian:11) All versions No fix listed
debian/cakephp(Debian:11) = 2.10.11-2.1 No fix listed
debian/cakephp(Debian:11) = 2.10.24-1 No fix listed
debian/cakephp(Debian:11) = 2.10.24-2 No fix listed
cakephp/cakephp = >= 4.2.0, < 4.2.12 No fix listed
cakephp/cakephp = >= 4.3.0, < 4.3.11 No fix listed
cakephp/cakephp = >= 4.4.0, < 4.4.10 No fix listed
ubuntu/cakephp(Ubuntu:22.04) All versions No fix listed
cakephp/cakephp >= 4.2.0, < 4.2.12 4.2.12
cakephp/cakephp >= 4.3.0, < 4.3.11 4.3.11
cakephp/cakephp >= 4.4.0, < 4.4.10 4.4.10
ubuntu/cakephp(Ubuntu:Pro:16.04) All versions No fix listed
ubuntu/cakephp(Ubuntu:Pro:16.04) = 2.7.2-1 No fix listed
ubuntu/cakephp(Ubuntu:Pro:16.04) = 2.8.0-1 No fix listed
ubuntu/cakephp(Ubuntu:Pro:16.04) = 2.8.0-1ubuntu0.1~esm1 No fix listed
ubuntu/cakephp(Ubuntu:20.04) All versions No fix listed
ubuntu/cakephp(Ubuntu:20.04) = 2.10.11-2 No fix listed
ubuntu/cakephp(Ubuntu:22.04) = 2.10.11-2.1 No fix listed
ubuntu/cakephp(Ubuntu:22.04) = 2.10.24-1 No fix listed

References