fix: SQL error when inconsistency in DB

if a user is linked to a not existing group, a SQL IN statement begins with a comma fix #3242
pluginsGLPI · Apr 19, 2023 · 1af7872 · 1af7872
1 parent 7df2f7a
commit 1af7872
Showing 1 changed file with 3 additions and 0 deletions.
diff --git a/hook.php b/hook.php
@@ -265,6 +265,9 @@ function plugin_formcreator_addDefaultWhere($itemtype) {
 
             $groupIDs = [];
             foreach ($groups as $group) {
+               if ($group['id'] === null) {
+                  continue;
+               }
                $groupIDs[] = $group['id'];
             }
             $groupIDs = implode(',', $groupIDs);