Hello , I have my Icingaweb2 server connected to our domain controller for users ,all users are imported correctly but when i am trying to Create New Membership <https://212.143.237.23/icingaweb2/user/createmembership?backend=Dalet_ad&user=dlasry> i get following error below Same when i am trying to get user group details ant idea Please advice Thanks
Create New Membership <https://212.143.237.23/icingaweb2/user/createmembership?backend=Dalet_ad&user=dlasry>* error* > SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gm.group_id' in > 'on clause', query was: SELECT g.name AS group_name FROM > icingaweb_group_membership AS gm > INNER JOIN icingaweb_group AS g ON gm.group_id = g.id WHERE (gm.username > = 'tbaror') > ------------------------------ > > #0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): > Zend_Db_Statement_Pdo->_execute(Array) > #1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): > Zend_Db_Statement->execute(Array) > #2 > /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232): > Zend_Db_Adapter_Abstract->query('SELECT g.name A...', Array) > #3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(782): > Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array) > #4 /usr/share/php/Icinga/Data/Db/DbConnection.php(290): > Zend_Db_Adapter_Abstract->fetchCol(Object(Zend_Db_Select)) > #5 /usr/share/php/Icinga/Data/SimpleQuery.php(590): > Icinga\Data\Db\DbConnection->fetchColumn(Object(Icinga\Data\Db\DbQuery)) > #6 /usr/share/php/Icinga/Repository/RepositoryQuery.php(569): > Icinga\Data\SimpleQuery->fetchColumn() > #7 > /usr/share/icingaweb2/application/forms/Config/User/CreateMembershipForm.php(164): > Icinga\Repository\RepositoryQuery->fetchColumn() > #8 > /usr/share/icingaweb2/application/forms/Config/User/CreateMembershipForm.php(97): > Icinga\Forms\Config\User\CreateMembershipForm->createDataSource() > #9 /usr/share/php/Icinga/Web/Form.php(1183): > Icinga\Forms\Config\User\CreateMembershipForm->onRequest() > #10 /usr/share/icingaweb2/application/controllers/UserController.php(237): > Icinga\Web\Form->handleRequest() > #11 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): > Icinga\Controllers\UserController->createmembershipAction() > #12 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): > Zend_Controller_Action->dispatch('createmembershi...') > #13 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): > Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), > Object(Icinga\Web\Response)) > #14 /usr/share/php/Icinga/Application/Web.php(389): > Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), > Object(Icinga\Web\Response)) > #15 /usr/share/php/Icinga/Application/webrouter.php(109): > Icinga\Application\Web->dispatch() > #16 /usr/share/icingaweb2/public/index.php(4): > require_once('/usr/share/php/...') > #17 {main} > > * group details error* > SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gm.group_id' in > 'on clause', query was: SELECT gm.username AS user_name FROM > icingaweb_group_membership AS gm > INNER JOIN icingaweb_group AS g ON gm.group_id = g.id WHERE (g.name = > 'gefen_users') LIMIT 25 > ------------------------------ > > #0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): > Zend_Db_Statement_Pdo->_execute(Array) > #1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): > Zend_Db_Statement->execute(Array) > #2 > /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232): > Zend_Db_Adapter_Abstract->query('SELECT gm.usern...', Array) > #3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(744): > Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array) > #4 /usr/share/php/Icinga/Data/Db/DbConnection.php(278): > Zend_Db_Adapter_Abstract->fetchRow(Object(Zend_Db_Select)) > #5 /usr/share/php/Icinga/Data/SimpleQuery.php(577): > Icinga\Data\Db\DbConnection->fetchRow(Object(Icinga\Data\Db\DbQuery)) > #6 /usr/share/php/Icinga/Data/SimpleQuery.php(453): > Icinga\Data\SimpleQuery->fetchRow() > #7 /usr/share/php/Icinga/Repository/RepositoryQuery.php(450): > Icinga\Data\SimpleQuery->hasResult() > #8 > zend.view:///usr/share/icingaweb2/application/views/scripts/group/show.phtml(67): > Icinga\Repository\RepositoryQuery->hasResult() > #9 /usr/share/php/Icinga/Web/View.php(231): include('zend.view:///us...') > #10 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(877): > Icinga\Web\View->_run('/usr/share/icin...') > #11 > /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(904): > Zend_View_Abstract->render() > #12 > /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(925): > > Zend_Controller_Action_Helper_ViewRenderer->renderScript('group/show.phtm...', > NULL) > #13 > /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(964): > Zend_Controller_Action_Helper_ViewRenderer->render() > #14 > /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/HelperBroker.php(272): > Zend_Controller_Action_Helper_ViewRenderer->postDispatch() > #15 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(518): > Zend_Controller_Action_HelperBroker->notifyPostDispatch() > #16 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): > Zend_Controller_Action->dispatch('showAction') > #17 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): > Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), > Object(Icinga\Web\Response)) > #18 /usr/share/php/Icinga/Application/Web.php(389): > Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), > Object(Icinga\Web\Response)) > #19 /usr/share/php/Icinga/Application/webrouter.php(109): > Icinga\Application\Web->dispatch() > #20 /usr/share/icingaweb2/public/index.php(4): > require_once('/usr/share/php/...') > #21 {main} > > - Tal Bar-or
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
