CVE-2020-7471
Python packages · CVE-2020-7471
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.
Exposure status: unknown. This page does not establish whether an installed system is affected or corrected.
Severity and exploitation evidence
EPSS: 65.575% · score date 2026-11-19. EPSS is an estimated probability over the next 30 days, not proof of exploitation.
CISA KEV: not included in the checked catalog; exploitation may still occur. Last checked: 2026-11-19T16:57:41.748Z. Public exploit availability is not used to set this status.
Verification by field
| Field | Status | Checked at (UTC) | Source |
|---|---|---|---|
| kev | verified | 2026-11-19T16:57:41.748Z | CISA KEV |
| cvss | unknown | unknown | unknown |
| epss | verified | 2026-11-19T16:04:28.860Z | FIRST EPSS |
| patches | verified | 2026-11-19T12:52:01.389Z | OSV |
| affected | verified | 2026-11-19T12:55:39.110Z | CVE Program |
| lifecycle | verified | 2026-11-19T12:55:39.110Z | CVE Program |
Affected versions and configuration
n/a n/a; default status: unknown: n/a [affected; scheme: unspecified]
Defaults, conditional configuration, package status and version schemes are retained below. A version range alone is not an exposure verdict.
CVE Program · cve-json · full conditions
{
"affected": [
{
"vendor": "n/a",
"product": "n/a",
"versions": [
{
"status": "affected",
"version": "n/a"
}
]
}
],
"additionalContainers": [
{
"title": "CVE Program Container",
"references": [
{
"url": "https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "https://docs.djangoproject.com/en/3.0/releases/security/",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "https://www.openwall.com/lists/oss-security/2020/02/03/1",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "http://www.openwall.com/lists/oss-security/2020/02/03/1",
"name": "[oss-security] 20200203 Django 3.0.3, 2.2.10 and 1.11.28: CVE-2020-7471: Potential SQL injection via ``StringAgg(delimiter)``",
"tags": [
"mailing-list",
"x_refsource_MLIST",
"x_transferred"
]
},
{
"url": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "https://usn.ubuntu.com/4264-1/",
"name": "USN-4264-1",
"tags": [
"vendor-advisory",
"x_refsource_UBUNTU",
"x_transferred"
]
},
{
"url": "https://seclists.org/bugtraq/2020/Feb/30",
"name": "20200219 [SECURITY] [DSA 4629-1] python-django security update",
"tags": [
"mailing-list",
"x_refsource_BUGTRAQ",
"x_transferred"
]
},
{
"url": "https://www.debian.org/security/2020/dsa-4629",
"name": "DSA-4629",
"tags": [
"vendor-advisory",
"x_refsource_DEBIAN",
"x_transferred"
]
},
{
"url": "https://security.netapp.com/advisory/ntap-20200221-0006/",
"tags": [
"x_refsource_CONFIRM",
"x_transferred"
]
},
{
"url": "https://security.gentoo.org/glsa/202004-17",
"name": "GLSA-202004-17",
"tags": [
"vendor-advisory",
"x_refsource_GENTOO",
"x_transferred"
]
},
{
"url": "https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/",
"name": "FEDORA-2020-c2639662af",
"tags": [
"vendor-advisory",
"x_refsource_FEDORA",
"x_transferred"
]
}
],
"providerMetadata": {
"orgId": "af854a3a-2127-422b-91ae-364da2661108",
"shortName": "CVE",
"dateUpdated": "2024-08-04T09:33:19.635Z"
}
}
]
}Archived source JSONOSV · osv · full conditions
{
"id": "GHSA-hmr4-m2h5-33qx",
"aliases": [
"BIT-django-2020-7471",
"CVE-2020-7471",
"PYSEC-2020-35"
],
"affected": [
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "0"
},
{
"fixed": "1.11.28"
}
]
}
],
"package": {
"name": "django",
"purl": "pkg:pypi/django",
"ecosystem": "PyPI"
},
"versions": [
"1.0.1",
"1.0.2",
"1.0.3",
"1.0.4",
"1.1",
"1.1.1",
"1.1.2",
"1.1.3",
"1.1.4",
"1.10",
"1.10.1",
"1.10.2",
"1.10.3",
"1.10.4",
"1.10.5",
"1.10.6",
"1.10.7",
"1.10.8",
"1.10a1",
"1.10b1",
"1.10rc1",
"1.11",
"1.11.1",
"1.11.10",
"1.11.11",
"1.11.12",
"1.11.13",
"1.11.14",
"1.11.15",
"1.11.16",
"1.11.17",
"1.11.18",
"1.11.2",
"1.11.20",
"1.11.21",
"1.11.22",
"1.11.23",
"1.11.24",
"1.11.25",
"1.11.26",
"1.11.27",
"1.11.3",
"1.11.4",
"1.11.5",
"1.11.6",
"1.11.7",
"1.11.8",
"1.11.9",
"1.11a1",
"1.11b1",
"1.11rc1",
"1.2",
"1.2.1",
"1.2.2",
"1.2.3",
"1.2.4",
"1.2.5",
"1.2.6",
"1.2.7",
"1.3",
"1.3.1",
"1.3.2",
"1.3.3",
"1.3.4",
"1.3.5",
"1.3.6",
"1.3.7",
"1.4",
"1.4.1",
"1.4.10",
"1.4.11",
"1.4.12",
"1.4.13",
"1.4.14",
"1.4.15",
"1.4.16",
"1.4.17",
"1.4.18",
"1.4.19",
"1.4.2",
"1.4.20",
"1.4.21",
"1.4.22",
"1.4.3",
"1.4.4",
"1.4.5",
"1.4.6",
"1.4.7",
"1.4.8",
"1.4.9",
"1.5",
"1.5.1",
"1.5.10",
"1.5.11",
"1.5.12",
"1.5.2",
"1.5.3",
"1.5.4",
"1.5.5",
"1.5.6",
"1.5.7",
"1.5.8",
"1.5.9",
"1.6",
"1.6.1",
"1.6.10",
"1.6.11",
"1.6.2",
"1.6.3",
"1.6.4",
"1.6.5",
"1.6.6",
"1.6.7",
"1.6.8",
"1.6.9",
"1.7",
"1.7.1",
"1.7.10",
"1.7.11",
"1.7.2",
"1.7.3",
"1.7.4",
"1.7.5",
"1.7.6",
"1.7.7",
"1.7.8",
"1.7.9",
"1.8",
"1.8.1",
"1.8.10",
"1.8.11",
"1.8.12",
"1.8.13",
"1.8.14",
"1.8.15",
"1.8.16",
"1.8.17",
"1.8.18",
"1.8.19",
"1.8.2",
"1.8.3",
"1.8.4",
"1.8.5",
"1.8.6",
"1.8.7",
"1.8.8",
"1.8.9",
"1.8a1",
"1.8b1",
"1.8b2",
"1.8c1",
"1.9",
"1.9.1",
"1.9.10",
"1.9.11",
"1.9.12",
"1.9.13",
"1.9.2",
"1.9.3",
"1.9.4",
"1.9.5",
"1.9.6",
"1.9.7",
"1.9.8",
"1.9.9",
"1.9a1",
"1.9b1",
"1.9rc1",
"1.9rc2"
],
"database_specific": {
"source": "https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2020/02/GHSA-hmr4-m2h5-33qx/GHSA-hmr4-m2h5-33qx.json"
}
},
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "2.0"
},
{
"fixed": "2.2.10"
}
]
}
],
"package": {
"name": "django",
"purl": "pkg:pypi/django",
"ecosystem": "PyPI"
},
"versions": [
"2.0",
"2.0.1",
"2.0.10",
"2.0.12",
"2.0.13",
"2.0.2",
"2.0.3",
"2.0.4",
"2.0.5",
"2.0.6",
"2.0.7",
"2.0.8",
"2.0.9",
"2.1",
"2.1.1",
"2.1.10",
"2.1.11",
"2.1.12",
"2.1.13",
"2.1.14",
"2.1.15",
"2.1.2",
"2.1.3",
"2.1.4",
"2.1.5",
"2.1.7",
"2.1.8",
"2.1.9",
"2.1a1",
"2.1b1",
"2.1rc1",
"2.2",
"2.2.1",
"2.2.2",
"2.2.3",
"2.2.4",
"2.2.5",
"2.2.6",
"2.2.7",
"2.2.8",
"2.2.9",
"2.2a1",
"2.2b1",
"2.2rc1"
],
"database_specific": {
"source": "https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2020/02/GHSA-hmr4-m2h5-33qx/GHSA-hmr4-m2h5-33qx.json"
}
},
{
"ranges": [
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "3.0"
},
{
"fixed": "3.0.3"
}
]
}
],
"package": {
"name": "django",
"purl": "pkg:pypi/django",
"ecosystem": "PyPI"
},
"versions": [
"3.0",
"3.0.1",
"3.0.2"
],
"database_specific": {
"source": "https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2020/02/GHSA-hmr4-m2h5-33qx/GHSA-hmr4-m2h5-33qx.json"
}
}
],
"severity": [
{
"type": "CVSS_V3",
"score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
},
{
"type": "CVSS_V4",
"score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"
}
],
"upstream": [],
"withdrawn": null,
"references": [
{
"url": "https://nvd.nist.gov/vuln/detail/CVE-2020-7471",
"type": "ADVISORY"
},
{
"url": "https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
"type": "WEB"
},
{
"url": "https://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
},
{
"url": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases",
"type": "WEB"
},
{
"url": "https://www.debian.org/security/2020/dsa-4629",
"type": "WEB"
},
{
"url": "https://usn.ubuntu.com/4264-1",
"type": "WEB"
},
{
"url": "https://security.netapp.com/advisory/ntap-20200221-0006",
"type": "WEB"
},
{
"url": "https://security.gentoo.org/glsa/202004-17",
"type": "WEB"
},
{
"url": "https://seclists.org/bugtraq/2020/Feb/30",
"type": "WEB"
},
{
"url": "https://lists.fedoraproject.org/archives/list/[email protected]/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ",
"type": "WEB"
},
{
"url": "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI",
"type": "WEB"
},
{
"url": "https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2020-35.yaml",
"type": "WEB"
},
{
"url": "https://github.com/django/django",
"type": "PACKAGE"
},
{
"url": "https://github.com/advisories/GHSA-hmr4-m2h5-33qx",
"type": "ADVISORY"
},
{
"url": "https://docs.djangoproject.com/en/3.0/releases/security",
"type": "WEB"
},
{
"url": "http://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
}
],
"relatedGitRanges": [],
"database_specific": {
"cwe_ids": [
"CWE-89"
],
"severity": "CRITICAL",
"github_reviewed": true,
"nvd_published_at": null,
"github_reviewed_at": "2020-02-05T15:07:21Z"
}
}Archived source JSONOSV · osv · full conditions
{
"id": "PYSEC-2020-35",
"aliases": [
"BIT-django-2020-7471",
"CVE-2020-7471",
"GHSA-hmr4-m2h5-33qx"
],
"affected": [
{
"ranges": [
{
"repo": "https://github.com/django/django",
"type": "GIT",
"events": [
{
"introduced": "0"
},
{
"fixed": "eb31d845323618d688ad429479c6dda973056136"
}
]
},
{
"type": "ECOSYSTEM",
"events": [
{
"introduced": "1.11"
},
{
"fixed": "1.11.28"
},
{
"introduced": "2.2"
},
{
"fixed": "2.2.10"
},
{
"introduced": "3.0"
},
{
"fixed": "3.0.3"
}
]
}
],
"package": {
"name": "django",
"purl": "pkg:pypi/django",
"ecosystem": "PyPI"
},
"versions": [
"1.11",
"1.11.1",
"1.11.2",
"1.11.3",
"1.11.4",
"1.11.5",
"1.11.6",
"1.11.7",
"1.11.8",
"1.11.9",
"1.11.10",
"1.11.11",
"1.11.12",
"1.11.13",
"1.11.14",
"1.11.15",
"1.11.16",
"1.11.17",
"1.11.18",
"1.11.20",
"1.11.21",
"1.11.22",
"1.11.23",
"1.11.24",
"1.11.25",
"1.11.26",
"1.11.27",
"2.2",
"2.2.1",
"2.2.2",
"2.2.3",
"2.2.4",
"2.2.5",
"2.2.6",
"2.2.7",
"2.2.8",
"2.2.9",
"3.0",
"3.0.1",
"3.0.2"
],
"database_specific": {
"source": "https://github.com/pypa/advisory-database/blob/main/vulns/django/PYSEC-2020-35.yaml"
}
}
],
"severity": [],
"upstream": [],
"withdrawn": null,
"references": [
{
"url": "https://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
},
{
"url": "https://docs.djangoproject.com/en/3.0/releases/security/",
"type": "WEB"
},
{
"url": "https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI",
"type": "WEB"
},
{
"url": "https://www.djangoproject.com/weblog/2020/feb/03/security-releases/",
"type": "ARTICLE"
},
{
"url": "http://www.openwall.com/lists/oss-security/2020/02/03/1",
"type": "WEB"
},
{
"url": "https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136",
"type": "FIX"
},
{
"url": "https://usn.ubuntu.com/4264-1/",
"type": "WEB"
},
{
"url": "https://seclists.org/bugtraq/2020/Feb/30",
"type": "WEB"
},
{
"url": "https://www.debian.org/security/2020/dsa-4629",
"type": "ADVISORY"
},
{
"url": "https://security.netapp.com/advisory/ntap-20200221-0006/",
"type": "ADVISORY"
},
{
"url": "https://security.gentoo.org/glsa/202004-17",
"type": "ADVISORY"
},
{
"url": "https://lists.fedoraproject.org/archives/list/[email protected]/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/",
"type": "WEB"
},
{
"url": "https://github.com/advisories/GHSA-hmr4-m2h5-33qx",
"type": "ADVISORY"
}
],
"relatedGitRanges": [],
"database_specific": {}
}Archived source JSONCorrection evidence
Distribution packages and upstream releases are distinct. ESM channels may require the corresponding Ubuntu entitlement. Notes and branch ranges are not installable package versions. OSV fixed boundaries are ecosystem-specific version thresholds, not proof that a package is currently available or installed.
| Evidence type | Distribution / release | Package | Channel | Version or source note | Source |
|---|---|---|---|---|---|
| ecosystem-boundary | PyPI / package | django | Not a distribution channel | 1.11.28 | Official record |
| ecosystem-boundary | PyPI / package | django | Not a distribution channel | 2.2.10 | Official record |
| ecosystem-boundary | PyPI / package | django | Not a distribution channel | 3.0.3 | Official record |
Vendor notices and operational guidance
No connected vendor notice is available for this record.
Original sources and dates
- OSVConsulted: 2026-11-19T12:52:01.389ZArchived source JSON
Source publication: 2020-02-11T21:03:20.000Z
Source modification: 2025-02-21T06:12:43.981ZDocument fingerprint
5a8be0996fde40ecda7b6ec330977c591c5041d8f88a9054d3364a892c671177 - OSVConsulted: 2026-11-19T12:52:01.389ZArchived source JSON
Source publication: 2020-02-03T12:15:00.000Z
Source modification: 2023-12-06T01:00:38.606ZDocument fingerprint
5a8be0996fde40ecda7b6ec330977c591c5041d8f88a9054d3364a892c671177 - CVE ProgramConsulted: 2026-11-19T12:55:39.110ZArchived source JSON
Source publication: 2020-02-03T11:59:20.000Z
Source modification: 2024-08-04T09:33:19.635ZDocument fingerprint
ca926ee0684d07a0a83c748a63dd35cbeb14af82a2c9bbf1735cc4dbc98042af - CISA KEVConsulted: 2026-11-19T16:57:41.748ZArchived source JSON
Source publication: not supplied
Source modification: 2026-11-18T19:17:41.0354ZDocument fingerprint
a35fdc67c7d9802988dcfc1d3ff1198da327948d1db122ab7692ac201055ac56 - FIRST EPSSConsulted: 2026-11-19T16:04:28.860ZArchived source JSON
Source publication: not supplied
Source modification: not suppliedDocument fingerprint
f5c8827616eb2ca04211842edac88756217214ce2eeb1487530f7c0502297196
Official status history
- UNKNOWN → PUBLISHED · · evidence