{"items":[{"id":"NVI-00003232","kind":"vulnerability","title":"ZendFramework1 Potential SQL injection in the ORDER implementation of Zend_Db_Select","revision":1,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected."],"lifecycle":"active","identifiers":["GHSA-2x36-qhx3-7m5f"],"plain_summary":"OSV carries this publisher advisory for zendframework/zendframework1. 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 1.12.7 for zendframework/zendframework1. Confirm the publisher’s latest guidance.","source_ids":["sr-373d785dda1fb85b027f3a6e367275f7"],"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-373d785dda1fb85b027f3a6e367275f7","url":"https://github.com/advisories/GHSA-2x36-qhx3-7m5f","basis":"vendor_advisory","notes":"GitHub-origin advisory, CC-BY-4.0; OSV is an aggregate copy, not independent corroboration.","title":"GHSA-2x36-qhx3-7m5f","publisher":"GitHub Advisory Database via OSV","observed_at":"2026-10-31T21:41:49.646Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-373d785dda1fb85b027f3a6e367275f7"],"technology":"zendframework/zendframework1","known_exclusions":[],"conditions_summary":"The implementation of the ORDER BY SQL statement in Zend_Db_Select of Zend Framework 1 contains a potential SQL injection when the query string passed contains parentheses.\n\nFor instance, the following code is affected by this issue:\n```\n$db     = Zend_Db::factory( /* options here */ );\n$select = $db->select()\n    ->from(array('p' => 'products'))\n    ->order('MD5(1); drop table products');\necho $select;\n```\nThis code produce the string:\n```\nSELECT \"p\".* FROM \"products\" AS \"p\" ORDER BY MD5(1);drop table products ASC\n```\ninstead of the correct one:\n```\nSELECT \"p\".* FROM \"products\" AS \"p\" ORDER BY \"MD5(1);drop table products\" ASC\n```\nThe SQL injection occurs because we create a new Zend_Db_Expr() object, in presence of parentheses, passing directly the value without any filter on the string.","public_affected_ranges":["ECOSYSTEM: introduced 1.12.0; fixed 1.12.7"]}],"null_published_at":"2026-10-31T22:12:43.400Z","source_updated_at":"2024-12-04T05:39:35.461Z","source_disclosed_at":"2024-06-07T22:24:52.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:41:49.646Z"}],"next_cursor":null,"snapshot_revision":"42594"}