[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Dolibarr-user] Problème avec la base SQL en version 2.9
|
From: |
Laurent Destailleur (eldy) |
|
Subject: |
Re: [Dolibarr-user] Problème avec la base SQL en version 2.9 |
|
Date: |
Tue, 16 Nov 2010 00:25:50 +0100 |
|
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 |
La log a parlé.
As-tu le module webcalendar actif ?
A priori oui. C'est la connection à webcalendar qui échoue et donc la
transaction qui est annulée.
Si tu n'as pas besoin de synchro webcalendar, désactive le module.
On 16/11/2010 00:19, [ATNObUG] wrote:
> Voici les info du sylog après avoir validé une action..
>
> 2010-11-16 00:15:29 DEBUG 10.1.1.1 nologin index 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.login = 'admatnobug'
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index This is an already
> logged session. _SESSION['dol_login']=admatnobug
> 2010-11-16 00:15:29 DEBUG 10.1.1.1 admatnobug index 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
> 2010-11-16 00:15:29 DEBUG 10.1.1.1 admatnobug index 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
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index --- Access to
> /dolibarr/htdocs/compta/index.php
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url,
> m.langs, m.perms, m.enabled, m.target FROM llx_menu as m WHERE m.type = 'top'
> AND m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2)
> ORDER BY m.position
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> Menubase::menuLeftCharger sql=SELECT m.rowid, 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.menu_handler in('eldy','all') AND m.entity = 1 AND m.usertype in
> (0,2) ORDER BY m.position, m.rowid
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1010-0145 types=files recursive=0
> filter=FA1010-0145.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/(PROV161) types=files recursive=0
> filter=(PROV161).pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1009-0144 types=files recursive=0
> filter=FA1009-0144.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1001-0125 types=files recursive=0
> filter=FA1001-0125.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1003-0126 types=files recursive=0
> filter=FA1003-0126.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1004-0130 types=files recursive=0
> filter=FA1004-0130.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1005-0132 types=files recursive=0
> filter=FA1005-0132.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1007-0139 types=files recursive=0
> filter=FA1007-0139.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1007-0140 types=files recursive=0
> filter=FA1007-0140.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 INFO 10.1.1.1 admatnobug index
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1009-0144 types=files recursive=0
> filter=FA1009-0144.pdf excludefilter=\.meta$|\.png$
> 2010-11-16 00:15:29 DEBUG 10.1.1.1 admatnobug index DoliDB::disconnect
> 2010-11-16 00:15:30 INFO 10.1.1.1 nologin viewimage --- Access to
> /dolibarr/htdocs/viewimage.php
> 2010-11-16 00:15:30 INFO 10.1.1.1 nologin viewimage viewimage.php
> return file
> /var/www/dolibarr/documents/mycompany/logos/thumbs/mylogo_mini.png
> content-type=image/png
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 nologin facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.login = 'admatnobug'
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture This is an
> already logged session. _SESSION['dol_login']=admatnobug
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture --- Access to
> /dolibarr/htdocs/compta/facture.php
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url,
> m.langs, m.perms, m.enabled, m.target FROM llx_menu as m WHERE m.type = 'top'
> AND m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2)
> ORDER BY m.position
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture
> Menubase::menuLeftCharger sql=SELECT m.rowid, 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.menu_handler in('eldy','all') AND m.entity = 1 AND m.usertype in
> (0,2) ORDER BY m.position, m.rowid
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture Facture::Fetch
> sql=SELECT f.rowid,f.facnumber,f.ref_client,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_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_element_element as el ON el.fk_target = f.rowid AND el.targettype =
> 'facture' WHERE f.enti
> ty = 1 AND f.rowid=160
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 160
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 2
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 3
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NULL
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NOT
> NULL
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.rowid = 2
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug 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=160
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture
> Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle FROM
> llx_cond_reglement WHERE active=1 ORDER BY sortorder
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug 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 = 1 AND p.hidden=0 AND p.envente
> = 1 ORDER BY p.ref LIMIT 100
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 160
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1010-0145 types=files recursive=0
> filter= excludefilter=\.meta$
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture
> CommonObject::load_object_linked sql=SELECT fk_source, sourcetype, fk_target,
> targettype FROM llx_element_element WHERE (fk_source = '160' AND sourcetype =
> 'facture') OR (fk_target = '160' AND targettype = 'facture')
> 2010-11-16 00:15:40 INFO 10.1.1.1 admatnobug facture
> FormActions::showactions sql=SELECT a.id, 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 = 160
> 2010-11-16 00:15:40 DEBUG 10.1.1.1 admatnobug facture
> DoliDB::disconnect
> 2010-11-16 00:15:41 INFO 10.1.1.1 nologin viewimage --- Access to
> /dolibarr/htdocs/viewimage.php
> 2010-11-16 00:15:41 INFO 10.1.1.1 nologin viewimage viewimage.php
> return file
> /var/www/dolibarr/documents/mycompany/logos/thumbs/mylogo_mini.png
> content-type=image/png
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 nologin facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.login = 'admatnobug'
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture This is an
> already logged session. _SESSION['dol_login']=admatnobug
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture --- Access to
> /dolibarr/htdocs/compta/facture.php
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture Facture::Fetch
> sql=SELECT f.rowid,f.facnumber,f.ref_client,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_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_element_element as el ON el.fk_target = f.rowid AND el.targettype =
> 'facture' WHERE f.enti
> ty = 1 AND f.rowid=160
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url,
> m.langs, m.perms, m.enabled, m.target FROM llx_menu as m WHERE m.type = 'top'
> AND m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2)
> ORDER BY m.position
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture
> Menubase::menuLeftCharger sql=SELECT m.rowid, 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.menu_handler in('eldy','all') AND m.entity = 1 AND m.usertype in
> (0,2) ORDER BY m.position, m.rowid
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture Facture::Fetch
> sql=SELECT f.rowid,f.facnumber,f.ref_client,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_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_element_element as el ON el.fk_target = f.rowid AND el.targettype =
> 'facture' WHERE f.enti
> ty = 1 AND f.rowid=160
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 160
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 2
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 3
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NULL
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NOT
> NULL
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.rowid = 2
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug 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=160
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture
> Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle FROM
> llx_cond_reglement WHERE active=1 ORDER BY sortorder
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1010-0145 types=files recursive=0
> filter= excludefilter=\.meta$
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture
> CommonObject::load_object_linked sql=SELECT fk_source, sourcetype, fk_target,
> targettype FROM llx_element_element WHERE (fk_source = '160' AND sourcetype =
> 'facture') OR (fk_target = '160' AND targettype = 'facture')
> 2010-11-16 00:15:44 INFO 10.1.1.1 admatnobug facture
> FormActions::showactions sql=SELECT a.id, 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 = 160
> 2010-11-16 00:15:44 DEBUG 10.1.1.1 admatnobug facture
> DoliDB::disconnect
> 2010-11-16 00:15:44 INFO 10.1.1.1 nologin viewimage --- Access to
> /dolibarr/htdocs/viewimage.php
> 2010-11-16 00:15:44 INFO 10.1.1.1 nologin viewimage viewimage.php
> return file
> /var/www/dolibarr/documents/mycompany/logos/thumbs/mylogo_mini.png
> content-type=image/png
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 nologin facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.login = 'admatnobug'
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture This is an
> already logged session. _SESSION['dol_login']=admatnobug
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug 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
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture --- Access to
> /dolibarr/htdocs/compta/facture.php
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug facture Facture::Fetch
> sql=SELECT f.rowid,f.facnumber,f.ref_client,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_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_element_element as el ON el.fk_target = f.rowid AND el.targettype =
> 'facture' WHERE f.enti
> ty = 1 AND f.rowid=160
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug facture BEGIN Transaction
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:47 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug 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 FROM llx_facturedet WHERE fk_facture = 160
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture
> CommonObject::update_price sql=UPDATE llx_facture SET total='207.62',
> tva='0', localtax1='0', localtax2='0', total_ttc='207.62' WHERE rowid = 160
> 2010-11-16 00:15:47 INFO 10.1.1.1 admatnobug facture
> Facture::validate sql=UPDATE llx_facture SET facnumber='FA1010-0145',
> fk_statut = 1, fk_user_valid = 1 WHERE rowid = 160
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Triggers for file
> 'interface_modPhenix_Phenixsynchro.class.php' need module to be enabled
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Launch triggers for file
> 'interface_modAgenda_ActionsAuto.class.php'
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Launch triggers for file
> 'interface_all_Logevents.class.php'
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Triggers for file
> 'interface_modNotification_Notification.class.php' need module to be enabled
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Launch triggers for file
> 'interface_modLdap_Ldapsynchro.class.php'
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Launch triggers for file
> 'interface_modWebcalendar_Webcalsynchro.class.php'
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture Trigger
> 'Webcalsynchro' for action 'BILL_VALIDATE' launched by
> /var/www/dolibarr/htdocs/includes/triggers/interface_modWebcalendar_Webcalsynchro.class.php.
> id=160
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture DoliDB::connect
> host=10.1.1.201, port=, login=Jean-Yves, passwd=--hidden--, name=atnobugegrp
> 2010-11-16 00:15:48 ERROR 10.1.1.1 admatnobug facture DoliDB::DoliDB :
> Erreur Connect mysql_error=
> 2010-11-16 00:15:48 ERROR 10.1.1.1 admatnobug facture
> Interfaces::run_triggers action=BILL_VALIDATE Files found: 6, Files launched:
> 4, Done: 0, Failed: 1
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture ROLLBACK
> Transaction
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url,
> m.langs, m.perms, m.enabled, m.target FROM llx_menu as m WHERE m.type = 'top'
> AND m.entity = 1 AND m.menu_handler in('eldy','all') AND m.usertype in (0,2)
> ORDER BY m.position
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> Menubase::menuLeftCharger sql=SELECT m.rowid, 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.menu_handler in('eldy','all') AND m.entity = 1 AND m.usertype in
> (0,2) ORDER BY m.position, m.rowid
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture Facture::Fetch
> sql=SELECT f.rowid,f.facnumber,f.ref_client,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_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_element_element as el ON el.fk_target = f.rowid AND el.targettype =
> 'facture' WHERE f.enti
> ty = 1 AND f.rowid=160
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture
> Facture::fetch_lines sql=SELECT l.rowid, l.fk_product, 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.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 = 160 ORDER BY l.rang
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture Societe::fetch
> SELECT s.rowid, s.nom, s.entity, s.address, s.datec as dc, s.prefix_comm,
> s.price_level, 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.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.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 = 46
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 160
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 2
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug 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 = 160 AND f.type = 3
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NULL
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug 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 = 46 AND fk_facture_source IS NOT
> NULL
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture 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,
> u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel,
> u.datepreviouslogin as datep, u.photo as photo FROM llx_user as u WHERE
> u.entity IN (0,1) AND u.rowid = 2
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug 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=160
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture
> Form::load_cache_conditions_paiements sql=SELECT rowid, code, libelle FROM
> llx_cond_reglement WHERE active=1 ORDER BY sortorder
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug 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 = 1 AND p.hidden=0 AND p.envente
> = 1 ORDER BY p.ref LIMIT 100
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture
> Facture::getSommePaiement sql=SELECT sum(amount) as amount FROM
> llx_paiement_facture WHERE fk_facture = 160
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> files.lib.php::dol_dir_list
> path=/var/www/dolibarr/documents/facture/FA1010-0145 types=files recursive=0
> filter= excludefilter=\.meta$
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> CommonObject::load_object_linked sql=SELECT fk_source, sourcetype, fk_target,
> targettype FROM llx_element_element WHERE (fk_source = '160' AND sourcetype =
> 'facture') OR (fk_target = '160' AND targettype = 'facture')
> 2010-11-16 00:15:48 INFO 10.1.1.1 admatnobug facture
> FormActions::showactions sql=SELECT a.id, 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 = 160
> 2010-11-16 00:15:48 DEBUG 10.1.1.1 admatnobug facture
> DoliDB::disconnect
> 2010-11-16 00:15:48 INFO 10.1.1.1 nologin viewimage --- Access to
> /dolibarr/htdocs/viewimage.php
> 2010-11-16 00:15:48 INFO 10.1.1.1 nologin viewimage viewimage.php
> return file
> /var/www/dolibarr/documents/mycompany/logos/thumbs/mylogo_mini.png
> content-type=image/png
> Il y a un point qui me chipote.. dans ce cas, il s'agit d'une facture
> qui avait déjà été validée : elle n'a plus de numéro provisoire. Hors
> elle est encore considérée en brouillon
>
> Laurent Destailleur (eldy) a écrit :
>> Peux-tu activer le module syslog pour tracer dans un fichier log
>> et dire ce que contient ce fichier après avoir saisi une action qui ne
>> donne rien ?
>>
>>
>> On 15/11/2010 15:11, [ATNObUG] wrote:
>>
>>> Bonjour à tous,
>>>
>>> Je me permets de poster ici car je rencontre un problème qui devient
>>> terriblement bloquant pour mon activité et je ne trouve pas la
>>> solution sur le forum dolibarr.fr
>>>
>>> Sur une installation de Dolibarr 2.9,sur une Debian
>>> Lenny,Apache/2.2.9, Version 5.2.6-1+lenny9 with Suhosin-Patch, MySQL
>>> 5.0.51a-24+lenny4, (Mise à jour d'une 2.8.1) Dolibarr semble comme "figé"
>>>
>>> Par exemples :
>>> - la validation d'une facture ne se fait pas si je clique sur le
>>> bouton /valider/
>>> - si je crée un nouveau client, il n'apparaît pas dans la liste.
>>> - ...
>>>
>>>
>>> Cela donne l'impression d'un problème d'écriture des infos dans la
>>> base SQL. J'ai donc bien vérifié les droits de l'utilisateur mais ils
>>> sont OK (Grant : ALL PRIVILEGES).
>>> J'ai éliminé aussi un éventuel pb de navigateur ( le pb se pose aussi
>>> sous Windows, avec Firefox, ou IE)
>>> J'ai désactivé le cache d'Eaccelarator, au cas où le navigateur ne
>>> relirait que le cache
>>>
>>> Ceci ne fonctionnant toujours pas j'ai fait un dump de la base
>>> d'origine, réinstallé Dolibarr avec le .deb fournit sur le site et
>>> réécrasé la base avec le dump.
>>>
>>> Le problème est identique. Apparement, la base aurait donc un
>>> dysfonctionnement.
>>> Aucune action particulière n'a été faite sur les bases MySql avant que
>>> le problème ne se pose. (En tout cas, je ne vois pas quoi...)à
>>> Est-ce un bug de la 2.9 ?
>>>
>>> Quelles seraient les opérations nécéssaires afin de relancer Dolibarr,
>>> ou réparer la base ?
>>>
>>> Merci d'avance
>>>
>>> JY
>>>
>>>
>>> _______________________________________________
>>> Dolibarr-user mailing list
>>> address@hidden
>>> http://lists.nongnu.org/mailman/listinfo/dolibarr-user
>>>
>>
>>
>> _______________________________________________
>> Dolibarr-user mailing list
>> address@hidden
>> http://lists.nongnu.org/mailman/listinfo/dolibarr-user
>>
>>
>
>
> _______________________________________________
> Dolibarr-user mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/dolibarr-user