Are you sure the variable "$user" is defined correcty to an existing user ?
2017-10-20 14:19 GMT+02:00 Gilles Lengy <gilles.le...@artaban.fr>:
> Hello,
>
> I don't if this is the right place to post that kind of stuff...
>
> Sorry for any inconvenience.
>
>
> We use a cran that call a script to handle the socities and the contacts
> from a distant csv file.
>
> The socities are not created.
>
> Dolibarr 4.0.1.
>
> Here is an extract of the 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_option
> als_label
> 2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT
> rowid,name,label,type,size,elementtype,fieldunique,fieldrequ
> ired,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/i
> rd_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_option
> als_label
> 2017-10-20 12:47:45 DEBUG 83.152.44.246 sql=SELECT
> rowid,name,label,type,size,elementtype,fieldunique,fieldrequ
> ired,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
>
>
> The function that is supposed to create the socity :
>
> [code]
> 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;
> }
>
>
> We will be delight by any help.
>
> Best regards.
>
> --
> Gilles Lengy
>
> Artaban Communication
> 33 (0)1 40 09 18 18
> www.artaban.fr
> spip.artaban.fr
>
> Adhérent de l'April (www.april.org)
>
>
> _______________________________________________
> Dolibarr-dev mailing list
> Dolibarr-dev@nongnu.org
> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
>
--
EMail: e...@destailleur.fr
Web: http://www.destailleur.fr
------------------------------------------------------------------------------------
Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
Facebook: https://www.facebook.com/Destailleur.Laurent
Twitter: http://www.twitter.com/eldy10
------------------------------------------------------------------------------------
* Dolibarr (Project leader): https://www.dolibarr.org (make a donation for
Dolibarr project via Paypal: cont...@destailleur.fr)
* AWStats (Author) : http://awstats.sourceforge.net (make a donation for
AWStats project via Paypal: cont...@destailleur.fr)
* AWBot (Author) : http://awbot.sourceforge.net
* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________
Dolibarr-dev mailing list
Dolibarr-dev@nongnu.org
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
