CVE-2020-7471Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg…
- 9.8CriticalCVSS base score
- 65.6%Exploitation in 30 daysEPSS · top 0.7% of all CVEs
- NoKnown exploitednot in CISA's KEV catalog
- NonePublic exploitsnone known yet
Description
Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in Django applications that offer downloads of data as a series of rows with a user-specified column delimiter). By passing a suitably crafted delimiter to a contrib.postgres.aggregates.StringAgg instance, it was possible to break escaping and inject malicious SQL.
Timeline
ID reserved
By mitre
- 13 days later
· 13 days later
Published
- 5 years later
· 5 years later
Record updated
Changes after publication (a new score, a public exploit, EPSS crossing 1, 10 or 50 %, leaving KEV) are kept since November 2026; earlier ones are not known.
Scores
| Scored by | CVSS | Score | Vector |
|---|---|---|---|
| NVDNVD · Modified | 3.1 | Critical9.8 | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H |
- EPSS (exploitation in 30 days)
- 65.6% · top 0.7% of all CVEs (15 Nov 2026)
The list uses the assigner's score when there is one, then CISA's, then NVD's: Critical 9.8.
Affected products
n/a
- affected n/a
Affected packages
From reviewed advisories of the GitHub Advisory Database.
- PyPIDjangoGHSA-hmr4-m2h5-33qx (opens in a new tab)
References
References12
- https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI (opens in a new tab)x_refsource_CONFIRMx_transferred
- https://docs.djangoproject.com/en/3.0/releases/security/ (opens in a new tab)x_refsource_CONFIRMx_transferred
- https://www.openwall.com/lists/oss-security/2020/02/03/1 (opens in a new tab)x_refsource_CONFIRMx_transferred
- https://www.djangoproject.com/weblog/2020/feb/03/security-releases/ (opens in a new tab)x_refsource_CONFIRMx_transferred
- [oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)`` (opens in a new tab)mailing-listx_refsource_MLISTx_transferred
- https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136 (opens in a new tab)x_refsource_CONFIRMx_transferred
- USN-4264-1 (opens in a new tab)vendor-advisoryx_refsource_UBUNTUx_transferred
- 20200219 [SECURITY] [DSA 4629-1] python-django security update (opens in a new tab)mailing-listx_refsource_BUGTRAQx_transferred
- DSA-4629 (opens in a new tab)vendor-advisoryx_refsource_DEBIANx_transferred
- https://security.netapp.com/advisory/ntap-20200221-0006/ (opens in a new tab)x_refsource_CONFIRMx_transferred
- GLSA-202004-17 (opens in a new tab)vendor-advisoryx_refsource_GENTOOx_transferred
- FEDORA-2020-c2639662af (opens in a new tab)vendor-advisoryx_refsource_FEDORAx_transferred
Sources
The same CVE in the primary databases and aggregators, to check against.
- CVE.org record (opens in a new tab)
- CVE List JSON (GitHub) (opens in a new tab)
- NVD (opens in a new tab)
- FIRST EPSS (opens in a new tab)
- EUVD EUVD-2020-0071 (opens in a new tab)
- OSV.dev (opens in a new tab)
- GitHub Advisory GHSA-hmr4-m2h5-33qx (opens in a new tab)
- CIRCL Vulnerability-Lookup (opens in a new tab)
Badge for a README or a ticket
[](https://cveledger.app/cve/CVE-2020-7471)Record last updated .