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.
--
[ATNObUG]
1 Rue des Écoles 59780 Willems
Tél / Fax : 03 20 61 44 35
http://www.atnobug.fr
En application de l'article 22 de la loi du 21 juin 2004
pour la confiance dans l’économie numérique, l'adresse
mail address@hidden
ou les coordonnées téléphoniques ne peuvent être utilisées
à des fins publicitaires ou de prospection.
De même, nous nous opposons à toute collecte de ces
coordonnées.
La précédente mention acte le refus de consentement
préalable à toute prospection quelque soit le vecteur :
télécopie, automate d’appel, courrier électronique ou
autre dispositif électronique et sans limitation.
|
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
_______________________________________________
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
|