---
id: "CVE-2026-54455"
kind: "vulnerability"
aliases: ["CVE-2026-54455"]
title: "OpenCATS: date filters in activity grids allow SQL injection"
severity: "high"
cvss: 7.6
epss: null
exploited: false
status: "open"
category: "package"
products: []
ecosystems: []
tags: ["opencats", "package", "php", "self-hosted", "sql-injection"]
not_affected_if: ["no-user-accounts", "version-0.10.0-or-later"]
published_at: "2026-10-28T22:17:15+00:00"
first_seen_at: "2026-10-28T22:35:35+00:00"
updated_at: "2026-10-28T22:36:45+00:00"
sources: [{"source": "nvd", "url": "https://nvd.nist.gov/vuln/detail/CVE-2026-54455", "first_seen_at": "2026-10-28T22:35:35+00:00"}]
---

# OpenCATS: date filters in activity grids allow SQL injection

OpenCATS, a recruitment CRM, builds SQL from request-supplied date and period parameters in its home and activity DataGrid endpoints without proper escaping. An logged-in user can alter the query to read user accounts, candidate records, contacts, companies, job orders and activity history.

_Summary, check and fix written by a model from the sources; labelled as such._

## How to check

- Check the installed OpenCATS version in its config or release files; affected versions are those before `0.10.0`.
- Confirm whether `modules/home/dataGrids.php` and `modules/activity/dataGrids.php` exist and contain the date filtering code described in the advisory.

## Fix

- Upgrade OpenCATS to `0.10.0` or later.
- Until upgraded, restrict login to trusted staff, since exploitation needs a valid account.

## Timeline

- 2026-10-28T22:35:35+00:00 nvd https://nvd.nist.gov/vuln/detail/CVE-2026-54455

## From the sources

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.

---

_Free to read at a human pace. An API with keys and an MCP server are in preparation; early access: hello@infrastack.ai_