dolibarr-user
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Dolibarr-user] Problème de validation de factur e


From: [ATNObUG]
Subject: Re: [Dolibarr-user] Problème de validation de factur e
Date: Thu, 03 Nov 2011 08:30:57 +0100

Bonjour Laurent;

Pour insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 10, 'AC_SHIP',    'system', 'Send shipping by email'                ,'shipping', 11)  j j'obtiens  : #1062 - Duplicate entry '10' for key 'PRIMARY'

Toutes les autres requêtes fonctionnent.




Le mercredi 02 novembre 2011 à 18:47 +0100, Laurent Destailleur (eldy) a écrit :

Try to run this requests :

insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 1,  'AC_TEL',     'system', 'Phone call'                            ,NULL, 2);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 2,  'AC_FAX',     'system', 'Send Fax'                            ,NULL, 3);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 3,  'AC_PROP',    'system', 'Send commercial proposal by email'    ,'propal',  10);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 4,  'AC_EMAIL',   'system', 'Send Email'                            ,NULL, 4);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 5,  'AC_RDV',     'system', 'Rendez-vous'                            ,NULL, 1);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 8,  'AC_COM',     'system', 'Send customer order by email'        ,'order',   8);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 9,  'AC_FAC',     'system', 'Send customer invoice by email'        ,'invoice', 6);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 10, 'AC_SHIP',    'system', 'Send shipping by email'                ,'shipping', 11);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 30, 'AC_SUP_ORD', 'system', 'Send supplier order by email'        ,'order_supplier',    9);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values  (31, 'AC_SUP_INV', 'system', 'Send supplier invoice by email'        ,'invoice_supplier', 7);
insert into llx_c_actioncomm (id, code, type, libelle, module, position) values ( 50, 'AC_OTH',     'system', 'Other'                                ,NULL, 5);



Le 25/10/2011 10:09, [ATNObUG] a écrit :
Bonjour Régis,

Dans Dictionnaires - Liste des types d'événements de l'agenda, j'ai uniquement ceci :
AC_CLO    Clôture    system    0    Toujours actif
AC_SHIP    Envoi bon d'expédition par mail    system    11    Toujours actif


Sinon ta réponse est tronquée, je suppose qu'il faut décocher  "BILL_VALIDATE Validation facture client" dans la configuration de l'agenda ?




Le mardi 25 octobre 2011 à 01:53 +0200, Laurent Destailleur (eldy) a écrit :

Vérifie dans accueil - config - dictionnaire - type d'evennement agenda, que tu as une ligne avec pour code "AC_OTH"


Va dans la config du module agenda, est décoche la casLe 24/10/2011 12:09, [ATNObUG] a écrit :
Bonjour Régis,

En effet, en désactivant le module Agenda,cela fonctionne à nouveau  :) mais en le réactivant le module, la validation ne fonctionne plus.






Le lundi 24 octobre 2011 à 11:51 +0200, Régis Houssin a écrit :
Bonjour

essai en désactivant le module agenda
puis essai à nouveau en le réactivant



Le 24/10/11 11:46, [ATNObUG] a écrit :
Bonjour à tous,

Suite à la migration vers la version Debian/Ubuntu de Dolibarr 3.0 vers 3.1 avec dolibarr_3.1.0-1.1_all.deb, la validation de facture ne fonctionne pas.

J'ai essayé à partir d'un poste Windows, Linux avec Firefox, IE etc mais en aucun cas la facture est validée et reste en provisoire.

Dolibarr est installé sur un Debian Squeeze 2.6.32-5-amd64 #1 SMP Mon Oct 3 05:45:56 UTC 2011 x86_64  avec Apache/2.2.16 (Debian), Php 5.3.3-7+squeeze3 et MySQL 5.1.49

voici la partie du log de dolibarr concernée (j'ai remplacé le login par xxxxxxxxxxx):

2011-10-24 11:24:51 INFO  10.1.1.1        nologin  facture This is an already logged session. _SESSION['dol_login']=xxxxxxxxxx
2011-10-24 11:24:51 DEBUG 10.1.1.1        nologin  facture User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.signature, 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, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid FROM llx_user as u WHERE u.entity IN (0,1) AND u.login = 'xxxxxxxxxx'
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 r.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 1 AND r.perms IS NOT NULL AND r.entity = 1 AND gu.entity IN (0,1)
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture --- Access to /dolibarr/compta/facture.php
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::Fetch sql=SELECT f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva, f.localtax1, f.localtax2, f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise, f.datef as df, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, 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_doc, el.fk_source FROM llx_facture as f LEFT JOIN llx_c_payment_term 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_element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' WHERE f.entity = 1 AND f.rowid=204
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.description, l.product_type, l.price, l.qty, l.tva_tx,  l.localtax1_tx, l.localtax2_tx, l.remise, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_export_compta, p.ref as product_ref, 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 = 204 ORDER BY l.rang
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture Menubase::menuLeftCharger sql=SELECT m.rowid, m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu as m WHERE m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2) ORDER BY m.position, m.rowid
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture Menubase::menuLeftCharger sql=SELECT m.rowid, m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu as m WHERE m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2) ORDER BY m.position, m.rowid
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::Fetch sql=SELECT f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva, f.localtax1, f.localtax2, f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise, f.datef as df, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, 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_doc, el.fk_source FROM llx_facture as f LEFT JOIN llx_c_payment_term 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_element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' WHERE f.entity = 1 AND f.rowid=204
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.description, l.product_type, l.price, l.qty, l.tva_tx,  l.localtax1_tx, l.localtax2_tx, l.remise, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_export_compta, p.ref as product_ref, 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 = 204 ORDER BY l.rang
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture DiscountAbsolute::getSumCreditNotesUsed sql=SELECT sum(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND f.type = 2
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture DiscountAbsolute::getSumDepositsUsed sql=SELECT sum(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND f.type = 3
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 155 AND fk_facture_source IS NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 155 AND fk_facture_source IS NOT NULL
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.signature, 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, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid FROM llx_user as u WHERE u.entity IN (0,1) AND u.rowid = 2
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture mod_facture_terre::getNextValue sql=SELECT MAX(SUBSTRING(facnumber FROM 8)) as max FROM llx_facture WHERE facnumber LIKE 'FA____-%' AND entity = 1
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture mod_facture_terre::getNextValue return FA1110-0184
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture 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, sr.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=204
2011-10-24 11:24:51 DEBUG 10.1.1.1        xxxxxxxxxx facture Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle FROM llx_c_payment_term WHERE active=1 ORDER BY sortorder
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture files.lib.php::dol_dir_list path=/usr/share/dolibarr/documents/facture/(PROV204) types=files recursive=0 filter= excludefilter=\.meta$
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture CommonObject::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '204' AND sourcetype = 'facture') OR (fk_target = '204' AND targettype = 'facture')
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture ActionComm::getActions sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element = 204 AND a.elementtype = 'invoice'
2011-10-24 11:24:51 INFO  10.1.1.1        xxxxxxxxxx facture --- End access to /dolibarr/compta/facture.php
2011-10-24 11:24:53 INFO  10.1.1.1        nologin  facture This is an already logged session. _SESSION['dol_login']=xxxxxxxxxx
2011-10-24 11:24:53 DEBUG 10.1.1.1        nologin  facture User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.signature, 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, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid FROM llx_user as u WHERE u.entity IN (0,1) AND u.login = 'xxxxxxxxxx'
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 r.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 1 AND r.perms IS NOT NULL AND r.entity = 1 AND gu.entity IN (0,1)
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture --- Access to /dolibarr/compta/facture.php
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::Fetch sql=SELECT f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva, f.localtax1, f.localtax2, f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise, f.datef as df, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, 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_doc, el.fk_source FROM llx_facture as f LEFT JOIN llx_c_payment_term 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_element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' WHERE f.entity = 1 AND f.rowid=204
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.description, l.product_type, l.price, l.qty, l.tva_tx,  l.localtax1_tx, l.localtax2_tx, l.remise, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_export_compta, p.ref as product_ref, 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 = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture BEGIN Transaction
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.description, l.product_type, l.price, l.qty, l.tva_tx,  l.localtax1_tx, l.localtax2_tx, l.remise, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_export_compta, p.ref as product_ref, 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 = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture mod_facture_terre::getNextValue sql=SELECT MAX(SUBSTRING(facnumber FROM 8)) as max FROM llx_facture WHERE facnumber LIKE 'FA____-%' AND entity = 1
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture mod_facture_terre::getNextValue return FA1110-0184
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture CommonObject::update_price sql=SELECT qty, total_ht, total_tva as total_tva, total_localtax1 as total_localtax1, total_localtax2 as total_localtax2, total_ttc, tva_tx as vatrate FROM llx_facturedet WHERE fk_facture = 204 AND product_type <> 9
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture CommonObject::update_price sql=UPDATE llx_facture SET total='65', tva='0', localtax1='0', localtax2='0', total_ttc='65' WHERE rowid = 204
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Facture::validate sql=UPDATE llx_facture SET facnumber='FA1110-0184', fk_statut = 1, fk_user_valid = 1 WHERE rowid = 204
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Triggers for file 'interface_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Triggers for file 'interface_modWorkflow_WorkflowManager.class.php' need module to be enabled
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Launch triggers for file 'interface_modLdap_Ldapsynchro.class.php'
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Triggers for file 'interface_modNotification_Notification.class.php' need module to be enabled
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Launch triggers for file 'interface_all_Logevents.class.php'
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Launch triggers for file 'interface_modAgenda_ActionsAuto.class.php'
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Trigger 'ActionsAuto' for action 'BILL_VALIDATE' launched by /usr/share/dolibarr/htdocs/includes/triggers/interface_modAgenda_ActionsAuto.class.php. id=204
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:53 ERROR 10.1.1.1        xxxxxxxxxx facture interface_modAgenda_ActionsAuto.class.php: Failed to insert : 
2011-10-24 11:24:53 ERROR 10.1.1.1        xxxxxxxxxx facture Interfaces::run_triggers action="" Files found: 6, Files launched: 3, Done: 0, Failed: 1
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture ROLLBACK Transaction
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Menubase::menuLeftCharger sql=SELECT m.rowid, m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu as m WHERE m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2) ORDER BY m.position, m.rowid
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Menubase::menuLeftCharger sql=SELECT m.rowid, m.type, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu FROM llx_menu as m WHERE m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2) ORDER BY m.position, m.rowid
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::Fetch sql=SELECT f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva, f.localtax1, f.localtax2, f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise, f.datef as df, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, 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_doc, el.fk_source FROM llx_facture as f LEFT JOIN llx_c_payment_term 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_element_element as el ON el.fk_target = f.rowid AND el.targettype = 'facture' WHERE f.entity = 1 AND f.rowid=204
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.description, l.product_type, l.price, l.qty, l.tva_tx,  l.localtax1_tx, l.localtax2_tx, l.remise, l.remise_percent, l.fk_remise_except, l.subprice, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_export_compta, p.ref as product_ref, 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 = 204 ORDER BY l.rang
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, 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.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.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, 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 = 155
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture DiscountAbsolute::getSumCreditNotesUsed sql=SELECT sum(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND f.type = 2
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture DiscountAbsolute::getSumDepositsUsed sql=SELECT sum(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 204 AND f.type = 3
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 155 AND fk_facture_source IS NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture 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 = 155 AND fk_facture_source IS NOT NULL
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.signature, 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, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid FROM llx_user as u WHERE u.entity IN (0,1) AND u.rowid = 2
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture 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, sr.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=204
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle FROM llx_c_payment_term WHERE active=1 ORDER BY sortorder
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture DolEditor::DolEditor htmlname=dp_desc tool=
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture get_default_tva: seller use vat=0, seller country=FR, seller in cee=1, buyer country=FR, buyer in cee=1, idprod=0, SERVICE_ARE_ECOMMERCE_200238EC=
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Form::select_produits_do search product sql=SELECT  p.rowid, p.label, p.ref, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.duration, p.stock FROM llx_product as p WHERE p.entity IN (0,1) AND p.tosell = 1 ORDER BY p.ref LIMIT 100
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture DolEditor::DolEditor htmlname=np_desc tool=
2011-10-24 11:24:53 DEBUG 10.1.1.1        xxxxxxxxxx facture Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM llx_paiement_facture WHERE fk_facture = 204
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture files.lib.php::dol_dir_list path=/usr/share/dolibarr/documents/facture/(PROV204) types=files recursive=0 filter= excludefilter=\.meta$
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture CommonObject::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '204' AND sourcetype = 'facture') OR (fk_target = '204' AND targettype = 'facture')
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture ActionComm::getActions sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element = 204 AND a.elementtype = 'invoice'
2011-10-24 11:24:53 INFO  10.1.1.1        xxxxxxxxxx facture --- End access to /dolibarr/compta/facture.php

Quelqu'un aurait-il une idée pour résoudre le problème ?

Merci d'avance

JY



--

[ATNObUG]
1 Rue des Écoles 59780 Willems
Tél / Fax : 03 20 61 44 35
http://www.atnobug.fr

En


_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


Cordialement,
-- 
Régis Houssin
---------------------------------------------------------
Cap-Networks
30, quai de Verdun
71700 Tournus
FRANCE
VoIP: +33 1 83 62 40 03
GSM: +33 6 33 02 07 97
Web: http://www.cap-networks.com/
Email: address@hidden

Dolibarr developer: address@hidden
Web Portal: http://www.dolibarr.fr/
SaaS offers: http://www.dolibox.fr/
Shop: http://www.dolistore.com/
Development platform: https://doliforge.org/
---------------------------------------------------------
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


-- 
Eldy (Laurent Destailleur).
---------------------------------------------------------------
EMail: address@hidden
Web: http://www.destailleur.fr

Dolibarr (Project leader): http://www.dolibarr.org
To make a donation for Dolibarr project via Paypal: address@hidden
AWStats (Author) : http://awstats.sourceforge.net
To make a donation for AWStats project via Paypal: address@hidden
AWBot (Author) : http://awbot.sourceforge.net
CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user


-- 
Eldy (Laurent Destailleur).
---------------------------------------------------------------
EMail: address@hidden
Web: http://www.destailleur.fr

Dolibarr (Project leader): http://www.dolibarr.org
To make a donation for Dolibarr project via Paypal: address@hidden
AWStats (Author) : http://awstats.sourceforge.net
To make a donation for AWStats project via Paypal: address@hidden
AWBot (Author) : http://awbot.sourceforge.net
CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________
Dolibarr-user mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-user

reply via email to

[Prev in Thread] Current Thread [Next in Thread]