CVE-2026-121731 Details
Description
RosarioSIS before 12.9 contains a sql injection vulnerability that allows authenticated non-student users, including parents, to inject SQL via the unquoted period_id parameter in StudentSummary.php. Attackers can supply payloads without single quotes into IN() clauses to extract administrator password hashes and student records through time-based queries or modify data via stacked statements.
A SQL injection vulnerability has been identified in RosarioSIS versions prior to 12.9. The issue allows authenticated non-student users, such as parents, to inject SQL through the unquoted 'period_id' parameter in 'StudentSummary.php' within the Attendance module. Exploitation of this vulnerability enables attackers to execute arbitrary SQL commands, potentially leading to the extraction of sensitive data like administrator password hashes and student records, or modification of database information. The vulnerability arises because user input is directly interpolated into SQL queries without proper sanitization or quoting, allowing for the injection of malicious payloads that exploit the application's SQL query handling.
Users are advised to upgrade to RosarioSIS version 12.9 or later, where this vulnerability has been patched. The patch involves casting the 'period_id' parameter to an integer before use and validating it against real period IDs fetched from the database.
Metrics
CVSS 4.0 Severity and Vector Strings:
CVSS 3.x Severity and Vector Strings:
No data available for CVSS Version 2.0 on this CVE.
Volerion
Assessed Nov 3, 2026References to Advisories, Solutions, and Tools
By selecting these links, you will be leaving this site. These are references gathered from the official CVE record and are not endorsed by Volerion.
| URL | Source(s) | Tag(s) |
|---|---|---|
| https://github.com/francoisjacquet/rosariosis | [email protected] | ProductVendor |
| https://github.com/francoisjacquet/rosariosis/blob/v12.8.1/modules/Attendance/includes/StudentSummary.php#L119 | [email protected] | Source CodeVendor |
| https://github.com/francoisjacquet/rosariosis/commit/1b809f9761b50c3f6faf9e1b2b5f5e74d63509c1 | [email protected] | Source CodeVendor |
| https://github.com/francoisjacquet/rosariosis/releases/tag/v12.9 | [email protected] | Release NotesVendor |
| https://gitlab.com/francoisjacquet/rosariosis/-/issues/375 | [email protected] | ExploitIssue TrackingTechnical DescriptionVendor |
| https://www.vulncheck.com/advisories/rosariosis-before-12.9-sql-injection-via-period-id-in-attendance-absence-report | [email protected] | AdvisoryRemedy |
Weakness Enumeration
| CWE-ID | CWE Name | Source |
|---|---|---|
| CWE-89 | Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') | [email protected] |
Affected Products
| Product | Versions |
|---|---|
| RosarioSIS | >= 0, < 12.9 |
CPE
Remediation
| |
Change History
1 change record found show changes
| Date | Action | Recorded By |
|---|---|---|
| Nov 3, 2026 | New CVE Received | [email protected] |
Volerion