High severityNVD Advisory· Published Mar 16, 2023· Updated Feb 25, 2025
Pimcore has improper quoting of columns when calling methods "getByUuid" & "exists" on UUID Model
CVE-2023-28108
Description
Pimcore is an open source data and experience management platform. Prior to version 10.5.19, quoting is not done properly in UUID DAO model. There is the theoretical possibility to inject custom SQL if the developer is using this methods with input data and not doing proper input validation in advance and so relies on the auto-quoting being done by the DAO class. Users should update to version 10.5.19 to receive a patch or, as a workaround, apply the patch manually.
Affected packages
Versions sourced from the GitHub Security Advisory.
| Package | Affected versions | Patched versions |
|---|---|---|
pimcore/pimcorePackagist | < 10.5.19 | 10.5.19 |
Affected products
1Patches
108e7ba56ae98[Task] Optimized get by UUID (#14633)
1 file changed · +25 −2
models/Tool/UUID/Dao.php+25 −2 modified@@ -15,6 +15,7 @@ namespace Pimcore\Model\Tool\UUID; +use Doctrine\DBAL\Types\Types; use Pimcore\Db\Helper; use Pimcore\Model; @@ -80,7 +81,17 @@ public function delete() */ public function getByUuid($uuid) { - $data = $this->db->fetchAssociative('SELECT * FROM ' . self::TABLE_NAME ." where uuid='" . $uuid . "'"); + $queryBuilder = $this->db->createQueryBuilder(); + $queryBuilder + ->select('*') + ->from(self::TABLE_NAME) + ->where('uuid = :uuid') + ->setParameter('uuid', $uuid, Types::STRING); + + $data = $queryBuilder + ->execute() + ->fetchAssociative(); + $model = new Model\Tool\UUID(); $model->setValues($data); @@ -94,6 +105,18 @@ public function getByUuid($uuid) */ public function exists($uuid) { - return (bool) $this->db->fetchOne('SELECT uuid FROM ' . self::TABLE_NAME . ' where uuid = ?', [$uuid]); + $queryBuilder = $this->db->createQueryBuilder(); + $queryBuilder + ->select('uuid') + ->from(self::TABLE_NAME) + ->where('uuid = :uuid') + ->setParameter('uuid', $uuid, Types::STRING); + + + $result = $queryBuilder + ->execute() + ->fetchOne(); + + return (bool) $result; } }
Vulnerability mechanics
Generated by null/stub on May 9, 2026. Inputs: CWE entries + fix-commit diffs from this CVE's patches. Citations validated against bundle.
References
5- github.com/advisories/GHSA-xc9p-r5qj-8xm9ghsaADVISORY
- nvd.nist.gov/vuln/detail/CVE-2023-28108ghsaADVISORY
- github.com/pimcore/pimcore/commit/08e7ba56ae983c3c67ec563b6989b16ef8f35275.patchghsax_refsource_MISCWEB
- github.com/pimcore/pimcore/pull/14633ghsax_refsource_MISCWEB
- github.com/pimcore/pimcore/security/advisories/GHSA-xc9p-r5qj-8xm9ghsax_refsource_CONFIRMWEB
News mentions
0No linked articles in our index yet.