Payload: SQL injection in SQLite/Postgres

Overview

Payload is a free and open source headless content management system. Prior to 3.90.0 and 4.0.0-canary.34, an attacker with read and create or update access to a collection containing a json field or a blocks field with blocksAsJSON enabled can inject SQL through a crafted field path and operators. Collections without those fields are not affected, and richText fields are not affected. The SQLite packages are fixed in versions 3.90.0 and 4.0.0-canary.34, and the Postgres packages are fixed in version 3.73.0.

Affected

• payload >= 3.0.0, < 3.90.0
• payload >= 4.0.0-canary.0, < 4.0.0-canary.34
• db-d1-sqlite >= 3.0.0, < 3.90.0
• db-d1-sqlite >= 4.0.0-canary.0, < 4.0.0-canary.34
• db-postgres >= 3.0.0 < 3.73.0
• db-sqlite >= 3.0.0, < 3.90.0
• db-sqlite >= 4.0.0-canary.0, < 4.0.0-canary.34
• db-vercel-postgres >= 3.0.0 < 3.73.0

Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.