Bonjour à vous,
Je n’utilise Dolibarr que depuis quelques mois, donc mon souci vient probablement de moi. J’ai commencé en version 18 et quelques, et il y a peu de temps, je suis passé à la version 19.0.0. Je n’ai rien constaté d’anormal après la mise à jour. Puis, pour une facture, j’ai voulu créer une remise client fixe. Dès que je mets le montant et le motif obligatoire puis que je fais valider → page blanche. Du moins, page blanche sur Firefox, erreur 500 sur Chrome, mais ça, si j’ai bien compris en fouillant les forums, c’est une fausse erreur 500. Il faut savoir que je n’avais jusqu’à maintenant jamais fait de remise client, donc il est possible que cette fonctionnalité n’ait en réalité jamais fonctionné et que ce ne soit donc pas un souci de mise à jour.
Mon installation est faite sur un sous-domaine, hébergé chez O2switch, grâce à l’installation Softaculous et c’est aussi avec ça que j’ai fait la mise à jour. Sur le Cpanel, dans le menu Erreur, qui est censé, si j’ai bien compris, montrer les erreurs PHP, rien d’anormal.
Pour ce qui est des modules, j’en ai 19, mais uniquement parmi ceux disponibles par défaut (19 sur 78). Dont les logs du moment où j’essaie d’inscrire une remise que je vous donne à la fin car c’est très long !
Si jamais vous avez une piste car je ne comprends pas tout, je suis preneur.
Merci à vous
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx - This is an already logged session. _SESSION['dol_login']=utilisateuradmin _SESSION['dol_entity']=1
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxgp_user as u LEFT JOIN llxgp_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxgp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'utilisateuradmin' ORDER BY u.entity ASC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxgp_extrafields WHERE elementtype = 'user' ORDER BY pos
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT param, value FROM llxgp_user_param WHERE fk_user = 1 AND entity = 1
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx DefaultValues::fetchAll
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rowid,type,user_id,page,param,value FROM llxgp_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_user_rights as ur, llxgp_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance'
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_usergroup_rights as gr, llxgp_usergroup_user as gu, llxgp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2024-02-25 17:52:19 NOTICE xx.xx.xx.xx --- Access to GET /comm/remx.php - action=create_remise, massaction=
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT transkey, transvalue FROM llxgp_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxgp_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.type DESC, m.position, m.rowid
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.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.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxgp_societe as s LEFT JOIN llxgp_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxgp_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxgp_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxgp_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxgp_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxgp_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxgp_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxgp_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 51
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxgp_extrafields WHERE elementtype = 'societe' ORDER BY pos
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rowid, liensocietecom, site, politesse, intressparunsite, prendrecontact, apporteurdaffaire FROM llxgp_societe_extrafields WHERE fk_object = 51
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT COUNT(p.rowid) as nb FROM llxgp_socpeople as p WHERE p.fk_soc = 51 AND entity IN (1)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT COUNT(n.rowid) as nb FROM llxgp_projet as n WHERE fk_soc = 51 AND entity IN (1)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx SocieteAccount::getCustomerAccount Try to find the first system customer id for stripe of thirdparty id=51 (exemple: cus_.... for stripe)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT sa.key_account as key_account, sa.entity FROM llxgp_societe_account as sa WHERE sa.fk_soc = 51 AND sa.entity IN (1) AND sa.site = 'stripe' AND sa.status = 1 AND sa.key_account IS NOT NULL AND sa.key_account <> '' AND (sa.site_account = '' OR sa.site_account IS NULL OR sa.site_account = '') ORDER BY sa.site_account DESC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT COUNT(n.rowid) as nb FROM llxgp_societe_rib as n WHERE n.fk_soc = 51 AND (n.stripe_card_ref IS NULL OR (n.stripe_card_ref IS NOT NULL AND n.status = 1))
2024-02-25 17:52:19 INFO xx.xx.xx.xx files.lib.php::dol_dir_list path=/home/cbim3747/dolibarrdata/societe/51 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT COUNT(rowid) as nb FROM llxgp_links WHERE objecttype = 'societe' AND objectid = 51 AND entity = 1
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT COUNT(id) as nb FROM llxgp_actioncomm WHERE fk_soc = 51 AND entity IN (1)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT MAX(te.rowid) FROM llxgp_societe as te WHERE te.rowid < 51 AND te.entity IN (1)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT MIN(te.rowid) FROM llxgp_societe as te WHERE te.rowid > 51 AND te.entity IN (1)
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT SUM(rc.amount_ht) as amount, rc.fk_user FROM llxgp_societe_remise_except as rc WHERE rc.fk_soc = 51 AND rc.entity = 1 AND discount_type = 0 AND (fk_facture_line IS NULL AND fk_facture IS NULL) GROUP BY rc.fk_user
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx Translate::loadCacheCurrencies
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT code_iso, label, unicode FROM llxgp_c_currencies WHERE active = 1 AND code_iso = 'EUR'
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx Form::load_cache_vatrates
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT t.rowid, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly FROM llxgp_c_tva as t, llxgp_c_country as c WHERE t.fk_pays = c.rowid AND t.active > 0 AND t.entity IN (1) AND c.code IN ('FR') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rc.rowid, rc.amount_ht, rc.amount_tva, rc.amount_ttc, rc.tva_tx, rc.vat_src_code, rc.multicurrency_amount_ht, rc.multicurrency_amount_tva, rc.multicurrency_amount_ttc, rc.datec as dc, rc.description, rc.fk_facture_source, u.login, u.rowid as user_id, u.statut as status, u.firstname, u.lastname, u.photo, fa.ref as ref, fa.type as type FROM llxgp_user as u, llxgp_societe_remise_except as rc LEFT JOIN llxgp_facture as fa ON rc.fk_facture_source = fa.rowid WHERE rc.fk_soc = 51 AND rc.entity = 1 AND u.rowid = rc.fk_user AND rc.discount_type = 0 AND (rc.fk_facture_line IS NULL AND rc.fk_facture IS NULL) ORDER BY rc.datec DESC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rc.rowid, rc.amount_ht, rc.amount_tva, rc.amount_ttc, rc.tva_tx, rc.vat_src_code, rc.multicurrency_amount_ht, rc.multicurrency_amount_tva, rc.multicurrency_amount_ttc, rc.datec as dc, rc.description, rc.fk_facture_line, rc.fk_facture_source, u.login, u.rowid as user_id, u.statut as status, u.firstname, u.lastname, u.photo, f.rowid as invoiceid, f.ref, fa.ref as invoice_source_ref, fa.type as type FROM llxgp_facture as f , llxgp_user as u , llxgp_facturedet as fc , llxgp_societe_remise_except as rc LEFT JOIN llxgp_facture as fa ON rc.fk_facture_source = fa.rowid WHERE rc.fk_soc = 51 AND rc.fk_facture_line = fc.rowid AND fc.fk_facture = f.rowid AND rc.fk_user = u.rowid AND rc.discount_type = 0 ORDER BY dc DESC
2024-02-25 17:52:19 DEBUG xx.xx.xx.xx sql=SELECT rc.rowid, rc.amount_ht, rc.amount_tva, rc.amount_ttc, rc.tva_tx, rc.vat_src_code, rc.multicurrency_amount_ht, rc.multicurrency_amount_tva, rc.multicurrency_amount_ttc, rc.datec as dc, rc.description, rc.fk_facture, rc.fk_facture_source, u.login, u.rowid as user_id, u.statut as status, u.firstname, u.lastname, u.photo, f.rowid as invoiceid, f.ref, fa.ref as invoice_source_ref, fa.type as type FROM llxgp_facture as f , llxgp_user as u , llxgp_societe_remise_except as rc LEFT JOIN llxgp_facture as fa ON rc.fk_facture_source = fa.rowid WHERE rc.fk_soc = 51 AND rc.fk_facture = f.rowid AND rc.fk_user = u.rowid AND rc.discount_type = 0 ORDER BY dc DESC
2024-02-25 17:52:19 INFO xx.xx.xx.xx --- End access to /comm/remx.php
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx - This is an already logged session. _SESSION['dol_login']=utilisateuradmin _SESSION['dol_entity']=1
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxgp_user as u LEFT JOIN llxgp_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxgp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'utilisateuradmin' ORDER BY u.entity ASC
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxgp_extrafields WHERE elementtype = 'user' ORDER BY pos
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT param, value FROM llxgp_user_param WHERE fk_user = 1 AND entity = 1
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx DefaultValues::fetchAll
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT rowid,type,user_id,page,param,value FROM llxgp_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_user_rights as ur, llxgp_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance'
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_usergroup_rights as gr, llxgp_usergroup_user as gu, llxgp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2024-02-25 17:52:27 NOTICE xx.xx.xx.xx --- Access to POST /comm/remx.php - action=setremise, massaction=
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT transkey, transvalue FROM llxgp_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxgp_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.type DESC, m.position, m.rowid
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.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.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxgp_societe as s LEFT JOIN llxgp_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxgp_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxgp_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxgp_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxgp_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxgp_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxgp_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxgp_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 51
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxgp_extrafields WHERE elementtype = 'societe' ORDER BY pos
2024-02-25 17:52:27 DEBUG xx.xx.xx.xx sql=SELECT rowid, liensocietecom, site, politesse, intressparunsite, prendrecontact, apporteurdaffaire FROM llxgp_societe_extrafields WHERE fk_object = 51
2024-02-25 17:52:27 INFO xx.xx.xx.xx --- End access to /comm/remx.php
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx - This is an already logged session. _SESSION['dol_login']=utilisateuradmin _SESSION['dol_entity']=1
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxgp_user as u LEFT JOIN llxgp_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxgp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'utilisateuradmin' ORDER BY u.entity ASC
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxgp_extrafields WHERE elementtype = 'user' ORDER BY pos
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT param, value FROM llxgp_user_param WHERE fk_user = 1 AND entity = 1
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx DefaultValues::fetchAll
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT rowid,type,user_id,page,param,value FROM llxgp_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_user_rights as ur, llxgp_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance'
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxgp_usergroup_rights as gr, llxgp_usergroup_user as gu, llxgp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2024-02-25 17:52:38 NOTICE xx.xx.xx.xx --- Access to GET /document.php - action=, massaction= NOTOKENRENEWAL=1
2024-02-25 17:52:38 DEBUG xx.xx.xx.xx sql=SELECT transkey, transvalue FROM llxgp_overwrite_trans where (lang='fr_FR' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2024-02-25 17:52:38 INFO xx.xx.xx.xx dol_check_secure_access_document modulepart=logs original_file=dolibarr.log entity=1
2024-02-25 17:52:38 INFO xx.xx.xx.xx document.php download /home/cbim3747/dolibarrdata/dolibarr.log filename=dolibarr.log content-type=text/plain
