Can't add new group

mglockle · April 13, 2020, 12:04am

I am an Admin.

Under Users & Groups, Groups, New group I can’t add a new group. I am getting following failure message:

Current login: mg
Permission for this login can be defined by your Dolibarr administrator from menu Home->Users.

Please help

Thx
Michael

simicar · April 13, 2020, 8:12am

Hi Michael,

Did you check that beyond being admin, you have full rights on users and groups (permission tab under your user tab) ? That should be as an admin, but is worth verifying.

Regards,
Marc

mglockle · April 13, 2020, 8:31am

Thank you Marc, please check attached picture of my permissions:

simicar · April 13, 2020, 8:44am

Do you have any external module, such as multicompany ?

mglockle · April 13, 2020, 9:02am

No nothing, only started now to setup User/ Products/ Customers/ Vendors …

simicar · April 13, 2020, 10:06am

Sorry, I can’t see what can be wrong. This would need deeper inspection.
If anybody else can help, he is welcome…

Regards,
Marc

mglockle · April 13, 2020, 12:32pm

Another failure message if I want Add a Group under User / User card / List of groups for this user

simicar · April 13, 2020, 1:52pm

The behaviour is very strange. It looks like you have a problem with the entity definition. Moreover, if you are where I think you are, you should not have a -1 in the sql query (group id). What are these users ? Internal/external ? What exact version of Dolibarr are you running ? Is this a fresh install ? If not, what is the history ?
You have to activate logging if not done already and inspect what the system is doing, notably the sql command sent before this error.
Regards,
Marc

mglockle · April 13, 2020, 4:27pm

Picture 2

mglockle · April 13, 2020, 4:28pm

Picture 3

simicar · April 14, 2020, 7:38am

Thanks Michael, problem is lines are truncated in the screenshots and we are missing the one with “INSERT”. Could you provide the full log file ?
Regards,
Marc

mglockle · April 14, 2020, 9:10am

simicar · April 14, 2020, 9:26am

The error you had

is probably the one described below :

github.com/Dolibarr/dolibarr

Bug when adding group to user

opened 10:54AM - 01 Aug 19 UTC

closed 06:56PM - 07 Aug 20 UTC

jige18

Works for me / Can't reproduce

# Bug You have an error in your SQL syntax; check the manual that corresponds t…o your MySQL server version for the right syntax to use near '9,-1)' at line 1 ## Environment DOLIBARR ENVIRONMENT - Version: 10.0 - Operating System: Linux Wed May 15 10:40:34 CEST 2019 x86_64 - Web Server: Apache - PHP: 7.0.33 - Database: MySQL or MariaDB 5.6.42-log - URL(s): /user/card.php?id=5 ## Expected and actual behavior Expected: add a group to user Actual: error message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8,-1)' at line 1 ## Steps to reproduce the behavior Go in user info. Go below to "Liste des Groupes for this user". Click "Add" ![image](https://user-images.githubusercontent.com/53564106/62287881-058e2e00-b453-11e9-9d36-a917efb69c82.png)

It means this form is to add a group to a user, you have to select a group in the list, you can’t create a new group from there…

heinja · July 14, 2021, 12:17pm

Hi, I’ve also encountered this problem and my solution (which is hardly not technical) was:

Go to Setup > Security
Disable “Use the advanced permissions of some modules”
Go back to Users & Group > Groups > New Group
Create a group, in my case, I named it “Super Admin”
Edit the “Super Admin” to have all permissions
Go to Users & Group > List of users
Select your current admin user
Attach the newly created “Super Admin” to your admin user
Enable “Use the advanced permissions of some modules” in Setup > Security
And now you should be able to access the “New Group” page without the “Access denied.” message

Good luck!