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="" 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="" 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="" 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="" 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="" 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="" 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="" 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
|