SQL injection via unvalidated limit and offset strings
Published Jan 17, 2023 · Updated Mar 10, 2025
SQL injection in CakePHP allows remote attackers to read or modify database data through crafted limit or offset request values. The Query::limit() and Query::offset() methods accepted nonnumeric strings that were rendered directly into LIMIT or OFFSET clauses. Exploitation requires an application to pass unfiltered request data directly to either method instead of using CakePHP's Pagination wrappers.
Summary
What happened
SQL injection in CakePHP allows remote attackers to read or modify database data through crafted limit or offset request values. The Query::limit() and Query::offset() methods accepted nonnumeric strings that were rendered directly into LIMIT or OFFSET clauses. Exploitation requires an application to pass unfiltered request data directly to either method instead of using CakePHP's Pagination wrappers.
The record
- CVE
- CVE-2023-22727
- Published
- Jan 17, 2023
- Updated
- Mar 10, 2025
- Vendor
- CakePHP
- Product
- CakePHP
- Classifications
- CWE-89, CAPEC-66, T1190
- Attack vector
- network
- Privileges
- unauthenticated
Timeline
How it unfolded
- Jan 17, 2023CVE publishedPublication date reported by the CVE source.
- Mar 10, 2025Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=>= 4.2.0, < 4.2.12
- Affected versionversion=>= 4.3.0, < 4.3.11
- Affected versionversion=>= 4.4.0, < 4.4.10
What conditions does exploitation require?
What is affected?
Published CVSS scores
CVSS describes severity. EPSS estimates exploitation probability.
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
No public exploit references are available in this record.
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo