Bonjour,
Depuis la mise à jour 6.0.3, je possède une quantité d’erreur 500 HTTP. Ci-joint mes logs apache.
Que puis-je faire?
Merci
End access to /dolibarr/compta/index.php
dolibarr[776]: - This is an already logged session. _SESSION[‹ dol_login ›]=HUGO _SESSION[‹ dol_entity ›]=1
dolibarr[776]: sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ HUGO › ORDER BY u.entity ASC
dolibarr[776]: fetch_name_optionals_label elementtype=user
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
dolibarr[776]: sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
dolibarr[776]: sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
dolibarr[776]: sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
dolibarr[776]: 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
dolibarr[776]: — Access to /dolibarr/fourn/facture/list.php - action=, massaction=
dolibarr[776]: sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
dolibarr[776]: Menubase::menuLoad mymainmenu=accountancy myleftmenu=suppliers_bills type_user=0 menu_handler=eldy tabMenu size=0
dolibarr[776]: sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[776]: sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
dolibarr[776]: useLocalTax
dolibarr[776]: sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.localtax1_type <> ‹ 0 ›
dolibarr[776]: useLocalTax
dolibarr[776]: sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.localtax2_type <> ‹ 0 ›
dolibarr[776]: sql=SELECT rowid, code, label, nature FROM llx_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
dolibarr[776]: sql=SELECT f.rowid as facid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement as datelimite, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva as total_vat, f.paye as paye, f.fk_statut as fk_statut, f.libelle as label, f.datec as date_creation, f.tms as date_update, f.localtax1 as total_localtax1, f.localtax2 as total_localtax2, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, p.rowid as project_id, p.ref as project_ref, SUM(pf.amount) as dynamount_payed FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON pf.fk_facturefourn = f.rowid LEFT JOIN llx_projet as p ON p.rowid = f.fk_projet WHERE f.fk_soc = s.rowid AND f.entity IN (1) GROUP BY f.rowid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva, f.paye, f.fk_statut, f.libelle, f.datec, f.tms, f.localtax1, f.localtax2, s.rowid, s.nom, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code, state.code_departement, state.nom, p.rowid, p.ref ORDER BY f.datef DESC, f.rowid
dolibarr[776]: sql=SELECT f.rowid as facid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement as datelimite, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva as total_vat, f.paye as paye, f.fk_statut as fk_statut, f.libelle as label, f.datec as date_creation, f.tms as date_update, f.localtax1 as total_localtax1, f.localtax2 as total_localtax2, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, p.rowid as project_id, p.ref as project_ref, SUM(pf.amount) as dynamount_payed FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_facture_fourn as f LEFT JOIN llx_paiementfourn_facturefourn as pf ON pf.fk_facturefourn = f.rowid LEFT JOIN llx_projet as p ON p.rowid = f.fk_projet WHERE f.fk_soc = s.rowid AND f.entity IN (1) GROUP BY f.rowid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva, f.paye, f.fk_statut, f.libelle, f.datec, f.tms, f.localtax1, f.localtax2, s.rowid, s.nom, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code, state.code_departement, state.nom, p.rowid, p.ref ORDER BY f.datef DESC, f.rowid LIMIT 51
dolibarr[776]: sql=SELECT u.rowid, u.lastname, u.firstname, u.statut, u.login FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY statut DESC, lastname ASC
dolibarr[776]: Form::select_dolusers
dolibarr[776]: sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM llx_user as u WHERE u.entity IN (0,1) ORDER BY u.firstname ASC
dolibarr[776]: Form::select_all_categories: using numeric value for parameter type is deprecated. Use string code instead.
dolibarr[776]: Categorie::get_full_arbo(): numeric types are deprecated, please use string instead
dolibarr[776]: Categorie::load_motherof
dolibarr[776]: sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
dolibarr[776]: Categorie::get_full_arbo get category list
dolibarr[776]: sql=SELECT DISTINCT c.rowid, c.label, c.description, c.color, c.fk_parent FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 0
dolibarr[776]: Categorie::get_full_arbo call to build_path_from_id_categ
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=54 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=55 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=56 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=57 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=58 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=59 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=61 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=62 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=63 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=64 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=65 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=66 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=67 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=68 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=69 protection=0
dolibarr[776]: Categorie::build_path_from_id_categ id_categ=96 protection=0
dolibarr[776]: Categorie::get_full_arbo dol_sort_array
dolibarr[776]: Form::select_types_paiements , search_paymentmode, , 0
dolibarr[776]: Form::load_cache_types_paiements
dolibarr[776]: sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement
dolibarr[776]: Translate::getLabelFromKey
dolibarr[776]: sql=SELECT libelle as label FROM llx_c_paiement WHERE code = ‹ LCR ›
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 132
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/3/SI1711-0130 types=files recursive=0 filter=SI1711-0130[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 134
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/4/3/SI1711-0132 types=files recursive=0 filter=SI1711-0132[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 135
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/3/SI1711-0133 types=files recursive=0 filter=SI1711-0133[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 133
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/3/3/SI1711-0131 types=files recursive=0 filter=SI1711-0131[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 130
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/3/SI1710-0128 types=files recursive=0 filter=SI1710-0128[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 131
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/1/3/SI1710-0129 types=files recursive=0 filter=SI1710-0129[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 129
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/2/SI1710-0127 types=files recursive=0 filter=SI1710-0127[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 125
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/2/SI1710-0123 types=files recursive=0 filter=SI1710-0123[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 122
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/2/SI1710-0120 types=files recursive=0 filter=SI1710-0120[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 121
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/1/2/SI1710-0119 types=files recursive=0 filter=SI1710-0119[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 115
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/1/SI1710-0113 types=files recursive=0 filter=SI1710-0113[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 116
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/1/SI1710-0114 types=files recursive=0 filter=SI1710-0114[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 117
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/7/1/SI1710-0115 types=files recursive=0 filter=SI1710-0115[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 118
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/8/1/SI1710-0116 types=files recursive=0 filter=SI1710-0116[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 120
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/2/SI1710-0118 types=files recursive=0 filter=SI1710-0118[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 101
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/1/0/SI1710-0101 types=files recursive=0 filter=SI1710-0101[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 102
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/0/SI1710-0102 types=files recursive=0 filter=SI1710-0102[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 103
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/3/0/SI1710-0103 types=files recursive=0 filter=SI1710-0103[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 104
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/4/0/SI1710-0104 types=files recursive=0 filter=SI1710-0104[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 105
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/0/SI1710-0105 types=files recursive=0 filter=SI1710-0105[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 106
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/0/SI1710-0106 types=files recursive=0 filter=SI1710-0106[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 109
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/0/SI1710-0107 types=files recursive=0 filter=SI1710-0107[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 111
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/1/1/SI1710-0109 types=files recursive=0 filter=SI1710-0109[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 113
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/3/1/SI1710-0111 types=files recursive=0 filter=SI1710-0111[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 96
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/9/SI1709-0096 types=files recursive=0 filter=SI1709-0096[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 97
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/7/9/SI1709-0097 types=files recursive=0 filter=SI1709-0097[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 98
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/8/9/SI1709-0098 types=files recursive=0 filter=SI1709-0098[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 99
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/9/SI1709-0099 types=files recursive=0 filter=SI1709-0099[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 114
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/4/1/SI1709-0112 types=files recursive=0 filter=SI1709-0112[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 90
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/9/SI1709-0090 types=files recursive=0 filter=SI1709-0090[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 88
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/8/8/SI1709-0088 types=files recursive=0 filter=SI1709-0088[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 86
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/8/SI1709-0086 types=files recursive=0 filter=SI1709-0086[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 84
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/4/8/SI1709-0084 types=files recursive=0 filter=SI1709-0084[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 83
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/3/8/SI1709-0083 types=files recursive=0 filter=SI1709-0083[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 80
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/8/SI1709-0080 types=files recursive=0 filter=SI1709-0080[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 81
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/1/8/SI1709-0081 types=files recursive=0 filter=SI1709-0081[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 82
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/8/SI1709-0082 types=files recursive=0 filter=SI1709-0082[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 77
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/7/7/SI1708-0077 types=files recursive=0 filter=SI1708-0077[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 78
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/8/7/SI1708-0078 types=files recursive=0 filter=SI1708-0078[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 79
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/7/SI1708-0079 types=files recursive=0 filter=SI1708-0079[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 85
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/8/SI1707-0085 types=files recursive=0 filter=SI1707-0085[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 87
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/7/8/SI1708-0087 types=files recursive=0 filter=SI1708-0087[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 89
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/8/SI1708-0089 types=files recursive=0 filter=SI1708-0089[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 110
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/1/SI1708-0108 types=files recursive=0 filter=SI1708-0108[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 112
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/1/SI1708-0110 types=files recursive=0 filter=SI1708-0110[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 74
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/4/7/SI1708-0074 types=files recursive=0 filter=SI1708-0074[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 75
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/7/SI1708-0075 types=files recursive=0 filter=SI1708-0075[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 70
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/0/7/SI1708-0070 types=files recursive=0 filter=SI1708-0070[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 72
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/2/7/SI1708-0072 types=files recursive=0 filter=SI1708-0072[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 69
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/9/6/SI1708-0069 types=files recursive=0 filter=SI1708-0069[^-]+ excludefilter="\.meta$|\.png$"
dolibarr[776]: — End access to /dolibarr/fourn/facture/list.php
dolibarr[776]: - This is an already logged session. _SESSION[‹ dol_login ›]=HUGO _SESSION[‹ dol_entity ›]=1
dolibarr[776]: sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ HUGO › ORDER BY u.entity ASC
dolibarr[776]: fetch_name_optionals_label elementtype=user
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
dolibarr[776]: sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
dolibarr[776]: sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
dolibarr[776]: sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
dolibarr[776]: 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
dolibarr[776]: — Access to /dolibarr/fourn/facture/card.php - action=, massaction=
dolibarr[776]: sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
dolibarr[776]: Menubase::menuLoad mymainmenu=accountancy myleftmenu=suppliers_bills type_user=0 menu_handler=eldy tabMenu size=0
dolibarr[776]: sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[776]: FactureFournisseur::fetch
dolibarr[776]: sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=135
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[776]: FactureFournisseur::fetch_lines
dolibarr[776]: sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=135 ORDER BY f.rang, f.rowid
dolibarr[776]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.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 LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 179
dolibarr[776]: fetch_name_optionals_label elementtype=societe
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ societe › ORDER BY pos
dolibarr[776]: sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
dolibarr[776]: useLocalTax
dolibarr[776]: sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.localtax1_type <> ‹ 0 ›
dolibarr[776]: useLocalTax
dolibarr[776]: sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = ‹ FR › AND t.active = 1 AND t.localtax2_type <> ‹ 0 ›
dolibarr[776]: sql=SELECT rowid, code, label, nature FROM llx_accounting_journal WHERE entity = 1 AND active = 1 ORDER BY label DESC
dolibarr[776]: FactureFournisseur::fetch
dolibarr[776]: sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=135
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[776]: FactureFournisseur::fetch_lines
dolibarr[776]: sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=135 ORDER BY f.rang, f.rowid
dolibarr[776]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.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 LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 179
dolibarr[776]: fetch_name_optionals_label elementtype=societe
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ societe › ORDER BY pos
dolibarr[776]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.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 LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 179
dolibarr[776]: fetch_name_optionals_label elementtype=societe
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ societe › ORDER BY pos
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 135
dolibarr[776]: FactureFournisseur::liste_contact
dolibarr[776]: sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =135 AND ec.fk_c_type_contact=tc.rowid AND tc.element=‹ invoice_supplier › AND tc.source = ‹ internal › AND tc.active=1 ORDER BY t.lastname ASC
dolibarr[776]: FactureFournisseur::liste_contact
dolibarr[776]: sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =135 AND ec.fk_c_type_contact=tc.rowid AND tc.element=‹ invoice_supplier › AND tc.source = ‹ external › AND tc.active=1 ORDER BY t.lastname ASC
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/3/SI1711-0133 types=files recursive=0 filter= excludefilter="(\.meta|_preview.\.png)$"
dolibarr[776]: sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ invoice_supplier › AND objectid = 135 AND entity = 1
dolibarr[776]: sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < ‹ SI1711-0133 › AND te.entity IN (1)
dolibarr[776]: sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > ‹ SI1711-0133 › AND te.entity IN (1)
dolibarr[776]: sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 135 AND type = 2
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 135
dolibarr[776]: Form::load_cache_conditions_paiements
dolibarr[776]: sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE active > 0 ORDER BY sortorder
dolibarr[776]: Form::load_cache_types_paiements
dolibarr[776]: sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement
dolibarr[776]: Translate::getLabelFromKey
dolibarr[776]: sql=SELECT libelle as label FROM llx_c_paiement WHERE code = ‹ LCR ›
dolibarr[776]: Translate::loadCacheCurrencies
dolibarr[776]: sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
dolibarr[776]: sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.id as paiement_type, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiementfourn as p LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_paiementfourn_facturefourn as pf ON pf.fk_paiementfourn = p.rowid WHERE pf.fk_facturefourn = 135 ORDER BY p.datep, p.tms
dolibarr[776]: fetch_name_optionals_label elementtype=facture_fourn_det
dolibarr[776]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn_det › ORDER BY pos
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 135
dolibarr[776]: FactureFournisseur::getSommePaiement
dolibarr[776]: sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 135
dolibarr[776]: /core/lib/function2.lib.php::getListOfModels
dolibarr[776]: sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = ‹ invoice_supplier › AND entity IN (0,1) ORDER BY description DESC
dolibarr[776]: files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/5/3/SI1711-0133 types=files recursive=0 filter= excludefilter="(\.meta|_preview..*\.png)$"
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.facnumber as ref, t.ref_client, t.total as total_ht FROM llx_societe as s, llx_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, ‹ › as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, ‹ › as ref_supplier, t.total_ht FROM llx_societe as s, llx_supplier_proposal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM llx_societe as s, llx_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (179) AND t.entity IN (1)
dolibarr[776]: FactureFournisseur::fetchObjectLink
dolibarr[776]: sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 135 AND sourcetype = ‹ invoice_supplier ›) OR (fk_target = 135 AND targettype = ‹ invoice_supplier ›) ORDER BY sourcetype
[Sat Nov 04 10:48:10.545568 2017] [:error] [pid 776] [client 88.124.50.127:60288] PHP Fatal error: Uncaught Error: Cannot access empty property in /usr/share/dolibarr/htdocs/core/class/commonobject.class.php:2673\nStack trace:\n#0 /usr/share/dolibarr/htdocs/core/class/html.form.class.php(5506): CommonObject->fetchObjectLinked()\n#1 /usr/share/dolibarr/htdocs/fourn/facture/card.php(2858): Form->showLinkedObjectBlock(Object(FactureFournisseur), ‹ \n \t\t<dl clas… ›)\n#2 {main}\n thrown in /usr/share/dolibarr/htdocs/core/class/commonobject.class.php on line 2673, referer: http://si.hugoprod.fr/dolibarr/fourn/facture/list.php?leftmenu=suppliers_bills
dolibarr[776]: — End access to /dolibarr/fourn/facture/card.php
dolibarr[881]: - This is an already logged session. _SESSION[‹ dol_login ›]=HUGO SESSION[‹ dol_entity ›]=1
dolibarr[881]: sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ HUGO › ORDER BY u.entity ASC
dolibarr[881]: fetch_name_optionals_label elementtype=user
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
dolibarr[881]: sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
dolibarr[881]: sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
dolibarr[881]: sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
dolibarr[881]: 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
dolibarr[881]: — Access to /dolibarr/fourn/facture/card.php - action=builddoc, massaction=
dolibarr[881]: sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
dolibarr[881]: Menubase::menuLoad mymainmenu=accountancy myleftmenu=suppliers_bills type_user=0 menu_handler=eldy tabMenu size=0
dolibarr[881]: sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
dolibarr[881]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[881]: FactureFournisseur::fetch
dolibarr[881]: sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=135
dolibarr[881]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[881]: FactureFournisseur::fetch_lines
dolibarr[881]: sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=135 ORDER BY f.rang, f.rowid
dolibarr[881]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.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 LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 179
dolibarr[881]: fetch_name_optionals_label elementtype=societe
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ societe › ORDER BY pos
dolibarr[881]: FactureFournisseur::fetch
dolibarr[881]: sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as libelle_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON (t.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (t.fk_mode_reglement = p.id) LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=135
dolibarr[881]: fetch_name_optionals_label elementtype=facture_fourn
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ facture_fourn › ORDER BY pos
dolibarr[881]: FactureFournisseur::fetch_lines
dolibarr[881]: sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=135 ORDER BY f.rang, f.rowid
dolibarr[881]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as libelle_incoterms FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.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 LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.rowid = 179
dolibarr[881]: fetch_name_optionals_label elementtype=societe
dolibarr[881]: sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ societe › ORDER BY pos
dolibarr[881]: FactureFournisseur::setDocModel
dolibarr[881]: sql=UPDATE llx_facture_fourn SET model_pdf = ‹ canelle › WHERE rowid = 135
dolibarr[881]: sql=SELECT code, label, width, height, unit FROM llx_c_paper_format WHERE code = ‹ EUA4 ›
dolibarr[881]: sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, 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.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1
