2019-06-21 05:27:17 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:17 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 INFO 196.121.5.210 --- Access to /gest/htdocs/admin/modules.php - action=, massaction= 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context adminmodules: actions_myfield.class.php 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context globaladmin: actions_myfield.class.php 2019-06-21 05:27:17 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%adminmodules%' OR context like '%globaladmin%' OR context like '%main%' ) AND typefield =3 ORDER BY context, label 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:17 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:17 INFO 196.121.5.210 Scan directory /home2/khaled/klkindustry/gest/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modEmailCollector not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modCollab not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modDynamicPrices not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Module modWebServicesClient not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modLabel not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Module modReceiptPrinter not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Module modDocumentGeneration not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Module modHRM not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0,1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modTicket not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modDataPolicy not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 INFO 196.121.5.210 Module modAsset not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Module modTakePos not qualified 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:17 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 User::loadParentOf 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 User::get_full_tree get user list 2019-06-21 05:27:17 DEBUG 196.121.5.210 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-21 05:27:17 DEBUG 196.121.5.210 User::get_full_tree call to build_path_from_id_user 2019-06-21 05:27:17 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=1 protection=0 2019-06-21 05:27:17 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=2 protection=0 2019-06-21 05:27:17 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=3 protection=0 2019-06-21 05:27:17 DEBUG 196.121.5.210 User::get_full_tree dol_sort_array 2019-06-21 05:27:17 INFO 196.121.5.210 Build childid for id = 1 2019-06-21 05:27:17 INFO 196.121.5.210 Module modDeplacement not qualified 2019-06-21 05:27:17 INFO 196.121.5.210 Scan directory /home2/khaled/klkindustry/gest/htdocs/numberwords/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-21 05:27:17 INFO 196.121.5.210 Scan directory /home2/khaled/klkindustry/gest/htdocs/myfield/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT rowid FROM llx_menu WHERE mainmenu ='patastools' AND type = 'top' AND entity = 1 2019-06-21 05:27:17 INFO 196.121.5.210 Scan directory /home2/khaled/klkindustry/gest/htdocs/showprice/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-21 05:27:17 INFO 196.121.5.210 Scan directory /home2/khaled/klkindustry/gest/htdocs/infraspack/core/modules/ for module descriptor files (modXXX.class.php) 2019-06-21 05:27:17 DEBUG 196.121.5.210 BEGIN Transaction 2019-06-21 05:27:17 DEBUG 196.121.5.210 admin.lib::dolibarr_set_const 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=DELETE FROM llx_const WHERE name = 'INFRAS_PHP_EXT_XML' AND entity = 1 2019-06-21 05:27:17 DEBUG 196.121.5.210 admin.lib::dolibarr_set_const 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=INSERT INTO llx_const(name,value,type,visible,note,entity) VALUES ('INFRAS_PHP_EXT_XML', '1','chaine',0,'',1) 2019-06-21 05:27:17 DEBUG 196.121.5.210 COMMIT Transaction 2019-06-21 05:27:17 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printTabsHead of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%main%' ) AND typefield =1 ORDER BY context, label 2019-06-21 05:27:17 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%userdao%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%adminmodules%' OR context like '%globaladmin%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:18 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:18 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%userdao%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%adminmodules%' OR context like '%globaladmin%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:18 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:18 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:18 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:18 INFO 196.121.5.210 --- End access to /gest/htdocs/admin/modules.php 2019-06-21 05:27:22 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:22 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:22 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:22 DEBUG 196.121.5.210 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-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:22 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:22 DEBUG 196.121.5.210 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-21 05:27:22 DEBUG 196.121.5.210 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-21 05:27:22 INFO 196.121.5.210 --- Access to /gest/htdocs/admin/syslog.php - action=, massaction= 2019-06-21 05:27:22 DEBUG 196.121.5.210 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-21 05:27:22 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:22 DEBUG 196.121.5.210 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-21 05:27:22 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:22 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:22 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:22 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:22 DEBUG 196.121.5.210 admin.lib::dolibarr_get_const 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-06-21 05:27:22 DEBUG 196.121.5.210 admin.lib::dolibarr_get_const 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-06-21 05:27:22 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%userdao%' OR context like '%toprightmenu%' OR context like '%main%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:22 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:22 INFO 196.121.5.210 --- End access to /gest/htdocs/admin/syslog.php 2019-06-21 05:27:40 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:40 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:40 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 INFO 196.121.5.210 --- Access to /gest/htdocs/index.php - action=, massaction= 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context index: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:40 DEBUG 196.121.5.210 InfoBox::listBoxes get default box list for mode=activated userid= 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-06-21 05:27:40 INFO 196.121.5.210 box_lastlogin::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.logo FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_fournisseurs::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, f.rowid as facid, f.ref, f.ref_supplier, f.date_lim_reglement as datelimite, f.amount, f.datef as df, f.total_ht as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.type FROM llx_societe as s,llx_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye=0 AND fk_statut = 1 ORDER BY datelimite DESC, f.ref_supplier DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_factures_fourn_imp::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.code_fournisseur, s.logo, f.rowid as facid, f.ref, f.ref_supplier, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut, f.datef as df, f.datec as datec, f.date_lim_reglement as datelimite, f.tms, f.type FROM llx_societe as s, llx_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_factures_fourn::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_supplier_orders::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.facnumber, 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 = 1 AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.code_client, s.logo, f.facnumber, 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.facnumber ASC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_factures_imp::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT f.rowid as facid, f.facnumber, 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 = 1 ORDER BY f.tms DESC, f.facnumber DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_factures::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 FactureStats::getNbByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 FactureStats::getAmountByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_invoices_permonth::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 box_comptes::loadBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 3 2019-06-21 05:27:40 DEBUG 196.121.5.210 Translate::loadCacheCurrencies 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'MAD' 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 1 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 2 2019-06-21 05:27:40 INFO 196.121.5.210 box_comptes::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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) ORDER BY p.datec DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/VB6_25/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context fileslib: actions_myfield.class.php 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/VB6_25' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context productdao: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/VB5_22_3D/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/VB5_22_3D' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/VB4_17_3D/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/VB4_17_3D' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/TBP6_28/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/TBP6_28' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/TBP6_17/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/TBP6_17' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 box_produits::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT p.rowid, p.label, p.price, p.ref, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity, SUM(IF(s.reel IS NULL,0,s.reel)) as total_stock FROM llx_product as p LEFT JOIN llx_product_stock as s on p.rowid = s.fk_product WHERE p.entity IN (1) AND p.tosell = 1 AND p.seuil_stock_alerte > 0 GROUP BY p.rowid, p.ref, p.label, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.seuil_stock_alerte, p.entity HAVING SUM(IF(s.reel IS NULL,0,s.reel)) < p.seuil_stock_alerte ORDER BY p.seuil_stock_alerte DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/HB3_10/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/HB3_10' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/TBP2.5_12/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/TBP2.5_12' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/FFB3_15_3D/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/FFB3_15_3D' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/HB3_22/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/HB3_22' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/produit/TBP3_32/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/TBP3_32' AND entity = 1 2019-06-21 05:27:40 INFO 196.121.5.210 box_produits_alerte_stock::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 FactureStats::getAllByProductEntry read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2019-06-21 05:27:40 INFO 196.121.5.210 PropaleStats::getAllByProductEntry read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/PropaleStats_getAllByProductEntry_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2019-06-21 05:27:40 INFO 196.121.5.210 CommandeStats::getAllByProductEntry read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/CommandeStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type=pie this->MaxValue=2 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_product_distribution::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 CommandeStats::getNbByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_orders_supplier_permonth::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 ModeleBoxes::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 FactureStats::getNbByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 FactureStats::getAmountByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_invoices_supplier_permonth::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 box_ficheinter::loadBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT f.rowid, f.ref, f.fk_soc, f.fk_statut, f.datec, f.date_valid as datev, f.tms as datem, s.nom as name, s.rowid as socid, s.client FROM llx_societe as s, llx_fichinter as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_ficheinter::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 box_clients::loadBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-06-21 05:27:40 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context thirdpartydao: actions_myfield.class.php 2019-06-21 05:27:40 INFO 196.121.5.210 box_clients::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 box_prospect::loadBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-06-21 05:27:40 INFO 196.121.5.210 box_prospect::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-06-21 05:27:40 INFO 196.121.5.210 box_contacts::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 PropaleStats::getNbByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/PropaleStats_getNbByMonthWithPrevYear_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 PropaleStats::getAmountByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/PropaleStats_getAmountByMonthWithPrevYear_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type=bars,bars this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_propales_permonth::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 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 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_propales::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, c.ref, c.tms, c.rowid, c.date_commande, c.ref_client, c.fk_statut, c.fk_user_valid, c.facture, c.total_ht, c.tva as total_tva, c.total_ttc FROM llx_societe as s, llx_commande as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_commandes::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 CommandeStats::getNbByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /home2/khaled/klkindustry/gest/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1561050030. 2019-06-21 05:27:40 INFO 196.121.5.210 DolGraph::draw_jflot this->type= this->MaxValue=0 2019-06-21 05:27:40 INFO 196.121.5.210 box_graph_orders_permonth::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.datec, c.fin_validite, c.date_cloture FROM llx_societe as s, llx_contrat as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_contracts::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT c.rowid, c.ref, c.statut as fk_statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, MIN(cd.date_fin_validite) as date_line, COUNT(cd.rowid) as nb_services FROM llx_contrat as c, llx_societe s, llx_contratdet as cd WHERE cd.statut = 4 AND cd.date_fin_validite <= '2019-06-21 05:27:40' AND c.entity = 1 AND c.fk_soc=s.rowid AND cd.fk_contrat=c.rowid AND c.statut > 0 GROUP BY c.rowid, c.ref, c.statut, c.date_contrat, c.ref_customer, c.ref_supplier, s.nom, s.rowid ORDER BY date_line ASC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_services_expired::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, c.rowid, c.ref, c.statut as contract_status, c.ref_customer, c.ref_supplier, cd.rowid as cdid, cd.label, cd.description, cd.tms as datem, cd.statut, cd.product_type as type, p.rowid as product_id, p.ref as product_ref, p.label as plabel, p.fk_product_type as ptype, p.entity FROM (llx_societe as s INNER JOIN llx_contrat as c ON s.rowid = c.fk_soc INNER JOIN llx_contratdet as cd ON c.rowid = cd.fk_contrat LEFT JOIN llx_product as p ON cd.fk_product = p.rowid) WHERE c.entity = 1 ORDER BY c.tms DESC LIMIT 5 2019-06-21 05:27:40 INFO 196.121.5.210 box_services_contracts::showBox 2019-06-21 05:27:40 INFO 196.121.5.210 ModeleBoxes::showBox 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT count(u.rowid) as nb FROM llx_user as u WHERE u.statut > 0 AND u.entity IN (0,1) 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT count(s.rowid) as nb FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT count(co.rowid) as nb FROM llx_commande as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1) 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT count(p.rowid) as nb FROM llx_supplier_proposal as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1) 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT p.rowid, p.ref, p.datec as datec FROM llx_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 1 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT p.rowid, p.ref, p.datec as datec FROM llx_supplier_proposal as p WHERE p.entity IN (1) AND p.fk_statut = 2 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht FROM llx_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0)) 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0 2019-06-21 05:27:40 DEBUG 196.121.5.210 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-21 05:27:40 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%thirdpartydao%' OR context like '%productdao%' OR context like '%fileslib%' OR context like '%userdao%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%index%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:40 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:40 INFO 196.121.5.210 --- End access to /gest/htdocs/index.php 2019-06-21 05:27:45 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:45 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:45 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:45 DEBUG 196.121.5.210 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-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:45 DEBUG 196.121.5.210 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-21 05:27:45 DEBUG 196.121.5.210 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-21 05:27:45 INFO 196.121.5.210 --- Access to /gest/htdocs/user/home.php - action=, massaction= 2019-06-21 05:27:45 DEBUG 196.121.5.210 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-21 05:27:45 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=users type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:45 DEBUG 196.121.5.210 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-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userhome: actions_myfield.class.php 2019-06-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:45 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT DISTINCT u.rowid, u.lastname, u.firstname, u.admin, u.login, u.fk_soc, u.datec, u.statut, u.entity, u.ldap_sid, u.photo, u.admin, u.email, u.skype, s.nom as name, s.code_client, s.canvas FROM llx_user as u LEFT JOIN llx_societe as s ON u.fk_soc = s.rowid WHERE u.entity IN (0,1) ORDER BY u.datec DESC LIMIT 10 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT g.rowid, g.nom as name, g.note, g.entity, g.datec FROM llx_usergroup as g WHERE g.entity IN (0,1) ORDER BY g.datec DESC LIMIT 5 2019-06-21 05:27:45 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%userdao%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%userhome%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:45 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:45 INFO 196.121.5.210 --- End access to /gest/htdocs/user/home.php 2019-06-21 05:27:50 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:50 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:50 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:50 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:50 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 INFO 196.121.5.210 --- Access to /gest/htdocs/user/card.php - action=, massaction= 2019-06-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=users type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:50 DEBUG 196.121.5.210 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-21 05:27:50 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context usercard: actions_myfield.class.php 2019-06-21 05:27:50 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context globalcard: actions_myfield.class.php 2019-06-21 05:27:50 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:50 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%usercard%' OR context like '%globalcard%' OR context like '%main%' ) AND typefield =3 ORDER BY context, label 2019-06-21 05:27:50 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:51 DEBUG 196.121.5.210 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2019-06-21 05:27:51 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:51 DEBUG 196.121.5.210 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-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:51 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:51 DEBUG 196.121.5.210 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-21 05:27:51 DEBUG 196.121.5.210 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-21 05:27:51 DEBUG 196.121.5.210 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-21 05:27:51 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/users/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context fileslib: actions_myfield.class.php 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'user' AND objectid = 1 AND entity = 1 2019-06-21 05:27:51 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printTabsHead of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%main%' ) AND typefield =1 ORDER BY context, label 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%fileslib%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%userdao%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%usercard%' OR context like '%globalcard%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT MAX(te.rowid) FROM llx_user as te WHERE te.rowid < '1' AND te.entity IN (0,1) 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT MIN(te.rowid) FROM llx_user as te WHERE te.rowid > '1' AND te.entity IN (0,1) 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_user as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_user = 1 AND c.type = 7 AND c.entity IN (1) 2019-06-21 05:27:51 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:51 DEBUG 196.121.5.210 UserGroup::listGroupsForUser 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT g.rowid, ug.entity as usergroup_entity FROM llx_usergroup as g, llx_usergroup_user as ug WHERE ug.fk_usergroup = g.rowid AND ug.fk_user = 1 AND g.entity IN (0,1) ORDER BY g.nom 2019-06-21 05:27:51 DEBUG 196.121.5.210 Form::select_dolgroups 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT ug.rowid, ug.nom as name FROM llx_usergroup as ug WHERE ug.entity IN (0,1) ORDER BY ug.nom ASC 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context formfile: actions_myfield.class.php 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context formfile: actions_infraspack.class.php 2019-06-21 05:27:51 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/users/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2019-06-21 05:27:51 DEBUG 196.121.5.210 /core/lib/function2.lib.php::getListOfModels 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'user' AND entity IN (0,1) ORDER BY description DESC 2019-06-21 05:27:51 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class Actionsinfraspack, module=infraspack, action= context=formfile 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SHOW COLUMNS FROM llx_societe_address LIKE "email" 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SHOW COLUMNS FROM llx_societe_address LIKE "url" 2019-06-21 05:27:51 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context commonobject: actions_myfield.class.php 2019-06-21 05:27:51 DEBUG 196.121.5.210 User::fetchObjectLink 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 1 AND sourcetype = 'user') OR (fk_target = 1 AND targettype = 'user') ORDER BY sourcetype 2019-06-21 05:27:51 DEBUG 196.121.5.210 ActionComm::getActions 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1 AND a.elementtype = 'user' ORDER BY a.datep DESC, a.id DESC 2019-06-21 05:27:51 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%commonobject%' OR context like '%fileslib%' OR context like '%formfile%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%userdao%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%usercard%' OR context like '%globalcard%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:51 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:51 INFO 196.121.5.210 --- End access to /gest/htdocs/user/card.php 2019-06-21 05:27:55 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:27:55 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 INFO 196.121.5.210 --- Access to /gest/htdocs/user/perms.php - action=, massaction= 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=users type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_user as dbt WHERE dbt.rowid IN (1) AND dbt.entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2019-06-21 05:27:55 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context usercard: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userperms: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context globalcard: actions_myfield.class.php 2019-06-21 05:27:55 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%usercard%' OR context like '%userperms%' OR context like '%globalcard%' OR context like '%main%' ) AND typefield =3 ORDER BY context, label 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:27:55 INFO 196.121.5.210 files.lib.php::dol_dir_list path=/home2/khaled/klkindustry/gest/documents/users/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-06-21 05:27:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context fileslib: actions_myfield.class.php 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'user' AND objectid = 1 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printTabsHead of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%main%' ) AND typefield =1 ORDER BY context, label 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%fileslib%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%userdao%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%usercard%' OR context like '%userperms%' OR context like '%globalcard%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:55 DEBUG 196.121.5.210 BEGIN Transaction 2019-06-21 05:27:55 DEBUG 196.121.5.210 modEmailCollector::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EMAILCOLLECTOR' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modMultiCurrency::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MULTICURRENCY' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modPaypal::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PAYPAL' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modSupplierProposal::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SUPPLIERPROPOSAL' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1121 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1122 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1123 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1124 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1125 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1126 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modCron::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CRON' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modExternalSite::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXTERNALSITE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' 2019-06-21 05:27:55 DEBUG 196.121.5.210 modCategorie::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CATEGORIE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 241 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 242 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 243 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modExternalRss::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXTERNALRSS' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modVariants::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_VARIANTS' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modStock::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_STOCK' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1001 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1002 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1003 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1004 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1005 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modCollab::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COLLAB' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDon::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DON' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modSalaries::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SALARIES' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 511 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 512 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 514 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 517 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modStripe::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_STRIPE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modClickToDial::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CLICKTODIAL' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modExpedition::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPEDITION' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 101 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 102 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 104 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 105 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 106 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 109 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1101 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1102 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1104 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1109 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modFTP::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FTP' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modWebsite::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSITE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modNotification::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_NOTIFICATION' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modPrinting::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRINTING' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDynamicPrices::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DYNAMICPRICES' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modBookmark::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BOOKMARK' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modMargin::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MARGIN' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 59001 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 59002 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 59003 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modBlockedLog::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BLOCKEDLOG' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modContrat::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CONTRAT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 161 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 162 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 163 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 164 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 165 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 167 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modWebServicesClient::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSERVICESCLIENT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modApi::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_API' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modIncoterm::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_INCOTERM' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modComptabilite::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COMPTABILITE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modResource::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RESOURCE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modMailing::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MAILING' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modWebServices::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WEBSERVICES' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modExpenseReport::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPENSEREPORT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modFckeditor::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FCKEDITOR' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modAccounting::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ACCOUNTING' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modLabel::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LABEL' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modECM::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ECM' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modReceiptPrinter::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_RECEIPTPRINTER' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modMailmanSpip::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MAILMANSPIP' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modGeoIPMaxmind::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_GEOIPMAXMIND' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modImport::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_IMPORT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modWorkflow::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_WORKFLOW' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDocumentGeneration::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DOCUMENTGENERATION' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modHRM::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_HRM' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modCommande::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_COMMANDE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 81 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 82 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 84 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 86 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 87 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 88 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 89 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1421 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modProductBatch::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRODUCTBATCH' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modLdap::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LDAP' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modSociete::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SOCIETE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 121 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 122 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 125 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 126 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 262 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 281 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 282 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 283 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 286 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-06-21 05:27:55 DEBUG 196.121.5.210 modFournisseur::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FOURNISSEUR' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1181 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1182 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1183 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1184 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1185 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1186 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1187 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1189 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1188 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1191 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1231 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1232 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1233 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1234 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1235 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1236 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modHoliday::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_HOLIDAY' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modOauth::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_OAUTH' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modAdherent::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ADHERENT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modTicket::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TICKET' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modFacture::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FACTURE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 11 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 12 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 13 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 14 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 15 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 16 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 19 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1321 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1322 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDataPolicy::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DATAPOLICY' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modFicheinter::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_FICHEINTER' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 61 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 62 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 64 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 67 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 68 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 69 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 70 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modPayBox::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PAYBOX' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modPropale::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PROPALE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 21 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 22 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 24 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 25 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 26 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 27 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 28 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modExport::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_EXPORT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDav::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DAV' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modAsset::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_ASSET' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modOpenSurvey::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_OPENSURVEY' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modTakePos::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TAKEPOS' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modCashDesk::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_CASHDESK' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modUser::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_USER' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 251 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 252 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 253 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 254 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 255 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 256 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 341 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 342 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 343 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 344 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 351 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 352 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 353 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 354 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 358 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modBanque::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BANQUE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 111 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 112 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 113 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 114 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 115 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 116 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 117 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modProjet::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PROJET' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modGravatar::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_GRAVATAR' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modBarcode::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_BARCODE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modLoan::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_LOAN' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modPrelevement::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRELEVEMENT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2019-06-21 05:27:55 DEBUG 196.121.5.210 modAgenda::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_AGENDA' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modProduct::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_PRODUCT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 31 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 32 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 34 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 38 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 39 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 useNPR 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'MA' AND t.active = 1 AND t.recuperableonly = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax1_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 useLocalTax 2019-06-21 05:27:55 DEBUG 196.121.5.210 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 = 'MA' AND t.active = 1 AND t.localtax2_type <> '0' 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modService::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SERVICE' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 531 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 532 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 534 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 538 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 User::loadParentOf 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 User::get_full_tree get user list 2019-06-21 05:27:55 DEBUG 196.121.5.210 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-21 05:27:55 DEBUG 196.121.5.210 User::get_full_tree call to build_path_from_id_user 2019-06-21 05:27:55 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=1 protection=0 2019-06-21 05:27:55 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=2 protection=0 2019-06-21 05:27:55 DEBUG 196.121.5.210 User::build_path_from_id_user id_user=3 protection=0 2019-06-21 05:27:55 DEBUG 196.121.5.210 User::get_full_tree dol_sort_array 2019-06-21 05:27:55 INFO 196.121.5.210 Build childid for id = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modDeplacement::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_DEPLACEMENT' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modSyslog::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SYSLOG' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 modTax::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_TAX' AND entity IN (0,1) 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 91 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 92 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 93 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 94 AND entity = 1 2019-06-21 05:27:55 DEBUG 196.121.5.210 modNumberWords::insert_permissions 2019-06-21 05:27:55 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_NUMBERWORDS' AND entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT rowid FROM llx_menu WHERE mainmenu ='patastools' AND type = 'top' AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 modmyfield::insert_permissions 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_MYFIELD' AND entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1602111 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1602112 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1602113 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1602114 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1602115 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 modShowPrice::insert_permissions 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_SHOWPRICE' AND entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT count(*) as nb FROM llx_rights_def WHERE id = 1400281 AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 admin.lib::dolibarr_set_const 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=DELETE FROM llx_const WHERE name = 'INFRAS_PHP_EXT_XML' AND entity = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 admin.lib::dolibarr_set_const 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=INSERT INTO llx_const(name,value,type,visible,note,entity) VALUES ('INFRAS_PHP_EXT_XML', '1','chaine',0,'',1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 modinfraspack::insert_permissions 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT value as value FROM llx_const WHERE name = 'MAIN_MODULE_INFRASPACK' AND entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 COMMIT Transaction 2019-06-21 05:27:56 DEBUG 196.121.5.210 get user perms 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT DISTINCT ur.fk_id FROM llx_user_rights as ur WHERE ur.entity = 1 AND ur.fk_user = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 get user perms 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT DISTINCT gr.fk_id, gu.entity FROM llx_usergroup_rights as gr, llx_usergroup_user as gu WHERE gr.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT MAX(te.rowid) FROM llx_user as te WHERE te.rowid < '1' AND te.entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT MIN(te.rowid) FROM llx_user as te WHERE te.rowid > '1' AND te.entity IN (0,1) 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT r.id, r.libelle, r.module FROM llx_rights_def as r WHERE r.libelle NOT LIKE 'tou%' AND r.entity = 1 ORDER BY r.module, r.id 2019-06-21 05:27:56 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%userdao%' OR context like '%fileslib%' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%toprightmenu%' OR context like '%main%' OR context like '%usercard%' OR context like '%userperms%' OR context like '%globalcard%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:56 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:27:56 INFO 196.121.5.210 --- End access to /gest/htdocs/user/perms.php 2019-06-21 05:30:55 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:30:55 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:30:55 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:30:55 DEBUG 196.121.5.210 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-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:30:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:30:55 DEBUG 196.121.5.210 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-21 05:30:55 DEBUG 196.121.5.210 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-21 05:30:55 INFO 196.121.5.210 --- Access to /gest/htdocs/user/group/card.php - action=create, massaction= 2019-06-21 05:30:55 DEBUG 196.121.5.210 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-21 05:30:55 DEBUG 196.121.5.210 Menubase::menuLoad mymainmenu=home myleftmenu=users type_user=0 menu_handler=eldy tabMenu size=0 2019-06-21 05:30:55 DEBUG 196.121.5.210 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-21 05:30:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context toprightmenu: actions_myfield.class.php 2019-06-21 05:30:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context userdao: actions_myfield.class.php 2019-06-21 05:30:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context searchform: actions_myfield.class.php 2019-06-21 05:30:55 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context leftblock: actions_myfield.class.php 2019-06-21 05:30:55 DEBUG 196.121.5.210 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printCommonFooter of class ActionsMyfield, module=myfield, action= context=main 2019-06-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%searchform%' OR context like '%leftblock%' OR context like '%userdao%' OR context like '%toprightmenu%' OR context like '%main%' ) AND typefield =0 ORDER BY context, label 2019-06-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%tmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:30:55 DEBUG 196.121.5.210 sql=SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context='' OR context like '%vsmenu%' ) AND typefield =2 ORDER BY context, label 2019-06-21 05:30:55 INFO 196.121.5.210 --- End access to /gest/htdocs/user/group/card.php 2019-06-21 05:31:01 DEBUG 196.121.5.210 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2019-06-21 05:31:01 DEBUG 196.121.5.210 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 = 'admin' ORDER BY u.entity ASC 2019-06-21 05:31:01 INFO 196.121.5.210 fetch_name_optionals_label elementtype=user 2019-06-21 05:31:01 DEBUG 196.121.5.210 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-21 05:31:01 DEBUG 196.121.5.210 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2019-06-21 05:31:01 DEBUG 196.121.5.210 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-06-21 05:31:01 INFO 196.121.5.210 HookManager::initHooks Loading hook class for context main: actions_myfield.class.php 2019-06-21 05:31:01 DEBUG 196.121.5.210 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-21 05:31:01 DEBUG 196.121.5.210 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-21 05:31:01 INFO 196.121.5.210 --- Access to /gest/htdocs/document.php - action=, massaction= 2019-06-21 05:31:01 DEBUG 196.121.5.210 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-21 05:31:01 INFO 196.121.5.210 modulepart=logs original_file=dolibarr.log entity=1 2019-06-21 05:31:01 INFO 196.121.5.210 document.php download /home2/khaled/klkindustry/gest/documents/dolibarr.log filename=dolibarr.log content-type=text/plain