diff options
| -rwxr-xr-x | checksetup.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/checksetup.pl b/checksetup.pl index 16edfae3d..e8c5e1da9 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -4134,8 +4134,8 @@ $dbh->do("DELETE FROM user_group_map WHERE grant_type = " . GRANT_DERIVED); $sth = $dbh->prepare("SELECT profiles.userid, profiles.login_name, groups.id, groups.userregexp, user_group_map.group_id - FROM profiles - CROSS JOIN groups + FROM (profiles + CROSS JOIN groups) LEFT JOIN user_group_map ON user_group_map.user_id = profiles.userid AND user_group_map.group_id = groups.id |