shahiem / frontend-roles-manager Goto Github PK

I just try to make a fresh install of the plugin and I get the following error on artisan plugin:install

shahiemseymor_roles' doesn't exist

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.shahiemseymor_roles' doesn't exist (SQL: al  
  ter table `shahiemseymor_roles` add `description` text not null, add `default_group` int not null)    ```

  ```[PDOException]                                                                                             
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.shahiemseymor_roles' doesn't exist```

On backend section is unable to change user group in "ROLES" tab, because form input is named same as default groups ...

On "Account" tab is User[groups][] checkboxes,
and on "Roles" tab is User[groups][] checkboxes...

Then when i will change user role in Roles tab, then checkbox is "checked" on Account tab, no on Roles tab...

Maybe is needed to change checkboxes name from User[groups][] to User[roles][]

When upgrading to version 1.0.5 , i got a not null constraint violation.
I had to delete all the records in the user roles and permission to install this update.

i am using october cms with postgresql

@Shahiem can you spend a bit time for this plugin please? This is useful in most cases but needs to merge fixes and other improvements like "roles tab duplication" in users page etc..

Clicking on Users > Roles triggers an error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shahiemseymor_permission_role.user_group_id' in 'where clause'
(SQL: select `shahiemseymor_roles`.*, (select group_concat(shahiemseymor_permissions.name separator ', ') 
from `shahiemseymor_permissions` 
inner join `shahiemseymor_permission_role` on `shahiemseymor_permissions`.`id` = `shahiemseymor_permission_role`.`user_permission_id` 
where `shahiemseymor_permission_role`.`user_group_id` = `shahiemseymor_roles`.`id`) as `permissions`, 
(SELECT COUNT(1) FROM shahiemseymor_assigned_roles 
WHERE role_id = shahiemseymor_roles.id) as `users` 
from `shahiemseymor_roles` order by `name` desc limit 20 offset 0)
....../vendor/laravel/framework/src/Illuminate/Database/Connection.php line 614

shahiemseymor_permission_role doesn't indeed have a user_group_id columnn

CREATE TABLE `shahiemseymor_permission_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

RainLab.User 1.0.15
RainLab.Forum 1.0.12
User Plus 1.0.4
Frontend User Roles manager 1.0.6

Hi, I tried using this plugin with the option of using a SQLite database. It fails to create a database table needed by this plugin.

The error exception I am getting when installing is:

Update failed

"SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL (SQL: alter table "users" add column "primary_usergroup" integer not null)" on line 614 of C:\xampp\htdocs\public\name\vendor\laravel\framework\src\Illuminate\Database\Connection.php

Steps to reproduce this error:

1. Execute a clean install (make sure dependent plugins are already selected while installing user/blog).
2. Navigate to the back-end and log in
3. Select the plugin to install (shahiemseymor.roles)
4. Error occurs.

The yaml files in the permission is throwing an error " Yaml file is using tabs".
Editing the yaml files by replacing tabs with spaces solved the issue

Is there a page restriction for user roles and/or permissions? Like the page restriction that the RainLab plugin 'User' has...
If there is none, would it be something that you would consider implementing?
If not, what would be the recommended way to do that oneself?

Hello!

@ symbol causes errors. Need to replace it in controllers/config_list.yaml to ~ and need to remove it in models/groups/columns.yaml in 'select: @name' string

Delete button not working for Roles & Permission List. Backend Top Menu also broken. Following workaround works for me:

frontend-roles-manager/controllers/groups/_list_toolbar.htm -> Line 11
data-trigger-type="enable"
should be
data-trigger-action="enable"

Same workaround for Permission List.

Having issues with octoshop after purchase, can you support please?