⚠ Reference material — not professional advice. Test in staging, back up first, verify against your specific version. Use your own judgment for your environment.
● Critical · CVSS 9.3

How to Fix CVE-2026-31877: Frappe SQL Injection due to improper field sanitization in frappe

Other vulnerabilities in the same area that are worth patching alongside this one:

*By Sai Kiran Pandrala*

⚡ At a glance
SeverityCVSS 9.3, Critical
Actively exploited?No
Affectedfrappe (>= 15.0.0, < 15.84.0, < 14.99.0)
Fixed in15.84.0, 14.99.0
Type (CWE)CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

What is CVE-2026-31877?

Frappe is a full-stack web application framework. Prior to 15.84.0 and 14.99.0, a specially crafted request made to a certain endpoint could result in SQL injection, allowing an attacker to extract information they wouldn't otherwise be able to. This vulnerability is fixed in 15.84.0 and 14.99.0.

In practical terms, a successful attacker gets SQL injection that can read or modify the backing database. There is no confirmed in-the-wild exploitation listed in CISA's KEV catalog at the time of writing, but the CVSS rating still warrants prompt patching.

Am I affected?

You're affected if you run frappe at any version in the Affected row above. Use these probes to find your installed build:


# Confirm the installed version via your package manager
dpkg -l | grep -i frappe   # Debian/Ubuntu
rpm -qa | grep -i frappe   # RHEL/CentOS/Rocky

How to fix CVE-2026-31877

The primary fix is to upgrade to the patched build listed in the Fixed in row above (15.84.0, 14.99.0). Pick the platform that matches your install and run the commands below.

Linux (Ubuntu / Debian)


sudo apt-get update
sudo apt-get install --only-upgrade frappe
# Confirm the installed version meets or exceeds 15.84.0
dpkg -s frappe | grep ^Version

Linux (RHEL / CentOS / Rocky)


sudo dnf upgrade --security frappe -y
rpm -q frappe

Windows (PowerShell, admin)


# Try winget first
winget upgrade --id 'Frappe.frappe' --silent --accept-source-agreements --accept-package-agreements
# If winget does not know the product, download the patched installer from the vendor and:
Start-Process -FilePath "$env:TEMP\frappe-15.84.0.msi" -ArgumentList '/qn /norestart' -Wait

PowerShell script (Windows) - detect, back up, upgrade, verify, log


# Run as Administrator
$ErrorActionPreference = 'Stop'
$log = "$env:ProgramData\frappe-Patch-CVE-2026-31877.log"
function Write-Log($msg) { "$(Get-Date -Format s)  $msg" | Tee-Object -FilePath $log -Append }

Write-Log "Starting CVE-2026-31877 remediation for Frappe frappe"

# 1. Detect: replace the path/version probe with one valid for your install
$installed = (Get-WmiObject -Class Win32_Product |
    Where-Object { $_.Name -like '*frappe*' } |
    Select-Object -First 1 -ExpandProperty Version)
Write-Log "Detected version: $installed"

if (-not $installed) {
    Write-Log "Product not installed on this host; nothing to do."
    return
}
if ([version]$installed -ge [version]'15.84.0') {
    Write-Log "Already at fixed version $installed; no action needed."
    return
}

# 2. Backup configuration to a timestamped folder
$backup = "$env:ProgramData\frappe-Backup-$(Get-Date -Format yyyyMMdd-HHmm)"
New-Item -ItemType Directory -Path $backup -Force | Out-Null
# Adjust the source path to match your install
$src = "$env:ProgramFiles\Frappe\frappe"
if (Test-Path $src) { Copy-Item -Path $src -Destination $backup -Recurse -Force }
Write-Log "Backed up config to $backup"

# 3. Apply the patched installer (place the verified file on a share or staging path)
$installer = "$env:TEMP\frappe-15.84.0.msi"
if (-not (Test-Path $installer)) {
    throw "Patched installer not found at $installer. Stage it from your software repo first."
}
Start-Process msiexec.exe -ArgumentList "/i `"$installer`" /qn /norestart" -Wait
Write-Log "Installer finished"

# 4. Verify
$verify = (Get-WmiObject -Class Win32_Product |
    Where-Object { $_.Name -like '*frappe*' } |
    Select-Object -First 1 -ExpandProperty Version)
if ([version]$verify -ge [version]'15.84.0') {
    Write-Log "SUCCESS: now at $verify (>= 15.84.0)"
} else {
    Write-Log "FAILURE: still at $verify after install"
    exit 1
}

Bash script (Linux) - detect, back up, upgrade, verify, log


#!/usr/bin/env bash
set -euo pipefail
LOG=/var/log/frappe-patch-cve-2026-31877.log
log()  { echo "$(date -Iseconds)  $*" | tee -a "$LOG"; }

log "Starting CVE-2026-31877 remediation for Frappe frappe"

# 1. Detect installed version (works for deb and rpm packages)
if command -v dpkg >/dev/null && dpkg -s frappe >/dev/null 2>&1; then
    CURRENT=$(dpkg-query -W -f='${Version}' frappe)
    PKG_MGR=apt
elif command -v rpm >/dev/null && rpm -q frappe >/dev/null 2>&1; then
    CURRENT=$(rpm -q --queryformat '%{VERSION}' frappe)
    PKG_MGR=dnf
else
    log "frappe not installed via apt or rpm; check your package manager or vendor instructions."
    exit 0
fi
log "Detected: frappe=$CURRENT (manager=$PKG_MGR)"

# 2. Backup config
BACKUP=/var/backups/frappe-$(date +%Y%m%d-%H%M)
mkdir -p "$BACKUP"
for d in /etc/frappe /etc/${pkg%%-*} ; do
    [ -d "$d" ] && cp -a "$d" "$BACKUP/" && log "Backed up $d to $BACKUP"
done

# 3. Upgrade
if [ "$PKG_MGR" = apt ]; then
    sudo apt-get update -y
    sudo apt-get install --only-upgrade -y frappe
else
    sudo dnf upgrade --security -y frappe
fi

# 4. Verify
if [ "$PKG_MGR" = apt ]; then
    NEW=$(dpkg-query -W -f='${Version}' frappe)
else
    NEW=$(rpm -q --queryformat '%{VERSION}' frappe)
fi
log "After upgrade: $NEW"

# Optionally compare against 15.84.0 with dpkg --compare-versions or sort -V
log "Done. Restart the affected service if the package install did not."

If you can't patch immediately

These are runnable hardening commands. They reduce blast radius but they're not a replacement for the vendor patch.

Block obvious SQL injection patterns with a WAF rule


# ModSecurity / OWASP CRS-style rule
SecRule ARGS "@rx (?i)(union(.|\n)+?select|select(.|\n)+?from|insert(.|\n)+?into)" \
  "id:900100,phase:2,deny,log,msg:'SQLi pattern blocked'"

How to verify the fix worked

Run the version probe again and confirm the running build matches the Fixed in row above.


# Confirm the running build matches the patched version listed by the vendor
# Example for Linux package installs:
dpkg -l | grep -i "frappe"   # Debian/Ubuntu
rpm -qa | grep -i "frappe"   # RHEL/CentOS/Rocky

Expected output: the package version should meet or exceed 15.84.0.

Then re-run any vulnerability scanner you used previously and confirm the finding for CVE-2026-31877 has cleared. Sweep your logs for the indicators of compromise listed in the vendor or CISA advisory, especially if the system was internet-reachable during the disclosure window.

Frequently asked questions

Is CVE-2026-31877 being actively exploited?

Not at the time of writing. It is not listed in CISA's Known Exploited Vulnerabilities catalog. That status can change, so monitor the vendor advisory and the KEV catalog if the system is exposed.

How severe is CVE-2026-31877?

CVSS rates it 9.3 (Critical). Use that score to set your patch priority next to the other items in your queue.

Do I have to take frappe offline to apply the patch?

It depends on the deployment. High-availability or clustered installs can usually patch one node at a time with no full outage. Standalone installs typically need a short restart. Always follow the vendor's documented upgrade steps.

What if my vulnerability scanner still flags CVE-2026-31877 after I patch?

Re-run the scan after a service restart, then confirm the scanner's plugin set is up to date. Some scanners detect by banner version only and lag the official fix metadata by a release.

References

*Written by Sai Kiran Pandrala on 2026-05-25. Sourced from the official vendor advisory, the NVD record, and the CISA KEV listing. Always confirm against the vendor advisory before applying changes in production.*