2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 - This is an already logged session. _SESSION['dol_login']=Jbeteau _SESSION['dol_entity']=1 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_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.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.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 = 'Jbeteau' ORDER BY u.entity ASC 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 fetch_name_optionals_label elementtype=user 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 --- Access to /admin/modules.php - action=, massaction= 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modDocumentGeneration not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::loadParentOf 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree get user list 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree call to build_path_from_id_user 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=1 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=2 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=3 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=4 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=5 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=6 protection=0 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree dol_sort_array 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Build childid for id = 1 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modDeplacement not qualified 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modReceiptPrinter not qualified 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modLabel not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modAsset not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modDataPolicy not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modCollab not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modHRM not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Module modDocument not qualified 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/google/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/abricot/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/agefodd/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'agefodd_formation_catalogue' 2019-06-04 14:18:12 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'agefodd_session' 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/sendinblue/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/advtargetemailing/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:12 INFO 86.206.139.13->86.206.139.13 --- End access to /admin/modules.php 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 - This is an already logged session. _SESSION['dol_login']=Jbeteau _SESSION['dol_entity']=1 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_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.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.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 = 'Jbeteau' ORDER BY u.entity ASC 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 fetch_name_optionals_label elementtype=user 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 --- Access to /admin/modules.php - action=, massaction= 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modDocumentGeneration not qualified 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::loadParentOf 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree get user list 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree call to build_path_from_id_user 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=1 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=2 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=3 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=4 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=5 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=6 protection=0 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree dol_sort_array 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Build childid for id = 1 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modDeplacement not qualified 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modReceiptPrinter not qualified 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modLabel not qualified 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modAsset not qualified 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modDataPolicy not qualified 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 INFO 86.206.139.13->86.206.139.13 Module modCollab not qualified 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:35 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Module modHRM not qualified 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useNPR 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 useLocalTax 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Module modDocument not qualified 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/google/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/abricot/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/agefodd/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'agefodd_formation_catalogue' 2019-06-04 14:18:36 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'agefodd_session' 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/sendinblue/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Scan directory /srv/data/web/vhosts/crm.zenessor.fr/htdocs/custom/advtargetemailing/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 Save lastsearch_values_tmp_admin/modules.php={"search_status":"-1","search_nature":"-1","search_version":"-1"} (systematic recording of last search criterias) 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 --- End access to /admin/modules.php 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 --- Access to /viewimage.php - action=, massaction= 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 modulepart=mycompany original_file=logos/thumbs/logo-zenessor_mini.png entity=1 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 viewimage.php return file /srv/data/web/vhosts/crm.zenessor.fr/documents/mycompany/logos/thumbs/logo-zenessor_mini.png filename=logo-zenessor_mini.png content-type=image/png 2019-06-04 14:18:36 INFO 86.206.139.13->86.206.139.13 --- End access to /viewimage.php 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 - This is an already logged session. _SESSION['dol_login']=Jbeteau _SESSION['dol_entity']=1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_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.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.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 = 'Jbeteau' ORDER BY u.entity ASC 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 fetch_name_optionals_label elementtype=user 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 --- Access to /index.php - action=, massaction= 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 InfoBox::listBoxes get default box list for mode=activated userid=1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 IN (0,1) ORDER BY b.box_order 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 box_prospect::loadBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 10 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 box_prospect::showBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 10 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 box_contacts::showBox 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 ModeleBoxes::showBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT p.rowid, p.ref, p.title, p.fk_statut, p.public FROM llx_projet as p WHERE p.fk_statut = 1 ORDER BY p.datec DESC 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 28 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(*) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 24 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 box_project::showBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, p.rowid, p.ref, p.fk_statut, p.datep as dp, p.datec, p.fin_validite, p.date_cloture, p.total_ht, p.tva as total_tva, p.total as total_ttc, p.tms FROM llx_societe as s, llx_propal as p WHERE p.fk_soc = s.rowid AND p.entity = 1 ORDER BY p.tms DESC, p.ref DESC LIMIT 10 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 Translate::loadCacheCurrencies 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 box_propales::showBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 box_clients::loadBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 10 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 box_clients::showBox 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 ModeleBoxes::showBox 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(u.rowid) as nb FROM llx_user as u WHERE u.statut > 0 AND u.entity IN (0,1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(s.rowid) as nb FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(p.rowid) as nb FROM llx_propal as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(c.rowid) as nb FROM llx_contrat as c LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(fi.rowid) as nb FROM llx_fichinter as fi LEFT JOIN llx_societe as s ON fi.fk_soc = s.rowid WHERE fi.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(co.rowid) as nb FROM llx_commande_fournisseur as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(f.rowid) as nb FROM llx_facture_fourn as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(p.rowid) as nb FROM llx_projet as p WHERE p.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT count(ex.rowid) as nb FROM llx_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT a.id, a.datep as dp FROM llx_actioncomm as a LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee FROM (llx_projet as p) LEFT JOIN llx_societe as s on p.fk_soc = s.rowid WHERE p.fk_statut = 1 AND p.entity IN (1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = 'project' AND ctc.source = 'internal' 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT DISTINCT p.rowid, p.ref FROM llx_projet as p, llx_element_contact as ec WHERE p.entity IN (1) AND ec.element_id = p.rowid AND ( p.public = 1 OR ( ec.fk_c_type_contact IN (161,160) AND ec.fk_socpeople = 1) ) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT p.rowid as projectid, p.fk_statut as projectstatus, t.rowid as taskid, t.progress as progress, t.fk_statut as status, t.dateo as date_start, t.datee as datee FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid, llx_projet_task as t WHERE p.entity IN (1) AND p.fk_statut = 1 AND t.fk_projet = p.rowid AND t.progress < 100 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT cd.rowid, cd.date_ouverture_prevue as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 0 AND c.fk_soc = s.rowid AND c.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT cd.rowid, cd.date_fin_validite as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 4 AND c.fk_soc = s.rowid AND c.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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 = 1 AND f.fk_statut = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM llx_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::loadParentOf 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree get user list 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree call to build_path_from_id_user 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=1 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=2 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=3 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=4 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=5 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::build_path_from_id_user id_user=6 protection=0 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 User::get_full_tree dol_sort_array 2019-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 Build childid for id = 1 2019-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:06 INFO 86.206.139.13->86.206.139.13 --- End access to /index.php 2019-06-04 14:25:07 INFO 86.206.139.13->86.206.139.13 --- Access to /core/js/lib_head.js.php - action=, massaction= 2019-06-04 14:25:07 DEBUG 86.206.139.13->86.206.139.13 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-06-04 14:25:07 INFO 86.206.139.13->86.206.139.13 --- End access to /core/js/lib_head.js.php