SQL filter bypass leading to arbitrary write requests using "SQL Manager"
The advisory, in context
Impact
SQL filtering vulnerability, a BO user can write, update and delete in the database, even without having specific rights.
Patches
PrestaShop 8.0.4 and 1.7.8.9 will contain the patch.
Workarounds
no
References
no
Affected packages
Start with the recorded fix for your release branch. Check your installed version and test compatibility before upgrading. Fixing this advisory does not rule out other vulnerabilities in the release.
From 8.0.0 before 8.0.4
Fixed in 8.0.4
4 explicitly affected versions
8.0.0, 8.0.1, 8.0.2, 8.0.3
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "8.0.0"
},
{
"fixed": "8.0.4"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"8.0.0",
"8.0.1",
"8.0.2",
"8.0.3"
]
}Earlier releases before 1.7.8.9
Fixed in 1.7.8.9
76 explicitly affected versions
1.7.0.0, 1.7.0.0-beta.1.0, 1.7.0.0-beta.2.0, 1.7.0.0-beta.3.0, 1.7.0.0-beta.4.0, 1.7.0.0-rc.0.0, 1.7.0.0-rc.1.0, 1.7.0.0-rc.2.0, 1.7.0.1, 1.7.0.2, 1.7.0.3, 1.7.0.4, 1.7.0.5, 1.7.0.6, 1.7.1.0, 1.7.1.1, 1.7.1.2, 1.7.2.0, 1.7.2.0-rc.1.0, 1.7.2.1, 1.7.2.2, 1.7.2.3, 1.7.2.4, 1.7.2.5, 1.7.3.0, 1.7.3.1, 1.7.3.2, 1.7.3.3, 1.7.3.4, 1.7.4.0, 1.7.4.0-beta.1, 1.7.4.1, 1.7.4.2, 1.7.4.3, 1.7.4.4, 1.7.5.0, 1.7.5.0-beta.1, 1.7.5.0-rc.1, 1.7.5.1, 1.7.5.2, 1.7.6.0, 1.7.6.0-beta.1, 1.7.6.0-rc.1, 1.7.6.0-rc.2, 1.7.6.1, 1.7.6.2, 1.7.6.3, 1.7.6.4, 1.7.6.5, 1.7.6.6, 1.7.6.7, 1.7.6.8, 1.7.6.9, 1.7.7.0, 1.7.7.0-beta.1, 1.7.7.0-beta.2, 1.7.7.0-rc.1, 1.7.7.1, 1.7.7.2, 1.7.7.3, 1.7.7.4, 1.7.7.5, 1.7.7.6, 1.7.7.7, 1.7.7.8, 1.7.8.0, 1.7.8.0-beta.1, 1.7.8.0-rc.1, 1.7.8.1, 1.7.8.2, 1.7.8.3, 1.7.8.4, 1.7.8.5, 1.7.8.6, 1.7.8.7, 1.7.8.8
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"fixed": "1.7.8.9"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"1.7.0.0",
"1.7.0.0-beta.1.0",
"1.7.0.0-beta.2.0",
"1.7.0.0-beta.3.0",
"1.7.0.0-beta.4.0",
"1.7.0.0-rc.0.0",
"1.7.0.0-rc.1.0",
"1.7.0.0-rc.2.0",
"1.7.0.1",
"1.7.0.2",
"1.7.0.3",
"1.7.0.4",
"1.7.0.5",
"1.7.0.6",
"1.7.1.0",
"1.7.1.1",
"1.7.1.2",
"1.7.2.0",
"1.7.2.0-rc.1.0",
"1.7.2.1",
"1.7.2.2",
"1.7.2.3",
"1.7.2.4",
"1.7.2.5",
"1.7.3.0",
"1.7.3.1",
"1.7.3.2",
"1.7.3.3",
"1.7.3.4",
"1.7.4.0",
"1.7.4.0-beta.1",
"1.7.4.1",
"1.7.4.2",
"1.7.4.3",
"1.7.4.4",
"1.7.5.0",
"1.7.5.0-beta.1",
"1.7.5.0-rc.1",
"1.7.5.1",
"1.7.5.2",
"1.7.6.0",
"1.7.6.0-beta.1",
"1.7.6.0-rc.1",
"1.7.6.0-rc.2",
"1.7.6.1",
"1.7.6.2",
"1.7.6.3",
"1.7.6.4",
"1.7.6.5",
"1.7.6.6",
"1.7.6.7",
"1.7.6.8",
"1.7.6.9",
"1.7.7.0",
"1.7.7.0-beta.1",
"1.7.7.0-beta.2",
"1.7.7.0-rc.1",
"1.7.7.1",
"1.7.7.2",
"1.7.7.3",
"1.7.7.4",
"1.7.7.5",
"1.7.7.6",
"1.7.7.7",
"1.7.7.8",
"1.7.8.0",
"1.7.8.0-beta.1",
"1.7.8.0-rc.1",
"1.7.8.1",
"1.7.8.2",
"1.7.8.3",
"1.7.8.4",
"1.7.8.5",
"1.7.8.6",
"1.7.8.7",
"1.7.8.8"
]
}References
- https://github.com/PrestaShop/PrestaShop/security/advisories/GHSA-p379-cxqh-q822
- https://nvd.nist.gov/vuln/detail/CVE-2023-30839
- https://github.com/PrestaShop/PrestaShop/commit/0f2a9b7fdd42d1dd3b21d4fad586a849642f3c30
- https://github.com/PrestaShop/PrestaShop/commit/d1d27dc371599713c912b71bc2a455cacd7f2149
- https://github.com/PrestaShop/PrestaShop
- https://github.com/PrestaShop/PrestaShop/releases/tag/1.7.8.9
- https://github.com/PrestaShop/PrestaShop/releases/tag/8.0.4