CakePHP up to 5.3.6 FunctionsBuilder FunctionsBuilder.php dateAdd dataType/part/unit sql injection

Summaryinfo

A vulnerability marked as critical has been reported in CakePHP up to 4.5.11/4.6.4/5.1.8/5.2.13/5.3.6. The impacted element is the function CakePHP\Database\FunctionsBuilder::cast/CakePHP\Database\FunctionsBuilder::extract/CakePHP\Database\FunctionsBuilder::datePart/CakePHP\Database\FunctionsBuilder::dateAdd of the file src/Database/FunctionsBuilder.php of the component FunctionsBuilder. This manipulation of the argument dataType/part/unit causes sql injection. This vulnerability is handled as CVE-2026-79752. The attack can be initiated remotely. There is not any exploit available. It is suggested to upgrade the affected component.

Detailsinfo

A vulnerability was found in CakePHP up to 4.5.11/4.6.4/5.1.8/5.2.13/5.3.6. It has been declared as critical. Affected by this vulnerability is the function CakePHP\Database\FunctionsBuilder::cast/CakePHP\Database\FunctionsBuilder::extract/CakePHP\Database\FunctionsBuilder::datePart/CakePHP\Database\FunctionsBuilder::dateAdd of the file src/Database/FunctionsBuilder.php of the component FunctionsBuilder. The manipulation of the argument dataType/part/unit with an unknown input leads to a sql injection vulnerability. The CWE definition for the vulnerability is CWE-89. The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. As an impact it is known to affect confidentiality, integrity, and availability. The summary by CVE is:

CakePHP is a rapid development framework for PHP. Prior to 4.5.12, 4.6.5, 5.1.9, 5.2.14, and 5.3.7, FunctionsBuilder::cast, FunctionsBuilder::extract, FunctionsBuilder::datePart, and FunctionsBuilder::dateAdd in src/Database/FunctionsBuilder.php accept user-controlled dataType, part, or unit values and incorporate them into generated SQL as unescaped structural fragments. An application that passes untrusted input to these parameters can permit SQL injection with confidentiality, integrity, and availability impact according to the database connection's privileges. This issue is fixed in versions 4.5.12, 4.6.5, 5.1.9, 5.2.14, and 5.3.7.

The advisory is shared at github.com. This vulnerability is known as CVE-2026-79752 since 08/25/2026. The exploitation appears to be easy. The attack can be launched remotely. The exploitation doesn't need any form of authentication. Technical details are known, but no exploit is available. MITRE ATT&CK project uses the attack technique T1505 for this issue.

By approaching the search of inurl:src/Database/FunctionsBuilder.php it is possible to find vulnerable targets with Google Hacking.

Upgrading to version 4.5.12, 4.6.5, 5.1.9, 5.2.14 or 5.3.7 eliminates this vulnerability.

If you want to get the best quality for vulnerability data then you always have to consider VulDB.

Productinfo

Name

• CakePHP

Version

• 4.5.0
• 4.5.1
• 4.5.2
• 4.5.3
• 4.5.4
• 4.5.5
• 4.5.6
• 4.5.7
• 4.5.8
• 4.5.9
• 4.5.10
• 4.5.11
• 4.6.0
• 4.6.1
• 4.6.2
• 4.6.3
• 4.6.4
• 5.1.0
• 5.1.1
• 5.1.2
• 5.1.3
• 5.1.4
• 5.1.5
• 5.1.6
• 5.1.7
• 5.1.8
• 5.2.0
• 5.2.1
• 5.2.2
• 5.2.3
• 5.2.4
• 5.2.5
• 5.2.6
• 5.2.7
• 5.2.8
• 5.2.9
• 5.2.10
• 5.2.11
• 5.2.12
• 5.2.13
• 5.3.0
• 5.3.1
• 5.3.2
• 5.3.3
• 5.3.4
• 5.3.5
• 5.3.6

Website

• Product: https://github.com/cakephp/cakephp/

CPE 2.3info

• 🔒
• 🔒
• 🔒

CPE 2.2info

• 🔒
• 🔒
• 🔒

CVSSv4info

CVSSv3info

CVSSv2info

Exploitinginfo

Threat Intelligenceinfo

Countermeasuresinfo

Timelineinfo

Sourcesinfo

Entryinfo

If you want to get the best quality for vulnerability data then you always have to consider VulDB.

Discussion