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.
CVE-2020-7471
“—” beside the score: it is equal to NVD's CVSS score.
Score 9.8 from GitHub Security Advisory (severity: CRITICAL) published 2020-02-11. NVD baseline CVSS 9.8; sources differ by 0.0.
Also known asEUVD-2020-0071 (ENISA EUVD) · GHSA-hmr4-m2h5-33qx (GitHub Security Advisories)Source: ENISA EUVD
- High exploitation likelihood — EPSS 66%
- Public exploit or proof-of-concept code is available
A fix is available — apply it.
- CVSS v3
- 9.8
- EG Score
- 9.8CRITICALmedium confidence
- EG Risk
- 70EG Risk 70/100
EG Risk is EchelonGraph's 0–100 priority score. It fuses impact severity (EG Severity, the CVSS base score, never the KEV-floored or EPSS-lifted EG Score) with real-world exploitation and automatability, under weights EchelonGraph set by hand, so you can rank equal-severity CVEs and fix the most dangerous first. Higher = act sooner.
How it’s computed (value × EchelonGraph’s weight)Severity98% × 45%Impact severity (EG Severity): CVSS 9.8 of 10. Never the KEV-floored or EPSS-lifted EG Score.Exploitation66% × 40%FIRST EPSS: the 30-day exploitation probability when EchelonGraph scored this CVE.Automatability0% × 15%CISA's BOD 26-04 default: no one has published Automatable for this CVE, and CISA treats it as “no” for a CVE not in KEV.SSVC (CISA's decision table, applied by EchelonGraph): Track at low, Track* at medium and Attend at high mission impact.Exploitation public PoC (exploit code on record) · Automatable no (CISA's BOD 26-04 default) · Technical impact total (CISA's BOD 26-04 default). EchelonGraph holds no SSVC assessment of this CVE from CISA: none of these inputs is from Vulnrichment. EchelonGraph applied CISA's decision table to them; CISA publishes SSVC inputs and the table, not a decision for each CVE.Action: A fix is available. Apply it within your standard update timelines at low or medium mission impact and sooner than that at high. - EPSS PROB
- 66%
- EPSS %ILE
- 99th
- KEV
- Not listed
What the EG score is made of (scorer v4.0: the three questions the 0–10 score mixes, published apart · methodology)
The EG score (9.8): severity, escalated by confirmed exploitation. This CVE's 9.8 is its impact severity (EG Severity), not escalated.
- EG Severity
- 9.8 CRITICALCVSS-B, impact only: no KEV listing, EPSS or EG-KEV tier raises it.GitHub Security Advisory CVSS
- EG Likelihood
- 66% within 30 daysSource: FIRST EPSS (model v2026.06.15, score date 2026-10-31). FIRST's exploitation probability, not an EchelonGraph model.
- Confirmed exploitation
- None on record (CISA KEV, EG-KEV Tier 1)Reported apart from the likelihood: an observed fact, not a probability.
- EG Priority
- SSVC Track* at medium mission impactTrack at low, Track* at medium and Attend at high mission impact.CISA BOD 26-04: 14 days if the affected system is publicly exposed; Fix on system upgrade if it is not.Each input and its source, and whom BOD 26-04 binds: the SSVC and BOD 26-04 blocks below.
SSVC (CISA's decision table, applied by EchelonGraph)Track at low, Track* at medium and Attend at high mission impact.
A fix is available. Apply it within your standard update timelines at low or medium mission impact and sooner than that at high.
Exploitation public PoC (exploit code on record) · Automatable no (CISA's BOD 26-04 default) · Technical impact total (CISA's BOD 26-04 default). EchelonGraph holds no SSVC assessment of this CVE from CISA: none of these inputs is from Vulnrichment. EchelonGraph applied CISA's decision table to them; CISA publishes SSVC inputs and the table, not a decision for each CVE. Mission impact is CISA's Mission & Well-being decision point, and only you can judge it. CISA's table makes it high when Mission Prevalence is Essential — the vulnerable component "directly provides capabilities that constitute at least one MEF for at least one entity" (MEF: mission essential function) — or when Public Well-Being Impact is Irreversible: "multiple fatalities are likely", the cyber-physical system "is likely lost or destroyed", "extreme or serious externalities" are imposed on other parties, or social systems such as elections or the financial grid "are destabilized and potentially collapse". CISA's decision table
BOD 26-04 (CISA's remediation timeline, Table 1)14 days if the affected system is publicly exposed; Fix on system upgrade if it is not.
The score's inputs: In CISA KEV no (CISA's KEV catalog) · Automatable no (CISA's BOD 26-04 default) · Technical impact total (CISA's BOD 26-04 default). Where an input reads “CISA's BOD 26-04 default”, no one has published it for this CVE, and CISA's implementation guidance says: “If “Automatable” and “Technical Impact” information items about a CVE ID are not available and the CVE ID is not in the KEV Catalog, CISA will treat its values as “no” and “total,” respectively, until CISA or a third party provides metadata about the CVE ID. CISA will always provide the Vulnrichment data for a CVE ID listed in the KEV Catalog.” Whether your system is publicly exposed is yours to answer. BOD 26-04 binds US Federal Civilian Executive Branch agencies; for anyone else it is CISA's published timeline, a reference rather than an obligation. The directive · how EchelonGraph applies it
Published
February 3, 2020
Last Modified
November 21, 2024
Advisory Details (9)
Auto-updated Oct 4, 2026[SECURITY] [DSA 4629-1] python-django security update
https://www.debian.org/security/2020/dsa-4629Django: Multiple vulnerabilities (GLSA 202004-17) — Gentoo security
https://security.gentoo.org/glsa/202004-17Bugtraq: [SECURITY] [DSA 4629-1] python-django security update
https://seclists.org/bugtraq/2020/Feb/30[SECURITY] Fedora 32 Update: python-django-3.0.7-1.fc32 - package-announce - Fedora mailing-lists
https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/Redirecting to Google Groups
https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZIcommit eb31d8453236 (django/django)
Fix landed in django/django commit eb31d8453236 — awaiting tagged release
https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136Archive of security issues | Django documentation | Django
https://docs.djangoproject.com/en/3.0/releases/security/oss-security - Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``
http://www.openwall.com/lists/oss-security/2020/02/03/1Patch Availability(4)
| Vendor / Ecosystem | Fix (by version range) / Patch | Released | Source |
|---|---|---|---|
| ubuntu | python3-django (1:1.11.11-1ubuntu1.7) @ bionic | 2026-11-01 | ubuntu |
| pip | django @ 1.11.28 (fixes < 1.11.28) | — | ghsa |
| pip | Django @ 2.2.10 (fixes >= 2.0, < 2.2.10) | — | ghsa |
| pip | Django @ 3.0.3 (fixes >= 3.0, < 3.0.3) | — | ghsa |
Patches are aggregated from vendor advisories (Red Hat, Microsoft, Cisco, GitHub) and package ecosystems (OSV, GHSA). Multiple rows for the same upstream release have been deduplicated.
Affected Packages
(12 across 12 ecosystems)
Alpine:v3.10(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| py-django | — |
| — |
Alpine:v3.11(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| py3-django | — |
| — |
Alpine:v3.12(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| py3-django | — |
| — |
Alpine:v3.8(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| py-django | — |
| — |
Alpine:v3.9(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| py-django | — |
| — |
Debian:10(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | 1:1.11.21-1, 1:1.11.22-1, 1:1.11.22-1~deb10u1, 1:1.11.23-1~deb10u1, 1:1.11.27-1~deb10u1 |
| — |
Debian:11(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | — |
| — |
Debian:12(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | — |
| — |
Debian:13(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | — |
| — |
Debian:14(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | — |
| — |
Debian:9(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| python-django | 1:1.10.7-2 ... 1:1.10.7-2+deb9u7 (8 versions) |
| — |
PyPI(1)
| Package | Vulnerable range | Fix by version range | Dependents |
|---|---|---|---|
| django | 1.11 ... 3.0.2 (40 versions) |
| — |
Weakness Classification(1)
MITRE Common Weakness Enumeration — the root-cause categories this CVE belongs to.
All Vendor Advisories
(1)
Every vendor that published an advisory referencing this CVE — pulled from our cve_vendor_advisories aggregation. Click any row for the vendor's original advisory page.
Data Freshness Timeline
(refreshed 15× in last 7d / 58× in last 30d)
Each row is a time one of our pipelines fetched, updated or re-scored this CVE. For example, "NVD update" means NVD published or revised its analysis for this CVE; "MITRE cvelistV5" means we ingested or refreshed it from the CNA feed. An arrow marks a change the record states ("CVSS v3 → 9.1"); EPSS and GHSA rows show the values recorded at that time, not what changed (EPSS values are rounded; hover one for the exact figures). Most recent first.
Showing the most recent 98 of 182 refreshes on record for this CVE.
A repeat, a row identical to one the same pipeline wrote less than 10 seconds earlier, is not a separate refresh and is not counted. 2 repeat rows among the latest 100 are merged into the row they repeat. The 84 oldest rows on record are not shown and were not checked, so the counts can still include repeats.
- 2026-11-01 14:01 UTCVendor advisory
- 2026-11-01 14:01 UTCGHSA enrichmentGHSA-hmr4-m2h5-33qx · GitHub severity CRITICAL · GitHub CVSS 9.8
- 2026-11-01 08:35 UTCGHSA enrichmentGHSA-hmr4-m2h5-33qx · GitHub severity CRITICAL · GitHub CVSS 9.8
- 2026-11-01 08:35 UTCEG score recompute
- 2026-10-31 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-31 12:28 UTCEG score recompute
- 2026-10-30 16:29 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-30 10:54 UTCEG score recompute
- 2026-10-29 09:21 UTCEG score recompute
- 2026-10-28 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-28 07:48 UTCEG score recompute
- 2026-10-28 07:48 UTCVendor advisory
- 2026-10-27 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-27 06:14 UTCEG score recompute
- 2026-10-27 06:14 UTCVendor advisory
- 2026-10-25 18:40 UTCEG score recompute
- 2026-10-25 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-24 22:57 UTCEG score recompute
- 2026-10-24 22:57 UTCVendor advisory
- 2026-10-24 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-23 21:24 UTCEG score recompute
- 2026-10-23 21:24 UTCVendor advisory
- 2026-10-23 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-22 19:50 UTCEG score recompute
- 2026-10-22 19:50 UTCVendor advisory
Show 73 moreShow fewer
- 2026-10-21 18:17 UTCEG score recompute
- 2026-10-21 18:17 UTCVendor advisory
- 2026-10-21 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-20 16:44 UTCEG score recompute
- 2026-10-20 16:44 UTCVendor advisory
- 2026-10-20 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-19 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-19 15:10 UTCEG score recompute
- 2026-10-19 15:10 UTCVendor advisory
- 2026-10-18 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-18 09:17 UTCEG score recompute
- 2026-10-17 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-17 12:01 UTCEG score recompute
- 2026-10-17 12:01 UTCVendor advisory
- 2026-10-16 16:33 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-16 10:26 UTCEG score recompute
- 2026-10-16 10:26 UTCVendor advisory
- 2026-10-15 08:51 UTCEG score recompute
- 2026-10-15 08:51 UTCVendor advisory
- 2026-10-14 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-14 05:07 UTCEG score recompute
- 2026-10-13 16:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-12 19:31 UTCEG score recompute
- 2026-10-12 16:29 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-11 23:55 UTCEG score recompute
- 2026-10-11 13:43 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-10 19:56 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-09 20:04 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-09 08:58 UTCOSV refresh
- 2026-10-07 23:44 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-06 15:13 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-04 23:18 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-03 14:22 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-10-01 19:46 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-30 15:22 UTCEG score recompute
- 2026-09-30 14:59 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-27 13:41 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-26 15:54 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-24 14:00 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-22 14:44 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-21 20:28 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-19 16:03 UTCOSV refresh
- 2026-09-19 15:37 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-18 19:23 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-17 19:22 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-16 14:04 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-15 03:06 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-13 16:43 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-12 14:57 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-07 15:58 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-06 13:44 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-05 15:25 UTCEPSS rescoreEPSS 66% · 99th percentile
- 2026-09-04 05:03 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-09-02 14:08 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-31 19:34 UTCOSV refresh
- 2026-08-30 19:14 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-30 01:19 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-28 21:37 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-26 14:42 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-21 23:45 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-19 17:00 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-16 02:11 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-15 01:27 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-14 22:54 UTCOSV refresh
- 2026-08-13 21:57 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-12 13:47 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-08 16:33 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-06 13:43 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-08-05 19:14 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-07-30 16:25 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-07-30 11:44 UTCOSV refresh
- 2026-07-30 01:27 UTCEPSS rescoreEPSS 65% · 99th percentile
- 2026-07-28 15:33 UTCEPSS rescoreEPSS 65% · 99th percentile
Publicly available exploits
(3 references)Public exploit code is referenced for this CVE (3 GitHub PoCs). Defenders should treat patch urgency accordingly.
- GitHub PoCSNCKER/CVE-2020-7471Published Feb 22, 2020
CVE-2020-7471 Potential SQL injection via StringAgg(delimiter)
Open source ↗ - GitHub PoCsecoba/DjVul_StringAggPublished Feb 13, 2020
Django StringAgg SQL Injection (CVE-2020-7471)
Open source ↗ - GitHub PoCSaferman/CVE-2020-7471Published Feb 11, 2020
django 漏洞:CVE-2020-7471 Potential SQL injection via StringAgg(delimiter) 的漏洞环境和 POC
Open source ↗
Related CVEs(same product + same CWE)
Same product
10 shownAlpine:v3.8:py-django
Frequently asked(5)
What is CVE-2020-7471?
When was the CVE record for CVE-2020-7471 published?
Is CVE-2020-7471 actively exploited?
What is the CVSS score of CVE-2020-7471?
How do I remediate CVE-2020-7471?
Dependency Blast Radius
See which npm, PyPI, Go, and Maven packages are affected by CVE-2020-7471
Is Your Infrastructure Affected by CVE-2020-7471?
EchelonGraph automatically scans your cloud infrastructure and maps CVE exposure using blast radius analysis.