CyberRota Analysis
AI-GeneratedKoha versions up to 26.05.01 are vulnerable to a stored SQL injection that allows authenticated staff with specific permissions to execute arbitrary SQL queries, potentially exposing sensitive database contents, including patron personally identifiable information (PII) and staff password hashes. The vulnerability arises from the improper handling of user input in the agefield value of an automatic item modification rule, which is later interpolated into a SQL query without proper parameterization. Organizations using affected Koha versions should prioritize patching this vulnerability to mitigate the risk of data breaches and unauthorized access to sensitive information.
Original NVD Description
A stored SQL injection vulnerability in Koha through 24.11.17, 25.05.12, 25.11.06, and 26.05.01 allows authenticated staff with the tools => items_batchmod permission to read arbitrary database contents by storing a SQL payload in the agefield value of an automatic item modification rule. The agefield value is stored verbatim to the system preference and later interpolated without parameterization into a SQL query in C4::Items::ToggleNewStatus (line 1228) when the scheduled cron job executes. The injection is SELECT-only under standard MariaDB/MySQL DBI single-statement execution; a time-based SLEEP payload is also achievable via the cron trigger. An attacker can read the entire Koha database including patron PII and staff bcrypt password hashes.