Advisory

GHSA-6g8q-qfpv-57wp

Also known as: CVE-2023-22727

Summary

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

Details

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

Severity

Critical Basis: The source's own band: CRITICAL

Dates

Published
2023-01-20 17:30 UTC
Modified
2026-09-10 03:49 UTC

Affected packages and fixes

cakephp/cakephp

Packagist · All systems

Affected

  • introduced 4.2.0, fixed 4.2.12 (ecosystem)

Fixed versions

4.2.12

Fix

The export has no generic command for this ecosystem.

cakephp/cakephp

Packagist · All systems

Affected

  • introduced 4.3.0, fixed 4.3.11 (ecosystem)

Fixed versions

4.3.11

Fix

The export has no generic command for this ecosystem.

cakephp/cakephp

Packagist · All systems

Affected

  • introduced 4.4.0, fixed 4.4.10 (ecosystem)

Fixed versions

4.4.10

Fix

The export has no generic command for this ecosystem.

cakephp/database

Packagist · All systems

Affected

  • introduced 4.2.0, fixed 4.2.12 (ecosystem)

Fixed versions

4.2.12

Fix

The export has no generic command for this ecosystem.

cakephp/database

Packagist · All systems

Affected

  • introduced 4.3.0, fixed 4.3.11 (ecosystem)

Fixed versions

4.3.11

Fix

The export has no generic command for this ecosystem.

cakephp/database

Packagist · All systems

Affected

  • introduced 4.4.0, fixed 4.4.10 (ecosystem)

Fixed versions

4.4.10

Fix

The export has no generic command for this ecosystem.

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0

Sources & licences