Miggo Logo
Miggo Vulnerability Database
→
CVE-2023-39524

CVE-2023-39524: PrestaShop boolean SQL injection

6.7

CVSS Score
3.1

Basic Information

CVE ID
CVE-2023-39524
GHSA ID
GHSA-75p5-jwx4-qw9h
EPSS Score
0.52918%
CWE
CWE-89
Published
8/9/2023
Updated
11/6/2023
KEV Status
No
Technology
TechnologyPHP

Technical Details

CVSS Vector
CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:U/C:L/I:H/A:H
Package NameEcosystemVulnerable VersionsFirst Patched Version
prestashop/prestashopcomposer<= 8.1.08.1.1

Vulnerability Intelligence
Miggo AIMiggo AI

Miggo AIRoot Cause Analysis

The commit diff shows the vulnerability was patched by adding pSQL() sanitization to $searchPhrase in ProductRepository.php's getSearchQueryBuilder method. This function directly processes user-controlled input for SQL query construction without proper escaping in vulnerable versions, making it the clear injection point. The patch confirms the vulnerability stemmed from missing input sanitization at this location.

Vulnerable functions

Only Mi**o us*rs **n s** t*is s**tion

WAF Protection Rules

WAF Rule

### Imp**t SQL inj**tion possi*l* in pro*u*t s**r** *i*l*, in *O's pro*u*t p*** ### P*t***s *.*.* ### *oun* *y *l*ks*y Solov*v (Positiv* T***nolo*i*s) ### Work*roun*s non* ### R***r*n**s non*

Reasoning

T** *ommit *i** s*ows t** vuln*r**ility w*s p*t**** *y ***in* pSQL() s*nitiz*tion to $s**r**P*r*s* in Pro*u*tR*pository.p*p's **tS**r**Qu*ry*uil**r m*t*o*. T*is *un*tion *ir**tly pro**ss*s us*r-*ontroll** input *or SQL qu*ry *onstru*tion wit*out prop