CVE-2026-54455

OpenCATS: Authenticated SQL injection in activity DataGrid date filters

Published Oct 28, 2026 CVSS 3.1 · 7.6 High EPSS < 1% KEV · Not listed
Description
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.

Analysis

AI-generated

Technical impact

The vulnerability is an authenticated SQL injection in OpenCATS where the home and activity datagrid endpoints accept period, startDate, and endDate parameters without proper validation or escaping. An authenticated user can manipulate these inputs to craft arbitrary SQL, enabling reading of sensitive tables such as users, candidates, contacts, companies, jobs, and activity logs. The weakness falls under uncontrolled input and SQL injection (CWE‑20 and CWE‑89).

Affected Systems

Vulnerable versions are all releases of OpenCATS prior to 0.10.0. The affected product is the open‑source application OpenCATS, which is used by staffing agencies and hiring teams.

Risk and Exploitability

The CVSS score of 7.6 indicates a high severity. The EPSS score is not available, and the vulnerability is not listed in the CISA KEV catalog, suggesting no widespread exploitation to date. However, the exploit requires a valid OpenCATS login, so an attacker would need legitimate credentials or an insider. Once authenticated, abuse of the datagrid parameters can lead to full disclosure of the database contents. Because the attack vector is internal, the overall risk for an organization depends on the breadth of user privileges and the sensitivity of the stored data.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade OpenCATS to version 0.10.0 or later to apply the vendor fix that validates and escapes all date‑filter parameters.
  • If an immediate upgrade is not possible, limit access to the affected DataGrid endpoints to users who truly require that functionality and audit usage for suspicious activity.
  • Implement server‑side input validation and switch to parameterized queries or prepared statements for the period, startDate, and endDate parameters to eliminate future injection opportunities.

Generated by OpenCVE AI on October 28, 2026 at 23:25 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories available
History
Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'no', 'Exploitation': 'none', 'Technical Impact': 'partial'}, 'version': '2.0.3'}

Type Values Removed Values Added
First Time appeared Opencats
Opencats opencats
Vendors & Products Opencats
Opencats opencats
Type Values Removed Values Added
Description 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.
Title OpenCATS: Authenticated SQL injection in activity DataGrid date filters
Weaknesses CWE-20
CWE-89
References
Metrics cvssV3_1

{'score': 7.6, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:L/A:L'}

Weaknesses
  • CWE-20

    Improper Input Validation

  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Sources

Status
PUBLISHED
Assigner
GitHub_M
Published
Updated
Oct 29, 2026, 5:21 PM
Reserved
Jun 15, 2026, 3:30 PM
Status
Deferred
Published
Oct 28, 2026, 10:17 PM
Modified
Oct 29, 2026, 6:17 PM