| @@ -49,9 +49,9 @@ | ||
| 49 | 49 | * @throws UserGroupTypeException |
| 50 | 50 | */ |
| 51 | 51 | private function loadUserGroups(): array |
| 52 | 52 | { |
| 53 | - $query = "SELECT * FROM {$this->database->getUserGroupTable()}"; | |
| 53 | + $query = "SELECT * FROM `{$this->database->getUserGroupTable()}`"; | |
| 54 | 54 | $userGroups = []; |
| 55 | 55 | |
| 56 | 56 | foreach ((array) $this->database->getResults($query) as $databaseUserGroup) { |
| 57 | 57 | $userGroup = $this->userGroupFactory->createUserGroupFromDatabaseRow($databaseUserGroup); |
| @@ -83,12 +83,12 @@ | ||
| 83 | 83 | $dynamicUserGroups = [$notLoggedInUserGroup->getId() => $notLoggedInUserGroup]; |
| 84 | 84 | |
| 85 | 85 | $userGroupTypes = implode('\', \'', [DynamicUserGroup::ROLE_TYPE, DynamicUserGroup::USER_TYPE]); |
| 86 | 86 | |
| 87 | - $query = "SELECT group_id AS id, group_type AS type | |
| 88 | - FROM {$this->database->getUserGroupToObjectTable()} | |
| 89 | - WHERE group_type IN ('$userGroupTypes') | |
| 90 | - GROUP BY group_type, group_id"; | |
| 87 | + $query = "SELECT `group_id` AS `id`, `group_type` AS `type` | |
| 88 | + FROM `{$this->database->getUserGroupToObjectTable()}` | |
| 89 | + WHERE `group_type` IN ('$userGroupTypes') | |
| 90 | + GROUP BY `group_type`, `group_id`"; | |
| 91 | 91 | |
| 92 | 92 | foreach ((array) $this->database->getResults($query) as $databaseUserGroup) { |
| 93 | 93 | $userGroup = $this->userGroupFactory->createDynamicUserGroup( |
| 94 | 94 | $databaseUserGroup->type, |
