CVE-2026-31844: Authenticated SQL Injection in Koha displayby parameter of suggestion.pl
An authenticated SQL Injection vulnerability (CWE-89) exists in the Koha staff interface in the /cgi-bin/koha/suggestion/suggestion.pl endpoint due to improper validation of the displayby parameter used by the GetDistinctValues functionality. Successful exploitation may lead to full compromise of the backend database, including disclosure or modification of stored data.
Security readout for executives and security teams
Plain-English summary
Koha staff users with valid credentials may be able to manipulate a report parameter and access or alter the library system’s backend database. This could expose patron, catalogue, account, or operational data stored there. The supplied record rates the issue critical, but provides no evidence of active exploitation.
Executive priority
Treat as an urgent remediation item for affected Koha installations, especially internet-accessible staff interfaces. Authentication is required, but stolen or misused staff credentials could turn this into a full database confidentiality and integrity incident.
Technical view
CVE-2026-31844 is an authenticated SQL injection in Koha’s staff endpoint /cgi-bin/koha/suggestion/suggestion.pl. Improper validation of the displayby parameter, used by GetDistinctValues, may permit database disclosure, modification, or broader compromise. The supplied CVSS v2 score is 9.0 (AV:N/AC:L/Au:S/C:C/I:C/A:C).
Likely exposure
The supplied record identifies Koha 24.11.0, 25.05.0, and 25.11.0. Exploitation requires authenticated access to the staff interface, reducing anonymous exposure but increasing concern where credentials are compromised or broadly assigned. Evidence supplied does not establish wider affected version ranges.
Exploitation context
The attack is remotely reachable but requires a valid Koha staff session. The CVE is not listed as KEV in the supplied bundle, and no supplied source claims active exploitation. Database impact could be severe if exploitation succeeds.
Researcher notes
The vulnerable data flow is displayby into GetDistinctValues within suggestion.pl, categorized as CWE-89. The bundle identifies three affected releases but does not provide complete version-boundary or patch-diff details. Avoid inferring additional affected versions or confirmed exploitation without vendor evidence.
Mitigation direction
Inventory Koha deployments and identify whether any run the three listed versions.
Consult the linked Koha advisory and release notes for the vendor-approved corrected release.
Prioritize remediation for staff interfaces reachable from untrusted or broadly accessible networks.
Restrict staff-interface access and review unnecessary staff accounts while remediation is pending.
Back up the database and protect backups before applying vendor-directed changes.
Validation and detection
Confirm the deployed Koha version using trusted asset or deployment records.
Verify staff-interface network exposure and authentication controls.
Review access logs for unusual requests involving suggestion.pl or the displayby parameter.
Examine database audit logs for unexpected queries or unauthorized data changes.
After remediation, confirm the installed version matches current Koha guidance.
Generated from the cited source records. This long-tail analysis has not been individually reviewed by a named human.
Potential ATT&CK relevance
Conservative CVE-to-ATT&CK context
These mappings and lookup hints may be relevant to the vulnerability behavior, CWE, affected product, or exposure path. Glexia-inferred context is not an official MITRE, ATT&CK, CWE, or CVE Program mapping.
ATT&CK lookup starting points
Use these exact CWE pages and searches to review the Glexia ATT&CK library from this CVE's weakness and description context.
cwe · medium confidence lookup
CWE-89: Database access and collection lookup
Injection into data stores can inform collection, data access, and exfiltration detection reviews. Open the exact CWE lookup page first, then review the ATT&CK searches from that MITRE weakness context. This is a Glexia lookup hint, not an official ATT&CK mapping.
The CVE wording references database injection or access, so collection and exfiltration review may help. This is a Glexia inferred lookup path, not an official MITRE, ATT&CK, or CVE Program mapping.
These fields come from the CVE record and ADP containers, not from Glexia's Take. They preserve time-varying source decisions such as CISA SSVC, KEV status, CVSS metrics, and provider references.
3CVSS vectors
3Timeline events
1ADP providers
4Source links
SSVC decision data
CISA-ADPCISA Coordinator
Timestamp
Version
2.0.3
Exploitation: pocAutomatable: noTechnical Impact: total
CVSS vector scores
3 official scores
We collect every scored CVSS vector available in the official CNA and ADP containers. When more than one version is present, the table keeps the source vectors side by side instead of collapsing them into the highest score.
CWE links open Glexia weakness intelligence pages with official CWE context, developer remediation guidance, and related CVE mappings.
CWE-89 · source CWE mapping
Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') represents a recurring weakness pattern that can create exploitable paths when design, validation, or implementation controls are missing.