CVE-2026-71288: Koha SQL Injection via order_by and {order}_ovalue Parameters in guided_reports.pl

Published Aug 5, 2026
·
Updated

Koha's guided report builder (reports/guidedreports.pl) reads the orderby CGI parameter and, for each value, a dynamically-named {order}ovalue parameter, and concatenates both directly into an SQL ORDER BY clause with no allowlist or validation: my @orderby = $input->multiparam('orderby'); foreach my $order (@orderby) { my $value = $input->param($order . "ovalue"); $queryorderby = " ORDER BY $order $value"; }. The resulting string is appended verbatim to the final query in C4::Reports::Guided ($query .= $orderby;) with no escaping. Since ORDER BY columns cannot be bound via prepared-statement placeholders, this requires an explicit allowlist, which does not exist. Any staff account with the low-privilege createreports or executereports permission (commonly granted to non-admin library staff) can perform time-based blind SQL injection against the Koha database, which stores patron PII and staff/LDAP credentials.

Affected Software

2 affected components
Koha guided_reports.pl
Koha C4::Reports::Guided

Event History

Aug 5, 2026
CVE Published
via MITRE·12:26 PM
Data Sourced
via MITRE·12:26 PM
DescriptionSeverityWeakness
Free Weekly Intel

Don't miss critical vulnerabilities

Join thousands of security professionals who receive our weekly digest of trending CVEs, zero-days, and exploited vulnerabilities.

No spam. Unsubscribe anytime.

Frequently Asked Questions

1

What is the severity of CVE-2026-71288?

The severity of CVE-2026-71288 is rated as high with a score of 8.8.

2

How do I fix CVE-2026-71288?

To fix CVE-2026-71288, validate and sanitize the `order_by` parameter and `{order}_ovalue` parameters before using them in SQL queries.

3

What type of vulnerability is CVE-2026-71288?

CVE-2026-71288 is classified as an SQL Injection vulnerability.

4

What components are affected by CVE-2026-71288?

CVE-2026-71288 affects the Koha guided report builder, specifically the guided_reports.pl file.

5

What impact does CVE-2026-71288 have?

CVE-2026-71288 could allow an attacker to manipulate SQL queries, potentially leading to unauthorized data access or system compromise.

Contact

SecAlerts Pty Ltd.
132 Wickham Terrace
Fortitude Valley,
QLD 4006, Australia
info@secalerts.co
By using SecAlerts services, you agree to our services end-user license agreement. This website is safeguarded by reCAPTCHA and governed by the Google Privacy Policy and Terms of Service. All names, logos, and brands of products are owned by their respective owners, and any usage of these names, logos, and brands for identification purposes only does not imply endorsement. If you possess any content that requires removal, please get in touch with us.
© 2026 SecAlerts Pty Ltd.
ABN: 70 645 966 203, ACN: 645 966 203