CVEMETERBack to radar
OFFICIAL RECORD · Python packages

CVE-2020-7471

PUBLISHEDOfficial status check: verifiedCVSS unknown: unknown · unknown

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

FieldStatusChecked at (UTC)Source
kevverified2026-11-19T16:57:41.748ZCISA KEV
cvssunknownunknownunknown
epssverified2026-11-19T16:04:28.860ZFIRST EPSS
patchesverified2026-11-19T12:52:01.389ZOSV
affectedverified2026-11-19T12:55:39.110ZCVE Program
lifecycleverified2026-11-19T12:55:39.110ZCVE 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 JSON
OSV · 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 JSON
OSV · 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 JSON

Correction 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 typeDistribution / releasePackageChannelVersion or source noteSource
ecosystem-boundaryPyPI / packagedjangoNot a distribution channel1.11.28Official record
ecosystem-boundaryPyPI / packagedjangoNot a distribution channel2.2.10Official record
ecosystem-boundaryPyPI / packagedjangoNot a distribution channel3.0.3Official record

Vendor notices and operational guidance

No connected vendor notice is available for this record.

Original sources and dates

Official status history