CVE-2026-41422: Daptin: SQL injection via unvalidated goqu.L() calls in aggregate API
Summary The /aggregate/:typename endpoint accepted column and group query parameters that were passed verbatim to goqu.L() — a raw SQL literal expression builder — without any validation. This bypassed all parameterization and allowed authenticated users with any valid session to inject arbitrary SQL expressions.
Published Apr 22, 2026 · Updated May 8, 2026
Affected packages
github.com/daptin/daptin
- Ecosystem
- Go
- Affected
- < 0.11.4
- Fixed in
- 0.11.4
- Check
go list -m github.com/daptin/daptin
Advisory details
From the GitHub Advisory Database (CC BY 4.0).
Summary
The /aggregate/:typename endpoint accepted column and group query parameters that were passed verbatim to goqu.L() — a raw SQL literal expression builder — without any validation. This bypassed all parameterization and allowed authenticated users with any valid session to inject arbitrary SQL expressions.
Impact
An authenticated low-privilege user could:
- Extract data from any table via subquery:
(SELECT group_concat(email) FROM user_account) as leak - Disclose database internals:
sqlite_version(),(SELECT sql FROM sqlite_master) - Exfiltrate cross-table data via correlated subqueries
The vulnerability was confirmed locally; user_account.email values were extracted via a crafted column parameter by a non-admin user.
Root Cause
goqu.L(userInput) in server/resource/resource_aggregate.go inserted user-supplied query parameters directly into the SQL string with no validation.
Fix (v0.11.4)
All goqu.L() calls on user-controlled input were eliminated and replaced with:
- Structural expression parsing supporting all documented API forms
- Schema-based column validation (column names checked against entity schema via
TableInfo().GetColumnByName()) - Exact-match allowlist for aggregate functions (
count,sum,avg,min,max,first,last) and scalar functions (date,strftime,upper,lower, etc.) - Safe goqu constructors (
goqu.I(),goqu.SUM(),goqu.Func()) for all generated expressions allowedTablesscope enforcement: qualified column refs (table.col) validated against root entity + explicitly joined tables only
Two additional DoS bugs were fixed in the same commit: uuid.MustParse panic on malformed UUID input and an index-out-of-range panic in ToOrderedExpressionArray on empty sort expressions.
Credits
Reported by @VashuVats.
Credited to VashuVats.
References
How this page is made: the data panel comes from the GitHub Advisory Database, CISA’s KEV catalog, the NVD and FIRST EPSS, and updates twice a day. No analysis has been written for this entry yet. Methodology
More Go vulnerabilities
All Go entriesCVE-2026-77367
Daptin: Unauthenticated SQL Injection via the `sort` query parameter on every entity list endpoint
critical9.4Nov 20, 2026CVE-2026-77369
Daptin: Broken Access Control (IDOR) in the generic YJS collaboration endpoint
critical9.6Nov 20, 2026CVE-2026-62160
Daptin: ParseAcceptLanguage `_` separator bypass enables >250x CPU amplification via Accept-Language header in LanguageMiddleware
high8.7No fixOct 29, 2026GHSA-258c-965c-p3hc
Daptin's Session Management Vulnerability Leads to Insufficient Session Expiration After Password Change
medium6.5May 7, 2026CVE-2026-44349
Daptin fuzzy search injects unvalidated column name into raw SQL
high7.1May 6, 2026GHSA-9cp7-j3f8-p5jx
Daptin has Unauthenticated Path Traversal and Zip Slip
critical10.0Apr 10, 2026
