CriticalGHSA-887w-45rq-vxgfCVE-2019-7164PYSEC-2019-123
SQLAlchemy vulnerable to SQL Injection via order_by parameter
Published 16 Apr 2019 · Updated 9 Jun 2026
Is your project on an affected sqlalchemy?
Look after several Python apps? Indie watches up to 15 repos, private ones too, for $5 a month. See Indie
Affected package
sqlalchemyPyPI
- Affected
- <1.3.0b3
- Fixed in
- 1.3.0b3
Update to the fixed version for your release line, for example:
pip install 'sqlalchemy>=1.3.0b3'Details
SQLAlchemy before 1.3.0b3 allows SQL Injection via the order_by parameter. The fix (commit 30307c4) was applied only to the main branch and was never backported to the 1.2.x release line; all 1.2.x versions remain vulnerable.
Is GHSA-887w-45rq-vxgf in any of your client repos?
Checking one package by hand is fine. Checking it across forty client projects is not. NPMscan reads the lockfiles in every GitHub repo you pick, finds each project with an affected sqlalchemy, and gives you the command that fixes it.
More advisories for sqlalchemy
- CriticalCVE-2012-0805SQLAlchemy vulnerable to SQL injection · 14 May 2022
- CriticalCVE-2019-7548SQLAlchemy is vulnerable to SQL Injection via group_by parameter · 16 Apr 2019
References
- Advisorynvd.nist.gov/vuln/detail/CVE-2019-7164
- Linkgithub.com/sqlalchemy/sqlalchemy/issues/4481
- Linkgithub.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414
- Linkaccess.redhat.com/errata/RHSA-2019:0981
- Linkaccess.redhat.com/errata/RHSA-2019:0984
- Advisorygithub.com/advisories/GHSA-887w-45rq-vxgf
- Linkgithub.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-123.yaml
- Packagegithub.com/sqlalchemy/sqlalchemy
- Linklists.debian.org/debian-lts-announce/2019/03/msg00020.html
- Linklists.debian.org/debian-lts-announce/2021/11/msg00005.html
- Linkwww.oracle.com/security-alerts/cpujan2021.html
- Linklists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html
- Linklists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html
- Linklists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html
Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.