CyberRota Analysis
AI-GeneratedKoha's reports/issues_avg_stats.pl is vulnerable due to improper handling of user-controlled parameters in SQL queries, allowing authenticated staff users with reports module permissions to perform SQL injection attacks. This vulnerability can lead to unauthorized access to sensitive data, including borrower information and API keys. Organizations using Koha should prioritize addressing this issue to protect their databases from potential data breaches.
Original NVD Description
Koha's reports/issues_avg_stats.pl builds dynamic SQL in sub calculate by concatenating several user-controlled request parameters directly into the query string. The Line and Column parameters are not validated against any whitelist and land verbatim in identifier positions (SELECT DISTINCTROW, GROUP BY, ORDER BY), and each Filter slot is concatenated raw into single-quoted LIKE, BETWEEN, and comparison fragments with no bound parameters.