Security advisory

{
  "id": "520564a19565ce33d1578e7759ae1723655914df92c2435ec80e794e8c8affb2",
  "url": "https://osv.dev/vulnerability/CVE-2020-24617",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "CVE-2020-24617",
    "summary": "Mailtrain through 1.24.1 allows SQL Injection in statsClickedSubscribersByColumn in lib/models/campaigns.js via /campaigns/clicked/ajax because variable column names are not properly escaped.",
    "evidence": "osv:CVE-2020-24617",
    "products": [],
    "severity": "high",
    "structured": {
      "id": "CVE-2020-24617",
      "aliases": [
        "CVE-2020-24617"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/mailtrain-org/mailtrain",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "last_affected": "f661ba8a6b5b0114f36bf7256bcc8227917ea363"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "cpe": "cpe:2.3:a:mailtrain:mailtrain:*:*:*:*:*:*:*:*",
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "last_affected": "1.24.1"
                      }
                    ],
                    "source": "CPE_RANGE"
                  }
                ]
              }
            }
          ],
          "versions": [
            "v1.24.1",
            "v1.23.2",
            "v1.23.1",
            "v1.22.0",
            "v1.21.0",
            "v1.20.0",
            "v1.19.1",
            "v1.19.0",
            "v1.18.0",
            "v1.17.0",
            "v1.16.0",
            "v1.15.1",
            "v1.15.0",
            "v1.14.0",
            "v1.13.0",
            "v1.12.1",
            "v1.12.0",
            "v1.11.0",
            "v1.10.1",
            "v1.10.0",
            "v1.9.0",
            "v1.8.2",
            "v1.8.1",
            "v1.8.0",
            "v1.7.0",
            "v1.6.0",
            "v1.4.1",
            "v1.4",
            "v1.3.0",
            "v1.2.0",
            "v1.1.0",
            "v1.0.0"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2020-24617.json"
          }
        }
      ],
      "modified": "2026-10-20T10:52:51.688133748Z",
      "provider": "osv",
      "references": [
        "https://github.com/Mailtrain-org/mailtrain/pull/909",
        "https://securitylab.github.com/advisories/GHSL-2020-132-Mailtrain"
      ],
      "provider_metadata": {}
    },
    "related_cves": [
      {
        "value": "CVE-2020-24617",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 383966,
  "published_at": "2021-02-19T23:15:12.577+00:00"
}