Bug-No-FIX: Old Supplier Regulation on 4.0.2

join dolibarr.log:

2016-12-23 10:02:05 DEBUG ip.ip.ip.ip Removed file /...../...../...../...../documents/dolibarr.log 2016-12-23 10:02:05 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:05 INFO ip.ip.ip.ip --- End access to /...../htdocs/admin/tools/purge.php 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:19 INFO ip.ip.ip.ip --- Access to /...../htdocs/societe/index.php 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.client, s.fournisseur FROM llx_societe as s WHERE s.entity IN (1) 2016-12-23 10:02:19 WARNING ip.ip.ip.ip dol_print_graph is deprecated 2016-12-23 10:02:19 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.nom as name, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.logo, s.canvas, s.tms as datem, s.status as status FROM llx_societe as s WHERE s.entity IN (1) ORDER BY s.tms DESC LIMIT 15 2016-12-23 10:02:19 INFO ip.ip.ip.ip --- End access to /...../htdocs/societe/index.php 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:21 INFO ip.ip.ip.ip --- Access to /...../htdocs/societe/list.php 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle as label FROM llx_c_stcomm WHERE active = 1 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip societe/list.php 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT code, label, sortorder, 0 as is_in_range FROM llx_c_prospectlevel WHERE active > 0 ORDER BY sortorder 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.nom as name, s.name_alias, s.barcode, s.town, s.zip, s.datec, s.code_client, s.code_fournisseur, st.libelle as stcomm, s.fk_stcomm as stcomm_id, s.fk_prospectlevel, s.prefix_comm, s.client, s.fournisseur, s.canvas, s.status as status, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.fk_pays, s.tms as date_update, s.datec as date_creation, s.code_compta,s.code_compta_fournisseur, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name,ef.12qlx7 as options_12qlx7 FROM llx_societe as s LEFT JOIN llx_societe_extrafields as ef on (s.rowid = ef.fk_object) LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement) ,llx_c_stcomm as st WHERE s.fk_stcomm = st.id AND s.entity IN (1) AND ((s.nom LIKE '%nesl%' OR s.name_alias LIKE '%nesl%' OR s.code_client LIKE '%nesl%' OR s.code_fournisseur LIKE '%nesl%' OR s.email LIKE '%nesl%' OR s.url LIKE '%nesl%' OR s.tva_intra LIKE '%nesl%' OR s.siren LIKE '%nesl%' OR s.siret LIKE '%nesl%' OR s.ape LIKE '%nesl%' OR s.idprof4 LIKE '%nesl%' OR s.barcode LIKE '%nesl%')) AND s.status = 1 ORDER BY s.nom ASC 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.nom as name, s.name_alias, s.barcode, s.town, s.zip, s.datec, s.code_client, s.code_fournisseur, st.libelle as stcomm, s.fk_stcomm as stcomm_id, s.fk_prospectlevel, s.prefix_comm, s.client, s.fournisseur, s.canvas, s.status as status, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.fk_pays, s.tms as date_update, s.datec as date_creation, s.code_compta,s.code_compta_fournisseur, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name,ef.12qlx7 as options_12qlx7 FROM llx_societe as s LEFT JOIN llx_societe_extrafields as ef on (s.rowid = ef.fk_object) LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement) ,llx_c_stcomm as st WHERE s.fk_stcomm = st.id AND s.entity IN (1) AND ((s.nom LIKE '%nesl%' OR s.name_alias LIKE '%nesl%' OR s.code_client LIKE '%nesl%' OR s.code_fournisseur LIKE '%nesl%' OR s.email LIKE '%nesl%' OR s.url LIKE '%nesl%' OR s.tva_intra LIKE '%nesl%' OR s.siren LIKE '%nesl%' OR s.siret LIKE '%nesl%' OR s.ape LIKE '%nesl%' OR s.idprof4 LIKE '%nesl%' OR s.barcode LIKE '%nesl%')) AND s.status = 1 ORDER BY s.nom ASC LIMIT 51 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.statut, u.login FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY lastname ASC 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip FormCompany::typent_array 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip FormCompany::typent_array 2016-12-23 10:02:21 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2016-12-23 10:02:21 INFO ip.ip.ip.ip --- End access to /...../htdocs/societe/list.php 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:22 INFO ip.ip.ip.ip --- Access to /...../htdocs/societe/soc.php 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, canvas FROM llx_societe WHERE entity IN (1) AND rowid = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:22 INFO ip.ip.ip.ip Societe::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 2 2016-12-23 10:02:22 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 2 AND entity = 1 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '2' AND te.entity IN (1) 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '2' AND te.entity IN (1) 2016-12-23 10:02:22 INFO ip.ip.ip.ip Societe::check_codefournisseur code_fournisseur=SU1301-0002 module=mod_codeclient_monkey 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip mod_codeclient_monkey::verif_dispo 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT code_client FROM llx_societe WHERE code_client = 'SU1301-0002' AND entity IN (1) AND rowid <> 2 2016-12-23 10:02:22 INFO ip.ip.ip.ip mod_codeclient_monkey::verif type=1 result=0 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip FormCompany::typent_array 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_fournisseur as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_soc = 2 AND c.type = 1 AND c.entity IN (1) 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Categorie::fetch 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type FROM llx_categorie WHERE rowid = '3' 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'categories' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description FROM llx_categorie_lang WHERE fk_category=3 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 3 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_soc, bank, number, code_banque, code_guichet, cle_rib, bic, iban_prefix as iban, domiciliation, proprio, owner_address, default_rib, label, datec, tms as datem, rum, frstrecur FROM llx_societe_rib WHERE fk_soc = 2 AND default_rib = 1 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT DISTINCT u.rowid, u.lastname, u.firstname, u.email, u.statut, u.entity FROM llx_societe_commerciaux as sc, llx_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc =2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid FROM llx_socpeople WHERE fk_soc = '2' 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Contact::fetch id=2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 2 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Contact::fetch id=336 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 336 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 336 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Contact::fetch id=1523 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 1523 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 1523 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Contact::fetch id=1636 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 1636 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 1636 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip /core/lib/function2.lib.php::getListOfModels 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'company' AND entity IN (0,1) ORDER BY description DESC 2016-12-23 10:02:22 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.nom as name, s.address, s.zip, s.town, s.code_client, s.canvas FROM llx_societe as s WHERE s.parent = 2 AND s.entity IN (1) ORDER BY s.nom 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip core/lib/company.lib.php :: show_contacts 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.lastname, p.firstname, p.fk_pays as country_id, p.civility, p.poste, p.phone as phone_pro, p.phone_mobile, p.phone_perso, p.fax, p.email, p.skype, p.statut , p.civility as civility_id, p.address, p.zip, p.town FROM llx_socpeople as p WHERE p.fk_soc = 2 AND p.statut = 1 ORDER BY p.lastname ASC 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:22 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:22 INFO ip.ip.ip.ip --- End access to /...../htdocs/societe/soc.php 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:23 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:23 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:23 INFO ip.ip.ip.ip modulepart=societe original_file=2//logos/thumbs/logo_small.png 2016-12-23 10:02:23 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/societe/2//logos/thumbs/logo_small.png content-type=image/png 2016-12-23 10:02:23 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:24 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/card.php 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:24 INFO ip.ip.ip.ip Fournisseur::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Fournisseur::fetch_optionals 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 2 2016-12-23 10:02:24 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 2 AND entity = 1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '2' AND te.fournisseur = 1 AND te.entity IN (1) 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '2' AND te.fournisseur = 1 AND te.entity IN (1) 2016-12-23 10:02:24 INFO ip.ip.ip.ip Fournisseur::check_codefournisseur code_fournisseur=SU1301-0002 module=mod_codeclient_monkey 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip mod_codeclient_monkey::verif_dispo 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT code_client FROM llx_societe WHERE code_client = 'SU1301-0002' AND entity IN (1) AND rowid <> 2 2016-12-23 10:02:24 INFO ip.ip.ip.ip mod_codeclient_monkey::verif type=1 result=0 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip useLocalTax 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip useLocalTax 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_fournisseur as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_soc = 2 AND c.type = 1 AND c.entity IN (1) 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Categorie::fetch 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type FROM llx_categorie WHERE rowid = '3' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'categories' ORDER BY pos 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description FROM llx_categorie_lang WHERE fk_category=3 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 3 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT count(pfp.rowid) as nb FROM llx_product_fournisseur_price as pfp WHERE pfp.entity = 1 AND pfp.fk_soc = 2 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.ref, p.label, p.fk_product_type, p.entity, pfp.tms, pfp.ref_fourn as supplier_ref, pfp.price, pfp.quantity, pfp.unitprice FROM llx_product_fournisseur_price as pfp LEFT JOIN llx_product as p ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND pfp.fk_soc = 2 ORDER BY pfp.tms DESC LIMIT 5 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT s.nom, s.rowid as socid, s.client, c.rowid, c.ref, c.total_ht, c.ref_supplier, c.date_valid, c.date_commande, c.date_livraison, c.fk_statut FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND s.rowid = 2 AND c.fk_statut IN (5) AND c.billed = 0 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT count(p.rowid) as total FROM llx_commande_fournisseur as p WHERE p.fk_soc =2 AND p.entity =1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT p.rowid,p.ref, p.date_commande as dc, p.fk_statut, p.total_ht, p.tva as total_tva, p.total_ttc FROM llx_commande_fournisseur as p WHERE p.fk_soc =2 AND p.entity =1 ORDER BY p.date_commande DESC LIMIT 5 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Translate::loadCacheCurrencies 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT f.rowid,f.libelle,f.ref,f.ref_supplier,f.fk_statut,f.datef as df, f.total_ht, f.total_tva, f.total_ttc as amount,f.paye, SUM(pf.amount) as am FROM llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON f.rowid=pf.fk_facturefourn WHERE f.fk_soc = 2 AND f.entity =1 GROUP BY f.rowid,f.libelle,f.ref,f.ref_supplier,f.fk_statut,f.datef,f.total_ht,f.total_tva,f.total_ttc,f.paye ORDER BY f.datef DESC 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip core/lib/company.lib.php :: show_contacts 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.lastname, p.firstname, p.fk_pays as country_id, p.civility, p.poste, p.phone as phone_pro, p.phone_mobile, p.phone_perso, p.fax, p.email, p.skype, p.statut , p.civility as civility_id, p.address, p.zip, p.town FROM llx_socpeople as p WHERE p.fk_soc = 2 AND p.statut = 1 ORDER BY p.lastname ASC 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:24 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/card.php 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:24 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:24 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:24 INFO ip.ip.ip.ip modulepart=societe original_file=2//logos/thumbs/logo_small.png 2016-12-23 10:02:24 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/societe/2//logos/thumbs/logo_small.png content-type=image/png 2016-12-23 10:02:24 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:27 INFO ip.ip.ip.ip --- Access to /...../htdocs/societe/soc.php 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, canvas FROM llx_societe WHERE entity IN (1) AND rowid = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:27 INFO ip.ip.ip.ip Societe::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 2 2016-12-23 10:02:27 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 2 AND entity = 1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '2' AND te.entity IN (1) 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '2' AND te.entity IN (1) 2016-12-23 10:02:27 INFO ip.ip.ip.ip Societe::check_codefournisseur code_fournisseur=SU1301-0002 module=mod_codeclient_monkey 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip mod_codeclient_monkey::verif_dispo 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT code_client FROM llx_societe WHERE code_client = 'SU1301-0002' AND entity IN (1) AND rowid <> 2 2016-12-23 10:02:27 INFO ip.ip.ip.ip mod_codeclient_monkey::verif type=1 result=0 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip FormCompany::typent_array 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_fournisseur as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_soc = 2 AND c.type = 1 AND c.entity IN (1) 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Categorie::fetch 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type FROM llx_categorie WHERE rowid = '3' 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'categories' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description FROM llx_categorie_lang WHERE fk_category=3 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 3 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_soc, bank, number, code_banque, code_guichet, cle_rib, bic, iban_prefix as iban, domiciliation, proprio, owner_address, default_rib, label, datec, tms as datem, rum, frstrecur FROM llx_societe_rib WHERE fk_soc = 2 AND default_rib = 1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT DISTINCT u.rowid, u.lastname, u.firstname, u.email, u.statut, u.entity FROM llx_societe_commerciaux as sc, llx_user as u WHERE entity in (0, 1) AND u.rowid = sc.fk_user AND sc.fk_soc =2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid FROM llx_socpeople WHERE fk_soc = '2' 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Contact::fetch id=2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 2 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Contact::fetch id=336 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 336 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 336 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Contact::fetch id=1523 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 1523 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 1523 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Contact::fetch id=1636 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, 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.photo, c.priv, c.note_private, c.note_public, c.default_lang, c.no_email, c.canvas, c.import_key, co.label as country, co.code as country_code, d.nom as state, d.code_departement as state_code, u.rowid as user_id, u.login as user_login, s.nom as socname, s.address as socaddress, s.zip as soccp, s.town as soccity, s.default_lang as socdefault_lang FROM llx_socpeople as c LEFT JOIN llx_c_country as co ON c.fk_pays = co.rowid LEFT JOIN llx_c_departements as d ON c.fk_departement = d.rowid LEFT JOIN llx_user as u ON c.rowid = u.fk_socpeople LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.rowid = 1636 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid FROM llx_user as u WHERE u.fk_socpeople = 1636 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'socpeople' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip /core/lib/function2.lib.php::getListOfModels 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'company' AND entity IN (0,1) ORDER BY description DESC 2016-12-23 10:02:27 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT s.rowid, s.nom as name, s.address, s.zip, s.town, s.code_client, s.canvas FROM llx_societe as s WHERE s.parent = 2 AND s.entity IN (1) ORDER BY s.nom 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip core/lib/company.lib.php :: show_contacts 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.lastname, p.firstname, p.fk_pays as country_id, p.civility, p.poste, p.phone as phone_pro, p.phone_mobile, p.phone_perso, p.fax, p.email, p.skype, p.statut , p.civility as civility_id, p.address, p.zip, p.town FROM llx_socpeople as p WHERE p.fk_soc = 2 AND p.statut = 1 ORDER BY p.lastname ASC 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:27 INFO ip.ip.ip.ip --- End access to /...../htdocs/societe/soc.php 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:27 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:27 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:27 INFO ip.ip.ip.ip modulepart=societe original_file=2//logos/thumbs/logo_small.png 2016-12-23 10:02:27 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/societe/2//logos/thumbs/logo_small.png content-type=image/png 2016-12-23 10:02:27 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/card.php 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:29 INFO ip.ip.ip.ip Fournisseur::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Fournisseur::fetch_optionals 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT COUNT(n.rowid) as nb FROM llx_notify_def as n WHERE fk_soc = 2 2016-12-23 10:02:29 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/societe/2 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'societe' AND objectid = 2 AND entity = 1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT MAX(te.rowid) FROM llx_societe as te WHERE te.rowid < '2' AND te.fournisseur = 1 AND te.entity IN (1) 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT MIN(te.rowid) FROM llx_societe as te WHERE te.rowid > '2' AND te.fournisseur = 1 AND te.entity IN (1) 2016-12-23 10:02:29 INFO ip.ip.ip.ip Fournisseur::check_codefournisseur code_fournisseur=SU1301-0002 module=mod_codeclient_monkey 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip mod_codeclient_monkey::verif_dispo 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT code_client FROM llx_societe WHERE code_client = 'SU1301-0002' AND entity IN (1) AND rowid <> 2 2016-12-23 10:02:29 INFO ip.ip.ip.ip mod_codeclient_monkey::verif type=1 result=0 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip useLocalTax 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip useLocalTax 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_fournisseur as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_soc = 2 AND c.type = 1 AND c.entity IN (1) 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Categorie::fetch 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type FROM llx_categorie WHERE rowid = '3' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'categories' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description FROM llx_categorie_lang WHERE fk_category=3 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 3 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT count(pfp.rowid) as nb FROM llx_product_fournisseur_price as pfp WHERE pfp.entity = 1 AND pfp.fk_soc = 2 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.ref, p.label, p.fk_product_type, p.entity, pfp.tms, pfp.ref_fourn as supplier_ref, pfp.price, pfp.quantity, pfp.unitprice FROM llx_product_fournisseur_price as pfp LEFT JOIN llx_product as p ON p.rowid = pfp.fk_product WHERE p.entity IN (1) AND pfp.fk_soc = 2 ORDER BY pfp.tms DESC LIMIT 5 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT s.nom, s.rowid as socid, s.client, c.rowid, c.ref, c.total_ht, c.ref_supplier, c.date_valid, c.date_commande, c.date_livraison, c.fk_statut FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND s.rowid = 2 AND c.fk_statut IN (5) AND c.billed = 0 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT count(p.rowid) as total FROM llx_commande_fournisseur as p WHERE p.fk_soc =2 AND p.entity =1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT p.rowid,p.ref, p.date_commande as dc, p.fk_statut, p.total_ht, p.tva as total_tva, p.total_ttc FROM llx_commande_fournisseur as p WHERE p.fk_soc =2 AND p.entity =1 ORDER BY p.date_commande DESC LIMIT 5 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Translate::loadCacheCurrencies 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT f.rowid,f.libelle,f.ref,f.ref_supplier,f.fk_statut,f.datef as df, f.total_ht, f.total_tva, f.total_ttc as amount,f.paye, SUM(pf.amount) as am FROM llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON f.rowid=pf.fk_facturefourn WHERE f.fk_soc = 2 AND f.entity =1 GROUP BY f.rowid,f.libelle,f.ref,f.ref_supplier,f.fk_statut,f.datef,f.total_ht,f.total_tva,f.total_ttc,f.paye ORDER BY f.datef DESC 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip core/lib/company.lib.php :: show_contacts 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.lastname, p.firstname, p.fk_pays as country_id, p.civility, p.poste, p.phone as phone_pro, p.phone_mobile, p.phone_perso, p.fax, p.email, p.skype, p.statut , p.civility as civility_id, p.address, p.zip, p.town FROM llx_socpeople as p WHERE p.fk_soc = 2 AND p.statut = 1 ORDER BY p.lastname ASC 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip Company.lib::getCountry 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=17 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/card.php 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 INFO ip.ip.ip.ip modulepart=societe original_file=2//logos/thumbs/logo_small.png 2016-12-23 10:02:29 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/societe/2//logos/thumbs/logo_small.png content-type=image/png 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 INFO ip.ip.ip.ip modulepart=product original_file=/9/8/6789/photos/thumbs/housse-de-protection_small.jpg 2016-12-23 10:02:29 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/produit//9/8/6789/photos/thumbs/housse-de-protection_small.jpg content-type=image/jpeg 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:29 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- Access to /...../htdocs/viewimage.php 2016-12-23 10:02:29 INFO ip.ip.ip.ip modulepart=product original_file=/5/0/5/photos/thumbs/capiton_small.jpg 2016-12-23 10:02:29 INFO ip.ip.ip.ip viewimage.php return file /...../...../...../...../documents/produit//5/0/5/photos/thumbs/capiton_small.jpg content-type=image/jpeg 2016-12-23 10:02:29 INFO ip.ip.ip.ip --- End access to /...../htdocs/viewimage.php 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:30 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/facture/list.php 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT f.rowid as facid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement as datelimite, f.total_ht, f.total_ttc, f.total_tva as total_vat, f.paye as paye, f.fk_statut as fk_statut, f.libelle as label, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, p.rowid as project_id, p.ref as project_ref FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_facture_fourn as f LEFT JOIN llx_projet as p ON p.rowid = f.fk_projet WHERE f.fk_soc = s.rowid AND f.entity = 1 AND s.rowid = 2 ORDER BY f.datef DESC,f.rowid DESC 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT f.rowid as facid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement as datelimite, f.total_ht, f.total_ttc, f.total_tva as total_vat, f.paye as paye, f.fk_statut as fk_statut, f.libelle as label, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, p.rowid as project_id, p.ref as project_ref FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_facture_fourn as f LEFT JOIN llx_projet as p ON p.rowid = f.fk_projet WHERE f.fk_soc = s.rowid AND f.entity = 1 AND s.rowid = 2 ORDER BY f.datef DESC,f.rowid DESC LIMIT 51 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:30 INFO ip.ip.ip.ip Societe::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.statut, u.login FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY lastname ASC 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Form::select_dolusers 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.lastname ASC 2016-12-23 10:02:30 WARNING ip.ip.ip.ip Form::select_all_categories: using numeric value for parameter type is deprecated. Use string code instead. 2016-12-23 10:02:30 WARNING ip.ip.ip.ip Categorie::get_full_arbo(): numeric types are deprecated, please use string instead 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::load_motherof 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1) 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::get_full_arbo get category list 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent, t.label as label_trans, t.description as description_trans FROM llx_categorie as c LEFT JOIN llx_categorie_lang as t ON t.fk_category=c.rowid AND t.lang='fr_FR' WHERE c.entity IN (1) AND c.type = 0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::get_full_arbo call to build_path_from_id_categ 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=6 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=9 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=10 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=11 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=12 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=13 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=14 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=15 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=16 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=17 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=18 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=19 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=20 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=21 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=22 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=23 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=24 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=25 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=26 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=27 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=28 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=29 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=30 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=31 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=32 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=33 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=34 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=35 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=36 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=37 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=38 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=39 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=40 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=41 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=42 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=43 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=44 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=45 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=46 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=47 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=48 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=49 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=50 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=51 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=52 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=53 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=54 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=55 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=56 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=57 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=58 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=59 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=60 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=61 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=62 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=63 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=64 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=65 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=66 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=67 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=68 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=69 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=70 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=71 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=72 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=73 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=74 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=75 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=76 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=77 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=78 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=79 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=80 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=81 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=82 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=83 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=84 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=85 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=86 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=87 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=88 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=89 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=90 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=91 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=92 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=93 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=94 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=95 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=96 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=97 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=98 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=99 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=100 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=101 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=102 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=103 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=104 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=105 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=106 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=107 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=108 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=109 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=110 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=111 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=112 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=113 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=114 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=115 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=116 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=117 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=118 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=119 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=120 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=121 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=122 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=123 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=124 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=125 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=126 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=127 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=128 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=129 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=130 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=131 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=132 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=133 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=134 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=135 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=136 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=137 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=138 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=139 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=140 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=141 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=142 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=143 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=144 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=145 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=146 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=147 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=148 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=149 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=150 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=151 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=152 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=153 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=154 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=155 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=156 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=157 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=158 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=159 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=160 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=161 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=162 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=163 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=164 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=165 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=166 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=167 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=168 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=169 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=170 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=171 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=172 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=173 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=174 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=175 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=176 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=177 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::build_path_from_id_categ id_categ=178 protection=0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Categorie::get_full_arbo dol_sort_array 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Form::select_types_paiements , search_paymentmode, , 0 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Form::load_cache_types_paiements 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PRO' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PPL' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PBX' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'KWX' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CBPBX' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'ETRANS' 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:30 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'AMA' 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/5/4/SI1611-1289 types=files recursive=0 filter=SI1611-1289[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/0/1/SI1610-1254 types=files recursive=0 filter=SI1610-1254[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/2/9/SI1609-1236 types=files recursive=0 filter=SI1609-1236[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/6/8/SI1609-1230 types=files recursive=0 filter=SI1609-1230[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/1/8/SI1609-1226 types=files recursive=0 filter=SI1609-1226[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/0/8/SI1609-1225 types=files recursive=0 filter=SI1609-1225[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/6/SI1609-1209 types=files recursive=0 filter=SI1609-1209[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/7/SI1609-1218 types=files recursive=0 filter=SI1609-1218[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/4/SI1608-1190 types=files recursive=0 filter=SI1608-1190[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/4/SI1607-1191 types=files recursive=0 filter=SI1607-1191[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/4/SI1607-1194 types=files recursive=0 filter=SI1607-1194[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/6/4/SI1607-1193 types=files recursive=0 filter=SI1607-1193[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/1/1/SI1607-1255 types=files recursive=0 filter=SI1607-1255[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/2/SI1607-1173 types=files recursive=0 filter=SI1607-1173[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/2/SI1607-1172 types=files recursive=0 filter=SI1607-1172[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/5/4/SI1607-1192 types=files recursive=0 filter=SI1607-1192[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/1/0/SI1607-1151 types=files recursive=0 filter=SI1607-1151[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/0/0/SI1607-1150 types=files recursive=0 filter=SI1607-1150[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/9/9/SI1607-1149 types=files recursive=0 filter=SI1607-1149[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/0/1/SI1607-1160 types=files recursive=0 filter=SI1607-1160[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/6/0/SI1606-1156 types=files recursive=0 filter=SI1606-1156[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/2/0/SI1606-1152 types=files recursive=0 filter=SI1606-1152[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/0/SI1606-1157 types=files recursive=0 filter=SI1606-1157[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/0/SI1606-1153 types=files recursive=0 filter=SI1606-1153[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/1/SI1606-1163 types=files recursive=0 filter=SI1606-1163[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/5/0/SI1606-1155 types=files recursive=0 filter=SI1606-1155[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/0/SI1606-1154 types=files recursive=0 filter=SI1606-1154[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/7/SI1606-1125 types=files recursive=0 filter=SI1606-1125[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/9/6/SI1606-1121 types=files recursive=0 filter=SI1606-1121[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/2/1/SI1606-1162 types=files recursive=0 filter=SI1606-1162[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/4/SI1606-1096 types=files recursive=0 filter=SI1606-1096[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/4/SI1606-1095 types=files recursive=0 filter=SI1606-1095[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/6/4/SI1606-1098 types=files recursive=0 filter=SI1606-1098[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/1/1/SI1606-1161 types=files recursive=0 filter=SI1606-1161[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/2/4/SI1606-1094 types=files recursive=0 filter=SI1606-1094[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/1/4/SI1606-1093 types=files recursive=0 filter=SI1606-1093[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/4/SI1606-1099 types=files recursive=0 filter=SI1606-1099[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/0/4/SI1606-1092 types=files recursive=0 filter=SI1606-1092[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/9/3/SI1606-1091 types=files recursive=0 filter=SI1606-1091[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/5/4/SI1606-1097 types=files recursive=0 filter=SI1606-1097[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/9/4/SI1605-1101 types=files recursive=0 filter=SI1605-1101[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/8/4/SI1605-1100 types=files recursive=0 filter=SI1605-1100[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/8/3/SI1606-1090 types=files recursive=0 filter=SI1606-1090[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/3/SI1606-1089 types=files recursive=0 filter=SI1606-1089[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/1/SI1605-1069 types=files recursive=0 filter=SI1605-1069[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/6/1/SI1605-1068 types=files recursive=0 filter=SI1605-1068[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/7/0/SI1605-1059 types=files recursive=0 filter=SI1605-1059[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/9/0/SI1605-1159 types=files recursive=0 filter=SI1605-1159[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/4/1/SI1605-1066 types=files recursive=0 filter=SI1605-1066[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/1/SI1605-1065 types=files recursive=0 filter=SI1605-1065[^-]+ excludefilter="\.meta$|\.png$" 2016-12-23 10:02:30 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/facture/list.php 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:33 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/facture/card.php 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=1413 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch_lines 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2 , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=1413 ORDER BY f.rang, f.rowid 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 INFO ip.ip.ip.ip Societe::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=1413 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch_lines 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2 , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=1413 ORDER BY f.rang, f.rowid 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 INFO ip.ip.ip.ip Societe::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Societe::fetch_optionals 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 INFO ip.ip.ip.ip Fournisseur::fetch 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.phone, s.fax, s.email, s.skype, 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_client, s.mode_reglement, s.cond_reglement, 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.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 FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Fournisseur::fetch_optionals 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, 12qlx7 FROM llx_societe_extrafields WHERE fk_object = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::liste_contact 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =1413 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::liste_contact 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =1413 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2016-12-23 10:02:33 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/1/SI1605-1065 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 1413 AND entity = 1 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < 'SI1605-1065' AND te.entity IN (1) 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > 'SI1605-1065' AND te.entity IN (1) 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 1413 AND type = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.id as paiement_type, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label FROM llx_paiementfourn as p LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_paiementfourn_facturefourn as pf ON pf.fk_paiementfourn = p.rowid WHERE pf.fk_facturefourn = 1413 ORDER BY p.datep, p.tms 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Form::load_cache_conditions_paiements 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE active > 0 ORDER BY sortorder 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Form::load_cache_types_paiements 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PRO' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PPL' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'PBX' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'KWX' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CBPBX' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'ETRANS' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::getLabelFromKey 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'AMA' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Account::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_bank_account as ba LEFT JOIN llx_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid WHERE entity IN (1) AND ba.rowid = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'bank_account' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::getSommePaiement 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1413 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Translate::loadCacheCurrencies 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn_det' ORDER BY pos 2016-12-23 10:02:33 INFO ip.ip.ip.ip Product::fetch id=1569 ref= ref_ext= 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1569 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Product::fetch_optionals 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, longdescript, cyberprice FROM llx_product_extrafields WHERE fk_object = 1569 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description, note FROM llx_product_lang WHERE fk_product=1569 2016-12-23 10:02:33 INFO ip.ip.ip.ip Product::fetch id=1569 ref= ref_ext= 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, ref, ref_ext, label, description, url, note, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1569 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip Product::fetch_optionals 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, longdescript, cyberprice FROM llx_product_extrafields WHERE fk_object = 1569 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT lang, label, description, note FROM llx_product_lang WHERE fk_product=1569 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::getSommePaiement 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1413 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip /core/lib/function2.lib.php::getListOfModels 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2016-12-23 10:02:33 INFO ip.ip.ip.ip files.lib.php::dol_dir_list path=/...../...../...../...../documents/fournisseur/facture/3/1/SI1605-1065 types=files recursive=0 filter= excludefilter="(\.meta|_preview\.png)$" 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetchObjectLink 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '1413' AND sourcetype = 'invoice_supplier') OR (fk_target = '1413' AND targettype = 'invoice_supplier') ORDER BY sourcetype 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip CommandeFournisseur::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity = 1 AND c.rowid=701 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip CommandeFournisseur::fetchObjectLink 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '701' AND sourcetype = 'order_supplier') OR (fk_target = '701' AND targettype = 'order_supplier') ORDER BY sourcetype 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=1413 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture_fourn' ORDER BY pos 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip FactureFournisseur::fetch_lines 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2 , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=1413 ORDER BY f.rang, f.rowid 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip CommandeFournisseur::fetch get lines 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 701 ORDER BY l.rang, l.rowid 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT s.rowid as socid, s.nom as name, s.client, c.rowid, c.ref, c.ref_supplier, c.total_ht FROM llx_societe as s, llx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.fk_soc = 2 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ActionComm::getActions 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1413 AND a.elementtype = 'invoice_supplier' 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip ActionComm::fetch 2016-12-23 10:02:33 DEBUG ip.ip.ip.ip sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=3770 2016-12-23 10:02:33 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/facture/card.php 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:34 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/paiement/card.php 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity = 1 ORDER BY position 2016-12-23 10:02:34 DEBUG ip.ip.ip.ip sql=SELECT p.rowid, p.ref, p.entity, p.datep as dp, p.amount, p.statut, p.fk_bank, c.code as paiement_code, c.libelle as paiement_type, p.num_paiement, p.note, b.fk_account FROM llx_c_paiement as c, llx_paiementfourn as p LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid WHERE p.fk_paiement = c.id AND p.rowid = 1120 2016-12-23 10:02:34 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/paiement/card.php 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip This is an already logged session. _SESSION['dol_login']=nicolas 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip User::fetch 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, 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.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'nicolas' 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip ExtraFields::fetch_name_optionals_label 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip User::getrights 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-12-23 10:02:38 INFO ip.ip.ip.ip --- Access to /...../htdocs/fourn/paiement/info.php 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2016-12-23 10:02:38 DEBUG ip.ip.ip.ip sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2016-12-23 10:02:38 INFO ip.ip.ip.ip --- End access to /...../htdocs/fourn/paiement/info.php

Dolibarr / dolibarr

Bug-No-FIX: Old Supplier Regulation on 4.0.2 #6024

Bug

Environment