2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:27:41 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:27:41 INFO 37.171.173.2 --- Access to /admin/modules.php - action=, massaction= 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:27:41 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:27:41 INFO 37.171.173.2 Scan directory /home/signaltech/DoliTest/dolibarr-8.0.4/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2019-07-30 12:27:41 INFO 37.171.173.2 Module modLabel not qualified 2019-07-30 12:27:41 INFO 37.171.173.2 Module modWebServicesClient not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 useNPR 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 useNPR 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-07-30 12:27:41 INFO 37.171.173.2 Module modCollab not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-07-30 12:27:41 INFO 37.171.173.2 Module modDynamicPrices not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 INFO 37.171.173.2 Module modReception not qualified 2019-07-30 12:27:41 INFO 37.171.173.2 Module modDocumentGeneration not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-07-30 12:27:41 INFO 37.171.173.2 Module modBom not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2019-07-30 12:27:41 INFO 37.171.173.2 Module Blockedlog alreadyUsed with ignoresystem=1 is 2019-07-30 12:27:41 INFO 37.171.173.2 Module modAsset not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:27:41 DEBUG 37.171.173.2 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) 2019-07-30 12:27:41 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:27:41 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:27:41 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:27:41 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:27:41 INFO 37.171.173.2 Module modDeplacement not qualified 2019-07-30 12:27:41 INFO 37.171.173.2 Module modDataPolicy not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-07-30 12:27:41 DEBUG 37.171.173.2 useNPR 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 useNPR 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 useNPR 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:27:41 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:27:41 INFO 37.171.173.2 Module modReceiptPrinter not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-07-30 12:27:41 INFO 37.171.173.2 Module modHRM not qualified 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 2019-07-30 12:27:41 DEBUG 37.171.173.2 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 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:27:41 DEBUG 37.171.173.2 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2019-07-30 12:27:41 INFO 37.171.173.2 Module Blockedlog alreadyUsed with ignoresystem=1 is 2019-07-30 12:27:41 INFO 37.171.173.2 --- End access to /admin/modules.php 2019-07-30 12:27:50 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:27:50 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:27:50 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:27:50 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:27:50 INFO 37.171.173.2 --- Access to /admin/syslog.php - action=, massaction= 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:27:50 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:27:50 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-07-30 12:27:50 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:27:50 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-07-30 12:27:50 INFO 37.171.173.2 --- End access to /admin/syslog.php 2019-07-30 12:28:16 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:28:16 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:28:16 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:28:16 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:28:16 INFO 37.171.173.2 --- Access to /admin/syslog.php - action=set, massaction= 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:28:16 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:28:16 DEBUG 37.171.173.2 BEGIN Transaction 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_del_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE (name = 'SYSLOG_FACILITY') 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=INSERT INTO llx_const(name,value,type,visible,note,entity) VALUES ('SYSLOG_FACILITY', '/custom','chaine',0,'',0) 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_del_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE (name = 'SYSLOG_FILE') 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=INSERT INTO llx_const(name,value,type,visible,note,entity) VALUES ('SYSLOG_FILE', 'DOL_DATA_ROOT/dolibarr.log','chaine',0,'',0) 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_del_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE (name = 'SYSLOG_HANDLERS') 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=DELETE FROM llx_const WHERE name = 'SYSLOG_HANDLERS' AND entity = 0 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_set_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=INSERT INTO llx_const(name,value,type,visible,note,entity) VALUES ('SYSLOG_HANDLERS', '[\"mod_syslog_syslog\",\"mod_syslog_file\"]','chaine',0,'',0) 2019-07-30 12:28:16 INFO 37.171.173.2 admin/syslog: file /home/signaltech/DoliTest/dolibarr-8.0.4/documents/dolibarr.log 2019-07-30 12:28:16 DEBUG 37.171.173.2 COMMIT Transaction 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-07-30 12:28:16 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:28:16 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-07-30 12:28:16 INFO 37.171.173.2 --- End access to /admin/syslog.php 2019-07-30 12:28:22 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:28:22 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:28:22 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:28:22 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:28:22 INFO 37.171.173.2 --- Access to /hrm/index.php - action=, massaction= 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:28:22 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:28:22 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:28:22 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:28:22 DEBUG 37.171.173.2 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) 2019-07-30 12:28:22 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:28:22 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:28:22 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:28:22 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 AND affect = 1 2019-07-30 12:28:22 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 4 2019-07-30 12:28:22 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 5 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.photo, u.statut, x.rowid, x.rowid as ref, x.fk_type, x.date_debut as date_start, x.date_fin as date_end, x.halfday, x.tms as dm, x.statut as status FROM llx_holiday as x, llx_user as u WHERE u.rowid = x.fk_user AND x.entity = 1 ORDER BY x.tms DESC LIMIT 3 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 2019-07-30 12:28:22 DEBUG 37.171.173.2 sql=SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.statut, u.photo, x.rowid, x.ref, x.date_debut as date, x.tms as dm, x.total_ttc, x.fk_statut as status FROM llx_expensereport as x, llx_user as u WHERE u.rowid = x.fk_user_author AND x.entity = 1 ORDER BY x.tms DESC LIMIT 3 2019-07-30 12:28:22 INFO 37.171.173.2 --- End access to /hrm/index.php 2019-07-30 12:28:26 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:28:26 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:28:26 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:28:26 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:28:26 INFO 37.171.173.2 --- Access to /holiday/card.php - action=request, massaction= 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:28:26 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:28:26 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:28:26 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:28:26 DEBUG 37.171.173.2 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) 2019-07-30 12:28:26 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:28:26 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:28:26 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:28:26 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:28:26 DEBUG 37.171.173.2 Holiday::getConfCP name=delayForRequest createifnotfound= 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT value FROM llx_holiday_config WHERE name = 'delayForRequest' 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 AND affect = 1 2019-07-30 12:28:26 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 4 2019-07-30 12:28:26 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 5 2019-07-30 12:28:26 DEBUG 37.171.173.2 Form::select_dolusers 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) AND employee = 1 ORDER BY u.firstname ASC 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 2019-07-30 12:28:26 INFO 37.171.173.2 Holiday::fetch_users_approver_holiday sql=SELECT DISTINCT ur.fk_user FROM llx_user_rights as ur, llx_rights_def as rd WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'UNION SELECT DISTINCT ugu.fk_user FROM llx_usergroup_user as ugu, llx_usergroup_rights as ur, llx_rights_def as rd WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve' 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT DISTINCT ur.fk_user FROM llx_user_rights as ur, llx_rights_def as rd WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'UNION SELECT DISTINCT ugu.fk_user FROM llx_usergroup_user as ugu, llx_usergroup_rights as ur, llx_rights_def as rd WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve' 2019-07-30 12:28:26 DEBUG 37.171.173.2 Form::select_dolusers 2019-07-30 12:28:26 DEBUG 37.171.173.2 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) AND u.rowid IN (1) ORDER BY u.firstname ASC 2019-07-30 12:28:26 INFO 37.171.173.2 DolEditor::DolEditor htmlname=description width= height=80 toolbarname=dolibarr_notes 2019-07-30 12:28:26 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:28:43 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:28:43 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:28:43 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:28:43 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:28:43 INFO 37.171.173.2 --- Access to /holiday/card.php - action=create, massaction= 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:28:43 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:28:43 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:28:43 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:28:43 DEBUG 37.171.173.2 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) 2019-07-30 12:28:43 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:28:43 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:28:43 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:28:43 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:28:43 DEBUG 37.171.173.2 BEGIN Transaction 2019-07-30 12:28:43 DEBUG 37.171.173.2 Holiday::fetchByUser 2019-07-30 12:28:43 DEBUG 37.171.173.2 sql=SELECT cp.rowid, cp.ref, cp.fk_user, cp.fk_type, cp.date_create, cp.description, cp.date_debut, cp.date_fin, cp.halfday, cp.statut, cp.fk_validator, cp.date_valid, cp.fk_user_valid, cp.date_refuse, cp.fk_user_refuse, cp.date_cancel, cp.fk_user_cancel, cp.detail_refuse, uu.lastname as user_lastname, uu.firstname as user_firstname, uu.login as user_login, uu.statut as user_statut, uu.photo as user_photo, ua.lastname as validator_lastname, ua.firstname as validator_firstname, ua.login as validator_login, ua.statut as validator_statut, ua.photo as validator_photo FROM llx_holiday as cp, llx_user as uu, llx_user as ua WHERE cp.entity IN (1) AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid AND cp.fk_user IN (1) 2019-07-30 12:28:43 INFO 37.171.173.2 num_open_day timestampStart=1561939200 timestampEnd=1564444800 bit=1 country_code=FR 2019-07-30 12:28:43 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:28:57 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:28:57 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:28:57 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:28:57 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:28:57 INFO 37.171.173.2 --- Access to /holiday/card.php - action=create, massaction= 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:28:57 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:28:57 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:28:57 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:28:57 DEBUG 37.171.173.2 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) 2019-07-30 12:28:57 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:28:57 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:28:57 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:28:57 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:28:57 DEBUG 37.171.173.2 BEGIN Transaction 2019-07-30 12:28:57 DEBUG 37.171.173.2 Holiday::fetchByUser 2019-07-30 12:28:57 DEBUG 37.171.173.2 sql=SELECT cp.rowid, cp.ref, cp.fk_user, cp.fk_type, cp.date_create, cp.description, cp.date_debut, cp.date_fin, cp.halfday, cp.statut, cp.fk_validator, cp.date_valid, cp.fk_user_valid, cp.date_refuse, cp.fk_user_refuse, cp.date_cancel, cp.fk_user_cancel, cp.detail_refuse, uu.lastname as user_lastname, uu.firstname as user_firstname, uu.login as user_login, uu.statut as user_statut, uu.photo as user_photo, ua.lastname as validator_lastname, ua.firstname as validator_firstname, ua.login as validator_login, ua.statut as validator_statut, ua.photo as validator_photo FROM llx_holiday as cp, llx_user as uu, llx_user as ua WHERE cp.entity IN (1) AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid AND cp.fk_user IN (1) 2019-07-30 12:28:57 INFO 37.171.173.2 num_open_day timestampStart=1561939200 timestampEnd=1564444800 bit=1 country_code=FR 2019-07-30 12:28:57 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:29:02 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:29:02 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:29:02 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:29:02 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:29:02 INFO 37.171.173.2 --- Access to /holiday/card.php - action=create, massaction= 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:29:02 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:29:02 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:29:02 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:29:02 DEBUG 37.171.173.2 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) 2019-07-30 12:29:02 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:29:02 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:29:02 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:29:02 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:29:02 DEBUG 37.171.173.2 BEGIN Transaction 2019-07-30 12:29:02 DEBUG 37.171.173.2 Holiday::fetchByUser 2019-07-30 12:29:02 DEBUG 37.171.173.2 sql=SELECT cp.rowid, cp.ref, cp.fk_user, cp.fk_type, cp.date_create, cp.description, cp.date_debut, cp.date_fin, cp.halfday, cp.statut, cp.fk_validator, cp.date_valid, cp.fk_user_valid, cp.date_refuse, cp.fk_user_refuse, cp.date_cancel, cp.fk_user_cancel, cp.detail_refuse, uu.lastname as user_lastname, uu.firstname as user_firstname, uu.login as user_login, uu.statut as user_statut, uu.photo as user_photo, ua.lastname as validator_lastname, ua.firstname as validator_firstname, ua.login as validator_login, ua.statut as validator_statut, ua.photo as validator_photo FROM llx_holiday as cp, llx_user as uu, llx_user as ua WHERE cp.entity IN (1) AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid AND cp.fk_user IN (1) 2019-07-30 12:29:02 INFO 37.171.173.2 num_open_day timestampStart=1561939200 timestampEnd=1564444800 bit=1 country_code=FR 2019-07-30 12:29:02 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:29:05 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:29:05 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:29:05 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:29:05 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:29:05 INFO 37.171.173.2 --- Access to /holiday/card.php - action=create, massaction= 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:29:05 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:29:05 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:29:05 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:29:05 DEBUG 37.171.173.2 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) 2019-07-30 12:29:05 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:29:05 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:29:05 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:29:05 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:29:05 DEBUG 37.171.173.2 BEGIN Transaction 2019-07-30 12:29:05 DEBUG 37.171.173.2 Holiday::fetchByUser 2019-07-30 12:29:05 DEBUG 37.171.173.2 sql=SELECT cp.rowid, cp.ref, cp.fk_user, cp.fk_type, cp.date_create, cp.description, cp.date_debut, cp.date_fin, cp.halfday, cp.statut, cp.fk_validator, cp.date_valid, cp.fk_user_valid, cp.date_refuse, cp.fk_user_refuse, cp.date_cancel, cp.fk_user_cancel, cp.detail_refuse, uu.lastname as user_lastname, uu.firstname as user_firstname, uu.login as user_login, uu.statut as user_statut, uu.photo as user_photo, ua.lastname as validator_lastname, ua.firstname as validator_firstname, ua.login as validator_login, ua.statut as validator_statut, ua.photo as validator_photo FROM llx_holiday as cp, llx_user as uu, llx_user as ua WHERE cp.entity IN (1) AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid AND cp.fk_user IN (1) 2019-07-30 12:29:05 INFO 37.171.173.2 num_open_day timestampStart=1561939200 timestampEnd=1564444800 bit=1 country_code=FR 2019-07-30 12:29:05 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:29:06 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:29:06 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:29:06 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:29:06 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:29:06 INFO 37.171.173.2 --- Access to /holiday/card.php - action=request, massaction= 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:29:06 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=hrm myleftmenu=holiday type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:29:06 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:29:06 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:29:06 DEBUG 37.171.173.2 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) 2019-07-30 12:29:06 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:29:06 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:29:06 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:29:06 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:29:06 DEBUG 37.171.173.2 Holiday::getConfCP name=delayForRequest createifnotfound= 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT value FROM llx_holiday_config WHERE name = 'delayForRequest' 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 AND affect = 1 2019-07-30 12:29:06 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 4 2019-07-30 12:29:06 DEBUG 37.171.173.2 Holiday::getCPforUser 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT nb_holiday FROM llx_holiday_users WHERE fk_user = '1' AND fk_type = 5 2019-07-30 12:29:06 DEBUG 37.171.173.2 Form::select_dolusers 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) AND employee = 1 ORDER BY u.firstname ASC 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT rowid, code, label, affect, delay, newByMonth FROM llx_c_holiday_types WHERE (fk_country IS NULL OR fk_country = 1) AND active = 1 2019-07-30 12:29:06 INFO 37.171.173.2 Holiday::fetch_users_approver_holiday sql=SELECT DISTINCT ur.fk_user FROM llx_user_rights as ur, llx_rights_def as rd WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'UNION SELECT DISTINCT ugu.fk_user FROM llx_usergroup_user as ugu, llx_usergroup_rights as ur, llx_rights_def as rd WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve' 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT DISTINCT ur.fk_user FROM llx_user_rights as ur, llx_rights_def as rd WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'UNION SELECT DISTINCT ugu.fk_user FROM llx_usergroup_user as ugu, llx_usergroup_rights as ur, llx_rights_def as rd WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve' 2019-07-30 12:29:06 DEBUG 37.171.173.2 Form::select_dolusers 2019-07-30 12:29:06 DEBUG 37.171.173.2 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) AND u.rowid IN (1) ORDER BY u.firstname ASC 2019-07-30 12:29:06 INFO 37.171.173.2 DolEditor::DolEditor htmlname=description width= height=80 toolbarname=dolibarr_notes 2019-07-30 12:29:06 INFO 37.171.173.2 --- End access to /holiday/card.php 2019-07-30 12:32:33 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:32:33 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:32:33 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:32:33 INFO 37.171.173.2 --- Access to /index.php - action=, massaction= 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:32:33 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:32:33 DEBUG 37.171.173.2 InfoBox::listBoxes get default box list for mode=activated userid= 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user = 0 ORDER BY b.box_order 2019-07-30 12:32:33 INFO 37.171.173.2 box_lastlogin::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT f.rowid as facid, f.ref, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.datef as df, f.paye, f.fk_statut, f.datec, f.tms, s.rowid as socid, s.nom as name, s.code_client, s.email, s.tva_intra, s.code_compta, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, f.date_lim_reglement as datelimite FROM (llx_societe as s,llx_facture as f) WHERE f.fk_soc = s.rowid AND f.entity IN (1) ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_factures::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.ref, f.date_lim_reglement as datelimite, f.type, f.amount, f.datef as df, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.rowid as facid, sum(pf.amount) as am FROM llx_societe as s, llx_facture as f LEFT JOIN llx_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.code_client, s.logo, f.ref, f.date_lim_reglement, f.type, f.amount, f.datef, f.total, f.tva, f.total_ttc, f.paye, f.fk_statut, f.rowid ORDER BY datelimite ASC, f.ref ASC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_factures_imp::showBox 2019-07-30 12:32:33 INFO 37.171.173.2 FactureStats::getAllByProductEntry read data from cache file /home/signaltech/DoliTest/dolibarr-8.0.4/documents/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache 1564488333. 2019-07-30 12:32:33 INFO 37.171.173.2 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2019-07-30 12:32:33 INFO 37.171.173.2 box_graph_product_distribution::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT p.rowid, p.label, p.ref, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.fk_price_expression, p.entity FROM llx_product as p WHERE p.entity IN (1) AND p.fk_product_type != 1 ORDER BY p.datec DESC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_produits::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 box_comptes::loadBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT b.rowid, b.ref, b.label, b.bank,b.number, b.courant, b.clos, b.rappro, b.url, b.code_banque, b.code_guichet, b.cle_rib, b.bic, b.iban_prefix as iban, b.domiciliation, b.proprio, b.owner_address, b.account_number, b.currency_code, b.min_allowed, b.min_desired, comment, b.fk_accountancy_journal, aj.code as accountancy_journal FROM llx_bank_account as b LEFT JOIN llx_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_comptes::showBox 2019-07-30 12:32:33 INFO 37.171.173.2 ModeleBoxes::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT sp.rowid as id, sp.lastname, sp.firstname, sp.civility as civility_id, sp.datec, sp.tms, sp.fk_soc, sp.statut as status, sp.address, sp.zip, sp.town, sp.phone, sp.phone_perso, sp.phone_mobile, s.nom as socname, s.name_alias, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llx_socpeople as sp LEFT JOIN llx_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_contacts::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 box_prospect::loadBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.logo, s.fk_stcomm, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_prospect::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 box_clients::loadBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.code_compta, s.code_compta_fournisseur, s.logo, s.email, s.datec, s.tms, s.status FROM llx_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_clients::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 box_birthdays::loadBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.firstname, u.lastname, u.birth FROM llx_user as u WHERE u.entity IN (0,1) AND MONTH(u.birth) = 07 ORDER BY u.birth ASC LIMIT 5 2019-07-30 12:32:33 INFO 37.171.173.2 box_birthdays::showBox 2019-07-30 12:32:33 INFO 37.171.173.2 FactureStats::getNbByMonthWithPrevYear read data from cache file /home/signaltech/DoliTest/dolibarr-8.0.4/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1564488333. 2019-07-30 12:32:33 INFO 37.171.173.2 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-07-30 12:32:33 INFO 37.171.173.2 FactureStats::getAmountByMonthWithPrevYear read data from cache file /home/signaltech/DoliTest/dolibarr-8.0.4/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1564488333. 2019-07-30 12:32:33 INFO 37.171.173.2 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-07-30 12:32:33 INFO 37.171.173.2 box_graph_invoices_permonth::showBox 2019-07-30 12:32:33 INFO 37.171.173.2 ModeleBoxes::showBox 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(u.rowid) as nb FROM llx_user as u WHERE u.statut > 0 AND u.entity IN (0,1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(s.rowid) as nb, s.client FROM llx_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(sp.rowid) as nb FROM llx_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat=1)) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(f.rowid) as nb FROM llx_facture as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity IN (1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(ex.rowid) as nb FROM llx_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT count(h.rowid) as nb FROM llx_holiday as h WHERE h.statut > 1 AND h.entity IN (1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut, f.total FROM llx_facture as f WHERE f.paye=0 AND f.entity IN (1) AND f.fk_statut = 1 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT COUNT(ba.rowid) as nb FROM llx_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.fk_type = 'CHQ' AND b.fk_bordereau = 0 AND b.amount > 0 2019-07-30 12:32:33 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:32:33 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:32:33 DEBUG 37.171.173.2 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) 2019-07-30 12:32:33 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:32:33 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:32:33 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:32:33 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1)) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1)) 2019-07-30 12:32:33 DEBUG 37.171.173.2 sql=SELECT h.rowid, h.date_debut FROM llx_holiday as h WHERE h.statut = 2 AND h.entity IN (1) AND (h.fk_user IN (1) OR h.fk_validator IN (1)) 2019-07-30 12:32:33 INFO 37.171.173.2 --- End access to /index.php 2019-07-30 12:32:39 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:32:39 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:32:39 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:32:39 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:32:39 INFO 37.171.173.2 --- Access to /admin/index.php - action=, massaction= 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:32:39 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:32:39 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:32:39 INFO 37.171.173.2 --- End access to /admin/index.php 2019-07-30 12:32:44 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:32:44 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:32:44 INFO 37.171.173.2 --- Access to /admin/modules.php - action=, massaction= 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:32:44 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:32:44 INFO 37.171.173.2 Scan directory /home/signaltech/DoliTest/dolibarr-8.0.4/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2019-07-30 12:32:44 INFO 37.171.173.2 Module modLabel not qualified 2019-07-30 12:32:44 INFO 37.171.173.2 Module modWebServicesClient not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 useNPR 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 useNPR 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-07-30 12:32:44 INFO 37.171.173.2 Module modCollab not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-07-30 12:32:44 INFO 37.171.173.2 Module modDynamicPrices not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 INFO 37.171.173.2 Module modReception not qualified 2019-07-30 12:32:44 INFO 37.171.173.2 Module modDocumentGeneration not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-07-30 12:32:44 INFO 37.171.173.2 Module modBom not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2019-07-30 12:32:44 INFO 37.171.173.2 Module Blockedlog alreadyUsed with ignoresystem=1 is 2019-07-30 12:32:44 INFO 37.171.173.2 Module modAsset not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 User::loadParentOf 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 User::get_full_tree get user list 2019-07-30 12:32:44 DEBUG 37.171.173.2 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) 2019-07-30 12:32:44 DEBUG 37.171.173.2 User::get_full_tree call to build_path_from_id_user 2019-07-30 12:32:44 DEBUG 37.171.173.2 User::build_path_from_id_user id_user=1 protection=0 2019-07-30 12:32:44 DEBUG 37.171.173.2 User::get_full_tree dol_sort_array 2019-07-30 12:32:44 INFO 37.171.173.2 Build childid for id = 1 2019-07-30 12:32:44 INFO 37.171.173.2 Module modDeplacement not qualified 2019-07-30 12:32:44 INFO 37.171.173.2 Module modDataPolicy not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-07-30 12:32:44 DEBUG 37.171.173.2 useNPR 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 useNPR 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 useNPR 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-07-30 12:32:44 DEBUG 37.171.173.2 useLocalTax 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-07-30 12:32:44 INFO 37.171.173.2 Module modReceiptPrinter not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-07-30 12:32:44 INFO 37.171.173.2 Module modHRM not qualified 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 2019-07-30 12:32:44 DEBUG 37.171.173.2 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 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-07-30 12:32:44 DEBUG 37.171.173.2 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2019-07-30 12:32:44 INFO 37.171.173.2 Module Blockedlog alreadyUsed with ignoresystem=1 is 2019-07-30 12:32:44 INFO 37.171.173.2 --- End access to /admin/modules.php 2019-07-30 12:32:52 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:32:52 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:32:52 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:32:52 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:32:52 INFO 37.171.173.2 --- Access to /admin/syslog.php - action=, massaction= 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:32:52 DEBUG 37.171.173.2 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 2019-07-30 12:32:52 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-07-30 12:32:52 DEBUG 37.171.173.2 admin.lib::dolibarr_get_const 2019-07-30 12:32:52 DEBUG 37.171.173.2 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-07-30 12:32:52 INFO 37.171.173.2 --- End access to /admin/syslog.php 2019-07-30 12:32:59 DEBUG 37.171.173.2 - This is an already logged session. _SESSION['dol_login']=altinfo _SESSION['dol_entity']=1 2019-07-30 12:32:59 DEBUG 37.171.173.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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.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_int, 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 IN (0, 1) AND u.login = 'altinfo' ORDER BY u.entity ASC 2019-07-30 12:32:59 INFO 37.171.173.2 fetch_name_optionals_label elementtype=user 2019-07-30 12:32:59 DEBUG 37.171.173.2 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2019-07-30 12:32:59 DEBUG 37.171.173.2 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-07-30 12:32:59 DEBUG 37.171.173.2 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-07-30 12:32:59 DEBUG 37.171.173.2 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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-07-30 12:32:59 DEBUG 37.171.173.2 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-07-30 12:32:59 INFO 37.171.173.2 --- Access to /document.php - action=, massaction= 2019-07-30 12:32:59 DEBUG 37.171.173.2 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2019-07-30 12:32:59 INFO 37.171.173.2 modulepart=logs original_file=dolibarr.log entity=1 2019-07-30 12:32:59 INFO 37.171.173.2 document.php download /home/signaltech/DoliTest/dolibarr-8.0.4/documents/dolibarr.log filename=dolibarr.log content-type=text/plain