Bonjour à tous,
Nous utilisons un cron pour gérer les société et les contacts depuis un fichier csv distant. C’est un cron qui appelle le script.
La création de société ne marche pas.
Voici un extrait des logs
2017-10-20 12:47:45 INFO 83.152.44.246 Societe::create Ambassade de France à Oman
2017-10-20 12:47:45 DEBUG 83.152.44.246 BEGIN Transaction
2017-10-20 12:47:45 DEBUG 83.152.44.246 Societe::create
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=INSERT INTO llx_societe (nom, name_alias, entity, datec, fk_user_creat, canvas, status, ref_int, ref_ext, fk_stcomm, fk_incoterms, location_incoterms ,import_key, fk_multicurrency, multicurrency_code) VALUES ('Ambassade de France à Oman', '', 1, '20171020124745', null, null, 1, null, null, 0, 0, '', null, 0, '')
2017-10-20 12:47:45 INFO 83.152.44.246 Societe::Update id=15680 call_trigger=0 allowmodcodeclient=1 allowmodcodefournisseur=1
2017-10-20 12:47:45 INFO 83.152.44.246 Societe::update verify ok or not done
2017-10-20 12:47:45 DEBUG 83.152.44.246 Societe::Update
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=UPDATE llx_societe SET nom = 'Ambassade de France à Oman',name_alias = '',ref_ext = null,address = 'PO Box 208',zip = null,town = 'Mascate',fk_departement = '0',fk_pays = '174',phone = '[968]24681800',fax = '[968]24681882',email = null,skype = null,url = null,siren = '',siret = '',ape = '',idprof4 = '',idprof5 = '',idprof6 = '',tva_assuj = '1',tva_intra = '',status = 1,localtax1_assuj = null,localtax2_assuj = null,localtax1_value =0.000,localtax2_value =0.000,capital = null,prefix_comm = null,fk_effectif = null,fk_typent = 0,fk_forme_juridique = null,mode_reglement = null,cond_reglement = null,mode_reglement_supplier = null,cond_reglement_supplier = null,fk_shipping_method = null,client = 0,fournisseur = 0,barcode = null,default_lang = null,logo = null,outstanding_limit= null,fk_prospectlevel='',webservices_url = null,webservices_key = null, fk_incoterms = 0, location_incoterms = null, fk_user_modif = null, fk_multicurrency = 0, multicurrency_code = '' WHERE rowid = '15680'
2017-10-20 12:47:45 INFO 83.152.44.246 Loading hook:actions_supportparutioncontact.class.php
2017-10-20 12:47:45 INFO 83.152.44.246 HookManager::executeHooks method=insertExtraFields action=update context=thirdpartydao
2017-10-20 12:47:45 WARNING 83.152.44.246 Warning: The hook 'insertExtraFields' is deprecated and must not be used. Use instead trigger on CRUD event (ask it to dev team if not implemented)
2017-10-20 12:47:45 DEBUG 83.152.44.246 ExtraFields::fetch_name_optionals_label
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-10-20 12:47:45 DEBUG 83.152.44.246 Societe::insertExtraFields delete
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=DELETE FROM llx_societe_extrafields WHERE fk_object = 15680
2017-10-20 12:47:45 DEBUG 83.152.44.246 Societe::insertExtraFields insert
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=INSERT INTO llx_societe_extrafields (fk_object,adresse2,cedex,id_yoocan) VALUES (15680,'MSQ pc 115',null,'AMBAS.FRA.OMAN')
2017-10-20 12:47:45 INFO 83.152.44.246 Societe::Update success
2017-10-20 12:47:45 DEBUG 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2017-10-20 12:47:45 DEBUG 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Triggers for file 'interface_20_modWorkflow_WorkflowManager.class.php' need module to be enabled
2017-10-20 12:47:45 DEBUG 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled
2017-10-20 12:47:45 DEBUG 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled
2017-10-20 12:47:45 DEBUG 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled
2017-10-20 12:47:45 INFO 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Launch runTrigger for file 'interface_20_all_Logevents.class.php'
2017-10-20 12:47:45 INFO 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php'
2017-10-20 12:47:45 INFO 83.152.44.246 Trigger 'ActionsAuto' for action 'COMPANY_CREATE' launched by /home/yadlapoire/public_html/ird_prod/htdocs/core/triggers/interface_50_modAgenda_ActionsAuto.class.php. id=15680
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 15680
2017-10-20 12:47:45 INFO 83.152.44.246 Societe::fetch SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 15680
2017-10-20 12:47:45 DEBUG 83.152.44.246 ExtraFields::fetch_name_optionals_label
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-10-20 12:47:45 DEBUG 83.152.44.246 Societe::fetch_optionals
2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT rowid, adresse2, cedex, code_region, email2, date_maj_yoocan, id_yoocan FROM llx_societe_extrafields WHERE fk_object = 15680
2017-10-20 12:47:45 WARNING 83.152.44.246 You tried to create an event but mandatory property ownerid was not defined
2017-10-20 12:47:45 ERR 83.152.44.246 interface_modAgenda_ActionsAuto.class.php: Failed to insert event : ErrorPropertyUserowneridNotDefined
2017-10-20 12:47:45 ERR 83.152.44.246 Interfaces::run_triggers action=COMPANY_CREATE Files found: 7, Files launched: 2, Done: 0, Failed: 1 - Nb of error string returned in this->errors = 1
2017-10-20 12:47:45 ERR 83.152.44.246 Societe::Create echec update
2017-10-20 12:47:45 DEBUG 83.152.44.246 ROLLBACK Transaction
La function qui est sensé créer une société :
function creation_organisme($organisme, $status, $user) {
global $conf, $db;
if ($status == 'ACTIF' || $status == 'ETAT CONTACT') {
$organisme->statut = 1;
} else {
$organisme->statut = 0;
}
$result_creation_organisme = $organisme->create($user);
return $result_creation_organisme;
}
Toute aide sera grandement appréciée.