Dolibarr before 24.0.0 SQL Injection via the CSV and XLSX Import Update Keys

{
  "id": "da5d17519c26166d0dfdb858abe55d421f09d1236a97f939ccac7e1a62132b21",
  "url": "https://osv.dev/vulnerability/CVE-2026-81728",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "Dolibarr before 24.0.0 SQL Injection via the CSV and XLSX Import Update Keys",
    "summary": "Dolibarr before 24.0.0 contains a SQL injection in its CSV and XLSX import wizard. The wizard reads its update keys with GETPOST('updatekeys', 'array') in htdocs/imports/import.php, which applies only the generic alphanohtml filter: that strips HTML but leaves SQL keywords, comment markers, parentheses, spaces and quotes intact. import_insert() in htdocs/core/modules/import/import_csv.modules.php then iterates the submitted values and builds a filter with $where[] = $key.' = '.$data[$key], having first applied preg_replace('/^.*\\./i', '', $key), an alias strip that does nothing to a value containing no dot. The assembled string is executed through $this->db->query(). The injected SELECT resolves the row id that the import then assigns to $lastinsertid, which becomes the WHERE target of a subsequent UPDATE, so a UNION SELECT returning an attacker-chosen integer both exfiltrates arbitrary table content and redirects which row the import overwrites; for category link tables the raw filter array is spliced into that UPDATE directly. The interface offers a fixed list of legitimate column codes but the server never checks the submitted values against it. A user holding the import permission can exploit this. Release 23.0.4 does not carry the fix; the allow-list test was added in 24.0.0.",
    "evidence": "osv:CVE-2026-81728",
    "products": [],
    "severity": "high",
    "structured": {
      "id": "CVE-2026-81728",
      "aliases": [
        "CVE-2026-81728"
      ],
      "metrics": [
        {
          "type": "CVSS_V4",
          "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:H/VA:N/SC:N/SI:N/SA:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/dolibarr/dolibarr",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "fixed": "769c7db907099643558e77d7002c109cfda919e5"
                },
                {
                  "fixed": "24b1b99c89c79a3fe2d1e83b22dc1810cf0fa6e1"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "cpe": "cpe:2.3:a:dolibarr:dolibarr_erp\\/crm:*:*:*:*:*:*:*:*",
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "fixed": "24.0.0"
                      }
                    ],
                    "source": "CPE_RANGE"
                  },
                  {
                    "range": [
                      {
                        "fixed": "24b1b99c89c79a3fe2d1e83b22dc1810cf0fa6e1"
                      }
                    ],
                    "source": "REFERENCES_COMMIT"
                  }
                ]
              }
            }
          ],
          "versions": [
            "lne_audit_init_20260601",
            "14.0.0",
            "14.0.1",
            "6.0.0-beta",
            "5.0.0-beta",
            "4.0.0-rc",
            "3.8.0-beta",
            "3.7.1",
            "3.7.0",
            "3.6.2",
            "3.6.1",
            "3.6.0",
            "3.6.0-beta",
            "3.6.beta1_20140514",
            "3.6.0-alpha",
            "3.5.beta1_20131120",
            "3.5.beta1_20131106",
            "3.4.beta1_20130502",
            "3.4.beta1_20130429",
            "3.3.beta1_20121221"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-81728.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:23.351812405Z",
      "provider": "osv",
      "references": [
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/81xxx/CVE-2026-81728.json",
        "https://nvd.nist.gov/vuln/detail/CVE-2026-81728",
        "https://www.vulncheck.com/advisories/dolibarr-before-24.0.0-sql-injection-via-the-csv-and-xlsx-import-update-keys",
        "https://github.com/Dolibarr/dolibarr/commit/24b1b99c89c79a3fe2d1e83b22dc1810cf0fa6e1",
        "https://github.com/Dolibarr/dolibarr",
        "https://github.com/Dolibarr/dolibarr/blob/23.0.4/htdocs/core/modules/import/import_csv.modules.php#L925"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "cna_assigner": "VulnCheck",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/81xxx/CVE-2026-81728.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-81728",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 489445,
  "published_at": "2026-08-27T20:07:33.503+00:00"
}