{"items":[{"id":"NVI-00007891","kind":"vulnerability","title":"CodeIgniter: SQL injection in Query Builder deleteBatch() when used with where() conditions","revision":3,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected.","NVD lastModified does not establish freshness of every associated CPE record."],"lifecycle":"active","identifiers":["GHSA-c9w5-rwh3-7pm9","CVE-2026-63221"],"plain_summary":"OSV carries this publisher advisory for codeigniter4/framework. This is an aggregated source copy; consult the original publisher and compare update dates.","review_status":"source_listed","control_topics":[],"public_actions":[{"summary":"The original advisory lists fixed boundaries 4.7.4 for codeigniter4/framework. Confirm the publisher’s latest guidance.","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"action_type":"vendor_patch","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null},{"summary":"Identify the exact component and deployed version, examine the linked publisher’s conditions, and retain evidence of any mitigation.","source_ids":["sr-21d27a0d1fdc17cf363efd3ce887d016"],"action_type":"investigate","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null}],"schema_version":"1.1.0","source_metrics":[{"kind":"CVSS","as_of":"2026-09-08T20:51:43.490Z","value":"9.4 CRITICAL (3.1)","meaning":"security-advisories@github.com severity; no combined Null risk score.","source_id":"sr-3cf5bd556abe0e32916297224c4bbda8"},{"kind":"EPSS","as_of":"2026-11-03T12:00:27.000Z","value":"0.612%","meaning":"FIRST EPSS model v2026.06.15; exploitation probability over 30 days, percentile 0.49364. Missing scores are unknown.","source_id":"sr-21d27a0d1fdc17cf363efd3ce887d016"}],"why_it_matters":"Published affected context helps an owner decide what evidence to gather. This report has not examined your application.","related_sources":[{"id":"sr-ecab021f26c2ad5f55114d398aef5359","url":"https://github.com/advisories/GHSA-c9w5-rwh3-7pm9","basis":"vendor_advisory","notes":"GitHub-origin advisory, CC-BY-4.0; OSV is an aggregate copy, not independent corroboration.","title":"GHSA-c9w5-rwh3-7pm9","publisher":"GitHub Advisory Database via OSV","observed_at":"2026-10-31T21:42:10.698Z"},{"id":"sr-3cf5bd556abe0e32916297224c4bbda8","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-63221","basis":"official_catalog","notes":"This product uses data from the NVD API but is not endorsed or certified by the NVD.","title":"CVE-2026-63221","publisher":"NIST National Vulnerability Database","observed_at":"2026-11-04T02:47:38.696Z"},{"id":"sr-21d27a0d1fdc17cf363efd3ce887d016","url":"https://www.first.org/epss/data.html","basis":"official_catalog","notes":"FIRST EPSS; probability of exploitation in the next 30 days, not local compromise. Dataset date/model retained; FIRST services terms apply.","title":"CVE-2026-63221","publisher":"FIRST EPSS","observed_at":"2026-11-03T17:45:16.076Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"technology":"codeigniter4/framework","known_exclusions":[],"conditions_summary":"### Impact\nA 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.\n\nThis affects only the `deleteBatch()` code path. Regular `delete()` operations escape `where()` binds correctly.\n\n### Patches\nUpgrade to v4.7.4 or later.\n\n### Workarounds\nIf you cannot upgrade immediately:\n\n- Strictly validate and cast values (e.g. numeric IDs) before using them in conditions - though this does not fully protect string conditions.\n- Do not pass user-controlled input to `where()` when using `deleteBatch()`.\n- For user-controlled conditions, use a normal `delete()` with Query Builder binds instead of `deleteBatch(`).\n- Where possible, express required matching values through the batch data and `onConstraint()` rather than as separate user-controlled `where()` clauses.","public_affected_ranges":["ECOSYSTEM: introduced 4.3.0; fixed 4.7.4"]}],"null_published_at":"2026-11-07T14:01:55.430Z","source_updated_at":"2026-08-07T18:31:29.631Z","source_disclosed_at":"2026-08-07T18:22:59.000Z","is_synthetic_fixture":false,"null_last_reviewed_at":null,"public_change_summary":"Dated EPSS estimate updated; this is not a new disclosure or proof of exploitation.","null_first_observed_at":"2026-10-31T21:42:10.698Z"},{"id":"NVI-00007891","kind":"vulnerability","title":"CodeIgniter: SQL injection in Query Builder deleteBatch() when used with where() conditions","revision":2,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected.","NVD lastModified does not establish freshness of every associated CPE record."],"lifecycle":"active","identifiers":["GHSA-c9w5-rwh3-7pm9","CVE-2026-63221"],"plain_summary":"OSV carries this publisher advisory for codeigniter4/framework. This is an aggregated source copy; consult the original publisher and compare update dates.","review_status":"source_listed","control_topics":[],"public_actions":[{"summary":"The original advisory lists fixed boundaries 4.7.4 for codeigniter4/framework. Confirm the publisher’s latest guidance.","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"action_type":"vendor_patch","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null},{"summary":"Identify the exact component and deployed version, examine the linked publisher’s conditions, and retain evidence of any mitigation.","source_ids":["sr-3cf5bd556abe0e32916297224c4bbda8"],"action_type":"investigate","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null}],"schema_version":"1.1.0","source_metrics":[{"kind":"CVSS","as_of":"2026-09-08T20:51:43.490Z","value":"9.4 CRITICAL (3.1)","meaning":"security-advisories@github.com severity; no combined Null risk score.","source_id":"sr-3cf5bd556abe0e32916297224c4bbda8"}],"why_it_matters":"Published affected context helps an owner decide what evidence to gather. This report has not examined your application.","related_sources":[{"id":"sr-ecab021f26c2ad5f55114d398aef5359","url":"https://github.com/advisories/GHSA-c9w5-rwh3-7pm9","basis":"vendor_advisory","notes":"GitHub-origin advisory, CC-BY-4.0; OSV is an aggregate copy, not independent corroboration.","title":"GHSA-c9w5-rwh3-7pm9","publisher":"GitHub Advisory Database via OSV","observed_at":"2026-10-31T21:42:10.698Z"},{"id":"sr-3cf5bd556abe0e32916297224c4bbda8","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-63221","basis":"official_catalog","notes":"This product uses data from the NVD API but is not endorsed or certified by the NVD.","title":"CVE-2026-63221","publisher":"NIST National Vulnerability Database","observed_at":"2026-11-04T02:47:38.696Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"technology":"codeigniter4/framework","known_exclusions":[],"conditions_summary":"### Impact\nA 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.\n\nThis affects only the `deleteBatch()` code path. Regular `delete()` operations escape `where()` binds correctly.\n\n### Patches\nUpgrade to v4.7.4 or later.\n\n### Workarounds\nIf you cannot upgrade immediately:\n\n- Strictly validate and cast values (e.g. numeric IDs) before using them in conditions - though this does not fully protect string conditions.\n- Do not pass user-controlled input to `where()` when using `deleteBatch()`.\n- For user-controlled conditions, use a normal `delete()` with Query Builder binds instead of `deleteBatch(`).\n- Where possible, express required matching values through the batch data and `onConstraint()` rather than as separate user-controlled `where()` clauses.","public_affected_ranges":["ECOSYSTEM: introduced 4.3.0; fixed 4.7.4"]}],"null_published_at":"2026-11-04T10:04:35.936Z","source_updated_at":"2026-08-07T18:31:29.631Z","source_disclosed_at":"2026-08-07T18:22:59.000Z","is_synthetic_fixture":false,"null_last_reviewed_at":null,"public_change_summary":"Source facts changed; compare the preserved prior revision.","null_first_observed_at":"2026-10-31T21:42:10.698Z"},{"id":"NVI-00007891","kind":"vulnerability","title":"CodeIgniter: SQL injection in Query Builder deleteBatch() when used with where() conditions","revision":1,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected."],"lifecycle":"active","identifiers":["GHSA-c9w5-rwh3-7pm9","CVE-2026-63221"],"plain_summary":"OSV carries this publisher advisory for codeigniter4/framework. This is an aggregated source copy; consult the original publisher and compare update dates.","review_status":"source_listed","control_topics":[],"public_actions":[{"summary":"The original advisory lists fixed boundaries 4.7.4 for codeigniter4/framework. Confirm the publisher’s latest guidance.","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"action_type":"vendor_patch","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null}],"schema_version":"1.1.0","source_metrics":[],"why_it_matters":"Published affected context helps an owner decide what evidence to gather. This report has not examined your application.","related_sources":[{"id":"sr-ecab021f26c2ad5f55114d398aef5359","url":"https://github.com/advisories/GHSA-c9w5-rwh3-7pm9","basis":"vendor_advisory","notes":"GitHub-origin advisory, CC-BY-4.0; OSV is an aggregate copy, not independent corroboration.","title":"GHSA-c9w5-rwh3-7pm9","publisher":"GitHub Advisory Database via OSV","observed_at":"2026-10-31T21:42:10.698Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-ecab021f26c2ad5f55114d398aef5359"],"technology":"codeigniter4/framework","known_exclusions":[],"conditions_summary":"### Impact\nA 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.\n\nThis affects only the `deleteBatch()` code path. Regular `delete()` operations escape `where()` binds correctly.\n\n### Patches\nUpgrade to v4.7.4 or later.\n\n### Workarounds\nIf you cannot upgrade immediately:\n\n- Strictly validate and cast values (e.g. numeric IDs) before using them in conditions - though this does not fully protect string conditions.\n- Do not pass user-controlled input to `where()` when using `deleteBatch()`.\n- For user-controlled conditions, use a normal `delete()` with Query Builder binds instead of `deleteBatch(`).\n- Where possible, express required matching values through the batch data and `onConstraint()` rather than as separate user-controlled `where()` clauses.","public_affected_ranges":["ECOSYSTEM: introduced 4.3.0; fixed 4.7.4"]}],"null_published_at":"2026-10-31T22:13:18.639Z","source_updated_at":"2026-08-07T18:31:29.631Z","source_disclosed_at":"2026-08-07T18:22:59.000Z","is_synthetic_fixture":false,"null_last_reviewed_at":null,"public_change_summary":"First indexed by Null; source disclosure date is shown separately.","null_first_observed_at":"2026-10-31T21:42:10.698Z"}],"next_cursor":null,"snapshot_revision":"42594"}