Bonjour,
Depuis le passage en version 9.0, je ne peux plus envoyer de mail , j ai desactivé le CustomField, mais rien n y fait
je n ai meme pas l interface de mail
si qq un a une idée
Merci
2019-02-11 09:41:02 DEBUG 192.168.1.87 - This is an already logged session. _SESSION['dol_login']=nicolas _SESSION['dol_entity']=1
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'nicolas' ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 3 AND entity = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 3)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 3 AND r.perms IS NOT NULL
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 3 AND r.perms IS NOT NULL
2019-02-11 09:41:02 INFO 192.168.1.87 --- Access to /fourn/commande/card.php - action=presend, massaction=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR'
2019-02-11 09:41:02 DEBUG 192.168.1.87 Menubase::menuLoad mymainmenu=commercial myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2019-02-11 09:41:02 INFO 192.168.1.87 HookManager::initHooks Loading hook class for context ordersuppliercard: actions_restock.class.php
2019-02-11 09:41:02 INFO 192.168.1.87 HookManager::initHooks Loading hook class for context ordersuppliercard: actions_customfields.class.php
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, 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=63
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetch get lines
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, 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 = 63 ORDER BY l.rang, l.rowid
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.twitter, s.facebook, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 10805
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=societe
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsRestock, module=restock, action=presend context=ordersuppliercard
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 3 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, 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=63
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetch get lines
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, 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 = 63 ORDER BY l.rang, l.rowid
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.twitter, s.facebook, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity = 1) WHERE s.entity IN (1) AND s.rowid = 10805
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=societe
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::liste_contact
2019-02-11 09:41:02 DEBUG 192.168.1.87 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.login, t.photo, 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 =63 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::liste_contact
2019-02-11 09:41:02 DEBUG 192.168.1.87 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 =63 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC
2019-02-11 09:41:02 WARNING 192.168.1.87 Passing 5 values in tabs module_parts is deprecated. Please update to 6 with permissions.
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/fournisseur/commande/CF1902-0038 types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'order_supplier' AND objectid = 63 AND entity = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT MAX(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref < 'CF1902-0038' AND te.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT MIN(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref > 'CF1902-0038' AND te.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, code, libelle as label FROM llx_c_input_method WHERE active=1 AND rowid = 3
2019-02-11 09:41:02 DEBUG 192.168.1.87 DiscountAbsolute::getAvailableDiscounts
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 10805 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%'))
2019-02-11 09:41:02 DEBUG 192.168.1.87 DiscountAbsolute::getAvailableDiscounts
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 10805 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%'))
2019-02-11 09:41:02 DEBUG 192.168.1.87 Form::load_cache_conditions_paiements
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder
2019-02-11 09:41:02 DEBUG 192.168.1.87 ProductFournisseur::find_min_price_product_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 993 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 50
2019-02-11 09:41:02 INFO 192.168.1.87 ProductFournisseur::fetch id=1 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 ProductFournisseur::find_min_price_product_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 995 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 50
2019-02-11 09:41:02 INFO 192.168.1.87 ProductFournisseur::fetch id=1 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 ProductFournisseur::find_min_price_product_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 997 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 30
2019-02-11 09:41:02 INFO 192.168.1.87 ProductFournisseur::fetch id=1 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 ProductFournisseur::find_min_price_product_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 1001 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 120
2019-02-11 09:41:02 INFO 192.168.1.87 ProductFournisseur::fetch id=1 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 ProductFournisseur::find_min_price_product_fournisseur
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days ,pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.entity = 1 AND pfp.fk_product = 1004 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 120
2019-02-11 09:41:02 INFO 192.168.1.87 ProductFournisseur::fetch id=1 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsCustomFields, module=customfields, action=presend context=ordersuppliercard
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 WARNING 192.168.1.87 Error: Translate::Load was called but language was not set yet with langs->setDefaultLang(). Nothing will be loaded.
2019-02-11 09:41:02 DEBUG 192.168.1.87 CustomFields::probeTable_CustomFields sql=SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_SCHEMA='dolibarr'
AND TABLE_NAME='llx_commande_fournisseur_customfields';
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_SCHEMA='dolibarr'
AND TABLE_NAME='llx_commande_fournisseur_customfields';
2019-02-11 09:41:02 WARNING 192.168.1.87 Interfaces::run_triggers action=COMMANDE_FOURNISSEUR_CUSTOMFIELD_PROBETABLE Launch old method run_trigger (rename your trigger into runTrigger) for file 'interface_50_modCustomFields_SaveFields.class.php'
2019-02-11 09:41:02 WARNING 192.168.1.87 Warning, module LDAP is enabled but LDAP functions not available in this PHP
2019-02-11 09:41:02 DEBUG 192.168.1.87 COMMIT Transaction
2019-02-11 09:41:02 DEBUG 192.168.1.87 CustomFields::fetchFieldStruct_CustomFields sql=SELECT c.ordinal_position,c.column_name,c.column_default,c.is_nullable,c.data_type,c.column_type,c.character_maximum_length,
k.referenced_table_name, k.referenced_column_name, k.constraint_name,
s.index_name,
e.extraoptions
FROM (SELECT * FROM information_schema.columns
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as c
LEFT OUTER JOIN (SELECT * FROM information_schema.key_column_usage
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as k USING(table_schema, table_name, column_name)
LEFT OUTER JOIN (SELECT * FROM information_schema.statistics
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as s USING(table_schema, table_name, column_name)
LEFT OUTER JOIN (SELECT * FROM llx_customfields_extraoptions
WHERE table_name = 'llx_commande_fournisseur_customfields') as e ON(e.table_name=c.table_name AND e.column_name=c.column_name)
ORDER BY c.ordinal_position;
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT c.ordinal_position,c.column_name,c.column_default,c.is_nullable,c.data_type,c.column_type,c.character_maximum_length,
k.referenced_table_name, k.referenced_column_name, k.constraint_name,
s.index_name,
e.extraoptions
FROM (SELECT * FROM information_schema.columns
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as c
LEFT OUTER JOIN (SELECT * FROM information_schema.key_column_usage
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as k USING(table_schema, table_name, column_name)
LEFT OUTER JOIN (SELECT * FROM information_schema.statistics
WHERE table_schema = 'dolibarr' AND table_name = 'llx_commande_fournisseur_customfields' AND column_name != 'rowid' AND column_name != 'fk_commande_fournisseur') as s USING(table_schema, table_name, column_name)
LEFT OUTER JOIN (SELECT * FROM llx_customfields_extraoptions
WHERE table_name = 'llx_commande_fournisseur_customfields') as e ON(e.table_name=c.table_name AND e.column_name=c.column_name)
ORDER BY c.ordinal_position;
2019-02-11 09:41:02 WARNING 192.168.1.87 Interfaces::run_triggers action=COMMANDE_FOURNISSEUR_CUSTOMFIELD_FETCHFIELD Launch old method run_trigger (rename your trigger into runTrigger) for file 'interface_50_modCustomFields_SaveFields.class.php'
2019-02-11 09:41:02 WARNING 192.168.1.87 Warning, module LDAP is enabled but LDAP functions not available in this PHP
2019-02-11 09:41:02 DEBUG 192.168.1.87 COMMIT Transaction
2019-02-11 09:41:02 DEBUG 192.168.1.87 CustomFields::fetch_CustomFields sql=SELECT * FROM llx_commande_fournisseur_customfields WHERE fk_commande_fournisseur=63 LIMIT 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT * FROM llx_commande_fournisseur_customfields WHERE fk_commande_fournisseur=63 LIMIT 1
2019-02-11 09:41:02 WARNING 192.168.1.87 Interfaces::run_triggers action=COMMANDE_FOURNISSEUR_CUSTOMFIELD_FETCHRECORD Launch old method run_trigger (rename your trigger into runTrigger) for file 'interface_50_modCustomFields_SaveFields.class.php'
2019-02-11 09:41:02 WARNING 192.168.1.87 Warning, module LDAP is enabled but LDAP functions not available in this PHP
2019-02-11 09:41:02 DEBUG 192.168.1.87 COMMIT Transaction
2019-02-11 09:41:02 DEBUG 192.168.1.87 Translate::loadCacheCurrencies
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR'
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 Product::fetch id=993 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 993
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=product
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, col FROM llx_product_extrafields WHERE fk_object = 993
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/produit/P000080/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/P000080' AND entity = 1
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 Product::fetch id=995 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 995
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=product
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, col FROM llx_product_extrafields WHERE fk_object = 995
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/produit/P000082/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/P000082' AND entity = 1
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 Product::fetch id=997 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 997
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=product
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, col FROM llx_product_extrafields WHERE fk_object = 997
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/produit/P000084/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/P000084' AND entity = 1
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 Product::fetch id=1001 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1001
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=product
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, col FROM llx_product_extrafields WHERE fk_object = 1001
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/produit/P000088/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/P000088' AND entity = 1
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=commande_fournisseurdet
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 Product::fetch id=1004 ref= ref_ext=
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1004
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=product
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, col FROM llx_product_extrafields WHERE fk_object = 1004
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/produit/P000091/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/P000091' AND entity = 1
2019-02-11 09:41:02 DEBUG 192.168.1.87 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsRestock, module=restock, action=presend context=ordersuppliercard
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetchObjectLink
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 63 AND sourcetype = 'order_supplier') OR (fk_target = 63 AND targettype = 'order_supplier') ORDER BY sourcetype
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/fournisseur/commande/CF1902-0038 types=files recursive=0 filter= excludefilter="(\.meta|_preview.*.*\.png)$"
2019-02-11 09:41:02 DEBUG 192.168.1.87 /core/lib/function2.lib.php::getListOfModels
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'order_supplier' AND entity IN (0,1) ORDER BY description DESC
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.facnumber as ref, t.ref_client, t.total as total_ht FROM llx_societe as s, llx_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref FROM llx_societe as s, llx_fichinter as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, '' as ref_supplier, t.total_ht FROM llx_societe as s, llx_supplier_proposal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM llx_societe as s, llx_facture_fourn as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (10805) AND t.entity IN (1)
2019-02-11 09:41:02 DEBUG 192.168.1.87 CommandeFournisseur::fetchObjectLink
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 63 AND sourcetype = 'order_supplier') OR (fk_target = 63 AND targettype = 'order_supplier') ORDER BY sourcetype
2019-02-11 09:41:02 DEBUG 192.168.1.87 ActionComm::getActions
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 63 AND a.elementtype = 'order_supplier' ORDER BY a.datep DESC, a.id DESC
2019-02-11 09:41:02 DEBUG 192.168.1.87 ActionComm::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=7504
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 7504 AND element_type IN ('user', 'socpeople')
2019-02-11 09:41:02 DEBUG 192.168.1.87 ActionComm::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=7503
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 7503 AND element_type IN ('user', 'socpeople')
2019-02-11 09:41:02 DEBUG 192.168.1.87 ActionComm::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=7502
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 7502 AND element_type IN ('user', 'socpeople')
2019-02-11 09:41:02 DEBUG 192.168.1.87 ActionComm::fetch
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=7501
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 7501 AND element_type IN ('user', 'socpeople')
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC
2019-02-11 09:41:02 INFO 192.168.1.87 fetch_name_optionals_label elementtype=user
2019-02-11 09:41:02 DEBUG 192.168.1.87 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2019-02-11 09:41:02 INFO 192.168.1.87 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/fournisseur/commande/CF1902-0038 types=files recursive=0 filter=CF1902\-0038[^\-]+ excludefilter=["(\.meta|_preview.*\.png)$","^\."]
2019-02-11 09:41:02 DEBUG 192.168.1.87
Bonjour,
Et bien déjà, si vous nous disiez si c’est une mise à jour. Et si oui à partir de quelle version ?
Quel système ? Hébergé local ? Distant ? Dolibarr en archive ?
Avez-vous vérifié les logs apache ?
Frédéric
Désactiver ne suffit pas, il faut supprimer les fichiers !
Pour moi, la question serait : à partir de quelle page, ou quelle action.
il s agit effectivement d une maj, a partir de la version 8.0, sur linux kde, hebergé en local, tout les envois de mail sont impacté ( facture , comande, …)
Effectivement j ai supprimé les fichiers , les mails refonctionne
Merci a tous
