Koha SQL Injection via order_by and {order}_ovalue Parameters in guided_reports.pl
Koha Community Koha
Affected versions
| Product | Affected | Fixed in |
|---|---|---|
| Koha Community Koha |
| No fix yet |
Original description
Koha's guided report builder (reports/guided_reports.pl) reads the CGI parameter and, for each value, a dynamically-named parameter, and concatenates both directly into an SQL ORDER BY clause with no allowlist or validation. Since ORDER BY columns cannot be bound via prepared-statement placeholders, this requires an explicit allowlist, which does not exist.
From the CVE record · TuranSec