CVE-2020-7471 SQL injection in Django
Attackers can inject malicious SQL via crafted delimiters in Django's StringAgg aggregate, potentially reading or modifying database contents.
- Exploited in the wild
- Not known
- Login needed
- Not needed
- Attackable
- Over the internet
- Victim action needed
- Not needed
- Fix
- Available
What is CVE-2020-7471?
CVE-2020-7471 is a critical SQL injection vulnerability in Djangoproject Django, published on 3 Feb 2020. An attacker can exploit it over the internet without logging in, with no action from the victim.
Official 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.
Weakness: CWE-89
Which versions are affected by CVE-2020-7471?
8 open source packages ship an affected version, including django and Django. It affects 1 product.
| Package | Affected | Fixed in |
|---|---|---|
django Bitnami | From 1.11.0 | 1.11.28, 2.2.10, 3.0.3 |
django PyPI | All versions | 1.11.28 |
django PyPI | From 1.11 | 1.11.28, 2.2.10, 3.0.3 |
django PyPI | From 2.0 | 2.2.10 |
django PyPI | From 3.0 | 3.0.3 |
Django PyPI | All versions | 1.11.28 |
2 more packages
Django PyPI | From 2.0 | 2.2.10 |
Django PyPI | From 3.0 | 3.0.3 |
Products include Djangoproject Django.
How do I fix CVE-2020-7471?
Upgrade django to a fixed version for your release line: 1.11.28, 2.2.10 or 3.0.3.
Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.
Is CVE-2020-7471 being exploited?
There is no known exploitation of CVE-2020-7471 in the wild and no public exploit code.
Public exploit code: 7 proofs of concept on GitHub.
Other vulnerabilities in Djangoproject Django
- CVE-2026-4277 Privilege abuse in GenericInlineModelAdmin
- CVE-2024-53908 Django SQL injection in HasKey(lhs, rhs) on Oracle
- CVE-2024-42005 Django SQL injection vulnerability
- CVE-2023-31047 Django bypasses validation when using one form field to upload multiple files
- CVE-2022-34265 Django `Trunc()` and `Extract()` database functions vulnerable to SQL Injection
Sources
Also known as ALPINE-CVE-2020-7471, BIT-django-2020-7471, DEBIAN-CVE-2020-7471, DSA-4629-1, GHSA-hmr4-m2h5-33qx, PYSEC-2020-35 and 2 more.