Queda el evento registrado de validación, pero el mail no sale.
Los querys que creo son relevantes:
SELECT id, code, type, libelle, module, active,todo,color,picto,position FROM `core_c_actioncomm` WHERE `id`=3
3; AC_PROP; systemauto; Send commercial proposal by email; propal; 1; 10
SELECT rowid, elementtype, code, label, description,rang FROM `core_c_action_trigger` WHERE `rowid`=3
3; propal; PROPAL_VALIDATE; Customer proposal validated; Executed when a commercial proposal is validated; 2
Adjunto un extracto del log, donde asumo podría estar el error, no me deja insertarlo como adjunto.
Código: Seleccionar todo
2017-04-06 14:39:40 DEBUG 192.168.0.1 Propal::fetch
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT p.rowid, p.ref, p.remise, p.remise_percent, p.remise_absolue, p.fk_soc, p.total, p.tva, p.localtax1, p.localtax2, p.total_ht, p.datec, p.date_valid as datev, p.datep as dp, p.fin_validite as dfv, p.date_livraison as date_livraison, p.model_pdf, p.ref_client, p.extraparams, p.note_private, p.note_public, p.fk_projet, p.fk_statut, p.fk_user_author, p.fk_user_valid, p.fk_user_cloture, p.fk_delivery_address, p.fk_availability, p.fk_input_reason, p.fk_cond_reglement, p.fk_mode_reglement, p.fk_account, p.fk_shipping_method, p.fk_incoterms, p.location_incoterms, p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc, i.libelle as libelle_incoterms, c.label as statut_label, ca.code as availability_code, ca.label as availability, dr.code as demand_reason_code, dr.label as demand_reason, cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, cp.code as mode_reglement_code, cp.libelle as mode_reglement FROM core_c_propalst as c, core_propal as p LEFT JOIN core_c_paiement as cp ON p.fk_mode_reglement = cp.id LEFT JOIN core_c_payment_term as cr ON p.fk_cond_reglement = cr.rowid LEFT JOIN core_c_availability as ca ON p.fk_availability = ca.rowid LEFT JOIN core_c_input_reason as dr ON p.fk_input_reason = dr.rowid LEFT JOIN core_c_incoterms as i ON p.fk_incoterms = i.rowid WHERE p.fk_statut = c.id AND p.entity IN (1) AND p.rowid=2
2017-04-06 14:39:40 DEBUG 192.168.0.1 ExtraFields::fetch_name_optionals_label
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM core_extrafields WHERE entity IN (0,1) AND elementtype = 'propal' ORDER BY pos
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product, d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type, d.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, d.date_start, d.date_end ,d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc FROM core_propaldet as d LEFT JOIN core_product as p ON d.fk_product = p.rowid WHERE d.fk_propal = 2 ORDER by d.rang
2017-04-06 14:39:40 DEBUG 192.168.0.1 ExtraFields::fetch_name_optionals_label
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM core_extrafields WHERE entity IN (0,1) AND elementtype = 'propaldet' ORDER BY pos
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 INFO 192.168.0.1 Societe::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 DEBUG 192.168.0.1 ExtraFields::fetch_name_optionals_label
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM core_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-04-06 14:39:40 DEBUG 192.168.0.1 BEGIN Transaction
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 INFO 192.168.0.1 Societe::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 DEBUG 192.168.0.1 ExtraFields::fetch_name_optionals_label
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM core_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-04-06 14:39:40 DEBUG 192.168.0.1 Propal::valid
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=UPDATE core_propal SET ref = 'PR1704-0002', fk_statut = 1, date_valid='20170406143940', fk_user_valid=1 WHERE rowid = 2 AND fk_statut = 0
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Triggers for file 'interface_20_modWorkflow_WorkflowManager.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Launch runTrigger for file 'interface_20_all_Logevents.class.php'
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php'
2017-04-06 14:39:40 INFO 192.168.0.1 Trigger 'ActionsAuto' for action 'PROPAL_VALIDATE' launched by /home/midominio.com/subdomains/midominio/core/triggers/interface_50_modAgenda_ActionsAuto.class.php. id=2
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 INFO 192.168.0.1 Societe::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.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.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM core_societe as s LEFT JOIN core_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN core_c_country as c ON s.fk_pays = c.rowid LEFT JOIN core_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN core_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN core_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN core_c_typent as te ON s.fk_typent = te.id LEFT JOIN core_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 1
2017-04-06 14:39:40 DEBUG 192.168.0.1 ExtraFields::fetch_name_optionals_label
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM core_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-04-06 14:39:40 DEBUG 192.168.0.1 CActionComm::fetch
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=SELECT id, code, type, libelle as label, color, active, picto FROM core_c_actioncomm WHERE code='AC_OTH_AUTO'
2017-04-06 14:39:40 DEBUG 192.168.0.1 ActionComm::add
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=INSERT INTO core_actioncomm(datec,datep,datep2,durationp,fk_action,code,fk_soc,fk_project,note,fk_contact,fk_user_author,fk_user_action,fk_user_done,label,percent,priority,fulldayevent,location,punctual,transparency,fk_element,elementtype,entity) VALUES ('20170406143940','20170406143940','20170406143940',null,40, 'AC_OTH_AUTO', '1',null, 'Presupuesto PR1704-0002 validado\nAutor: sastredba',null,'1','1',null,'Presupuesto PR1704-0002 validado','-1','0','0','','1','0',2,'propal',1)
2017-04-06 14:39:40 DEBUG 192.168.0.1 sql=INSERT INTO core_actioncomm_resources(fk_actioncomm, element_type, fk_element, mandatory, transparency, answer_status) VALUES(25, 'user', 1, 0, 0, 0)
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_20_modWorkflow_WorkflowManager.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled
2017-04-06 14:39:40 DEBUG 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Launch runTrigger for file 'interface_20_all_Logevents.class.php'
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php'
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=ACTION_CREATE Launch runTrigger for file 'interface_50_modNotification_Notification.class.php'
2017-04-06 14:39:40 INFO 192.168.0.1 Interfaces::run_triggers action=PROPAL_VALIDATE Launch runTrigger for file 'interface_50_modNotification_Notification.class.php'
2017-04-06 14:39:40 DEBUG 192.168.0.1 COMMIT Transaction
2017-04-06 14:39:40 DEBUG 192.168.0.1 Propal::fetch