Re: [Dolibarr-user] Petit pb sur dolibarr 2.5 lors de l'ajout d'une nouvelle facture fournisseur...

[Eldy]

Pour le 2eme pb, as-tu activé le module agenda ?

Pour le 1er, bizarre, il y a effectivement un select avec where sur le
libellé de société au lieu de sur son id. As-tu le pb sur la démo
demo.dolibarr.org ?


Xavier Beaudouin a écrit :
>
> Le 18 févr. 09 à 20:05, Eldy a écrit :
>
>> Active le module syslog pour avoir plus d'info sur le pb.
>
> Hum... Ca n'aide pas trop :
>
> Warning: openlog() expects parameter 3 to be long, string given in
> /..../htdocs/lib/functions.lib.php on line 259
>
> Est-ce... un pb du au PHP5 ?
>
> Bon en le mettant dans un fichier /tmp/dolibarr.log j'arrive a ca :
>
> 2009-02-18 21:16:16 INFO  82.225.248.92 ???      Start session
> name=DOLSESSID_dolibarr Session id()=6af9d35c916c7ba4877eeb4d03efc5c5,
> _SESSION['dol_login']=kiwi, 1440
> 2009-02-18 21:16:16 DEBUG 82.225.248.92 ???      User::Fetch
> sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone,
> u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login,
> u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted,
> u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid,
> u.statut, u.lang, unix_timestamp(u.datec) as datec,
> unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as
> datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u
> WHERE u.login = 'kiwi'
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi     This is an already
> logged session. _SESSION['dol_login']=kiwi
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi     Access to
> /dolibarr/fourn/facture/fiche.php
> 2009-02-18 21:16:16 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_user= 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:16:16 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:16:16 DEBUG 82.225.248.92 kiwi     BEGIN Transaction
> 2009-02-18 21:16:16 DEBUG 82.225.248.92 kiwi     ROLLBACK Transaction
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi    
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre,
> m.url, m.langs, m.perms, mo.action FROM llx_menu as m LEFT JOIN
> llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN
> llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.type
> = 'top' AND m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER
> BY m.position
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi    
> Menubase::menuLeftCharger sql=SELECT m.rowid, m.fk_menu, m.url,
> m.titre, m.langs, m.perms, m.target, m.mainmenu, m.leftmenu, mo.action
> FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid =
> mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint =
> mo.rowid WHERE m.menu_handler in('eldy','all') AND m.user in (0,2)
> ORDER BY m.position, m.rowid
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi     Erreur Societe::Fetch
> echec sql=SELECT s.rowid, s.nom, s.address,unix_timestamp(s.datec) as
> dc, s.prefix_comm, s.price_level,unix_timestamp(s.tms) as date_update,
> s.tel, s.fax, s.email, s.url, s.cp, s.ville, s.note, s.client,
> s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, s.capital,
> s.tva_intra, s.rubrique, s.fk_typent as typent_id, s.fk_effectif as
> effectif_id, s.fk_forme_juridique as forme_juridique_code,
> s.code_client, s.code_fournisseur, s.code_compta,
> s.code_compta_fournisseur, s.parent, s.gencod, s.fk_departement,
> s.fk_pays, s.fk_stcomm, s.remise_client, s.mode_reglement,
> s.cond_reglement, s.tva_assuj, s.fk_prospectlevel, fj.libelle as
> forme_juridique, e.libelle as effectif, p.code as pays_code, p.libelle
> as pays, d.code_departement as departement_code, d.nom as departement,
> st.libelle as stcomm, te.code as typent_code FROM llx_societe as s
> LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN
> llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = Accelance MSP
> 2009-02-18 21:16:16 INFO  82.225.248.92 kiwi     Erreur Societe::Fetch
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'MSP' at line 1
>
> Il me semble que le WHERE est la cause du problème... Je me trompe?
>
>>
>> Sinon, que veux-tu dire par envoie de message plus actualisé ?
>
> Et bien quand je suis en mode compta/trésorie et que j'envoie un
> message (envoie de facture, rappel etc...) le message en bas n'est
> plus affiché comme par exemple dans la capture donnée :
>
>
> ------------------------------------------------------------------------
>
>
>
>
> Puisque que je suis dans les logs je viens de faire un rappel :
>
> 2009-02-18 21:21:42 INFO  82.225.248.92 ???      Start session
> name=DOLSESSID_dolibarr Session id()=6af9d35c916c7ba4877eeb4d03efc5c5,
> _SESSION['dol_login']=kiwi, 1440
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 ???      User::Fetch
> sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone,
> u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login,
> u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted,
> u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid,
> u.statut, u.lang, unix_timestamp(u.datec) as datec,
> unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as
> datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u
> WHERE u.login = 'kiwi'
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     This is an already
> logged session. _SESSION['dol_login']=kiwi
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     Access to
> /dolibarr/compta/facture.php
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_user= 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     Facture::Fetch
> sql=SELECT
> f.rowid,f.facnumber,f.ref_client,f.type,f.fk_soc,f.amount,f.tva,f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,unix_timestamp(f.datef)
> as df,unix_timestamp(f.date_lim_reglement) as
> dlr,unix_timestamp(f.datec) as datec,unix_timestamp(f.date_valid) as
> datev, f.note, f.note_public, f.fk_statut, f.paye, f.close_code,
> f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf,
> f.fk_facture_source, f.fk_mode_reglement, f.fk_cond_reglement,
> f.fk_projet, 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_facture, cf.fk_commande FROM llx_facture as f
> LEFT JOIN llx_cond_reglement 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_co_fa as cf ON cf.fk_facture = f.rowid WHERE f.rowid=226
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     Facture::fetch_lines
> sql=SELECT l.rowid, l.fk_product, l.description, l.price, l.qty,
> l.tva_taux,  l.remise, l.remise_percent, l.fk_remise_except,
> l.subprice, unix_timestamp(l.date_start) as
> date_start,unix_timestamp(l.date_end) as date_end, l.info_bits,
> l.total_ht, l.total_tva, l.total_ttc, l.fk_code_ventilation,
> l.fk_export_compta, p.fk_product_type as fk_product_type, p.label as
> 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 =
> 226 ORDER BY l.rang
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::CMailfile:
> from=Xavier Beaudouin <address@hidden>, to=Gilles Hottot
> <address@hidden>, address@hidden,
> addr_bcc=, errors_to=
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::CMailfile:
> subject=Relance facture FA0812-0214, deliveryreceipt=0, msgishtml=0
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::CMailfile:
> filename_list[0]=/hosting/http/d/o/l/i/dolibarr.local.oav.net/documents/facture/FA0812-0214/FA0812-0214.pdf,
> mimetype_list[0]=application/pdf mimefilename_list[0]=FA0812-0214.pdf
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> CMailFile::write_smtpheaders smtp_header=
> From: Xavier Beaudouin <address@hidden>
> Return-Path: Xavier Beaudouin <address@hidden>
> Cc: address@hidden
> X-Mailer: Dolibarr version 2.5
> MIME-Version: 1.0
> Content-Transfer-Encoding: 8bit
>
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> CMailFile::write_mimeheaders mime_header=
> Content-Type: multipart/mixed;
> boundary="341883527ebdc3f2960cde75ada9e582"
> X-attachments: FA0812-0214.pdf
>
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> CMailFile::write_files: i=0
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::sendfile
> addr_to=User <CENCURE>, subject=Relance facture FA0812-0214
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::sendfile
> header=
> From: Xavier Beaudouin <address@hidden>
> Return-Path: Xavier Beaudouin <address@hidden>
> X-Mailer: Dolibarr version 2.5
> MIME-Version: 1.0
> Content-Transfer-Encoding: 8bit
> Content-Type: multipart/mixed;
> boundary="341883527ebdc3f2960cde75ada9e582"
> X-attachments: FA0812-0214.pdf
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::sendfile:
> mail start SMTP=mail.oav.net, PORT=25
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     CMailFile::sendfile:
> mail end success
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Launch triggers for file
> 'interface_all_Logevents.class.php'
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Triggers for file
> 'interface_modAgenda_ActionsAuto.class.php' need module to be enabled
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Triggers for file
> 'interface_modLdap_Ldapsynchro.class.php' need module to be enabled
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Launch triggers for file
> 'interface_modNotification_Notification.class.php'
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Triggers for file
> 'interface_modPhenix_Phenixsynchro.class.php' need module to be enabled
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Interfaces::run_triggers Triggers for file
> 'interface_modWebcalendar_Webcalsynchro.class.php' need module to be
> enabled
> 2009-02-18 21:21:42 INFO  82.225.248.92 ???      Start session
> name=DOLSESSID_dolibarr Session id()=6af9d35c916c7ba4877eeb4d03efc5c5,
> _SESSION['dol_login']=kiwi, 1440
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 ???      User::Fetch
> sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone,
> u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login,
> u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted,
> u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid,
> u.statut, u.lang, unix_timestamp(u.datec) as datec,
> unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as
> datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u
> WHERE u.login = 'kiwi'
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     This is an already
> logged session. _SESSION['dol_login']=kiwi
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     Access to
> /dolibarr/compta/facture.php
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_user= 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     User::getRights
> sql=SELECT 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.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND
> r.perms IS NOT NULL
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre,
> m.url, m.langs, m.perms, mo.action FROM llx_menu as m LEFT JOIN
> llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN
> llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.type
> = 'top' AND m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER
> BY m.position
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> Menubase::menuLeftCharger sql=SELECT m.rowid, m.fk_menu, m.url,
> m.titre, m.langs, m.perms, m.target, m.mainmenu, m.leftmenu, mo.action
> FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid =
> mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint =
> mo.rowid WHERE m.menu_handler in('eldy','all') AND m.user in (0,2)
> ORDER BY m.position, m.rowid
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     Facture::Fetch
> sql=SELECT
> f.rowid,f.facnumber,f.ref_client,f.type,f.fk_soc,f.amount,f.tva,f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise,unix_timestamp(f.datef)
> as df,unix_timestamp(f.date_lim_reglement) as
> dlr,unix_timestamp(f.datec) as datec,unix_timestamp(f.date_valid) as
> datev, f.note, f.note_public, f.fk_statut, f.paye, f.close_code,
> f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf,
> f.fk_facture_source, f.fk_mode_reglement, f.fk_cond_reglement,
> f.fk_projet, 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_facture, cf.fk_commande FROM llx_facture as f
> LEFT JOIN llx_cond_reglement 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_co_fa as cf ON cf.fk_facture = f.rowid WHERE f.rowid=226
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     Facture::fetch_lines
> sql=SELECT l.rowid, l.fk_product, l.description, l.price, l.qty,
> l.tva_taux,  l.remise, l.remise_percent, l.fk_remise_except,
> l.subprice, unix_timestamp(l.date_start) as
> date_start,unix_timestamp(l.date_end) as date_end, l.info_bits,
> l.total_ht, l.total_tva, l.total_ttc, l.fk_code_ventilation,
> l.fk_export_compta, p.fk_product_type as fk_product_type, p.label as
> 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 =
> 226 ORDER BY l.rang
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi    
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 226
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi    
> DiscountAbsolute::getSommeCreditNote sql=SELECT sum(rc.amount_ttc) as
> amount FROM llx_societe_remise_except as rc WHERE rc.fk_facture = 226
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi    
> DiscountAbsolute::getAvailableDiscounts sql=SELECT SUM(rc.amount_ttc)
> as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS
> NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 56 AND
> fk_facture_source IS NULL
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi    
> DiscountAbsolute::getAvailableDiscounts sql=SELECT SUM(rc.amount_ttc)
> as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS
> NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 56 AND
> fk_facture_source IS NOT NULL
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi     User::Fetch
> sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone,
> u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login,
> u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted,
> u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid,
> u.statut, u.lang, unix_timestamp(u.datec) as datec,
> unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as
> datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u
> WHERE u.rowid = 2
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> DiscountAbsolute::fetch sql=SELECT sr.rowid, sr.fk_soc, sr.fk_user,
> sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx,
> sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source,
> sr.description, unix_timestamp(sr.datec) as datec, f.facnumber as
> ref_facture_source FROM llx_societe_remise_except as sr LEFT JOIN
> llx_facture as f ON sr.fk_facture_source = f.rowid WHERE
> sr.fk_facture_source=226
> 2009-02-18 21:21:42 DEBUG 82.225.248.92 kiwi    
> Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle
> FROM llx_cond_reglement WHERE active=1 ORDER BY sortorder
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> files.lib.php::dol_dir_list
> /hosting/http/d/o/l/i/dolibarr.local.oav.net/documents/facture/FA0812-0214
>
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi     facture.php:
> sql=SELECT unix_timestamp(p.datep) as dp, p.total_ht, p.ref,
> p.ref_client, p.rowid as propalid FROM llx_propal as p, llx_fa_pr as
> fp WHERE fp.fk_propal = p.rowid AND fp.fk_facture = 226
> 2009-02-18 21:21:42 INFO  82.225.248.92 kiwi    
> FormActions::showactions sql=SELECT a.id, unix_timestamp(a.datep) as
> da, a.label, a.note, u.login FROM llx_actioncomm as a, llx_user as u
> WHERE a.fk_user_author = u.rowid AND a.fk_facture = 226
>
> Et effectivement pas de mise a jour de la partie action...
>
> Que dois-je faire ? :p
> /Xavier
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Dolibarr-user mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/dolibarr-user


-- 
Laurent Destailleur.
---------------------------------------------------------------
EMail: address@hidden
Web: http://www.destailleur.fr
IM: IRC=Eldy, Jabber=Eldy

AWStats (Author) : http://awstats.sourceforge.net
CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
AWBot (Author) : http://awbot.sourceforge.net
Dolibarr (Contributor) : http://www.dolibarr.org