C’était ma première config mais vu que cela ne fonctionnait pas j’ai essayé autre chose
ok en ce cas on retourne toujours au même point: passage en mode debug et analyse des logs
→ Basculer dolibarr en mode "debug" [CAP-REL - Documentation publique]
pensez bien à désactiver le mode debug après …
2023-02-27 15:44:43 ERR 37.65.38.156 CMailFile::sendfile: mail end error=Failed to send mail with smtps lib to HOST=ssl://mail.mondomaine.fr, PORT=465 - Sender address ‹ › invalid
Je reproduit le même problème
On dirait qu’il ne récupère pas le from=
2023-02-27 15:52:26 DEBUG 92.184.124.15 CMailFile::CMailfile: sendmode=smtps charset=UTF-8 from=, [email protected], addr_cc=, addr_bcc=, errors_to=, replyto= trackid= sendcontext=standard
2023-02-27 15:52:26 DEBUG 92.184.124.15 CMailFile::CMailfile: subject=ticket de caisse, deliveryreceipt=0, msgishtml=1
2023-02-27 15:52:26 ERR 92.184.124.15 CMailFile::sendfile: mail end error=Failed to send mail with smtps lib to HOST=ssl://mail.mondomaine.fr, PORT=465 - Sender address '' invalid
2023-02-27 15:52:26 INFO 92.184.124.15 --- End access to /takepos/send.php
2
ok @Tonio-APEIF et @rom
on le sait déjà que le from est vide, il ne faut pas bloquer sur la ligne ERR dans les logs mais remonter la pile des appels pour ensuite chercher dans le code source pourquoi le from est vide
2023-02-27 15:44:40 NOTICE 37.65.38.156 --- Access to GET /htdocs/takepos/send.php - action=, massaction= NOTOKENRENEWAL=1
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-02-27 15:44:40 DEBUG 37.65.38.156 Facture::fetch
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=36
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos
2023-02-27 15:44:40 DEBUG 37.65.38.156 Facture::fetch_lines
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 36 ORDER BY l.rang, l.rowid
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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.entity IN (1) AND s.rowid = 3
2023-02-27 15:44:40 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-02-27 15:44:40 INFO 37.65.38.156 --- End access to /htdocs/takepos/send.php
2023-02-27 15:44:43 DEBUG 37.65.38.156 - This is an already logged session. _SESSION['dol_login']=MonLogin _SESSION['dol_entity']=1
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, 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 = 'MonLogin' ORDER BY u.entity ASC
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 5 AND entity = 1
2023-02-27 15:44:43 DEBUG 37.65.38.156 DefaultValues::fetchAll
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,5) AND entity IN (1,1))
2023-02-27 15:44:43 DEBUG 37.65.38.156 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 5 AND r.perms IS NOT NULL
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 5 AND r.perms IS NOT NULL
2023-02-27 15:44:43 NOTICE 37.65.38.156 --- Access to GET /htdocs/takepos/send.php - action=send, massaction= NOTOKENRENEWAL=1
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-02-27 15:44:43 DEBUG 37.65.38.156 Facture::fetch
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=36
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facture' ORDER BY pos
2023-02-27 15:44:43 DEBUG 37.65.38.156 Facture::fetch_lines
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 36 ORDER BY l.rang, l.rowid
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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.entity IN (1) AND s.rowid = 3
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT rowid, module, label, type_template, topic, joinfiles, content, content_lines, lang FROM llx_c_email_templates WHERE (type_template='facture_send' OR type_template='all') AND entity IN (0,1) AND (private = 0 OR fk_user = 5) AND active = 1 AND rowid=19 ORDER BY position ASC, lang ASC, label ASC
2023-02-27 15:44:43 DEBUG 37.65.38.156 Facture::fetch
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=36
2023-02-27 15:44:43 DEBUG 37.65.38.156 Facture::fetch_lines
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 36 ORDER BY l.rang, l.rowid
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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.entity IN (1) AND s.rowid = 3
2023-02-27 15:44:43 DEBUG 37.65.38.156 Translate::loadCacheCurrencies
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR'
2023-02-27 15:44:43 DEBUG 37.65.38.156 sql=SELECT p.pos_change as pos_change, p.datep as date, p.fk_paiement, p.num_paiement as num, pf.amount as amount, pf.multicurrency_amount, cp.code FROM llx_paiement_facture as pf, llx_paiement as p LEFT JOIN llx_c_paiement as cp ON p.fk_paiement = cp.id WHERE pf.fk_paiement = p.rowid AND pf.fk_facture = 36 ORDER BY p.datep
2023-02-27 15:44:43 DEBUG 37.65.38.156 CMailFile::CMailfile: sendmode=smtps charset=UTF-8 from=, to=destinataire.fr, addr_cc=, addr_bcc=, errors_to=, replyto= trackid= sendcontext=standard
2023-02-27 15:44:43 DEBUG 37.65.38.156 CMailFile::CMailfile: subject=Ticket de caisse, deliveryreceipt=0, msgishtml=1
2023-02-27 15:44:43 ERR 37.65.38.156 CMailFile::sendfile: mail end error=Failed to send mail with smtps lib to HOST=ssl://mail.mondomaine.fr, PORT=465 - Sender address '' invalid
2023-02-27 15:44:43 INFO 37.65.38.156 --- End access to /htdocs/takepos/send.php
Je ne sais pas si ça peur aider
Je ne sais pas si mondomaine.fr est enregistré.
Mais, un serveur smtp n’autorisera uniquement comme expéditeurs, les adresses du même domaine.
Par exemple, j’ai paramétré la configuration avec le domaine posteo.net. L’adresse de l’émetteur est (par exemple) [email protected].
en remontant un peu plus dans l’historique, n’y aurait il pas un POST sur un fichier php qui serait le moment où votre formulaire dans lequel vous entrez l’adresse mail du destinataire serait envoyée au serveur ?
Je ne vois pas de POST. Et le reste du fichier comporte trop d’informations sensibles pour que je puisse le mettre en ligne
Bonjour,
L’adresse from est définie à cette ligne
Sauf que je ne vois pas où dans le code $mysoc est défini, ceci expliquerait pourquoi from reste vide.
Edit : $mysoc est défini dans master.inc.php chargé par main.inc.php lui même chargé par send.php
Question : le champ email pour la configuration de votre société est-il renseigné ?
1 « J'aime »
Bonjour vous avez trouvé la solution. Merci. Il fallait en effet renseigner l’adresse mail dans la société et non uniquement dans l’utilisateur.
Bravo !
et comme un idiot j’ai mis le doigt sur l’adresse mail de l’utilisateur et pas de la société pffff quel naze !
Bonjour,
J’utilise la v19 avec le module takePOS je ne trouvais pas le bouton pour envoyer un reçu par mail.
Puis je me suis dit que c’était parce que je n’avais pas créé de modèle d’email. Donc j’en ai créé un de type Factures. J’ai testé de faire un modèle incluant une pièce jointe et j’ai aussi testé sans.
Puis j’ai sélectionné ce modèle dans les paramètres du module TakePOS.
J’ai maintenant le bouton « Envoyer le ticket » mais idem que pour Rom : le mail ne part pas.
J’ai pourtant bien renseigné le mail dans config>Societe>email.
Je precise que mes autres envois de mails fonctionnent correctement.
Voici mes logs Debug. Si quelqu’un peut m’aider SVP :
2024-01-06 21:01:17 DEBUG 2.4.249.127 - This is an already logged session. _SESSION[‹ dol_login ›]=julien _SESSION[‹ dol_entity ›]=1
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, 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 = ‹ julien › ORDER BY u.entity ASC
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ user › ORDER BY pos
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1
2024-01-06 21:01:17 DEBUG 2.4.249.127 DefaultValues::fetchAll
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,2) AND entity IN (0,1))
2024-01-06 21:01:17 DEBUG 2.4.249.127 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 2 AND r.perms IS NOT NULL AND r.perms NOT LIKE ‹ %_advance ›
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL
2024-01-06 21:01:17 NOTICE 2.4.249.127 — Access to GET /takepos/send.php - action=, massaction= NOTOKENRENEWAL=1
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang=‹ fr_FR › OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-01-06 21:01:17 DEBUG 2.4.249.127 Facture::fetch
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT f.rowid, f.entity, f.ref, f.ref_client, f.ref_ext, f.type, f.subtype, f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut as status, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid = 123
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ facture › ORDER BY pos
2024-01-06 21:01:17 DEBUG 2.4.249.127 Facture::fetch_lines
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.batch, l.fk_warehouse, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc, p.barcode as product_barcode FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 123 ORDER BY l.rang, l.rowid
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ facturedet › ORDER BY pos
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.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.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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.entity IN (1) AND s.rowid = 7
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ societe › ORDER BY pos
2024-01-06 21:01:17 INFO 2.4.249.127 — End access to /takepos/send.php
2024-01-06 21:01:17 DEBUG 2.4.249.127 DefaultValues::fetchAll
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,0) AND entity IN (1,1))
2024-01-06 21:01:17 NOTICE 2.4.249.127 — Access to GET /takepos/css/pos.css.php - action=, massaction= NOTOKENRENEWAL=1
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang=‹ fr_FR › OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-01-06 21:01:17 DEBUG 2.4.249.127 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, 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.type DESC, m.position, m.rowid
2024-01-06 21:01:17 INFO 2.4.249.127 — End access to /takepos/css/pos.css.php
2024-01-06 21:01:20 DEBUG 2.4.249.127 - This is an already logged session. _SESSION[‹ dol_login ›]=julien _SESSION[‹ dol_entity ›]=1
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, 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 = ‹ julien › ORDER BY u.entity ASC
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ user › ORDER BY pos
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1
2024-01-06 21:01:20 DEBUG 2.4.249.127 DefaultValues::fetchAll
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,2) AND entity IN (0,1))
2024-01-06 21:01:20 DEBUG 2.4.249.127 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 2 AND r.perms IS NOT NULL AND r.perms NOT LIKE ‹ %_advance ›
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL
2024-01-06 21:01:20 NOTICE 2.4.249.127 — Access to GET /takepos/send.php - action=send, massaction= NOTOKENRENEWAL=1
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where (lang=‹ fr_FR › OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-01-06 21:01:20 DEBUG 2.4.249.127 Facture::fetch
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT f.rowid, f.entity, f.ref, f.ref_client, f.ref_ext, f.type, f.subtype, f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut as status, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid = 123
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ facture › ORDER BY pos
2024-01-06 21:01:20 DEBUG 2.4.249.127 Facture::fetch_lines
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.batch, l.fk_warehouse, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc, p.barcode as product_barcode FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 123 ORDER BY l.rang, l.rowid
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ facturedet › ORDER BY pos
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.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.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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.entity IN (1) AND s.rowid = 7
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ societe › ORDER BY pos
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT rowid, module, label, type_template, topic, email_from, joinfiles, content, content_lines, lang, email_from, email_to, email_tocc, email_tobcc FROM llx_c_email_templates WHERE (type_template = ‹ facture_send › OR type_template = ‹ all ›) AND entity IN (0,1) AND (private = 0 OR fk_user = 2) AND active = 1 AND rowid = 53 ORDER BY position ASC, lang ASC, label ASC
2024-01-06 21:01:20 DEBUG 2.4.249.127 Facture::fetch
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT f.rowid, f.entity, f.ref, f.ref_client, f.ref_ext, f.type, f.subtype, f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut as status, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.fk_user_modif, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid = 123
2024-01-06 21:01:20 DEBUG 2.4.249.127 Facture::fetch_lines
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.batch, l.fk_warehouse, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc, p.barcode as product_barcode FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 123 ORDER BY l.rang, l.rowid
2024-01-06 21:01:20 DEBUG 2.4.249.127 Translate::loadCacheCurrencies
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2024-01-06 21:01:20 DEBUG 2.4.249.127 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.entity IN (1) AND t.localtax1_type <> ‹ 0 ›
2024-01-06 21:01:20 DEBUG 2.4.249.127 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.entity IN (1) AND t.localtax2_type <> ‹ 0 ›
2024-01-06 21:01:20 DEBUG 2.4.249.127 sql=SELECT p.pos_change as pos_change, p.datep as date, p.fk_paiement, p.num_paiement as num, f.multicurrency_code, pf.amount as amount, pf.multicurrency_amount, cp.code FROM llx_paiement_facture as pf, llx_facture as f, llx_paiement as p LEFT JOIN llx_c_paiement as cp ON p.fk_paiement = cp.id WHERE pf.fk_facture = f.rowid AND pf.fk_paiement = p.rowid AND pf.fk_facture = 123 ORDER BY p.datep
2024-01-06 21:01:20 DEBUG 2.4.249.127 CMailFile::CMailfile: charset=UTF-8 [email protected], [email protected], addr_cc=, addr_bcc=, errors_to=, replyto= trackid= sendcontext=
2024-01-06 21:01:20 DEBUG 2.4.249.127 CMailFile::CMailfile: subject=Domaine de Bannières - Votre reçu, deliveryreceipt=0, msgishtml=1
2024-01-06 21:01:20 INFO 2.4.249.127 — End access to /takepos/send.php
Bonjour,
La V19 est une version bêta a ne pas utiliser en production
1 « J'aime »
La v19 est mon interface de test. Je suis encore en v14.0.5 en production… Mais effectivement ça fonctionne en v14 donc désolé pour mon post inutile.
