dolibarr-user
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Dolibarr-user] Petit pb sur dolibarr 2.5 lors de l'ajout d'une nouv

From: Xavier Beaudouin
Subject: Re: [Dolibarr-user] Petit pb sur dolibarr 2.5 lors de l'ajout d'une nouvelle facture fournisseur...
Date: Wed, 18 Feb 2009 21:24:29 +0100 

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 :

PNG image




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
reply via email to
[Prev in Thread] Current Thread [Next in Thread]