SQL injection in OpenCATS activity DataGrid date filters
Key facts
- Attack vector
- Network
- Privileges required
- Low
- User interaction
- None
- Attack complexity
- Low
- Impact type
- SQL injection
- Confidentiality · integrity · availability
- High · Low · Low
- Fix status
- Fixed
Attack profile from CVSS 3.1 · CNA. Fix status from CNA. Impact type from CWE-89.
Summary
OpenCATS before 0.10.0 is affected. The activity DataGrid date filters insert request-controlled startDate, endDate and period values into SQL without sufficient escaping or validation (CWE-89). An authenticated user with access to the affected DataGrid endpoints can alter the query to read sensitive database contents, including user accounts, candidate records and job orders. Unauthenticated exploitation is not established.
Written with Claude Haiku 5.5 from the sources below · 2026-10-29
Description from the CNA
OpenCATS is an open-source applicant tracking system and recruitment CRM for staffing agencies and hiring teams. Prior to version 0.10.0, activity DataGrid date filtering in `home:CallsDataGrid` and `activity:ActivityDataGrid` uses request-controlled `period`, `startDate` and `endDate` parameters without sufficient validation or escaping. The vulnerable code is in `modules/home/dataGrids.php` and `modules/activity/dataGrids.php`. The `startDate` and `endDate` values are inserted into SQL string comparisons without safe escaping, and `period` can directly influence generated SQL. An authenticated user with access to the affected DataGrid endpoints can alter the intended query to access sensitive database contents, including user account data, candidate records, contact details, company information, job orders and activity history. A valid OpenCATS login is required; unauthenticated exploitation is not established. This issue is fixed in version 0.10.0.
Why it matters now
SSVC decision points
CISA ADP · SSVC 2.0.3
- Exploitation
- None
- Automatable
- No
- Technical impact
- Partial
The decision (Track, Attend, Act) also depends on your mission and well-being impact; see CISA's SSVC guide.
Affected products
Remediation
Upgrade OpenCATS to version 0.10.0, which fixes this issue.
Written with Claude Haiku 5.5 from the sources below · 2026-10-29
- Fix · CNA OpenCATS (opencats) Fixed in 0.10.0
Timeline
- 2026-10-28 Threatist record created from CVE-2026-54455
- 2026-10-29 CISA SSVC decision points changed
- 2026-10-29 Priority changed: MEDIUM → LOW
References
More opencats vulnerabilities
- TI-2021-22549 OpenCATS 0.9.4 Remote Code Execution via Resume Upload CVSS 4.0CRITICAL 9.3
- TI-2026-22120 OpenCATS PHP Code Injection via installer AJAX endpoint CVSS 4.0CRITICAL 9.2
- TI-2026-36639 OpenCATS - SQL Injection in DataGrid sortDirection Parameter CVSS 4.0HIGH 8.4
- TI-2023-12031 Cross-site scripting in OpenCATS CVSS 3.1MEDIUM 6.1
- TI-2023-12032 Cross-site scripting in OpenCATS CVSS 3.1MEDIUM 5.4
- TI-2023-12030 Open redirect in OpenCATS CVSS 3.1MEDIUM 5.4
Sources
This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences