Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Duplicate
-
3.0.x
-
None
-
None
-
PHP Environment: 5.2.3
Database: MySQL 5.0.16
Description
In includes/functions_admin.php on line 2607, the function update_foes() attempts to execute an invalid SQL query. This will trigger an error whenever the administrator updates a user account.
The syntax error is a missing space after "DELETE FROM". See below:
if ($db->multi_table_deletion)
|
{
|
$sql = 'DELETE FROM' . ZEBRA_TABLE . ' z
|
USING ' . USER_GROUP_TABLE . ' ug
|
WHERE z.zebra_id = ug.user_id
|
AND z.foe = 1
|
AND ' . $db->sql_in_set('ug.group_id', $groups);
|
$db->sql_query($sql);
|