Severity by source
CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:N/VA:H/SC:N/SI:N/SA:N/E:X/CR:X/IR:X/AR:X/MAV:X/MAC:X/MAT:X/MPR:X/MUI:X/MVC:X/MVI:X/MVA:X/MSC:X/MSI:X/MSA:X/S:X/AU:X/R:X/V:X/RE:X/U:X
Network-reachable with low complexity but needs the SA_GLANALYTIC privilege (PR:L); read-only blind data extraction yields C:H with no integrity or availability impact, contrary to the input's VA:H.
Primary rating from Vendor (VulnCheck).
CVSS VectorVendor: VulnCheck
Lifecycle Timeline
1DescriptionCVE.org
FrontAccounting before 2.4.20 contains a SQL injection vulnerability in the get_gl_transactions() function where the filter_type parameter is concatenated directly into a SQL IN() clause without parameterization. Attackers with SA_GLANALYTIC permission can inject arbitrary SQL by supplying a closing parenthesis followed by malicious conditions to extract sensitive journal entry data through boolean-based blind SQL injection with reliable response size differentials.
AnalysisAI
SQL injection in FrontAccounting's get_gl_transactions() function lets authenticated users holding the SA_GLANALYTIC permission read arbitrary database contents by injecting into the unparameterized filter_type parameter of a SQL IN() clause. The flaw enables boolean-based blind extraction of sensitive journal-entry and general-ledger data using reliable response-size differentials. Publicly available exploit code exists and a vendor patch shipped in 2.4.20, though there is no public exploit identified as actively exploited.
Technical ContextAI
FrontAccounting is an open-source, PHP/MySQL double-entry accounting and ERP web application. The root cause is CWE-89 (Improper Neutralization of Special Elements used in an SQL Command): the get_gl_transactions() routine concatenates the attacker-controlled filter_type value directly into the SQL IN(...) list rather than binding it as a parameter. By supplying a closing parenthesis followed by additional SQL, an attacker breaks out of the IN() set and appends arbitrary boolean conditions, turning the general-ledger analytics query into a blind SQLi oracle. The CPE cpe:2.3:a:frontaccounting:frontaccounting:*:*:*:*:*:*:*:* confirms the FrontAccounting application itself is the affected product across versions prior to 2.4.20.
RemediationAI
Vendor-released patch: upgrade to FrontAccounting 2.4.20 or later, which parameterizes the filter_type input; the corresponding code change is the upstream commit at https://github.com/FrontAccountingERP/FA/commit/647a18196caad27f96ea852e993c9e30f815357f and the release notes are at https://sourceforge.net/p/frontaccounting/news/2026/04/release-2420/. If immediate patching is not possible, the most effective compensating control is to revoke the SA_GLANALYTIC permission from all but fully trusted administrators, which prevents access to the vulnerable GL analytics report at the cost of disabling general-ledger analytics for those users. Additionally, restrict network access to the FrontAccounting instance (VPN/IP allowlist) and place a WAF rule in front of the GL transactions/analytics endpoint to block IN()-breakout payloads containing stray parentheses or SQL keywords in filter_type, accepting that WAF signatures can be bypassed and may cause false positives on legitimate filter values.
More in Frontaccounting
View allincludes/db/class.reflines_db.inc in FrontAccounting 2.4.6 contains a SQL Injection vulnerability in the reference field
Remote code execution in FrontAccounting before 2.4.20 lets an authenticated user abuse the attachment upload handler to
FrontAccounting 2.4.3 suffers from a CSRF flaw, which leads to adding a user account via admin/users.php (aka the "add u
Multiple SQL injection vulnerabilities in FrontAccounting (FA) before 2.3.21 allow remote attackers to execute arbitrary
FrontAccounting 2.4.5 contains a Time Based Blind SQL Injection vulnerability in the parameter "filterType" in /attachme
SQL injection in FrontAccounting's Audit Trail report handler (reporting/rep710.php) lets authenticated users holding th
SQL injection in FrontAccounting before 2.4.20 allows authenticated attackers to extract arbitrary database contents by
An issue was discovered in FrontAccounting 2.4.7. Rated medium severity (CVSS 4.9), this vulnerability is remotely explo
Unsalted MD5 password hashing in FrontAccounting through 2.4.20 renders every stored credential recoverable in minutes i
FrontAccounting 2.4.20 and earlier selectively enforces CSRF validation - tokens are generated for every rendered form b
Same weakness CWE-89 – SQL Injection
View allShare
External POC / Exploit Code
Leaving vuln.today
EUVD-2026-40079
GHSA-w5j4-x499-pfwp