Advisory

GHSA-c9w5-rwh3-7pm9

Also known as: CVE-2026-63221

Summary

CodeIgniter: SQL injection in Query Builder deleteBatch() when used with where() conditions

Details

Impact
A SQL injection vulnerability exists in the Query Builder's deleteBatch() method. When deleteBatch() is used together with where() conditions, the bound values from the WHERE clause are substituted directly into the generated SQL with their escape flag ignored, so they are never escaped or quoted. If an application passes user-controlled input to where() before calling deleteBatch(), that input is interpreted as SQL rather than as a value, allowing SQL injection.

This affects only the deleteBatch() code path. Regular delete() operations escape where() binds correctly.

Patches
Upgrade to v4.7.4 or later.

Workarounds
If you cannot upgrade immediately:

  • Strictly validate and cast values (e.g. numeric IDs) before using them in conditions - though this does not fully protect string conditions.
  • Do not pass user-controlled input to where() when using deleteBatch().
  • For user-controlled conditions, use a normal delete() with Query Builder binds instead of deleteBatch().
  • Where possible, express required matching values through the batch data and onConstraint() rather than as separate user-controlled where() clauses.

Severity

Critical Basis: The source's own band: CRITICAL

Dates

Published
2026-08-07 18:22 UTC
Modified
2026-08-07 18:31 UTC

Affected packages and fixes

codeigniter4/framework

Packagist · All systems

Affected

  • introduced 4.3.0, fixed 4.7.4 (ecosystem)

Fixed versions

4.7.4

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