search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.26k stars 2.73k forks source link

Can't see permissions related to the user module in the page to assign permission to user #18734

Open vincentjdc opened 3 years ago

vincentjdc commented 3 years ago

Bug

It the permission settings page of a user (/user/perms.php?id=...), the list of permissions related to a user (user->lire, user->creer, ...) are not displayed and so can't be assigned to a user.

Environment

Expected and actual behavior

The page should allow the admin to assign permissions related to users.

Steps to reproduce the behavior

ksar-ksar commented 2 years ago

Hi,

I have created a new user on a V14.0.3, and permissions settings are displayed image

vincentjdc commented 2 years ago

I'm using the following docker image : https://hub.docker.com/r/tuxgasy/dolibarr/ with the following docker-compose configuration : 


version: '3.4'

services:
    mariadb:
        image: mariadb:latest
        container_name: dolibarr-bug-db
        ports:
            - "127.0.0.1:${DOLIBARR_DB_PORT}:3306"
        environment:
            MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
            MYSQL_DATABASE: ${MYSQL_DATABASE}
        volumes:
            - ./mysql_data:/var/lib/mysql
    web:
        image: tuxgasy/dolibarr:latest
        container_name: dolibarr-bug
        ports:
            - "127.0.0.1:${DOLIBARR_PORT}:80"
        environment:
            DOLI_DB_HOST: mariadb
            DOLI_DB_USER: ${DOLI_DB_USER}
            DOLI_DB_PASSWORD: ${DOLI_DB_PASSWORD}
            DOLI_DB_NAME: ${DOLI_DB_NAME}
            DOLI_URL_ROOT: ${DOLI_URL_ROOT}
            PHP_INI_DATE_TIMEZONE: 'Europe/Brussels'
            DOLI_ADMIN_LOGIN: ${DOLI_ADMIN_LOGIN}
            DOLI_ADMIN_PASSWORD: ${DOLI_ADMIN_PASSWORD}
        links:
            - mariadb

and .env file

COMPOSE_PROJECT_NAME=dolibarr-bug

MYSQL_ROOT_PASSWORD=superrootpassword
MYSQL_DATABASE=dolibarr

DOLI_DB_USER=root
DOLI_DB_PASSWORD=superpassword
DOLI_DB_NAME=dolibarr
DOLIBARR_DB_PORT=3313
DOLI_URL_ROOT=http://localhost
DOLIBARR_PORT=84
DOLIBARR_VERSION=14
DOLI_ADMIN_LOGIN=admin
DOLI_ADMIN_PASSWORD=another superpassword

docker-compose up -d

After that, Dolibarr is running using 14.0.2. I can login as admin but can't see user permissions :

Capture du 2021-09-22 16-04-25

ksar-ksar commented 2 years ago

Hello,

Seems to be a "blank page" = Check the apache logs.

vincentjdc commented 2 years ago

Not sure. If I activate other module, I see theirs perms :

Capture du 2021-09-22 16-43-25

Apache logs does not seems to be relevant.

Capture du 2021-09-22 16-47-05

Did you mean dolibarr.log ?

ksar-ksar commented 2 years ago

No I meant Apache error log, what you display is access log.

vincentjdc commented 2 years ago

I'm using docker logs to get the dolibarr's container logs. It displays errors and access. I get no errors.

I also tried the following :

I've the same result.

hanneshier commented 2 years ago

I have the same problem on Dolibarr 15.0.1. I cannot the see the Permissions related to "Users & Groups". I use the Dolibarr -> LDAP Sync.

Screenshot 2022-05-17 at 16 09 33

hanneshier commented 2 years ago

I still can't find the permissions. Here is my docker-compose config:

version: "2.2"

services:

  dolibarr:
    image: tuxgasy/dolibarr:latest
    container_name: dolibarr
    restart: unless-stopped
    depends_on:
      - "mysql"
    environment:
      # Database
      DOLI_DB_HOST: "mysql"
      DOLI_DB_USER: "dolibarr"
      DOLI_DB_PASSWORD: "supersecurepasswrd"
      DOLI_DB_NAME: "dolibarr"
      # General
      DOLI_URL_ROOT: "https://dolibarr.example.com"
      DOLI_ADMIN_LOGIN: "admin"
      DOLI_ADMIN_PASSWORD: "evenmoresecurepassword"
      # LDAP
      DOLI_AUTH: "ldap, dolibarr"
      DOLI_LDAP_HOST: "openldap"
      DOLI_LDAP_DN: "ou=people,dc=example,dc=com"
      DOLI_LDAP_BIND_DN: "cn=dolibarr,ou=dsa,dc=example,dc=com"
      DOLI_LDAP_BIND_PASS: "mostsecurepassword"
      DOLI_LDAP_FILTER: "&(objectClass=inetOrgPerson)"
      # URL Proxy
      VIRTUAL_HOST: dolibarr.example.com
      LETSENCRYPT_HOST: dolibarr.example.com
      LETSENCRYPT_EMAIL: letsencrypt@example.com
    volumes:
      - ./docker-data/dolibarr:/var/www/documents
      - ./docker-data/theme:/var/www/htdocs/theme/mytheme
      - ./docker-data/plugin/cdav:/var/www/htdocs/cdav
    networks:
      - proxy
      - ldap
      - backend

  mysql:
    image: library/mariadb:latest
    container_name: dolibarr_db
    restart: unless-stopped
    environment:
      MARIADB_RANDOM_ROOT_PASSWORD: 1
      MYSQL_DATABASE: "dolibarr"
      MYSQL_USER: "dolibarr"
      MYSQL_PASSWORD: "supersecurepasswrd"
    volumes:
      - ./docker-data/db:/var/lib/mysql
    networks:
      - backend

networks:
  proxy:
    external:
      name: proxy
  ldap:
    external:
      name: ldap
  backend:
hanneshier commented 2 years ago

This section in the logs seems related to permission:

2022-05-27 10:10:11 NOTICE  172.18.0.1      --- Access to GET /user/perms.php - action=, massaction=
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='de_DE' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT COUNT(dbt.rowid) as nb FROM llx_user as dbt WHERE dbt.rowid IN (24) AND dbt.entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 24 ORDER BY u.entity ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT param, value FROM llx_user_param WHERE fk_user = 24 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1      DefaultValues::fetchAll
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,24) AND entity IN (1,1))
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 24 AND r.perms IS NOT NULL
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 24 AND r.perms IS NOT NULL
2022-05-27 10:10:11 INFO    172.18.0.1      files.lib.php::dol_dir_list path=/var/www/documents/users/24 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'user' AND objectid = 24 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1      BEGIN Transaction
2022-05-27 10:10:11 DEBUG   172.18.0.1       modTax::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TAX' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 91 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 92 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 93 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 94 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modRecruitment::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RECRUITMENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modImport::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_IMPORT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1251 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'warehouse' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modStock::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_STOCK' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modMailmanSpip::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MAILMANSPIP' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'contrat' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'contratdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modContrat::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CONTRAT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 161 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 162 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 163 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 164 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 165 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 167 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'resource' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modResource::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RESOURCE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       useNPR
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.recuperableonly = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'product' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       modService::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SERVICE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 531 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 532 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 534 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 538 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modNotification::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_NOTIFICATION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       User::loadParentOf
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       User::get_full_tree get user list
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       User::get_full_tree call to build_path_from_id_user
2022-05-27 10:10:11 DEBUG   172.18.0.1       User::get_full_tree dol_sort_array
2022-05-27 10:10:11 INFO    172.18.0.1       Build childid for id = 6
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDeplacement::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DEPLACEMENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'projet_task' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modProjet::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PROJET' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 41 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 42 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 44 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 45 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 141 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 142 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 144 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'user' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modCategorie::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CATEGORIE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 241 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 242 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 243 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modBanque::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BANQUE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 111 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 112 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 113 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 114 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 115 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 116 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 117 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDocumentGeneration::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DOCUMENTGENERATION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPrinting::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRINTING' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 64001 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modApi::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_API' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modLoan::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LOAN' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 521 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 522 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 524 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 525 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 527 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modMailing::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MAILING' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 221 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 222 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 223 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 229 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 237 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 238 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 239 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modBlockedLog::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BLOCKEDLOG' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 3201 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modOpenSurvey::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_OPENSURVEY' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPaymentByBankTransfer::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PAYMENTBYBANKTRANSFER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 561 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 562 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 563 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 564 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modSalaries::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SALARIES' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modProductBatch::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRODUCTBATCH' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'actioncomm' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modAgenda::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_AGENDA' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2401 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2402 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2403 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2411 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2412 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2413 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2414 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modModuleBuilder::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MODULEBUILDER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDav::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DAV' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modBookmark::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BOOKMARK' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modFckeditor::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FCKEDITOR' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modCron::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CRON' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 23001 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 23002 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 23003 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 23004 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'societe' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type != 'separate' AND elementtype = 'socpeople' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modSociete::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SOCIETE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 121 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 122 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 125 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 126 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 130 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 262 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 281 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 282 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 283 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 286 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modMargin::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MARGIN' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modBarcode::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BARCODE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modAsset::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ASSET' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modEventOrganization::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EVENTORGANIZATION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modZapier::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ZAPIER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDon::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DON' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 701 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 702 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 703 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDebugBar::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DEBUGBAR' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modWebServices::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSERVICES' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modWorkflow::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WORKFLOW' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modExternalSite::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXTERNALSITE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modIntracommreport::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_INTRACOMMREPORT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDataPolicy::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DATAPOLICY' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modReception::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RECEPTION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modLdap::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LDAP' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'commande' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'commandedet' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modCommande::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COMMANDE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPaypal::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PAYPAL' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modVariants::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_VARIANTS' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modWebsite::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSITE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expensereport' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'user' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modExpenseReport::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPENSEREPORT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modECM::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ECM' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2501 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2503 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 2515 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       useNPR
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.recuperableonly = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'product' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND  elementtype = 'product_fournisseur_price' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'DE' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-27 10:10:11 DEBUG   172.18.0.1       modProduct::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRODUCT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 31 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 32 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 34 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 38 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 39 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modLabel::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LABEL' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modWorkstation::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WORKSTATION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPrelevement::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRELEVEMENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 151 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 152 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 153 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 154 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modComptabilite::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COMPTABILITE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modTicket::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TICKET' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modEmailCollector::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EMAILCOLLECTOR' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modSyslog::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SYSLOG' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modExport::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPORT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1201 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1202 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modHRM::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_HRM' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modFTP::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FTP' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'user' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'user' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modUser::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_USER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modDynamicPrices::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DYNAMICPRICES' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modExternalRss::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXTERNALRSS' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPartnership::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PARTNERSHIP' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modIncoterm::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_INCOTERM' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modFacture::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FACTURE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 11 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 12 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 13 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 14 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 15 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 16 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 19 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1321 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1322 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modExpedition::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPEDITION' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modMultiCurrency::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MULTICURRENCY' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modTakePos::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TAKEPOS' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50151 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50152 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50153 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'propal' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'propaldet' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPropale::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PROPALE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bom' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bomline' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'bom_bom' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'bom_bomline' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modBom::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BOM' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modSupplierProposal::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SUPPLIERPROPOSAL' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modGravatar::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_GRAVATAR' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'mrp_mo' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'mrp_mo' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modMrp::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MRP' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modPayBox::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PAYBOX' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modCollab::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COLLAB' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'adherent' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modAdherent::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ADHERENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 71 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 72 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 74 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 76 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 75 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 78 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 79 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'facture_fourn' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'facture_fourn_det' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'commande_fournisseur' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE type <> 'separate' AND elementtype = 'commande_fournisseurdet' AND entity IN (0, 1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modFournisseur::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FOURNISSEUR' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1181 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1182 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1183 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1184 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1185 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1186 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1187 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1189 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1188 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1191 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1231 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1232 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1233 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1234 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1235 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1236 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modWebServicesClient::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSERVICESCLIENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modReceiptPrinter::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RECEIPTPRINTER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 67001 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       modStripe::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_STRIPE' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modGeoIPMaxmind::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_GEOIPMAXMIND' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modAccounting::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ACCOUNTING' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50440 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50401 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50411 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50412 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50414 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50415 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50418 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50420 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 50430 AND entity = 1
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinter' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinterdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modFicheinter::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FICHEINTER' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modOauth::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_OAUTH' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modKnowledgeManagement::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_KNOWLEDGEMANAGEMENT' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modClickToDial::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CLICKTODIAL' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'holiday' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'user' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2022-05-27 10:10:11 DEBUG   172.18.0.1       modHoliday::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_HOLIDAY' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1       modCDav::insert_permissions
2022-05-27 10:10:11 DEBUG   172.18.0.1       sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CDAV' AND entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1      COMMIT Transaction
2022-05-27 10:10:11 DEBUG   172.18.0.1      get user perms
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT DISTINCT ur.fk_id FROM llx_user_rights as ur WHERE ur.entity = 1 AND ur.fk_user = 24
2022-05-27 10:10:11 DEBUG   172.18.0.1      get user perms
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT DISTINCT gr.fk_id, gu.entity FROM llx_usergroup_rights as gr, llx_usergroup_user as gu WHERE gr.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 24
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 5
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT MAX(te.rowid) FROM llx_user as te WHERE te.rowid < '24' AND te.entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT MIN(te.rowid) FROM llx_user as te WHERE te.rowid > '24' AND te.entity IN (0,1)
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT r.id, r.libelle as label, r.module, r.perms, r.subperms, r.module_position, r.bydefault FROM llx_rights_def as r WHERE r.libelle NOT LIKE 'tou%' AND r.entity = 1 ORDER BY r.family_position, r.module_position, r.module, r.id
2022-05-27 10:10:11 DEBUG   172.18.0.1      sql=SELECT r.id, r.libelle as label, r.module, r.perms, r.subperms, r.module_position, r.bydefault FROM llx_rights_def as r WHERE r.libelle NOT LIKE 'tou%' AND r.entity = 1 ORDER BY r.family_position, r.module_position, r.module, r.id
2022-05-27 10:10:11 INFO    172.18.0.1      --- End access to /user/perms.php
hanneshier commented 2 years ago

I also noted that the User and Groups Module shows as disabled on the info page, although it cannot be deactivated or activated: Screenshot 2022-05-27 at 12 02 44

bmalynovytch commented 1 year ago

I also noted that the User and Groups Module shows as disabled on the info page, although it cannot be deactivated or activated

I had a different issue and fell here because symptoms were similar. I was trying to use the import module with users. Running the 16.0.3 tag in dev env, the module was working fine and the "import users & groups" was listed, while running another 16.0.3 wasn't showing the "users & groups" in the import module. Comparing both lead me to noticing what @hanneshier also noticed : modUser is shown as "disabled" while being "always enabled" (hard coded here).

I tried to figure out in the code where the error was, but failed (not enough time to investigate). Instead, worked around the issue by "enabling" the module using the "Configuration Modules/Application" page, copying the enable link from another module, pasting it in another tab and replacing the module name by "modUser". ie: Copied:

https://dolibarr.mydomain.com/admin/modules.php?id=750&token=xxxxxx&module_position=44&action=set&value=modRecruitment&mode=commonkanban
                                                                                                        ^^^^^^^^^^^^^^

Replaced by:

https://dolibarr.mydomain.com/admin/modules.php?id=750&token=xxxxxx&module_position=44&action=set&value=modUser&mode=commonkanban
                                                                                                        ^^^^^^^

I bet that the main issue that is just a matter of checking (properly) wether a module is enabled or not to enable features, not only by checking the "enabled" attribute but also the "always enabled".

hanneshier commented 1 year ago

I also noted that the User and Groups Module shows as disabled on the info page, although it cannot be deactivated or activated

I had a different issue and fell here because symptoms were similar. I was trying to use the import module with users. Running the 16.0.3 tag in dev env, the module was working fine and the "import users & groups" was listed, while running another 16.0.3 wasn't showing the "users & groups" in the import module. Comparing both lead me to noticing what @hanneshier also noticed : modUser is shown as "disabled" while being "always enabled" (hard coded here).

I tried to figure out in the code where the error was, but failed (not enough time to investigate). Instead, worked around the issue by "enabling" the module using the "Configuration Modules/Application" page, copying the enable link from another module, pasting it in another tab and replacing the module name by "modUser". ie: Copied:

https://dolibarr.mydomain.com/admin/modules.php?id=750&token=xxxxxx&module_position=44&action=set&value=modRecruitment&mode=commonkanban
                                                                                                        ^^^^^^^^^^^^^^

Replaced by:

https://dolibarr.mydomain.com/admin/modules.php?id=750&token=xxxxxx&module_position=44&action=set&value=modUser&mode=commonkanban
                                                                                                        ^^^^^^^

I bet that the main issue that is just a matter of checking (properly) wether a module is enabled or not to enable features, not only by checking the "enabled" attribute but also the "always enabled".

Instead, worked around the issue by "enabling" the module using the "Configuration Modules/Application" page, copying the enable link from another module, pasting it in another tab and replacing the module name by "modUser".

Nice workaround! I can confirm its working for me as well!

ksar-ksar commented 10 months ago

Hello,

I close the issue for now, you can re-open it if needed.

bmalynovytch commented 10 months ago

@ksar-ksar providing a workaround doesn't fix the main issue. It should remain open, unless really fixed.

ksar-ksar commented 10 months ago

Hello,

You can always re-open it, but has there is no clear root cause of why User Module is deactivated at some point, no correction will be made.

bmalynovytch commented 10 months ago

As explained in my previous comment (https://github.com/Dolibarr/dolibarr/issues/18734#issuecomment-1400140290), the module status is hard coded as always on, while the module manager allows to have it disabled. Therefore, the module manager isn't handling properly the fact that the module could be disabled by user, while hard coded as always on. There's definitely an issue. (Btw, I can't reopen the issue without creating a new one)

eldy commented 8 months ago

I have some reason to think this may be fixed into more recent version. Does this bug still occurs with last stable version ? If not, can you close ticket ? If yes, can you confirm the last stable version you reproduced the bug with ?

bmalynovytch commented 8 months ago

Version 18.0.4 is still affected.