<?php $group = 4; $user = \Auth::instance()->create_user('tester', '1234', 'tester@domain.com', $group, array('fullname' => 'a tester')); # I create permission $permission=\Model\Auth_Permission::forge( array( 'area' => 'admin', 'permission' => 'list', 'description' => 'testing admin in module admin and controller list', 'actions' => array('view', 'add', 'edit', 'delete', 'modify'), ) ); $permission->save(); # I create a this permission for this group with only 'view' action $actions = array(1); $permission_group=\Model\Auth_Grouppermission::forge(array('group_id'=>$group,'perms_id'=>$permission->id,'actions'=>$actions)); $permission_group->save(); /////// TEST if ( \Auth::has_access('admin.list[view]')) { echo 'you have access ...'; } # ======> error # Fuel\Core\Database_Exception [ Error ]: # SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.id' in 'field list' with query: "SELECT `t0`.`actions` AS `t0_c0`, `t0`.`id` AS `t0_c1`, `t0`.`group_id` AS `t0_c2`, `t0`.`perms_id` AS `t0_c3` FROM `users_group_permissions` AS `t0` WHERE `t0`.`group_id` = '4'"