{"schemaVersion":3,"id":"CVE-2020-7471","aliases":["ALPINE-CVE-2020-7471","GHSA-hmr4-m2h5-33qx","BIT-django-2020-7471","PYSEC-2020-35","UBUNTU-CVE-2020-7471","USN-4264-1","DEBIAN-CVE-2020-7471","DSA-4629-1"],"status":"published","duplicateOf":null,"title":null,"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.","dates":{"published":"2020-02-03T11:59:20.000Z","modified":"2024-08-04T09:33:19.635Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":9.8,"severity":"critical","version":"3.1","versionLabel":"v3.1","source":"NVD","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.1","versionLabel":"v3.1","source":"OSV · Alpine","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":10,"impact":9.8,"computed":true},{"version":"4.0","versionLabel":"v4.0","source":"OSV · Pypi","score":9.3,"severity":"critical","vector":"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","exploitability":null,"impact":null,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Pypi","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":10,"impact":9.8,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Ubuntu","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":10,"impact":9.8,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Debian","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":10,"impact":9.8,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":9.8,"severity":"critical","vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","exploitability":null,"impact":null,"computed":false},{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":7.5,"severity":"high","vector":"AV:N/AC:L/Au:N/C:P/I:P/A:P","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.65575,"percentile":0.99261,"severity":"critical","asOf":"2026-10-20T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-20T00:00:00.000Z","baselineScore":0.65575},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.65575,"percentile":0.99261}],"last30":[{"date":"2026-09-20T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.65575,"percentile":null},{"date":"2026-10-20T00:00:00.000Z","score":0.65575,"percentile":0.99261}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-89","name":"Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')","description":"The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/89.html"}],"affected":[{"vendor":"alpine","product":"py-django","name":"py-django","label":"py-django","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/py-django","purlType":"apk","versions":[{"text":"< 1.11.28-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 1.11.28-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"py3-django","name":"py3-django","label":"py3-django","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/py3-django","purlType":"apk","versions":[{"text":"< 1.11.28-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 1.11.28-r0","eol":null,"hubHref":null},{"vendor":"debian","product":"python-django","name":"python-django","label":"python-django","ecosystem":"Debian","cpePart":null,"purl":"pkg:deb/debian/python-django","purlType":"deb","versions":[{"text":"< 2:2.2.10-1","noFixRecorded":false,"fixedIn":null},{"text":"< 1:1.10.7-2+deb9u8","noFixRecorded":false,"fixedIn":null},{"text":"< 1:1.11.28-1~deb10u1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 2:2.2.10-1 | < 1:1.10.7-2+deb9u8 | < 1:1.11.28-1~deb10u1","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"python-django","name":"python-django","label":"python-django","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/python-django","purlType":"deb","versions":[{"text":"< 1:1.11.11-1ubuntu1.7","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 1:1.11.11-1ubuntu1.7","eol":null,"hubHref":null},{"vendor":"djangoproject","product":"django","name":"django","label":"django","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≥ 1.11, < 1.11.28","noFixRecorded":false,"fixedIn":null},{"text":"≥ 2.2, < 2.2.10","noFixRecorded":false,"fixedIn":null},{"text":"≥ 3.0, < 3.0.3","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 1.11, < 1.11.28 | ≥ 2.2, < 2.2.10 | ≥ 3.0, < 3.0.3","eol":{"isEol":null,"eolDate":null,"matchMethod":"cpe","cycle":null,"product":{"name":"django","label":"Django","category":"framework"}},"hubHref":"/vendor/djangoproject/django"},{"vendor":"PyPI","product":"django","name":"django","label":"django","ecosystem":"PyPI","cpePart":null,"purl":"pkg:pypi/django","purlType":"pypi","versions":[{"text":"< 1.11.28","noFixRecorded":false,"fixedIn":null},{"text":"≥ 2.0, < 2.2.10","noFixRecorded":false,"fixedIn":null},{"text":"< eb31d845323618d688ad429479c6dda973056136","noFixRecorded":false,"fixedIn":null},{"text":"≥ 3.0, < 3.0.3","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 1.11.28 | ≥ 2.0, < 2.2.10 | < eb31d845323618d688ad429479c6dda973056136 | ≥ 3.0, < 3.0.3","eol":null,"hubHref":null}],"affectedCount":6,"eol":{"hasEol":false,"count":0},"references":[{"url":"https://groups.google.com/forum/#%21topic/django-announce/X45S86X5bZI","label":"groups.google.com/forum/","hostname":"groups.google.com","tags":["X Refsource CONFIRM"]},{"url":"https://docs.djangoproject.com/en/3.0/releases/security/","label":"docs.djangoproject.com/en/3.0/releases/security/","hostname":"docs.djangoproject.com","tags":["X Refsource CONFIRM","WEB","Vendor Advisory"]},{"url":"https://www.openwall.com/lists/oss-security/2020/02/03/1","label":"www.openwall.com/lists/oss-security/2020/02/03/1","hostname":"www.openwall.com","tags":["X Refsource CONFIRM","WEB","REPORT","Mailing List","Third Party Advisory"]},{"url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases/","label":"www.djangoproject.com/weblog/2020/feb/03/security-releases/","hostname":"www.djangoproject.com","tags":["X Refsource CONFIRM","ARTICLE","Vendor Advisory"]},{"url":"http://www.openwall.com/lists/oss-security/2020/02/03/1","label":"www.openwall.com/lists/oss-security/2020/02/03/1","hostname":"www.openwall.com","tags":["Mailing List","X Refsource MLIST","WEB","Third Party Advisory"]},{"url":"https://github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136","label":"github.com/django/django/commit/eb31d845323618d688ad429479c6dda973056136","hostname":"github.com","tags":["X Refsource CONFIRM","WEB","FIX","Patch","Third Party Advisory"]},{"url":"https://usn.ubuntu.com/4264-1/","label":"usn.ubuntu.com/4264-1/","hostname":"usn.ubuntu.com","tags":["Vendor Advisory","X Refsource UBUNTU","WEB"]},{"url":"https://seclists.org/bugtraq/2020/Feb/30","label":"seclists.org/bugtraq/2020/Feb/30","hostname":"seclists.org","tags":["Mailing List","X Refsource BUGTRAQ","WEB"]},{"url":"https://www.debian.org/security/2020/dsa-4629","label":"www.debian.org/security/2020/dsa-4629","hostname":"www.debian.org","tags":["Vendor Advisory","X Refsource DEBIAN","WEB","Advisory"]},{"url":"https://security.netapp.com/advisory/ntap-20200221-0006/","label":"security.netapp.com/advisory/ntap-20200221-0006/","hostname":"security.netapp.com","tags":["X Refsource CONFIRM","Advisory"]},{"url":"https://security.gentoo.org/glsa/202004-17","label":"security.gentoo.org/glsa/202004-17","hostname":"security.gentoo.org","tags":["Vendor Advisory","X Refsource GENTOO","WEB","Advisory"]},{"url":"https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/","label":"lists.fedoraproject.org/archives/…","hostname":"lists.fedoraproject.org","tags":["Vendor Advisory","X Refsource FEDORA"]},{"url":"https://security.alpinelinux.org/vuln/CVE-2020-7471","label":"security.alpinelinux.org/vuln/CVE-2020-7471","hostname":"security.alpinelinux.org","tags":["Advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2020-7471","label":"nvd.nist.gov/vuln/detail/CVE-2020-7471","hostname":"nvd.nist.gov","tags":["Advisory"]},{"url":"https://github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd","label":"github.com/django/django/commit/001b0634cd309e372edb6d7d95d083d02b8e37bd","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b","label":"github.com/django/django/commit/505826b469b16ab36693360da9e11fd13213421b","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147","label":"github.com/django/django/commit/c67a368c16e4680b324b4f385398d638db4d8147","hostname":"github.com","tags":["WEB"]},{"url":"https://www.djangoproject.com/weblog/2020/feb/03/security-releases","label":"www.djangoproject.com/weblog/2020/feb/03/security-releases","hostname":"www.djangoproject.com","tags":["WEB"]},{"url":"https://usn.ubuntu.com/4264-1","label":"usn.ubuntu.com/4264-1","hostname":"usn.ubuntu.com","tags":["WEB"]},{"url":"https://security.netapp.com/advisory/ntap-20200221-0006","label":"security.netapp.com/advisory/ntap-20200221-0006","hostname":"security.netapp.com","tags":["WEB"]},{"url":"https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ","label":"lists.fedoraproject.org/archives/…","hostname":"lists.fedoraproject.org","tags":["WEB"]},{"url":"https://groups.google.com/forum/#!topic/django-announce/X45S86X5bZI","label":"groups.google.com/forum/","hostname":"groups.google.com","tags":["WEB"]},{"url":"https://github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2020-35.yaml","label":"github.com/pypa/advisory-database/tree/main/vulns/django/PYSEC-2020-35.yaml","hostname":"github.com","tags":["WEB"]},{"url":"https://github.com/django/django","label":"github.com/django/django","hostname":"github.com","tags":["PACKAGE"]},{"url":"https://github.com/advisories/GHSA-hmr4-m2h5-33qx","label":"github.com/advisories/GHSA-hmr4-m2h5-33qx","hostname":"github.com","tags":["Advisory"]},{"url":"https://docs.djangoproject.com/en/3.0/releases/security","label":"docs.djangoproject.com/en/3.0/releases/security","hostname":"docs.djangoproject.com","tags":["WEB"]},{"url":"https://lists.fedoraproject.org/archives/list/package-announce@lists.fedoraproject.org/message/4A2AP4T7RKPBCLTI2NNQG3T6MINDUUMZ/","label":"lists.fedoraproject.org/archives/…","hostname":"lists.fedoraproject.org","tags":["WEB"]},{"url":"https://ubuntu.com/security/CVE-2020-7471","label":"ubuntu.com/security/CVE-2020-7471","hostname":"ubuntu.com","tags":["REPORT"]},{"url":"https://ubuntu.com/security/notices/USN-4264-1","label":"ubuntu.com/security/notices/USN-4264-1","hostname":"ubuntu.com","tags":["Advisory"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2020-7471","label":"www.cve.org/CVERecord?id=CVE-2020-7471","hostname":"www.cve.org","tags":["REPORT"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2020-7471","label":"security-tracker.debian.org/tracker/CVE-2020-7471","hostname":"security-tracker.debian.org","tags":["Advisory"]}],"lineage":{"upstream":[],"downstream":["OPENSUSE-SU-2024:11205-1","OPENSUSE-SU-2024:13887-1","OPENSUSE-SU-2024:14208-1","OPENSUSE-SU-2026:10005-1","OPENSUSE-SU-2026:11235-1","OPENSUSE-SU-2026:11248-1","OPENSUSE-SU-2026:11270-1","SUSE-RU-2020:2161-1","SUSE-SU-2020:3309-1"],"duplicates":[],"related":["OPENSUSE-SU-2024:11205-1","OPENSUSE-SU-2024:13887-1","OPENSUSE-SU-2024:14208-1","OPENSUSE-SU-2026:10005-1","OPENSUSE-SU-2026:11235-1","OPENSUSE-SU-2026:11248-1","OPENSUSE-SU-2026:11270-1","SUSE-RU-2020:2161-1","SUSE-SU-2020:3309-1"]},"timeline":[{"kind":"published","date":"2020-02-03T11:59:20.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-04T09:33:19.635Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":70,"level":"high","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T16:57:44.772Z","stale":false,"partial":false}}