SQL injection in Koha Most-circulated items report
Key facts
- Attack vector
- Network
- Privileges required
- Low
- User interaction
- None
- Attack complexity
- Low
- Attack requirements
- None
- Impact type
- SQL injection
- Confidentiality · integrity · availability
- High · Low · Low
- Fix status
- Fixed
Attack profile from CVSS 4.0 · CNA. Fix status from CNA. Impact type from CWE-89.
Summary
Koha is affected in versions from 0 before 24.11.00, from 24.11.00 before 24.11.19, from 25.05.00 before 25.05.14, from 25.11.00 before 25.11.08, and from 26.05.00 before 26.05.03. The reports/cat_issues_top.pl script concatenates user-supplied Criteria, Filter and Limit parameters directly into dynamic SQL. This is SQL injection (CWE-89). An authenticated staff user with the reports module permission can inject SQL and read any table the Koha database user can reach, including borrower password hashes and API keys.
Written with Claude Haiku 5.5 from the sources below · 2026-10-28
Description from the CNA
Koha is vulnerable to SQL injection in the Most-circulated items report. The reports/cat_issues_top.pl script (sub calculate) concatenates the user-controlled Criteria, Filter, and Limit request parameters directly into dynamic SQL. Criteria is only prefix-normalized and never validated against an allow-list, so it is inserted verbatim into identifier positions (SELECT DISTINCTROW, GROUP BY, ORDER BY, and the main calculation query). Filter values are concatenated raw into single-quoted LIKE, BETWEEN, and comparison fragments. Limit is appended raw to a LIMIT clause. An authenticated staff user with the reports module permission (not requiring superlibrarian) can inject arbitrary SQL and read any table reachable by the Koha database user, including borrowers (userid and bcrypt password hashes, two-factor secrets, personal data), api_keys, and sessions. The issue is fixed in Koha 24.11.19, 25.05.14, 25.11.08, and 26.05.03, and in the 26.11 development branch. This is the unpatched twin of reports/bor_issues_top.pl (CVE-2026-70372).
Why it matters now
SSVC decision points
CISA ADP · SSVC 2.0.3
- Exploitation
- None
- Automatable
- No
- Technical impact
- Partial
The decision (Track, Attend, Act) also depends on your mission and well-being impact; see CISA's SSVC guide.
Affected products
| Vendor | Product | Affected versions | Fixed in | Status | Source |
|---|---|---|---|---|---|
| Koha Community | Koha | before 24.11.00; 24.11.00 to before 24.11.19; 25.05.00 to before 25.05.14; 25.11.00 to before 25.11.08; 26.05.00 to before 26.05.03 | 24.11.19, 25.05.14, 25.11.08, 26.05.03 | Patch available | CNA |
- Koha VendorKoha Community Affected before 24.11.00; 24.11.00 to before 24.11.19; 25.05.00 to before 25.05.14; 25.11.00 to before 25.11.08; 26.05.00 to before 26.05.03 Fixed in 24.11.19, 25.05.14, 25.11.08, 26.05.03 Patch available CNA
Remediation
Upgrade Koha to 24.11.19, 25.05.14, 25.11.08 or 26.05.03, or to the 26.11 development branch.
Written with Claude Haiku 5.5 from the sources below · 2026-10-28
- Fix · CNA Koha (Koha Community) Fixed in 24.11.19, 25.05.14, 25.11.08, 26.05.03
Timeline
- 2026-10-14 Threatist record created from CVE-2026-105107
- 2026-10-14 Alias added: GHSA-x89q-h3c4-g624
- 2026-10-14 CISA SSVC decision points changed
- 2026-10-14 Priority changed: MEDIUM → LOW
References
More Koha Community vulnerabilities
- TI-2026-73826 OS command injection in Koha Task Scheduler deletion via jobid CVSS 3.1HIGH 8.8
- TI-2026-24397 Authenticated SQL Injection in Koha displayby parameter of suggestion.pl CVSS 4.0HIGH 8.7
- TI-2023-24038 SQL Injection vulnerability in Koha Library Software 23.0.5.04 and before allows a remote… CVSS 3.1HIGH 7.5
- TI-2023-24039 File Upload vulnerability in Koha Library Software 23.05.04 and before allows a remote… CVSS 3.1MEDIUM 5.3
- TI-2026-05641 Koha SQL Injection in reports/catalogue_out.pl via Filter URL Parameter CVSS 4.0MEDIUM 5.6
- TI-2026-49955 Koha SQL Injection via order_by and {order}_ovalue Parameters in guided_reports.pl CVSS 3.1HIGH 8.8
Sources
- CVE-2026-105107 · CVE Program
- CVE-2026-105107 · NVD
- FIRST EPSS
- GHSA-x89q-h3c4-g624 · GitHub Advisory Database · CC BY 4.0
This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences