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.
Published: 2026-10-28
Score: 7.6 High
EPSS: n/a
KEV: No
Impact: Data breach from SQL injection
Action: Patch
AI Analysis

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.

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

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 yet.

History

Wed, 28 Oct 2026 22:00:00 +0000

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'}


Subscriptions

No data.

cve-icon MITRE

Status: PUBLISHED

Assigner: GitHub_M

Published:

Updated: 2026-10-28T21:45:00.241Z

Reserved: 2026-06-15T15:30:40.318Z

Link: CVE-2026-54455

cve-icon Vulnrichment

No data.

cve-icon NVD

Status : Deferred

Published: 2026-10-28T22:17:15.273

Modified: 2026-10-28T22:17:15.393

Link: CVE-2026-54455

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-10-28T23:30:09Z

Weaknesses
  • CWE-20

    Improper Input Validation

  • CWE-89

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