2019-02-02 13:13:32 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:13:32 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:13:32 INFO 213.44.131.100 --- Access to /admin/modules.php - action=, massaction= 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:13:32 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:13:32 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:13:32 INFO 213.44.131.100 Scan directory /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/core/modules/ for module descriptor files (modXXX.class.php) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT code, label, description FROM dolibarr_c_action_trigger ORDER by rang 2019-02-02 13:13:32 INFO 213.44.131.100 Module modAsset not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'societe' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'socpeople' 2019-02-02 13:13:32 INFO 213.44.131.100 Module modCollab not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 User::loadParentOf 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT fk_user as id_parent, rowid as id_son FROM dolibarr_user WHERE fk_user <> 0 AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 User::get_full_tree get user list 2019-02-02 13:13:32 DEBUG 213.44.131.100 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 dolibarr_user as u WHERE u.entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 User::get_full_tree call to build_path_from_id_user 2019-02-02 13:13:32 DEBUG 213.44.131.100 User::build_path_from_id_user id_user=1 protection=0 2019-02-02 13:13:32 DEBUG 213.44.131.100 User::get_full_tree dol_sort_array 2019-02-02 13:13:32 INFO 213.44.131.100 Build childid for id = 1 2019-02-02 13:13:32 INFO 213.44.131.100 Module modDeplacement not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modDocumentGeneration not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modDynamicPrices not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM dolibarr_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM dolibarr_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'facture_fourn' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'facture_fourn_det' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'facture_fourn' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'commande_fournisseur' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param FROM dolibarr_extrafields WHERE elementtype = 'commande_fournisseurdet' 2019-02-02 13:13:32 INFO 213.44.131.100 Module modHRM not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modLabel not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 useNPR 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.rowid FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 useNPR 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.rowid FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 useNPR 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.rowid FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 INFO 213.44.131.100 Module modReceiptPrinter not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type FROM dolibarr_extrafields WHERE elementtype = 'product' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 useNPR 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.rowid FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 useLocalTax 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT t.localtax1, t.localtax2 FROM dolibarr_c_tva as t, dolibarr_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'societe' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1) 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM dolibarr_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) 2019-02-02 13:13:32 INFO 213.44.131.100 Module modTicket not qualified 2019-02-02 13:13:32 DEBUG 213.44.131.100 sql=SELECT name, label, fieldrequired FROM dolibarr_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2019-02-02 13:13:32 INFO 213.44.131.100 Module modWebServicesClient not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modDataPolicy not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modEmailCollector not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 Module modTakePos not qualified 2019-02-02 13:13:32 INFO 213.44.131.100 --- End access to /admin/modules.php 2019-02-02 13:13:37 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:13:37 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:13:37 INFO 213.44.131.100 --- Access to /admin/syslog.php - action=, massaction= 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:13:37 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:13:37 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:13:37 DEBUG 213.44.131.100 admin.lib::dolibarr_get_const 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT value as value FROM dolibarr_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0 2019-02-02 13:13:37 DEBUG 213.44.131.100 admin.lib::dolibarr_get_const 2019-02-02 13:13:37 DEBUG 213.44.131.100 sql=SELECT value as value FROM dolibarr_const WHERE name = 'SYSLOG_FILE' AND entity = 0 2019-02-02 13:13:37 INFO 213.44.131.100 --- End access to /admin/syslog.php 2019-02-02 13:13:44 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:13:44 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:13:44 INFO 213.44.131.100 --- Access to /document.php - action=, massaction= 2019-02-02 13:13:44 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:13:44 INFO 213.44.131.100 modulepart=logs original_file=dolibarr.log entity=1 2019-02-02 13:13:44 INFO 213.44.131.100 document.php download /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain 2019-02-02 13:13:44 INFO 213.44.131.100 --- End access to /document.php 2019-02-02 13:14:11 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:11 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:11 INFO 213.44.131.100 --- Access to /document.php - action=, massaction= 2019-02-02 13:14:11 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:14:11 INFO 213.44.131.100 modulepart=logs original_file=dolibarr.log entity=1 2019-02-02 13:14:11 INFO 213.44.131.100 document.php download /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain 2019-02-02 13:14:11 INFO 213.44.131.100 --- End access to /document.php 2019-02-02 13:14:31 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:31 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:31 INFO 213.44.131.100 --- Access to /societe/index.php - action=, massaction= 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:14:31 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:14:31 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:14:31 DEBUG 213.44.131.100 sql=SELECT s.rowid, s.client, s.fournisseur FROM dolibarr_societe as s WHERE s.entity IN (1) 2019-02-02 13:14:31 INFO 213.44.131.100 DolGraph::draw_jflot this->type=pie this->MaxValue=0 2019-02-02 13:14:31 DEBUG 213.44.131.100 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 datem, s.status as status FROM dolibarr_societe as s WHERE s.entity IN (1) ORDER BY s.tms DESC LIMIT 15 2019-02-02 13:14:31 INFO 213.44.131.100 --- End access to /societe/index.php 2019-02-02 13:14:35 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:35 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:35 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:35 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:14:35 INFO 213.44.131.100 modulepart=societe original_file=1//logos/thumbs/Logo de L'Agence 3W_mini.png entity=1 2019-02-02 13:14:35 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1//logos/thumbs/Logo de L'Agence 3W_mini.png filename=Logo de L'Agence 3W_mini.png content-type=image/png 2019-02-02 13:14:35 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:14:36 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 INFO 213.44.131.100 --- Access to /societe/card.php - action=, massaction= 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:14:36 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:14:36 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, canvas FROM dolibarr_societe WHERE entity IN (1) AND rowid = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT COUNT(p.rowid) as nb FROM dolibarr_socpeople as p WHERE p.fk_soc = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_projet as n WHERE fk_soc = 1 AND entity IN (1) 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_societe_rib as n WHERE fk_soc = 1 2019-02-02 13:14:36 INFO 213.44.131.100 files.lib.php::dol_dir_list path=/kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT COUNT(rowid) as nb FROM dolibarr_links WHERE objecttype = 'societe' AND objectid = 1 AND entity = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT MAX(te.rowid) FROM dolibarr_societe as te WHERE te.rowid < '1' AND te.entity IN (1) 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT MIN(te.rowid) FROM dolibarr_societe as te WHERE te.rowid > '1' AND te.entity IN (1) 2019-02-02 13:14:36 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:14:36 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:14:36 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:14:36 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:14:36 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:14:36 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:14:36 DEBUG 213.44.131.100 FormCompany::typent_array 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2019-02-02 13:14:36 DEBUG 213.44.131.100 Translate::loadCacheCurrencies 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT code_iso, label, unicode FROM dolibarr_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid FROM dolibarr_socpeople WHERE fk_soc = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 Contact::fetch id=1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT c.rowid, c.entity, c.fk_soc, c.ref_ext, c.civility as civility_id, c.lastname, c.firstname, c.address, c.statut, c.zip, c.town, c.fk_pays as country_id, c.fk_departement, c.birthday, c.poste, c.phone, c.phone_perso, c.phone_mobile, c.fax, c.email, c.jabberid, c.skype, c.twitter, c.facebook, c.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, 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 dolibarr_socpeople as c LEFT JOIN dolibarr_c_country as co ON c.fk_pays = co.rowid LEFT JOIN dolibarr_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN dolibarr_user as u ON c.rowid = u.fk_socpeople LEFT JOIN dolibarr_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT u.rowid FROM dolibarr_user as u WHERE u.fk_socpeople = 1 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=socpeople 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2019-02-02 13:14:36 INFO 213.44.131.100 files.lib.php::dol_dir_list path=/kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2019-02-02 13:14:36 DEBUG 213.44.131.100 /core/lib/function2.lib.php::getListOfModels 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM dolibarr_document_model WHERE type = 'company' AND entity IN (0,1) ORDER BY description DESC 2019-02-02 13:14:36 DEBUG 213.44.131.100 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 dolibarr_societe as s WHERE s.parent = 1 AND s.entity IN (1) ORDER BY s.nom 2019-02-02 13:14:36 DEBUG 213.44.131.100 ActionComm::getActions 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT a.id FROM dolibarr_actioncomm as a WHERE a.entity IN (1) AND a.fk_soc = 1 ORDER BY a.datep DESC, a.id DESC LIMIT 11 2019-02-02 13:14:36 INFO 213.44.131.100 --- End access to /societe/card.php 2019-02-02 13:14:36 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:14:36 INFO 213.44.131.100 modulepart=societe original_file=1//logos/thumbs/Logo de L'Agence 3W_small.png entity=1 2019-02-02 13:14:36 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1//logos/thumbs/Logo de L'Agence 3W_small.png filename=Logo de L'Agence 3W_small.png content-type=image/png 2019-02-02 13:14:36 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:14:36 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:14:36 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:14:36 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:14:36 INFO 213.44.131.100 modulepart=userphoto original_file=1/thumbs/FB_IMG_1548080159448_mini.jpg entity=1 2019-02-02 13:14:36 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/users/1/thumbs/FB_IMG_1548080159448_mini.jpg filename=FB_IMG_1548080159448_mini.jpg content-type=image/jpeg 2019-02-02 13:14:36 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:16:02 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:16:02 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:16:02 INFO 213.44.131.100 --- Access to /societe/card.php - action=edit, massaction= 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:16:02 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:16:02 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:16:02 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:02 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:16:02 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, canvas FROM dolibarr_societe WHERE entity IN (1) AND rowid = 1 2019-02-02 13:16:02 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:16:02 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:02 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT COUNT(p.rowid) as nb FROM dolibarr_socpeople as p WHERE p.fk_soc = 1 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_projet as n WHERE fk_soc = 1 AND entity IN (1) 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_societe_rib as n WHERE fk_soc = 1 2019-02-02 13:16:02 INFO 213.44.131.100 files.lib.php::dol_dir_list path=/kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT COUNT(rowid) as nb FROM dolibarr_links WHERE objecttype = 'societe' AND objectid = 1 AND entity = 1 2019-02-02 13:16:02 INFO 213.44.131.100 Societe::codeclient_modifiable code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:02 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:02 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_client, 8, 3)) as val FROM dolibarr_societe WHERE code_client LIKE '_____1____' AND code_client NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::get_next_value return 0219 1 002 2019-02-02 13:16:02 INFO 213.44.131.100 Societe::codefournisseur_modifiable code_founisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:02 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:02 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_fournisseur, 8, 3)) as val FROM dolibarr_societe WHERE code_fournisseur LIKE '_____2____' AND code_fournisseur NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:16:02 DEBUG 213.44.131.100 functions2::get_next_value return 0219 2 002 2019-02-02 13:16:02 DEBUG 213.44.131.100 Form::select_country 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM dolibarr_c_country WHERE active > 0 2019-02-02 13:16:02 DEBUG 213.44.131.100 FormCompany::select_departement selected=76, country_codeid=FR 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM dolibarr_c_departements as d, dolibarr_c_regions as r,dolibarr_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departement 2019-02-02 13:16:02 DEBUG 213.44.131.100 FormCompany::select_departement num=101 2019-02-02 13:16:02 DEBUG 213.44.131.100 FormCompany::typent_array 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2019-02-02 13:16:02 DEBUG 213.44.131.100 FormCompany::effectif_array 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_effectif WHERE active = 1 ORDER BY id ASC 2019-02-02 13:16:02 DEBUG 213.44.131.100 FormCompany::select_juridicalstatus 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM dolibarr_c_forme_juridique as f, dolibarr_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code 2019-02-02 13:16:02 DEBUG 213.44.131.100 Form::select_dolusers 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM dolibarr_user as u WHERE u.entity IN (0,1) ORDER BY u.firstname ASC 2019-02-02 13:16:02 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:16:02 INFO 213.44.131.100 --- End access to /societe/card.php 2019-02-02 13:16:03 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:16:03 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:16:03 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:16:03 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:16:03 INFO 213.44.131.100 modulepart=societe original_file=1//logos/Logo de L'Agence 3W.png entity=1 2019-02-02 13:16:03 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1//logos/Logo de L'Agence 3W.png filename=Logo de L'Agence 3W.png content-type=image/png 2019-02-02 13:16:03 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:16:06 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:16:06 INFO 213.44.131.100 --- Access to /societe/card.php - action=update, massaction= 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:16:06 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:16:06 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, canvas FROM dolibarr_societe WHERE entity IN (1) AND rowid = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 dol_getIdFromCode (value not found into cache) 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT code as valuetoget FROM dolibarr_c_typent WHERE id = '4' 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, code, label FROM dolibarr_c_country WHERE rowid=1 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::codeclient_modifiable code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::codefournisseur_modifiable code_founisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::Update id=1 call_trigger=1 allowmodcodeclient=1 allowmodcodefournisseur=1 2019-02-02 13:16:06 DEBUG 213.44.131.100 BEGIN Transaction 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE siren = '797683950' AND entity IN (1) AND rowid <> 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE siret = '79768395000043' AND entity IN (1) AND rowid <> 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE email = 'bonjour@lagence3w.fr' AND entity IN (1) AND rowid <> 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 ROLLBACK Transaction 2019-02-02 13:16:06 WARNING 213.44.131.100 Societe::Update fails verify Le - est obligatoire (ForbiddenBySetupRules) 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(p.rowid) as nb FROM dolibarr_socpeople as p WHERE p.fk_soc = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_projet as n WHERE fk_soc = 1 AND entity IN (1) 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_societe_rib as n WHERE fk_soc = 1 2019-02-02 13:16:06 INFO 213.44.131.100 files.lib.php::dol_dir_list path=/kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT COUNT(rowid) as nb FROM dolibarr_links WHERE objecttype = 'societe' AND objectid = 1 AND entity = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, code, label FROM dolibarr_c_country WHERE rowid=1 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::codeclient_modifiable code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_client, 8, 3)) as val FROM dolibarr_societe WHERE code_client LIKE '_____1____' AND code_client NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::get_next_value return 0219 1 002 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::codefournisseur_modifiable code_founisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:16:06 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_fournisseur, 8, 3)) as val FROM dolibarr_societe WHERE code_fournisseur LIKE '_____2____' AND code_fournisseur NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:16:06 DEBUG 213.44.131.100 functions2::get_next_value return 0219 2 002 2019-02-02 13:16:06 DEBUG 213.44.131.100 Form::select_country 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM dolibarr_c_country WHERE active > 0 2019-02-02 13:16:06 DEBUG 213.44.131.100 FormCompany::select_departement selected=76, country_codeid=FR 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM dolibarr_c_departements as d, dolibarr_c_regions as r,dolibarr_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departement 2019-02-02 13:16:06 DEBUG 213.44.131.100 FormCompany::select_departement num=101 2019-02-02 13:16:06 DEBUG 213.44.131.100 FormCompany::typent_array 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2019-02-02 13:16:06 DEBUG 213.44.131.100 FormCompany::effectif_array 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_effectif WHERE active = 1 ORDER BY id ASC 2019-02-02 13:16:06 DEBUG 213.44.131.100 FormCompany::select_juridicalstatus 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM dolibarr_c_forme_juridique as f, dolibarr_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code 2019-02-02 13:16:06 DEBUG 213.44.131.100 Form::select_dolusers 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM dolibarr_user as u WHERE u.entity IN (0,1) ORDER BY u.firstname ASC 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:16:06 INFO 213.44.131.100 --- End access to /societe/card.php 2019-02-02 13:16:06 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:16:06 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:16:06 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:16:06 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:16:06 INFO 213.44.131.100 modulepart=societe original_file=1//logos/Logo de L'Agence 3W.png entity=1 2019-02-02 13:16:06 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1//logos/Logo de L'Agence 3W.png filename=Logo de L'Agence 3W.png content-type=image/png 2019-02-02 13:16:06 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:17:40 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:17:40 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:17:40 INFO 213.44.131.100 --- Access to /document.php - action=, massaction= 2019-02-02 13:17:40 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:17:40 INFO 213.44.131.100 modulepart=logs original_file=dolibarr.log entity=1 2019-02-02 13:17:40 INFO 213.44.131.100 document.php download /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain 2019-02-02 13:17:40 INFO 213.44.131.100 --- End access to /document.php 2019-02-02 13:20:28 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:20:28 INFO 213.44.131.100 --- Access to /societe/card.php - action=update, massaction= 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:20:28 DEBUG 213.44.131.100 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2019-02-02 13:20:28 DEBUG 213.44.131.100 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 dolibarr_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, canvas FROM dolibarr_societe WHERE entity IN (1) AND rowid = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 dol_getIdFromCode (value not found into cache) 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT code as valuetoget FROM dolibarr_c_typent WHERE id = '4' 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, code, label FROM dolibarr_c_country WHERE rowid=1 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::codeclient_modifiable code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::codefournisseur_modifiable code_founisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::Update id=1 call_trigger=1 allowmodcodeclient=1 allowmodcodefournisseur=1 2019-02-02 13:20:28 DEBUG 213.44.131.100 BEGIN Transaction 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE siren = '797683950' AND entity IN (1) AND rowid <> 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE siret = '79768395000043' AND entity IN (1) AND rowid <> 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(*) as idprof FROM dolibarr_societe WHERE email = 'bonjour@lagence3w.fr' AND entity IN (1) AND rowid <> 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 ROLLBACK Transaction 2019-02-02 13:20:28 WARNING 213.44.131.100 Societe::Update fails verify Le - est obligatoire (ForbiddenBySetupRules) 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 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.skype, s.twitter, s.facebook, 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, 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.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 libelle_incoterms, sr.remise_client FROM dolibarr_societe as s LEFT JOIN dolibarr_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN dolibarr_c_country as c ON s.fk_pays = c.rowid LEFT JOIN dolibarr_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN dolibarr_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN dolibarr_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN dolibarr_c_typent as te ON s.fk_typent = te.id LEFT JOIN dolibarr_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN dolibarr_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM dolibarr_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 1 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=societe 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, di, der, oer, odlr, ip FROM dolibarr_societe_extrafields WHERE fk_object = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(p.rowid) as nb FROM dolibarr_socpeople as p WHERE p.fk_soc = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_projet as n WHERE fk_soc = 1 AND entity IN (1) 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(n.rowid) as nb FROM dolibarr_societe_rib as n WHERE fk_soc = 1 2019-02-02 13:20:28 INFO 213.44.131.100 files.lib.php::dol_dir_list path=/kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT COUNT(rowid) as nb FROM dolibarr_links WHERE objecttype = 'societe' AND objectid = 1 AND entity = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, code, label FROM dolibarr_c_country WHERE rowid=1 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::codeclient_modifiable code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codeclient code_client=0219 1 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=0 result=0 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_client, 8, 3)) as val FROM dolibarr_societe WHERE code_client LIKE '_____1____' AND code_client NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::get_next_value return 0219 1 002 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::codefournisseur_modifiable code_founisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 INFO 213.44.131.100 Societe::check_codefournisseur code_fournisseur=0219 2 001 module=mod_codeclient_elephant 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::check_value result=0 2019-02-02 13:20:28 INFO 213.44.131.100 mod_codeclient_elephant::verif type=1 result=0 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::get_next_value mode=next 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT MAX(SUBSTRING(code_fournisseur, 8, 3)) as val FROM dolibarr_societe WHERE code_fournisseur LIKE '_____2____' AND code_fournisseur NOT LIKE '(PROV%)' AND entity IN (1) 2019-02-02 13:20:28 DEBUG 213.44.131.100 functions2::get_next_value return 0219 2 002 2019-02-02 13:20:28 DEBUG 213.44.131.100 Form::select_country 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM dolibarr_c_country WHERE active > 0 2019-02-02 13:20:28 DEBUG 213.44.131.100 FormCompany::select_departement selected=76, country_codeid=FR 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM dolibarr_c_departements as d, dolibarr_c_regions as r,dolibarr_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departement 2019-02-02 13:20:28 DEBUG 213.44.131.100 FormCompany::select_departement num=101 2019-02-02 13:20:28 DEBUG 213.44.131.100 FormCompany::typent_array 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2019-02-02 13:20:28 DEBUG 213.44.131.100 FormCompany::effectif_array 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT id, code, libelle FROM dolibarr_c_effectif WHERE active = 1 ORDER BY id ASC 2019-02-02 13:20:28 DEBUG 213.44.131.100 FormCompany::select_juridicalstatus 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM dolibarr_c_forme_juridique as f, dolibarr_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code 2019-02-02 13:20:28 DEBUG 213.44.131.100 Form::select_dolusers 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM dolibarr_user as u WHERE u.entity IN (0,1) ORDER BY u.firstname ASC 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT u.rowid, u.login, u.lastname, u.firstname, u.email, u.statut, u.entity, u.photo FROM dolibarr_societe_commerciaux as sc, dolibarr_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc = 1 2019-02-02 13:20:28 INFO 213.44.131.100 --- End access to /societe/card.php 2019-02-02 13:20:28 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:20:28 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:20:28 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:20:28 INFO 213.44.131.100 --- Access to /viewimage.php - action=, massaction= 2019-02-02 13:20:28 INFO 213.44.131.100 modulepart=societe original_file=1//logos/Logo de L'Agence 3W.png entity=1 2019-02-02 13:20:28 INFO 213.44.131.100 viewimage.php return file /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/societe/1//logos/Logo de L'Agence 3W.png filename=Logo de L'Agence 3W.png content-type=image/png 2019-02-02 13:20:28 INFO 213.44.131.100 --- End access to /viewimage.php 2019-02-02 13:20:31 DEBUG 213.44.131.100 - This is an already logged session. _SESSION['dol_login']=CPoujol _SESSION['dol_entity']=1 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM dolibarr_user as u LEFT JOIN dolibarr_c_country as c ON u.fk_country = c.rowid LEFT JOIN dolibarr_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'CPoujol' ORDER BY u.entity ASC 2019-02-02 13:20:31 INFO 213.44.131.100 fetch_name_optionals_label elementtype=user 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM dolibarr_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT param, value FROM dolibarr_user_param WHERE fk_user = 1 AND entity = 1 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT rowid, entity, type, page, param, value FROM dolibarr_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_user_rights as ur, dolibarr_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM dolibarr_usergroup_rights as gr, dolibarr_usergroup_user as gu, dolibarr_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2019-02-02 13:20:31 INFO 213.44.131.100 --- Access to /document.php - action=, massaction= 2019-02-02 13:20:31 DEBUG 213.44.131.100 sql=SELECT transkey, transvalue FROM dolibarr_overwrite_trans where lang='fr_FR' 2019-02-02 13:20:31 INFO 213.44.131.100 modulepart=logs original_file=dolibarr.log entity=1 2019-02-02 13:20:31 INFO 213.44.131.100 document.php download /kunden/homepages/7/d732407728/htdocs/LAgence3W/Dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain