2020-02-26 08:33:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:33:54 INFO 192.168.10.200 --- Access to /dolibarr/admin/modules.php - action=, massaction= 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:33:54 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsDolitools, module=dolitools, action= context=toprightmenu 2020-02-26 08:33:54 ERR 192.168.10.200 Error: Bug into hook printTopRightMenu of module class ActionsDolitools. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2020-02-26 08:33:54 INFO 192.168.10.200 Scan directory /usr/share/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 INFO 192.168.10.200 Module modHRM not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-02-26 08:33:54 INFO 192.168.10.200 Module modZapier not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'holiday' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 INFO 192.168.10.200 Module modMrp not qualified 2020-02-26 08:33:54 INFO 192.168.10.200 Module modDocumentGeneration not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expensereport' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 INFO 192.168.10.200 Module modReception not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bom' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bomline' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 INFO 192.168.10.200 Module modCollab not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 INFO 192.168.10.200 Module modWebServicesClient not qualified 2020-02-26 08:33:54 INFO 192.168.10.200 Module modAsset not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:33:54 DEBUG 192.168.10.200 useNPR 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:33:54 INFO 192.168.10.200 Module modReceiptPrinter not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-02-26 08:33:54 INFO 192.168.10.200 Module modDataPolicy not qualified 2020-02-26 08:33:54 INFO 192.168.10.200 Module modDynamicPrices not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 User::loadParentOf 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 User::get_full_tree get user list 2020-02-26 08:33:54 DEBUG 192.168.10.200 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) 2020-02-26 08:33:54 DEBUG 192.168.10.200 User::get_full_tree call to build_path_from_id_user 2020-02-26 08:33:54 DEBUG 192.168.10.200 User::build_path_from_id_user id_user=1 protection=0 2020-02-26 08:33:54 DEBUG 192.168.10.200 User::get_full_tree dol_sort_array 2020-02-26 08:33:54 INFO 192.168.10.200 Build childid for id = 1 2020-02-26 08:33:54 INFO 192.168.10.200 Module modDeplacement not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinter' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinterdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2020-02-26 08:33:54 INFO 192.168.10.200 Module modLabel not qualified 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product_lot' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2020-02-26 08:33:54 INFO 192.168.10.200 Module Blockedlog alreadyUsed with ignoresystem=1 is 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2020-02-26 08:33:54 INFO 192.168.10.200 Scan directory /usr/share/dolibarr/htdocs/custom/dolitools/core/modules/ for module descriptor files (modXXX.class.php) 2020-02-26 08:33:54 DEBUG 192.168.10.200 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2020-02-26 08:33:54 INFO 192.168.10.200 Module Blockedlog alreadyUsed with ignoresystem=1 is 2020-02-26 08:33:54 INFO 192.168.10.200 --- End access to /dolibarr/admin/modules.php 2020-02-26 08:33:54 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 DEBUG 192.168.10.200 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 2020-02-26 08:33:54 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:34:56 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 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 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 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 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:34:56 INFO 192.168.10.200 --- Access to /dolibarr/admin/modulehelp.php - action=, massaction= 2020-02-26 08:34:56 DEBUG 192.168.10.200 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 2020-02-26 08:34:56 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:34:56 INFO 192.168.10.200 Scan directory /usr/share/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 INFO 192.168.10.200 Module modHRM not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-02-26 08:34:56 INFO 192.168.10.200 Module modZapier not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'holiday' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 INFO 192.168.10.200 Module modMrp not qualified 2020-02-26 08:34:56 INFO 192.168.10.200 Module modDocumentGeneration not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expensereport' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 INFO 192.168.10.200 Module modReception not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bom' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bomline' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 INFO 192.168.10.200 Module modCollab not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 INFO 192.168.10.200 Module modWebServicesClient not qualified 2020-02-26 08:34:56 INFO 192.168.10.200 Module modAsset not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useLocalTax 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2020-02-26 08:34:56 DEBUG 192.168.10.200 useNPR 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT t.rowid FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2020-02-26 08:34:56 INFO 192.168.10.200 Module modReceiptPrinter not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-02-26 08:34:56 INFO 192.168.10.200 Module modDataPolicy not qualified 2020-02-26 08:34:56 INFO 192.168.10.200 Module modDynamicPrices not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 User::loadParentOf 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 User::get_full_tree get user list 2020-02-26 08:34:56 DEBUG 192.168.10.200 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) 2020-02-26 08:34:56 DEBUG 192.168.10.200 User::get_full_tree call to build_path_from_id_user 2020-02-26 08:34:56 DEBUG 192.168.10.200 User::build_path_from_id_user id_user=1 protection=0 2020-02-26 08:34:56 DEBUG 192.168.10.200 User::get_full_tree dol_sort_array 2020-02-26 08:34:56 INFO 192.168.10.200 Build childid for id = 1 2020-02-26 08:34:56 INFO 192.168.10.200 Module modDeplacement not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinter' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinterdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2020-02-26 08:34:56 INFO 192.168.10.200 Module modLabel not qualified 2020-02-26 08:34:56 DEBUG 192.168.10.200 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 2020-02-26 08:34:56 DEBUG 192.168.10.200 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 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product_lot' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT rowid FROM llx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2020-02-26 08:34:56 INFO 192.168.10.200 Module Blockedlog alreadyUsed with ignoresystem=1 is 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2020-02-26 08:34:56 INFO 192.168.10.200 Scan directory /usr/share/dolibarr/htdocs/custom/dolitools/core/modules/ for module descriptor files (modXXX.class.php) 2020-02-26 08:34:56 DEBUG 192.168.10.200 modPayBox::getLastActiveDate 2020-02-26 08:34:56 DEBUG 192.168.10.200 sql=SELECT tms, note FROM llx_const WHERE name = 'MAIN_MODULE_PAYBOX' AND entity IN (0, 1) 2020-02-26 08:34:56 INFO 192.168.10.200 --- End access to /dolibarr/admin/modulehelp.php 2020-02-26 08:35:33 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:33 INFO 192.168.10.200 --- Access to /dolibarr/societe/index.php - action=, massaction= 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:35:33 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsDolitools, module=dolitools, action= context=toprightmenu 2020-02-26 08:35:33 ERR 192.168.10.200 Error: Bug into hook printTopRightMenu of module class ActionsDolitools. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.client, s.fournisseur FROM llx_societe as s WHERE s.entity IN (1) 2020-02-26 08:35:33 INFO 192.168.10.200 DolGraph::draw_jflot this->type=pie this->MaxValue=0 2020-02-26 08:35:33 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.email, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.logo, s.canvas, s.tms as date_modification, s.status as status FROM llx_societe as s WHERE s.entity IN (1) ORDER BY s.tms DESC LIMIT 15 2020-02-26 08:35:33 INFO 192.168.10.200 --- End access to /dolibarr/societe/index.php 2020-02-26 08:35:33 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 DEBUG 192.168.10.200 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 2020-02-26 08:35:33 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:38 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:38 INFO 192.168.10.200 --- Access to /dolibarr/societe/list.php - action=, massaction= 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 = 'societe' ORDER BY pos 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT id, code, libelle as label FROM llx_c_stcomm WHERE active = 1 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT code, label, sortorder FROM llx_c_prospectlevel WHERE active > 0 ORDER BY sortorder 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.barcode, s.town, s.zip, s.datec, s.code_client, s.code_fournisseur, s.logo, st.libelle as stcomm, s.fk_stcomm as stcomm_id, s.fk_prospectlevel, s.prefix_comm, s.client, s.fournisseur, s.canvas, s.status as status, s.email, s.phone, s.fax, s.url, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.idprof5 as idprof5, s.idprof6 as idprof6, s.tva_intra, s.fk_pays, s.tms as date_update, s.datec as date_creation, s.code_compta, s.code_compta_fournisseur, s.parent as fk_parent, s2.nom as name2, typent.code as typent_code, staff.code as staff_code, country.code as country_code, country.label as country_label, state.code_departement as state_code, state.nom as state_name, region.code_region as region_code, region.nom as region_name FROM llx_societe as s LEFT JOIN llx_societe as s2 ON s.parent = s2.rowid LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_effectif as staff on (staff.id = s.fk_effectif) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement) LEFT JOIN llx_c_regions as region on (region. code_region = state.fk_region) LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id WHERE s.entity IN (1) AND (s.status IN (1)) ORDER BY s.nom ASC 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.barcode, s.town, s.zip, s.datec, s.code_client, s.code_fournisseur, s.logo, st.libelle as stcomm, s.fk_stcomm as stcomm_id, s.fk_prospectlevel, s.prefix_comm, s.client, s.fournisseur, s.canvas, s.status as status, s.email, s.phone, s.fax, s.url, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.idprof5 as idprof5, s.idprof6 as idprof6, s.tva_intra, s.fk_pays, s.tms as date_update, s.datec as date_creation, s.code_compta, s.code_compta_fournisseur, s.parent as fk_parent, s2.nom as name2, typent.code as typent_code, staff.code as staff_code, country.code as country_code, country.label as country_label, state.code_departement as state_code, state.nom as state_name, region.code_region as region_code, region.nom as region_name FROM llx_societe as s LEFT JOIN llx_societe as s2 ON s.parent = s2.rowid LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_effectif as staff on (staff.id = s.fk_effectif) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement) LEFT JOIN llx_c_regions as region on (region. code_region = state.fk_region) LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id WHERE s.entity IN (1) AND (s.status IN (1)) ORDER BY s.nom ASC LIMIT 51 2020-02-26 08:35:38 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:35:38 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsDolitools, module=dolitools, action= context=toprightmenu 2020-02-26 08:35:38 ERR 192.168.10.200 Error: Bug into hook printTopRightMenu of module class ActionsDolitools. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::load_motherof 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1) 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo get category list 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 2 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo call to build_path_from_id_categ 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=6 protection=0 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo dol_sort_array 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::load_motherof 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1) 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo get category list 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 1 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo call to build_path_from_id_categ 2020-02-26 08:35:38 DEBUG 192.168.10.200 Categorie::get_full_arbo dol_sort_array 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.statut, u.login FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY statut DESC, lastname ASC 2020-02-26 08:35:38 DEBUG 192.168.10.200 FormCompany::typent_array 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2020-02-26 08:35:38 DEBUG 192.168.10.200 FormCompany::typent_array 2020-02-26 08:35:38 DEBUG 192.168.10.200 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2020-02-26 08:35:38 INFO 192.168.10.200 Save lastsearch_values_tmp_societe/list.php={"search_level":[]} (systematic recording of last search criterias) 2020-02-26 08:35:38 INFO 192.168.10.200 --- End access to /dolibarr/societe/list.php 2020-02-26 08:35:38 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 DEBUG 192.168.10.200 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 2020-02-26 08:35:38 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:40 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:40 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:40 DEBUG 192.168.10.200 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 2020-02-26 08:35:40 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:40 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:40 DEBUG 192.168.10.200 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 2020-02-26 08:35:40 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:40 INFO 192.168.10.200 --- Access to /dolibarr/viewimage.php - action=, massaction= 2020-02-26 08:35:40 INFO 192.168.10.200 modulepart=societe original_file=5//logos/thumbs/POLLEN SCOP_mini.png entity=1 2020-02-26 08:35:40 INFO 192.168.10.200 viewimage.php return file /var/lib/dolibarr/documents/societe/5//logos/thumbs/POLLEN SCOP_mini.png filename=POLLEN SCOP_mini.png content-type=image/png 2020-02-26 08:35:40 INFO 192.168.10.200 --- End access to /dolibarr/viewimage.php 2020-02-26 08:35:41 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:41 INFO 192.168.10.200 --- Access to /dolibarr/societe/card.php - action=, massaction= 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 = 'societe' ORDER BY pos 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, canvas FROM llx_societe WHERE entity IN (1) AND rowid = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:35:41 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsDolitools, module=dolitools, action= context=toprightmenu 2020-02-26 08:35:41 ERR 192.168.10.200 Error: Bug into hook printTopRightMenu of module class ActionsDolitools. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT COUNT(p.rowid) as nb FROM llx_socpeople as p WHERE p.fk_soc = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT COUNT(n.rowid) as nb FROM llx_societe_rib as n WHERE n.fk_soc = 5 AND n.stripe_card_ref IS NULL 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 5 2020-02-26 08:35:41 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/societe/5 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 5 AND entity = 1 2020-02-26 08:35:41 INFO 192.168.10.200 Societe::fetch_barcode this->element=societe this->barcode_type= 2020-02-26 08:35:41 DEBUG 192.168.10.200 Societe::fetch_barcode 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, code, libelle as label, coder FROM llx_c_barcode_type WHERE rowid = 8 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '5' AND te.entity IN (1) 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '5' AND te.entity IN (1) 2020-02-26 08:35:41 INFO 192.168.10.200 Societe::check_codefournisseur code_fournisseur=FOU00001 module=mod_codeclient_elephant 2020-02-26 08:35:41 DEBUG 192.168.10.200 functions2::check_value result=0 2020-02-26 08:35:41 INFO 192.168.10.200 mod_codeclient_elephant::verif type=1 result=0 2020-02-26 08:35:41 DEBUG 192.168.10.200 FormCompany::typent_array 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_fournisseur as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_soc = 5 AND c.type = 1 AND c.entity IN (1) 2020-02-26 08:35:41 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsDolitools, module=dolitools, action=view context=toprightmenu 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.office_phone, u.job, u.email, u.statut, u.entity, u.photo FROM llx_societe_commerciaux as sc, llx_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsDolitools, module=dolitools, action=view context=toprightmenu 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid FROM llx_socpeople WHERE fk_soc = 5 2020-02-26 08:35:41 DEBUG 192.168.10.200 Contact::fetch id=2 ref_ext= email= 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT c.rowid, c.entity, c.fk_soc, c.ref_ext, c.civility as civility_code, c.lastname, c.firstname, c.address, c.statut, c.zip, c.town, c.fk_pays as country_id, c.fk_departement as state_id, c.birthday, c.poste, c.phone, c.phone_perso, c.phone_mobile, c.fax, c.email, c.socialnetworks, c.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.canvas, c.import_key, c.datec as date_creation, c.tms as date_modification, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 2 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 2 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 = 'socpeople' ORDER BY pos 2020-02-26 08:35:41 DEBUG 192.168.10.200 Contact::Contact::fetchRoles 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT tc.rowid, tc.element, tc.source, tc.code, tc.libelle, sc.rowid as contactroleid FROM llx_societe_contacts as sc INNER JOIN llx_c_type_contact as tc ON tc.rowid = sc.fk_c_type_contact AND sc.fk_socpeople = 2 AND tc.source = 'external' AND tc.active=1 AND sc.entity IN (1) 2020-02-26 08:35:41 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/societe/5 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-02-26 08:35:41 DEBUG 192.168.10.200 /core/lib/function2.lib.php::getListOfModels 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'company' AND entity IN (0,1) ORDER BY description DESC 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.client, s.fournisseur, s.nom as name, s.name_alias, s.email, s.address, s.zip, s.town, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.canvas FROM llx_societe as s WHERE s.parent = 5 AND s.entity IN (1) ORDER BY s.nom 2020-02-26 08:35:41 DEBUG 192.168.10.200 ActionComm::getActions 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_soc = 5 ORDER BY a.datep DESC, a.id DESC LIMIT 11 2020-02-26 08:35:41 DEBUG 192.168.10.200 ActionComm::fetch 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=12 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 12 AND element_type IN ('user', 'socpeople') 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 INFO 192.168.10.200 --- End access to /dolibarr/societe/card.php 2020-02-26 08:35:41 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:41 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:41 INFO 192.168.10.200 --- Access to /dolibarr/viewimage.php - action=, massaction= 2020-02-26 08:35:41 INFO 192.168.10.200 modulepart=barcode original_file= entity=1 2020-02-26 08:35:41 INFO 192.168.10.200 buildBarCode::TCPDF.getBarcodePNG 2020-02-26 08:35:41 INFO 192.168.10.200 --- End access to /dolibarr/viewimage.php 2020-02-26 08:35:41 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:41 DEBUG 192.168.10.200 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 2020-02-26 08:35:41 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:41 INFO 192.168.10.200 --- Access to /dolibarr/viewimage.php - action=, massaction= 2020-02-26 08:35:41 INFO 192.168.10.200 modulepart=societe original_file=5//logos/thumbs/POLLEN SCOP_small.png entity=1 2020-02-26 08:35:41 INFO 192.168.10.200 viewimage.php return file /var/lib/dolibarr/documents/societe/5//logos/thumbs/POLLEN SCOP_small.png filename=POLLEN SCOP_small.png content-type=image/png 2020-02-26 08:35:41 INFO 192.168.10.200 --- End access to /dolibarr/viewimage.php 2020-02-26 08:35:43 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:43 INFO 192.168.10.200 --- Access to /dolibarr/societe/document.php - action=, massaction= 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 5 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 = 'societe' ORDER BY pos 2020-02-26 08:35:43 DEBUG 192.168.10.200 HookManager::initHooks Loading hooks: context=toprightmenu-path=/dolitools/class/actions_dolitools.class.php 2020-02-26 08:35:43 DEBUG 192.168.10.200 HookManager::executeHooks Qualified hook found (hooktype=output). We call method printTopRightMenu of class ActionsDolitools, module=dolitools, action= context=toprightmenu 2020-02-26 08:35:43 ERR 192.168.10.200 Error: Bug into hook printTopRightMenu of module class ActionsDolitools. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT COUNT(p.rowid) as nb FROM llx_socpeople as p WHERE p.fk_soc = 5 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT COUNT(n.rowid) as nb FROM llx_societe_rib as n WHERE n.fk_soc = 5 AND n.stripe_card_ref IS NULL 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 5 2020-02-26 08:35:43 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/societe/5 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 5 AND entity = 1 2020-02-26 08:35:43 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/societe/5 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-26 08:35:43 INFO 192.168.10.200 Societe::fetch_barcode this->element=societe this->barcode_type= 2020-02-26 08:35:43 DEBUG 192.168.10.200 Societe::fetch_barcode 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT rowid, code, libelle as label, coder FROM llx_c_barcode_type WHERE rowid = 8 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '5' AND te.entity IN (1) 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '5' AND te.entity IN (1) 2020-02-26 08:35:43 INFO 192.168.10.200 Societe::check_codefournisseur code_fournisseur=FOU00001 module=mod_codeclient_elephant 2020-02-26 08:35:43 DEBUG 192.168.10.200 functions2::check_value result=0 2020-02-26 08:35:43 INFO 192.168.10.200 mod_codeclient_elephant::verif type=1 result=0 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 = 'societe/5' AND entity = 1 2020-02-26 08:35:43 DEBUG 192.168.10.200 Link::fetchAll 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT rowid, entity, datea, url, label, objecttype, objectid FROM llx_links WHERE objecttype = 'societe' AND objectid = 5 AND entity = 1 2020-02-26 08:35:43 DEBUG 192.168.10.200 Link::fetchAll 0records 2020-02-26 08:35:43 INFO 192.168.10.200 --- End access to /dolibarr/societe/document.php 2020-02-26 08:35:43 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:43 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:43 INFO 192.168.10.200 --- Access to /dolibarr/viewimage.php - action=, massaction= 2020-02-26 08:35:43 INFO 192.168.10.200 modulepart=barcode original_file= entity=1 2020-02-26 08:35:43 INFO 192.168.10.200 buildBarCode::TCPDF.getBarcodePNG 2020-02-26 08:35:43 INFO 192.168.10.200 --- End access to /dolibarr/viewimage.php 2020-02-26 08:35:43 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:43 DEBUG 192.168.10.200 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 2020-02-26 08:35:43 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:43 INFO 192.168.10.200 --- Access to /dolibarr/viewimage.php - action=, massaction= 2020-02-26 08:35:43 INFO 192.168.10.200 modulepart=societe original_file=5//logos/thumbs/POLLEN SCOP_small.png entity=1 2020-02-26 08:35:43 INFO 192.168.10.200 viewimage.php return file /var/lib/dolibarr/documents/societe/5//logos/thumbs/POLLEN SCOP_small.png filename=POLLEN SCOP_small.png content-type=image/png 2020-02-26 08:35:43 INFO 192.168.10.200 --- End access to /dolibarr/viewimage.php 2020-02-26 08:35:45 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:45 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:45 DEBUG 192.168.10.200 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 2020-02-26 08:35:45 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:45 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:45 DEBUG 192.168.10.200 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 2020-02-26 08:35:45 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:45 INFO 192.168.10.200 --- Access to /dolibarr/document.php - action=, massaction= 2020-02-26 08:35:45 DEBUG 192.168.10.200 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 2020-02-26 08:35:45 INFO 192.168.10.200 modulepart=societe original_file=5/Certificat Bio POLLEN SCOP.pdf entity=1 2020-02-26 08:35:45 INFO 192.168.10.200 document.php download /var/lib/dolibarr/documents/societe/5/Certificat Bio POLLEN SCOP.pdf filename=Certificat Bio POLLEN SCOP.pdf content-type=application/pdf 2020-02-26 08:35:45 INFO 192.168.10.200 --- End access to /dolibarr/document.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/takepos.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::load_motherof 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::get_full_arbo get category list 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::get_full_arbo call to build_path_from_id_categ 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=1 protection=0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=2 protection=0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=3 protection=0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=4 protection=0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=5 protection=0 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::get_full_arbo dol_sort_array 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT code, libelle FROM llx_c_paiement WHERE entity IN (1) AND active = 1 ORDER BY libelle 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/takepos.php 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 2 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 3 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 5 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/ajax/ajax.php - action=getProducts, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::getObjectsInCateg 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT c.fk_product FROM llx_categorie_product as c, llx_product as o WHERE o.entity IN (1) AND c.fk_categorie = 1 AND c.fk_product = o.rowid 2020-02-26 08:35:54 INFO 192.168.10.200 Product::fetch id=1 ref= ref_ext= 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'product' ORDER BY pos 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, stock_available FROM llx_product_extrafields WHERE fk_object = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=3 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=4 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=5 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/ajax/ajax.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/invoice.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT id FROM llx_c_paiement WHERE entity IN (1) AND code = '' 2020-02-26 08:35:54 DEBUG 192.168.10.200 Facture::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.entity IN (1) AND f.ref='(PROV-POS-0)' 2020-02-26 08:35:54 ERR 192.168.10.200 Facture::fetch Error Invoice with id= or ref=(PROV-POS-0) or ref_ext= not found 2020-02-26 08:35:54 DEBUG 192.168.10.200 Translate::loadCacheCurrencies 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/invoice.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 4 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 INFO 192.168.10.200 Product::fetch id=1 ref= ref_ext= 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 = 'product' ORDER BY pos 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT rowid, stock_available FROM llx_product_extrafields WHERE fk_object = 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=3 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=4 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=5 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:54 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/POT001/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-26 08:35:54 DEBUG 192.168.10.200 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/POT001' AND entity = 1 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:54 INFO 192.168.10.200 --- Access to /dolibarr/core/js/lib_foot.js.php - action=, massaction= 2020-02-26 08:35:54 DEBUG 192.168.10.200 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 2020-02-26 08:35:54 INFO 192.168.10.200 --- End access to /dolibarr/core/js/lib_foot.js.php 2020-02-26 08:35:58 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:58 DEBUG 192.168.10.200 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 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:58 DEBUG 192.168.10.200 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 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:58 INFO 192.168.10.200 --- Access to /dolibarr/takepos/takepos.php - action=, massaction= 2020-02-26 08:35:58 DEBUG 192.168.10.200 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 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::load_motherof 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1) 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::get_full_arbo get category list 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::get_full_arbo call to build_path_from_id_categ 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=1 protection=0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=2 protection=0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=3 protection=0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=4 protection=0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::build_path_from_id_categ id_categ=5 protection=0 2020-02-26 08:35:58 DEBUG 192.168.10.200 Categorie::get_full_arbo dol_sort_array 2020-02-26 08:35:58 DEBUG 192.168.10.200 sql=SELECT code, libelle FROM llx_c_paiement WHERE entity IN (1) AND active = 1 ORDER BY libelle 2020-02-26 08:35:58 INFO 192.168.10.200 --- End access to /dolibarr/takepos/takepos.php 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/custom/dolitools/css/altatheme.css.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/custom/dolitools/css/altatheme.css.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 2 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 3 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 4 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/invoice.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT id FROM llx_c_paiement WHERE entity IN (1) AND code = '' 2020-02-26 08:35:59 DEBUG 192.168.10.200 Facture::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount, f.tva, f.localtax1, f.localtax2, f.total, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.entity IN (1) AND f.ref='(PROV-POS1-0)' 2020-02-26 08:35:59 ERR 192.168.10.200 Facture::fetch Error Invoice with id= or ref=(PROV-POS1-0) or ref_ext= not found 2020-02-26 08:35:59 DEBUG 192.168.10.200 Translate::loadCacheCurrencies 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/invoice.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 5 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/ajax/ajax.php - action=getProducts, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::fetch 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext FROM llx_categorie WHERE rowid = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'categorie' ORDER BY pos 2020-02-26 08:35:59 DEBUG 192.168.10.200 Categorie::getObjectsInCateg 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT c.fk_product FROM llx_categorie_product as c, llx_product as o WHERE o.entity IN (1) AND c.fk_categorie = 1 AND c.fk_product = o.rowid 2020-02-26 08:35:59 INFO 192.168.10.200 Product::fetch id=1 ref= ref_ext= 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'product' ORDER BY pos 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, stock_available FROM llx_product_extrafields WHERE fk_object = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=3 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=4 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=5 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/ajax/ajax.php 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/core/js/lib_foot.js.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/core/js/lib_foot.js.php 2020-02-26 08:35:59 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:35:59 INFO 192.168.10.200 --- Access to /dolibarr/takepos/genimg/index.php - action=, massaction= 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 2020-02-26 08:35:59 INFO 192.168.10.200 Product::fetch id=1 ref= ref_ext= 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2020-02-26 08:35:59 DEBUG 192.168.10.200 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 = 'product' ORDER BY pos 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT rowid, stock_available FROM llx_product_extrafields WHERE fk_object = 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=1 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=2 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=3 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=4 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 DEBUG 192.168.10.200 sql=SELECT price, price_ttc, price_min, price_min_ttc, price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly FROM llx_product_price WHERE entity IN (1) AND price_level=5 AND fk_product = 1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2020-02-26 08:35:59 INFO 192.168.10.200 files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/POT001/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-02-26 08:35:59 DEBUG 192.168.10.200 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/POT001' AND entity = 1 2020-02-26 08:35:59 INFO 192.168.10.200 --- End access to /dolibarr/takepos/genimg/index.php 2020-02-26 08:36:00 DEBUG 192.168.10.200 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC 2020-02-26 08:36:00 DEBUG 192.168.10.200 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 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-02-26 08:36:00 DEBUG 192.168.10.200 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 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-02-26 08:36:00 INFO 192.168.10.200 --- Access to /dolibarr/takepos/pay.php - action=, massaction= 2020-02-26 08:36:00 DEBUG 192.168.10.200 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 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT rowid FROM llx_facture where ref='(PROV-POS1-0)' 2020-02-26 08:36:00 DEBUG 192.168.10.200 sql=SELECT code, libelle as label FROM llx_c_paiement WHERE entity IN (1) AND active = 1 ORDER BY libelle 2020-02-26 08:36:00 INFO 192.168.10.200 --- End access to /dolibarr/takepos/pay.php