Description
Koha's reports/issues_stats.pl (the circulation statistics report) builds its calculation query in sub calculate by concatenating several user-controlled request parameters directly into the SQL string. The PeriodTypeSel, PeriodDaySel, and PeriodMonthSel parameters are interpolated raw into single-quoted equality and function-comparison fragments, and the Filter slots plus the Line and Column identifiers are likewise interpolated with no whitelist and no placeholder binding.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| Koha Community | Koha | ≤ 24.11.17, 25.05.00 – ≤ 25.05.12, 25.11.00 – ≤ 25.11.06, 26.05.00 – ≤ 26.05.01 | — |
References
- https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42735 third-party-advisory
- https://koha-community.org/koha-25-05-12-released/ third-party-advisory
- https://download.koha-community.org/koha-25.05.12.tar.gz third-party-advisory