Fach, Fachbereich and views reworkedissue-4262

1 files changed, 6 insertions, 3 deletions

diff --git a/lib/classes/MvvPerm.php b/lib/classes/MvvPerm.php
index 693b7b7..d75a35d 100644
--- a/lib/classes/MvvPerm.php
+++ b/lib/classes/MvvPerm.php
@@ -638,9 +638,12 @@ class MvvPerm {
             }
 
             if (count($institutes)) {
-                $stmt = DBManager::get()->prepare('SELECT DISTINCT(Institut_id) '
-                        . 'FROM Institute WHERE Institut_id IN (:inst_ids) '
-                        . 'OR fakultaets_id IN (:inst_ids)');
+                $stmt = DBManager::get()->prepare('
+                    SELECT DISTINCT(`Institut_id`)
+                    FROM `Institute`
+                    WHERE `Institut_id` IN (:inst_ids)
+                        OR `fakultaets_id` IN (:inst_ids)
+                ');
                 $stmt->execute(['inst_ids' => $institutes]);
                 self::$user_role_institutes[$user_id] = $stmt->fetchAll(PDO::FETCH_COLUMN);
             } else {