2020-10-14 12:49:05 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:49:05 DEBUG Company.lib::getState 2020-10-14 12:49:05 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:05 DEBUG Company.lib::getState 2020-10-14 12:49:05 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:05 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:49:05 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:49:05 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:49:05 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:49:05 INFO --- Access to /fourn/facture/card.php - action=, massaction= 2020-10-14 12:49:05 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:49:05 DEBUG 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 2020-10-14 12:49:05 DEBUG HookManager::initHooks Loading hooks: context=invoicesuppliercard-path=/facturerreception/class/actions_facturerreception.class.php, context=invoicesuppliercard-path=/subtotal/class/actions_subtotal.class.php 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-10-14 12:49:05 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:05 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:05 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:05 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsfacturerReception, module=facturerreception, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:05 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:05 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:05 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:05 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:05 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:05 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:05 DEBUG DiscountAbsolute::getSumCreditNotesUsed 2020-10-14 12:49:05 DEBUG sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 1276 AND f.type IN (0, 2) 2020-10-14 12:49:05 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:05 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:05 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:05 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:05 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:05 DEBUG 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 =1276 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 2020-10-14 12:49:05 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:05 DEBUG 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 =1276 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 2020-10-14 12:49:05 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:05 DEBUG sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 1276 AND entity = 1 2020-10-14 12:49:05 DEBUG sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:05 DEBUG sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:05 DEBUG sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 1276 AND type = 2 2020-10-14 12:49:05 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:05 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:05 DEBUG Form::load_cache_conditions_paiements 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2020-10-14 12:49:05 DEBUG Form::load_cache_types_paiements 2020-10-14 12:49:05 DEBUG sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2020-10-14 12:49:05 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:05 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2020-10-14 12:49:05 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:05 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'NAT' AND entity IN (1) 2020-10-14 12:49:05 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:05 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'BOR' AND entity IN (1) 2020-10-14 12:49:05 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:05 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CHQNAT' AND entity IN (1) 2020-10-14 12:49:05 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:05 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'VIRNAT' AND entity IN (1) 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG Translate::loadCacheCurrencies 2020-10-14 12:49:05 DEBUG sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-10-14 12:49:05 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:05 DEBUG 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 = 1276 ORDER BY p.datep, p.tms 2020-10-14 12:49:05 DEBUG sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llx_societe_remise_except as re WHERE fk_invoice_supplier = 1276 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 INFO Product::fetch id=42727 ref= ref_ext= 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 42727 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-10-14 12:49:05 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/FRIGICOLL-KI-03S/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/FRIGICOLL-KI-03S' AND entity = 1 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 INFO Product::fetch id=43256 ref= ref_ext= 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 43256 2020-10-14 12:49:05 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/ECO.TELECOMMANDE/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/ECO.TELECOMMANDE' AND entity = 1 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsfacturerReception, module=facturerreception, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:05 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:05 DEBUG DiscountAbsolute::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_invoice_supplier_source=1276 2020-10-14 12:49:05 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:05 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:05 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:05 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-10-14 12:49:05 DEBUG /core/lib/function2.lib.php::getListOfModels 2020-10-14 12:49:05 DEBUG sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2020-10-14 12:49:05 DEBUG HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:05 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:05 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:05 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.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 (3905) AND t.entity IN (1) 2020-10-14 12:49:05 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3905) AND t.entity IN (1) 2020-10-14 12:49:05 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:05 DEBUG FactureFournisseur::fetchObjectLink 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 1276 AND sourcetype = 'invoice_supplier') OR (fk_target = 1276 AND targettype = 'invoice_supplier') ORDER BY sourcetype 2020-10-14 12:49:05 DEBUG CommandeFournisseur::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=883 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2020-10-14 12:49:05 DEBUG CommandeFournisseur::fetch get lines 2020-10-14 12:49:05 DEBUG sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 883 ORDER BY l.rang, l.rowid 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5190 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5191 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5192 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5194 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5193 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5195 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5196 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5197 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5198 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5199 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5200 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5201 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5202 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5203 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5204 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5205 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5206 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5207 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5208 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5209 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5211 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5210 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5253 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5254 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5255 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5256 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5257 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5258 2020-10-14 12:49:05 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5259 2020-10-14 12:49:05 DEBUG ActionComm::getActions 2020-10-14 12:49:05 DEBUG sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1276 AND a.elementtype = 'invoice_supplier' ORDER BY a.datep DESC, a.id DESC 2020-10-14 12:49:05 DEBUG ActionComm::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52336 2020-10-14 12:49:05 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52336 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:05 DEBUG ActionComm::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52231 2020-10-14 12:49:05 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52231 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:05 DEBUG ActionComm::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52041 2020-10-14 12:49:05 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52041 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:05 DEBUG ActionComm::fetch 2020-10-14 12:49:05 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=44094 2020-10-14 12:49:05 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 44094 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:05 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-10-14 12:49:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:05 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC 2020-10-14 12:49:05 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2020-10-14 12:49:05 INFO --- End access to /fourn/facture/card.php 2020-10-14 12:49:07 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:49:07 DEBUG Company.lib::getState 2020-10-14 12:49:07 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:07 DEBUG Company.lib::getState 2020-10-14 12:49:07 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:07 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:49:07 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:49:07 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:49:07 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:49:07 INFO --- Access to /fourn/facture/card.php - action=deletepaiement, massaction= 2020-10-14 12:49:07 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:49:07 DEBUG 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 2020-10-14 12:49:07 DEBUG HookManager::initHooks Loading hooks: context=invoicesuppliercard-path=/facturerreception/class/actions_facturerreception.class.php, context=invoicesuppliercard-path=/subtotal/class/actions_subtotal.class.php 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-10-14 12:49:07 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:07 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:07 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:07 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsfacturerReception, module=facturerreception, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsSubtotal, module=subtotal, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:07 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:07 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:07 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:07 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:07 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:07 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:07 DEBUG DiscountAbsolute::getSumCreditNotesUsed 2020-10-14 12:49:07 DEBUG sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 1276 AND f.type IN (0, 2) 2020-10-14 12:49:07 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:07 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:07 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:07 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:07 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:07 DEBUG 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 =1276 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 2020-10-14 12:49:07 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:07 DEBUG 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 =1276 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 2020-10-14 12:49:07 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:07 DEBUG sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 1276 AND entity = 1 2020-10-14 12:49:07 DEBUG sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:07 DEBUG sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:07 DEBUG sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 1276 AND type = 2 2020-10-14 12:49:07 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:07 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:07 DEBUG Form::load_cache_conditions_paiements 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2020-10-14 12:49:07 DEBUG Form::load_cache_types_paiements 2020-10-14 12:49:07 DEBUG sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2020-10-14 12:49:07 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:07 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2020-10-14 12:49:07 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:07 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'NAT' AND entity IN (1) 2020-10-14 12:49:07 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:07 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'BOR' AND entity IN (1) 2020-10-14 12:49:07 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:07 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CHQNAT' AND entity IN (1) 2020-10-14 12:49:07 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:07 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'VIRNAT' AND entity IN (1) 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsSubtotal, module=subtotal, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG Translate::loadCacheCurrencies 2020-10-14 12:49:07 DEBUG sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-10-14 12:49:07 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:07 DEBUG 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 = 1276 ORDER BY p.datep, p.tms 2020-10-14 12:49:07 DEBUG sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llx_societe_remise_except as re WHERE fk_invoice_supplier = 1276 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 INFO Product::fetch id=42727 ref= ref_ext= 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 42727 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-10-14 12:49:07 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/FRIGICOLL-KI-03S/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/FRIGICOLL-KI-03S' AND entity = 1 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 INFO Product::fetch id=43256 ref= ref_ext= 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 43256 2020-10-14 12:49:07 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/ECO.TELECOMMANDE/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/ECO.TELECOMMANDE' AND entity = 1 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsfacturerReception, module=facturerreception, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsSubtotal, module=subtotal, action=deletepaiement context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:07 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:07 DEBUG DiscountAbsolute::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_invoice_supplier_source=1276 2020-10-14 12:49:07 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:07 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:07 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:07 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-10-14 12:49:07 DEBUG /core/lib/function2.lib.php::getListOfModels 2020-10-14 12:49:07 DEBUG sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2020-10-14 12:49:07 DEBUG HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:07 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:07 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:07 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.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 (3905) AND t.entity IN (1) 2020-10-14 12:49:07 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3905) AND t.entity IN (1) 2020-10-14 12:49:07 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:07 DEBUG FactureFournisseur::fetchObjectLink 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 1276 AND sourcetype = 'invoice_supplier') OR (fk_target = 1276 AND targettype = 'invoice_supplier') ORDER BY sourcetype 2020-10-14 12:49:07 DEBUG CommandeFournisseur::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=883 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2020-10-14 12:49:07 DEBUG CommandeFournisseur::fetch get lines 2020-10-14 12:49:07 DEBUG sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 883 ORDER BY l.rang, l.rowid 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5190 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5191 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5192 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5194 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5193 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5195 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5196 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5197 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5198 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5199 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5200 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5201 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5202 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5203 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5204 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5205 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5206 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5207 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5208 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5209 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5211 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5210 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5253 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5254 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5255 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5256 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5257 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5258 2020-10-14 12:49:07 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5259 2020-10-14 12:49:07 DEBUG ActionComm::getActions 2020-10-14 12:49:07 DEBUG sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1276 AND a.elementtype = 'invoice_supplier' ORDER BY a.datep DESC, a.id DESC 2020-10-14 12:49:07 DEBUG ActionComm::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52336 2020-10-14 12:49:07 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52336 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:07 DEBUG ActionComm::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52231 2020-10-14 12:49:07 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52231 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:07 DEBUG ActionComm::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52041 2020-10-14 12:49:07 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52041 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:07 DEBUG ActionComm::fetch 2020-10-14 12:49:07 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=44094 2020-10-14 12:49:07 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 44094 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:07 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-10-14 12:49:07 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:07 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC 2020-10-14 12:49:07 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2020-10-14 12:49:07 INFO --- End access to /fourn/facture/card.php 2020-10-14 12:49:09 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:49:09 DEBUG Company.lib::getState 2020-10-14 12:49:09 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:09 DEBUG Company.lib::getState 2020-10-14 12:49:09 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:09 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:49:09 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:49:09 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:49:09 INFO --- Access to /fourn/facture/card.php - action=confirm_delete_paiement, massaction= 2020-10-14 12:49:09 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:49:09 DEBUG 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 2020-10-14 12:49:09 DEBUG HookManager::initHooks Loading hooks: context=invoicesuppliercard-path=/facturerreception/class/actions_facturerreception.class.php, context=invoicesuppliercard-path=/subtotal/class/actions_subtotal.class.php 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:09 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsfacturerReception, module=facturerreception, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsSubtotal, module=subtotal, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:09 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG sql=SELECT p.rowid, p.ref, p.entity, p.datep as dp, p.amount, p.statut, p.fk_bank, p.multicurrency_amount, c.code as paiement_code, c.libelle as paiement_type, p.num_paiement as num_payment, p.note, b.fk_account FROM llx_paiementfourn as p LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid WHERE p.entity IN (1) AND p.rowid = 447 2020-10-14 12:49:09 DEBUG BEGIN Transaction 2020-10-14 12:49:09 DEBUG PaiementFourn::getBillsArray 2020-10-14 12:49:09 DEBUG sql=SELECT fk_facturefourn FROM llx_paiementfourn_facturefourn as pf, llx_facture_fourn as f WHERE pf.fk_facturefourn = f.rowid AND fk_paiementfourn = 447 AND paye=1 2020-10-14 12:49:09 DEBUG ROLLBACK Transaction 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:09 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getSumCreditNotesUsed 2020-10-14 12:49:09 DEBUG sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 1276 AND f.type IN (0, 2) 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:09 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:09 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:09 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:09 DEBUG 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 =1276 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 2020-10-14 12:49:09 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:09 DEBUG 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 =1276 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 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 1276 AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 1276 AND type = 2 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG Form::load_cache_conditions_paiements 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2020-10-14 12:49:09 DEBUG Form::load_cache_types_paiements 2020-10-14 12:49:09 DEBUG sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'NAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'BOR' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CHQNAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'VIRNAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsSubtotal, module=subtotal, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG Translate::loadCacheCurrencies 2020-10-14 12:49:09 DEBUG sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:09 DEBUG 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 = 1276 ORDER BY p.datep, p.tms 2020-10-14 12:49:09 DEBUG sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llx_societe_remise_except as re WHERE fk_invoice_supplier = 1276 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 INFO Product::fetch id=42727 ref= ref_ext= 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 42727 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/FRIGICOLL-KI-03S/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/FRIGICOLL-KI-03S' AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 INFO Product::fetch id=43256 ref= ref_ext= 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 43256 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/ECO.TELECOMMANDE/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/ECO.TELECOMMANDE' AND entity = 1 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsfacturerReception, module=facturerreception, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsSubtotal, module=subtotal, action=confirm_delete_paiement context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG DiscountAbsolute::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_invoice_supplier_source=1276 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-10-14 12:49:09 DEBUG /core/lib/function2.lib.php::getListOfModels 2020-10-14 12:49:09 DEBUG sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetchObjectLink 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 1276 AND sourcetype = 'invoice_supplier') OR (fk_target = 1276 AND targettype = 'invoice_supplier') ORDER BY sourcetype 2020-10-14 12:49:09 DEBUG CommandeFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=883 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2020-10-14 12:49:09 DEBUG CommandeFournisseur::fetch get lines 2020-10-14 12:49:09 DEBUG sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 883 ORDER BY l.rang, l.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5190 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5191 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5192 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5194 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5193 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5195 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5196 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5197 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5198 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5199 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5200 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5201 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5202 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5203 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5204 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5205 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5206 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5207 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5208 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5209 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5211 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5210 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5253 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5254 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5255 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5256 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5257 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5258 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5259 2020-10-14 12:49:09 DEBUG ActionComm::getActions 2020-10-14 12:49:09 DEBUG sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1276 AND a.elementtype = 'invoice_supplier' ORDER BY a.datep DESC, a.id DESC 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52336 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52336 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52231 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52231 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52041 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52041 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=44094 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 44094 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2020-10-14 12:49:09 INFO --- End access to /fourn/facture/card.php 2020-10-14 12:49:09 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:49:09 DEBUG Company.lib::getState 2020-10-14 12:49:09 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:09 DEBUG Company.lib::getState 2020-10-14 12:49:09 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:49:09 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:49:09 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:49:09 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:49:09 INFO --- Access to /fourn/facture/card.php - action=, massaction= 2020-10-14 12:49:09 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:49:09 DEBUG 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 2020-10-14 12:49:09 DEBUG HookManager::initHooks Loading hooks: context=invoicesuppliercard-path=/facturerreception/class/actions_facturerreception.class.php, context=invoicesuppliercard-path=/subtotal/class/actions_subtotal.class.php 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn' ORDER BY pos 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:09 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsfacturerReception, module=facturerreception, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method doActions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, 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 as fk_project, 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 label_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=1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetch_lines 2020-10-14 12:49:09 DEBUG sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, 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=1276 ORDER BY f.rang, f.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG 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.socialnetworks, 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 as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, 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.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, 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 label_incoterms, sr.remise_client 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 LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 3905 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, noattmanipflu, datepernoattfluid FROM llx_societe_extrafields WHERE fk_object = 3905 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getSumCreditNotesUsed 2020-10-14 12:49:09 DEBUG sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 1276 AND f.type IN (0, 2) 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:09 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:09 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=1 2020-10-14 12:49:09 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 3905 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')) 2020-10-14 12:49:09 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:09 DEBUG 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 =1276 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 2020-10-14 12:49:09 DEBUG FactureFournisseur::liste_contact 2020-10-14 12:49:09 DEBUG 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 =1276 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 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 1276 AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > 'SI2007-1202' AND te.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 1276 AND type = 2 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG Form::load_cache_conditions_paiements 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder 2020-10-14 12:49:09 DEBUG Form::load_cache_types_paiements 2020-10-14 12:49:09 DEBUG sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'NAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'BOR' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'CHQNAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG Translate::getLabelFromKey 2020-10-14 12:49:09 DEBUG sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'VIRNAT' AND entity IN (1) 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method formObjectOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG Translate::loadCacheCurrencies 2020-10-14 12:49:09 DEBUG sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:09 DEBUG 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 = 1276 ORDER BY p.datep, p.tms 2020-10-14 12:49:09 DEBUG sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llx_societe_remise_except as re WHERE fk_invoice_supplier = 1276 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6547 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 INFO Product::fetch id=42727 ref= ref_ext= 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 42727 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/FRIGICOLL-KI-03S/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/FRIGICOLL-KI-03S' AND entity = 1 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_facture_fourn_det_extrafields WHERE fk_object = 6548 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printObjectLine of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 INFO Product::fetch id=43256 ref= ref_ext= 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, fk_default_warehouse, seuil_stock_alerte, canvas, net_measure, net_measure_units, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_buy_intra, accountancy_code_buy_export, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 43256 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/produit/ECO.TELECOMMANDE/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = 'produit/ECO.TELECOMMANDE' AND entity = 1 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsfacturerReception, module=facturerreception, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addMoreActionsButtons of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 DEBUG DiscountAbsolute::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_invoice_supplier_source=1276 2020-10-14 12:49:09 DEBUG sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 1276 2020-10-14 12:49:09 DEBUG FactureFournisseur::getSommePaiement 2020-10-14 12:49:09 DEBUG sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 1276 2020-10-14 12:49:09 INFO files.lib.php::dol_dir_list path=/var/lib/dolibarr/documents/fournisseur/facture/6/7/SI2007-1202 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$" 2020-10-14 12:49:09 DEBUG /core/lib/function2.lib.php::getListOfModels 2020-10-14 12:49:09 DEBUG sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice_supplier' AND entity IN (0,1) ORDER BY description DESC 2020-10-14 12:49:09 DEBUG HookManager::executeHooks Qualified hook found (hooktype=output). We call method formBuilddocOptions of class ActionsSubtotal, module=subtotal, action= context=invoicesuppliercard 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG 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 (3905) AND t.entity IN (1) 2020-10-14 12:49:09 DEBUG FactureFournisseur::fetchObjectLink 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 1276 AND sourcetype = 'invoice_supplier') OR (fk_target = 1276 AND targettype = 'invoice_supplier') ORDER BY sourcetype 2020-10-14 12:49:09 DEBUG CommandeFournisseur::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=883 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' ORDER BY pos 2020-10-14 12:49:09 DEBUG CommandeFournisseur::fetch get lines 2020-10-14 12:49:09 DEBUG sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 883 ORDER BY l.rang, l.rowid 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5190 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5191 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5192 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5194 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5193 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5195 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5196 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5197 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5198 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5199 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5200 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5201 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5202 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5203 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5204 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5205 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5206 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5207 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5208 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5209 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5211 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5210 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5253 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5254 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5255 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5256 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5257 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5258 2020-10-14 12:49:09 DEBUG sql=SELECT rowid, show_total_ht, show_reduc FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 5259 2020-10-14 12:49:09 DEBUG ActionComm::getActions 2020-10-14 12:49:09 DEBUG sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 1276 AND a.elementtype = 'invoice_supplier' ORDER BY a.datep DESC, a.id DESC 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52336 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52336 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52231 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52231 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=52041 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 52041 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG ActionComm::fetch 2020-10-14 12:49:09 DEBUG sql=SELECT a.id, a.id as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, c.id as type_id, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id=44094 2020-10-14 12:49:09 DEBUG sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 44094 AND element_type IN ('user', 'socpeople') 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC 2020-10-14 12:49:09 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC 2020-10-14 12:49:09 INFO --- End access to /fourn/facture/card.php 2020-10-14 12:50:01 ERR ???@root Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:50:01 DEBUG ???@root Company.lib::getState 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:01 DEBUG ???@root Company.lib::getState 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 IS NOT NULL AND u.login = 'admin' ORDER BY u.entity ASC 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT DISTINCT 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 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:50:01 DEBUG ???@root Cronjob::fetch_all 2020-10-14 12:50:01 DEBUG ???@root sql=SELECT t.rowid, t.entity, t.tms, t.datec, t.jobtype, t.label, t.command, t.classesname, t.objectname, t.methodename, t.params, t.md5params, t.module_name, t.priority, t.datelastrun, t.datenextrun, t.dateend, t.datestart, t.lastresult, t.datelastresult, t.lastoutput, t.unitfrequency, t.frequency, t.status, t.processing, t.fk_user_author, t.fk_user_mod, t.note, t.nbrun, t.libname, t.test FROM llx_cronjob as t WHERE 1 = 1 AND t.processing = 0 AND t.status = 1 ORDER BY t.priority ASC, t.entity ASC, t.rowid ASC 2020-10-14 12:50:01 DEBUG ???@root cron_run_jobs.php cronjobid: 3 priority=10 entity=1 label=SendEmailsReminders 2020-10-14 12:50:01 INFO ???@root cron_run_jobs.php job not qualified line->datenextrun:2020-10-14T12:50:25Z line->datestart:2018-11-29T10:20:25Z line->dateend: now:2020-10-14T12:50:01Z 2020-10-14 12:50:01 DEBUG ???@root cron_run_jobs.php cronjobid: 4 priority=50 entity=0 label=PurgeDeleteTemporaryFilesShort 2020-10-14 12:50:01 INFO ???@root cron_run_jobs.php job not qualified line->datenextrun:2020-10-21T12:05:30Z line->datestart:2018-12-05T11:05:30Z line->dateend: now:2020-10-14T12:50:01Z 2020-10-14 12:50:01 DEBUG ???@root cron_run_jobs.php cronjobid: 2 priority=50 entity=1 label=RecurringInvoices 2020-10-14 12:50:01 INFO ???@root cron_run_jobs.php job not qualified line->datenextrun:2020-10-15T11:27:27Z line->datestart:2018-09-19T11:27:27Z line->dateend: now:2020-10-14T12:50:01Z 2020-10-14 12:50:01 DEBUG ???@root cron_run_jobs.php cronjobid: 5 priority=90 entity=0 label=MakeLocalDatabaseDumpShort 2020-10-14 12:50:01 INFO ???@root cron_run_jobs.php job not qualified line->datenextrun:2020-10-15T01:10:00Z line->datestart:2018-12-05T11:05:00Z line->dateend: now:2020-10-14T12:50:01Z 2020-10-14 12:50:05 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:50:05 DEBUG Company.lib::getState 2020-10-14 12:50:05 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:05 DEBUG Company.lib::getState 2020-10-14 12:50:05 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:05 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:50:05 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:50:05 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:50:05 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:50:05 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:50:05 INFO --- Access to /admin/modules.php - action=, massaction= 2020-10-14 12:50:05 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:50:05 DEBUG 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 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Module modDocumentGeneration not qualified 2020-10-14 12:50:05 DEBUG User::loadParentOf 2020-10-14 12:50:05 DEBUG sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2020-10-14 12:50:05 DEBUG User::get_full_tree get user list 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1) 2020-10-14 12:50:05 DEBUG User::get_full_tree call to build_path_from_id_user 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=1 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=2 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=3 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=4 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=6 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=8 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=10 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=15 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=16 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=17 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=18 protection=0 2020-10-14 12:50:05 DEBUG User::build_path_from_id_user id_user=19 protection=0 2020-10-14 12:50:05 DEBUG User::get_full_tree dol_sort_array 2020-10-14 12:50:05 INFO Build childid for id = 1 2020-10-14 12:50:05 INFO Module modDeplacement not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'holiday' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 INFO Module modDynamicPrices not qualified 2020-10-14 12:50:05 INFO Module modDataPolicy not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinter' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'fichinterdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2020-10-14 12:50:05 INFO Module modZapier not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bom' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'bom_bomline' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 INFO Module modPaymentByBankTransfer not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn_det' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseur' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'commande_fournisseurdet' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG useNPR 2020-10-14 12:50:05 DEBUG sql=SELECT t.rowid 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.recuperableonly = 1 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG 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' 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang 2020-10-14 12:50:05 INFO Module modWebServicesClient not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'contrat' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'contratdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2020-10-14 12:50:05 INFO Module modLabel not qualified 2020-10-14 12:50:05 INFO Module modReceiptPrinter not qualified 2020-10-14 12:50:05 INFO Module modCollab not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2020-10-14 12:50:05 INFO Module modAsset not qualified 2020-10-14 12:50:05 INFO Module modHRM not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-10-14 12:50:05 DEBUG sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 INFO Module modReception not qualified 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 DEBUG sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'expensereport' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/myinventory/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/addremise/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/portofolio/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 DEBUG sql=SELECT rowid FROM llx_menu WHERE mainmenu ='patastools' AND type = 'top' AND entity = 1 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/societeinfo/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/subtotal/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/abricot/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/facturerreception/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Scan directory /usr/share/dolibarr/htdocs/custom/mydoli/core/modules/ for module descriptor files (modXXX.class.php) 2020-10-14 12:50:05 INFO Save lastsearch_values_tmp_admin/modules.php={"search_keyword":"bug"} (systematic recording of last search criterias) 2020-10-14 12:50:05 INFO --- End access to /admin/modules.php 2020-10-14 12:50:08 ERR Your state setup use an old syntax. Reedit it using setup area. 2020-10-14 12:50:08 DEBUG Company.lib::getState 2020-10-14 12:50:08 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:08 DEBUG Company.lib::getState 2020-10-14 12:50:08 DEBUG sql=SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=40 AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement 2020-10-14 12:50:08 DEBUG - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2020-10-14 12:50:08 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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 as note_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, 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 = 'admin' ORDER BY u.entity ASC 2020-10-14 12:50:08 DEBUG sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-10-14 12:50:08 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-10-14 12:50:08 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-10-14 12:50:08 DEBUG sql=SELECT DISTINCT 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 2020-10-14 12:50:08 DEBUG sql=SELECT DISTINCT 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 gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-10-14 12:50:08 INFO --- Access to /admin/modules.php - action=reset, massaction= 2020-10-14 12:50:08 DEBUG sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-10-14 12:50:08 DEBUG 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 2020-10-14 12:50:08 DEBUG BEGIN Transaction 2020-10-14 12:50:08 DEBUG modSyslog::_unactive 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_const WHERE name = 'MAIN_MODULE_SYSLOG' AND entity IN (0, 0) 2020-10-14 12:50:08 DEBUG modSyslog::delete_tabs 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_const WHERE name like 'MAIN_MODULE_SYSLOG_TABS_%' AND entity = 1 2020-10-14 12:50:08 DEBUG modSyslog::delete_cronjobs 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_cronjob WHERE module_name = 'syslog' AND entity = 1 AND test = '1' 2020-10-14 12:50:08 DEBUG modSyslog::delete_permissions 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_rights_def WHERE module = 'syslog' AND entity = 1 2020-10-14 12:50:08 DEBUG modSyslog::delete_menus 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_menu WHERE module = 'syslog' AND entity = 1 2020-10-14 12:50:08 DEBUG modSyslog::delete_dirs 2020-10-14 12:50:08 DEBUG sql=DELETE FROM llx_const WHERE name LIKE 'MAIN_MODULE_SYSLOG_DIR_%' AND entity = 1 2020-10-14 12:50:08 DEBUG COMMIT Transaction 2020-10-14 12:50:08 INFO --- End access to /admin/modules.php